diff options
Diffstat (limited to 'mysql-test/t/ps_2myisam.test')
-rw-r--r-- | mysql-test/t/ps_2myisam.test | 23 |
1 files changed, 22 insertions, 1 deletions
diff --git a/mysql-test/t/ps_2myisam.test b/mysql-test/t/ps_2myisam.test index c7e4746762b..534703efc14 100644 --- a/mysql-test/t/ps_2myisam.test +++ b/mysql-test/t/ps_2myisam.test @@ -15,7 +15,28 @@ let $type= 'MYISAM' ; -- source include/ps_renew.inc -- source include/ps_query.inc + +# parameter in SELECT ... MATCH/AGAINST +# case derived from client_test.c: test_bug1500() +--disable_warnings +drop table if exists t2 ; +--enable_warnings +eval create table t2 (s varchar(25), fulltext(s)) +ENGINE = $type ; +insert into t2 values ('Gravedigger'), ('Greed'),('Hollow Dogs') ; +commit ; + +prepare stmt1 from ' select s from t2 where match (s) against (?) ' ; +set @arg00='Dogs' ; +execute stmt1 using @arg00 ; +prepare stmt1 from ' SELECT s FROM t2 +where match (s) against (concat(?,''digger'')) '; +set @arg00='Grave' ; +execute stmt1 using @arg00 ; +drop table t2 ; + -- source include/ps_modify.inc -- source include/ps_modify1.inc +-- source include/ps_conv.inc -drop table t1, t_many_col_types; +drop table t1, t9; |