1 2 #Get deafult engine value 3--let $DEFAULT_ENGINE = `select @@global.default_storage_engine` 4 5############################################### 6# # 7# Prepared Statements test on MYISAM tables # 8# # 9############################################### 10 11# 12# NOTE: PLEASE SEE ps_1general.test (bottom) 13# BEFORE ADDING NEW TEST CASES HERE !!! 14 15use test; 16 17let $type= 'MYISAM' ; 18-- source include/ps_create.inc 19-- source include/ps_renew.inc 20 21-- source include/ps_query.inc 22 23# parameter in SELECT ... MATCH/AGAINST 24# case derived from client_test.c: test_bug1500() 25--disable_warnings 26drop table if exists t2 ; 27--enable_warnings 28eval create table t2 (s varchar(25), fulltext(s)) 29ENGINE = $type ; 30insert into t2 values ('Gravedigger'), ('Greed'),('Hollow Dogs') ; 31commit ; 32 33prepare stmt1 from ' select s from t2 where match (s) against (?) ' ; 34set @arg00='Dogs' ; 35execute stmt1 using @arg00 ; 36prepare stmt1 from ' SELECT s FROM t2 37where match (s) against (concat(?,''digger'')) '; 38set @arg00='Grave' ; 39execute stmt1 using @arg00 ; 40drop table t2 ; 41 42-- source include/ps_modify.inc 43-- source include/ps_modify1.inc 44-- source include/ps_conv.inc 45 46drop table t1, t9; 47 48# End of 4.1 tests 49