Debian Codegraph @

mysql-test/suite/maria/ps_maria.test

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