| blob | 1b2a0cc50b257571d35456c153fe71463ce3da20 |
1 drop table if exists t5, t6, t7, t8;
2 drop database if exists mysqltest ;
3 drop database if exists client_test_db;
4 drop database if exists testtets;
5 drop table if exists t1Aa,t2Aa,v1Aa,v2Aa;
6 drop view if exists t1Aa,t2Aa,v1Aa,v2Aa;
7 test_sequence
8 ------ basic tests ------
9 drop table if exists t1, t9 ;
10 create table t1
11 (
12 a int, b varchar(30),
13 primary key(a)
14 ) engine = 'MYISAM' ;
15 create table t9
16 (
17 c1 tinyint, c2 smallint, c3 mediumint, c4 int,
18 c5 integer, c6 bigint, c7 float, c8 double,
19 c9 double precision, c10 real, c11 decimal(7, 4), c12 numeric(8, 4),
20 c13 date, c14 datetime, c15 timestamp, c16 time,
21 c17 year, c18 tinyint, c19 bool, c20 char,
22 c21 char(10), c22 varchar(30), c23 tinyblob, c24 tinytext,
23 c25 blob, c26 text, c27 mediumblob, c28 mediumtext,
24 c29 longblob, c30 longtext, c31 enum('one', 'two', 'three'),
25 c32 set('monday', 'tuesday', 'wednesday'),
26 primary key(c1)
27 ) engine = 'MYISAM' ;
28 delete from t1 ;
29 insert into t1 values (1,'one');
30 insert into t1 values (2,'two');
31 insert into t1 values (3,'three');
32 insert into t1 values (4,'four');
33 commit ;
34 delete from t9 ;
35 insert into t9
36 set c1= 1, c2= 1, c3= 1, c4= 1, c5= 1, c6= 1, c7= 1, c8= 1, c9= 1,
37 c10= 1, c11= 1, c12 = 1,
38 c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
39 c16= '11:11:11', c17= '2004',
40 c18= 1, c19=true, c20= 'a', c21= '123456789a',
41 c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
42 c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
43 c29= 'longblob', c30= 'longtext', c31='one', c32= 'monday';
44 insert into t9
45 set c1= 9, c2= 9, c3= 9, c4= 9, c5= 9, c6= 9, c7= 9, c8= 9, c9= 9,
46 c10= 9, c11= 9, c12 = 9,
47 c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
48 c16= '11:11:11', c17= '2004',
49 c18= 1, c19=false, c20= 'a', c21= '123456789a',
50 c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
51 c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
52 c29= 'longblob', c30= 'longtext', c31='two', c32= 'tuesday';
53 commit ;
54 PREPARE stmt FROM ' select * from t1 where a = ? ' ;
55 SET @var= 2 ;
56 EXECUTE stmt USING @var ;
57 a b
58 2 two
59 select * from t1 where a = @var ;
60 a b
61 2 two
62 DEALLOCATE PREPARE stmt ;
63 prepare stmt1 from ' select 1 as my_col ' ;
64 prepare stmt1 from ' select ? as my_col ' ;
65 prepare ;
66 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
67 prepare stmt1 ;
68 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
69 prepare stmt1 from ;
70 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
71 prepare_garbage stmt1 from ' select 1 ' ;
72 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'prepare_garbage stmt1 from ' select 1 '' at line 1
73 prepare stmt1 from_garbage ' select 1 ' ;
74 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from_garbage ' select 1 '' at line 1
75 prepare stmt1 from ' select_garbage 1 ' ;
76 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select_garbage 1' at line 1
77 prepare from ' select 1 ' ;
78 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from ' select 1 '' at line 1
79 prepare stmt1 ' select 1 ' ;
80 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' select 1 '' at line 1
81 prepare ? from ' select ? as my_col ' ;
82 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? from ' select ? as my_col '' at line 1
83 set @arg00='select 1 as my_col';
84 prepare stmt1 from @arg00;
85 set @arg00='';
86 prepare stmt1 from @arg00;
87 ERROR 42000: Query was empty
88 set @arg00=NULL;
89 prepare stmt1 from @arg01;
90 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
91 prepare stmt1 from ' select * from t1 where a <= 2 ' ;
92 prepare stmt1 from ' select * from t1 where x <= 2 ' ;
93 ERROR 42S22: Unknown column 'x' in 'where clause'
94 prepare stmt1 from ' insert into t1(a,x) values(?,?) ' ;
95 ERROR 42S22: Unknown column 'x' in 'field list'
96 prepare stmt1 from ' insert into t1(x,a) values(?,?) ' ;
97 ERROR 42S22: Unknown column 'x' in 'field list'
98 drop table if exists not_exist ;
99 prepare stmt1 from ' select * from not_exist where a <= 2 ' ;
100 ERROR 42S02: Table 'test.not_exist' doesn't exist
101 prepare stmt1 from ' insert into t1 values(? ' ;
102 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
103 prepare stmt1 from ' select a, b from t1
104 where a=? and where ' ;
105 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where' at line 2
106 execute never_prepared ;
107 ERROR HY000: Unknown prepared statement handler (never_prepared) given to EXECUTE
108 prepare stmt1 from ' select * from t1 where a <= 2 ' ;
109 prepare stmt1 from ' select * from not_exist where a <= 2 ' ;
110 ERROR 42S02: Table 'test.not_exist' doesn't exist
111 execute stmt1 ;
112 ERROR HY000: Unknown prepared statement handler (stmt1) given to EXECUTE
113 create table t5
114 (
115 a int primary key,
116 b char(30),
117 c int
118 );
119 insert into t5( a, b, c) values( 1, 'original table', 1);
120 prepare stmt2 from ' select * from t5 ' ;
121 execute stmt2 ;
122 a b c
123 1 original table 1
124 drop table t5 ;
125 execute stmt2 ;
126 ERROR 42S02: Table 'test.t5' doesn't exist
127 create table t5
128 (
129 a int primary key,
130 b char(30),
131 c int
132 );
133 insert into t5( a, b, c) values( 9, 'recreated table', 9);
134 execute stmt2 ;
135 a b c
136 9 recreated table 9
137 drop table t5 ;
138 create table t5
139 (
140 a int primary key,
141 c int,
142 b char(30)
143 );
144 insert into t5( a, b, c) values( 9, 'recreated table', 9);
145 execute stmt2 ;
146 a c b
147 9 9 recreated table
148 drop table t5 ;
149 create table t5
150 (
151 a int primary key,
152 b char(30),
153 c int,
154 d timestamp default '2008-02-23 09:23:45'
155 );
156 insert into t5( a, b, c) values( 9, 'recreated table', 9);
157 execute stmt2 ;
158 a b c d
159 9 recreated table 9 2008-02-23 09:23:45
160 drop table t5 ;
161 create table t5
162 (
163 a int primary key,
164 d timestamp default '2008-02-23 09:23:45',
165 b char(30),
166 c int
167 );
168 insert into t5( a, b, c) values( 9, 'recreated table', 9);
169 execute stmt2 ;
170 a d b c
171 9 2008-02-23 09:23:45 recreated table 9
172 drop table t5 ;
173 create table t5
174 (
175 a timestamp default '2004-02-29 18:01:59',
176 b char(30),
177 c int
178 );
179 insert into t5( b, c) values( 'recreated table', 9);
180 execute stmt2 ;
181 a b c
182 2004-02-29 18:01:59 recreated table 9
183 drop table t5 ;
184 create table t5
185 (
186 f1 int primary key,
187 f2 char(30),
188 f3 int
189 );
190 insert into t5( f1, f2, f3) values( 9, 'recreated table', 9);
191 execute stmt2 ;
192 f1 f2 f3
193 9 recreated table 9
194 drop table t5 ;
195 prepare stmt1 from ' select * from t1 where a <= 2 ' ;
196 execute stmt1 ;
197 a b
198 1 one
199 2 two
200 set @arg00=1 ;
201 set @arg01='two' ;
202 prepare stmt1 from ' select * from t1 where a <= ? ' ;
203 execute stmt1 using @arg00;
204 a b
205 1 one
206 execute stmt1 ;
207 ERROR HY000: Incorrect arguments to EXECUTE
208 execute stmt1 using @arg00, @arg01;
209 ERROR HY000: Incorrect arguments to EXECUTE
210 execute stmt1 using @not_set;
211 a b
212 deallocate prepare never_prepared ;
213 ERROR HY000: Unknown prepared statement handler (never_prepared) given to DEALLOCATE PREPARE
214 prepare stmt1 from ' select * from t1 where a <= 2 ' ;
215 prepare stmt1 from ' select * from not_exist where a <= 2 ' ;
216 ERROR 42S02: Table 'test.not_exist' doesn't exist
217 deallocate prepare stmt1;
218 ERROR HY000: Unknown prepared statement handler (stmt1) given to DEALLOCATE PREPARE
219 create table t5
220 (
221 a int primary key,
222 b char(10)
223 );
224 prepare stmt2 from ' select a,b from t5 where a <= 2 ' ;
225 drop table t5 ;
226 deallocate prepare stmt2;
227 prepare stmt1 from ' select a from t1 where a <= 2 ' ;
228 prepare stmt2 from ' select b from t1 where a <= 2 ' ;
229 execute stmt2 ;
230 b
231 one
232 two
233 execute stmt1 ;
234 a
235 1
236 2
237 prepare stmt1 from ' select a from t1 where a <= 2 ' ;
238 prepare stmt2 from ' select a from t1 where a <= 2 ' ;
239 execute stmt2 ;
240 a
241 1
242 2
243 execute stmt1 ;
244 a
245 1
246 2
247 deallocate prepare stmt1 ;
248 execute stmt2 ;
249 a
250 1
251 2
252 test_sequence
253 ------ show and misc tests ------
254 drop table if exists t2;
255 create table t2
256 (
257 a int primary key, b char(10)
258 );
259 prepare stmt4 from ' show databases ';
260 execute stmt4;
261 Database
262 information_schema
263 mtr
264 mysql
265 test
266 prepare stmt4 from ' show tables from test like ''t2%'' ';
267 execute stmt4;
268 Tables_in_test (t2%)
269 t2
270 prepare stmt4 from ' show columns from t2 where field in (select ?) ';
271 SET @arg00="a";
272 execute stmt4 using @arg00;
273 Field Type Null Key Default Extra
274 a int(11) NO PRI NULL
275 SET @arg00="b";
276 execute stmt4 using @arg00;
277 Field Type Null Key Default Extra
278 b char(10) YES NULL
279 SET @arg00=1;
280 execute stmt4 using @arg00;
281 Field Type Null Key Default Extra
282 prepare stmt4 from ' show columns from t2 from test like ''a%'' ';
283 execute stmt4;
284 Field Type Null Key Default Extra
285 a int(11) NO PRI NULL
286 create index t2_idx on t2(b);
287 prepare stmt4 from ' show index from t2 from test ';
288 execute stmt4;
289 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
290 t2 0 PRIMARY 1 a A 0 NULL NULL BTREE
291 t2 1 t2_idx 1 b A NULL NULL NULL YES BTREE
292 prepare stmt4 from ' show table status from test like ''t2%'' ';
293 execute stmt4;
294 Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
295 t2 MyISAM 10 Fixed 0 0 0 # 1024 0 NULL # # # latin1_swedish_ci NULL
296 prepare stmt4 from ' show table status from test like ''t9%'' ';
297 execute stmt4;
298 Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
299 t9 MyISAM 10 Dynamic 2 216 432 # 2048 0 NULL # # # latin1_swedish_ci NULL
300 prepare stmt4 from ' show status like ''Threads_running'' ';
301 execute stmt4;
302 Variable_name Value
303 Threads_running #
304 prepare stmt4 from ' show variables like ''sql_mode'' ';
305 execute stmt4;
306 Variable_name Value
307 sql_mode
308 prepare stmt4 from ' show engine myisam logs ';
309 execute stmt4;
310 Type Name Status
311 prepare stmt4 from ' show grants for user ';
312 prepare stmt4 from ' show create table t2 ';
313 prepare stmt4 from ' show master status ';
314 prepare stmt4 from ' show master logs ';
315 prepare stmt4 from ' show slave status ';
316 prepare stmt4 from ' show warnings limit 20 ';
317 prepare stmt4 from ' show errors limit 20 ';
318 prepare stmt4 from ' show storage engines ';
319 execute stmt4;
320 drop table if exists t5;
321 prepare stmt1 from ' drop table if exists t5 ' ;
322 execute stmt1 ;
323 Warnings:
324 Note 1051 Unknown table 't5'
325 prepare stmt1 from ' drop table t5 ' ;
326 execute stmt1 ;
327 ERROR 42S02: Unknown table 't5'
328 prepare stmt1 from ' SELECT @@version ' ;
329 execute stmt1 ;
330 @@version
331 <version>
332 prepare stmt_do from ' do @var:= (1 in (select a from t1)) ' ;
333 prepare stmt_set from ' set @var= (1 in (select a from t1)) ' ;
334 execute stmt_do ;
335 content of @var is:
336 1
337 execute stmt_set ;
338 content of @var is:
339 1
340 execute stmt_do ;
341 content of @var is:
342 1
343 execute stmt_set ;
344 content of @var is:
345 1
346 execute stmt_do ;
347 content of @var is:
348 1
349 execute stmt_set ;
350 content of @var is:
351 1
352 drop table if exists t5 ;
353 create table t5 (a int) ;
354 prepare stmt_do from ' do @var:= (1 in (select a from t5)) ' ;
355 prepare stmt_set from ' set @var= (1 in (select a from t5)) ' ;
356 execute stmt_do ;
357 content of @var is:
358 0
359 execute stmt_set ;
360 content of @var is:
361 0
362 execute stmt_do ;
363 content of @var is:
364 0
365 execute stmt_set ;
366 content of @var is:
367 0
368 execute stmt_do ;
369 content of @var is:
370 0
371 execute stmt_set ;
372 content of @var is:
373 0
374 drop table t5 ;
375 deallocate prepare stmt_do ;
376 deallocate prepare stmt_set ;
377 prepare stmt1 from ' prepare stmt2 from '' select 1 '' ' ;
378 ERROR HY000: This command is not supported in the prepared statement protocol yet
379 prepare stmt1 from ' execute stmt2 ' ;
380 ERROR HY000: This command is not supported in the prepared statement protocol yet
381 prepare stmt1 from ' deallocate prepare never_prepared ' ;
382 ERROR HY000: This command is not supported in the prepared statement protocol yet
383 prepare stmt1 from 'alter view v1 as select 2';
384 ERROR HY000: This command is not supported in the prepared statement protocol yet
385 prepare stmt4 from ' use test ' ;
386 ERROR HY000: This command is not supported in the prepared statement protocol yet
387 prepare stmt3 from ' create database mysqltest ';
388 create database mysqltest ;
389 prepare stmt3 from ' drop database mysqltest ';
390 drop database mysqltest ;
391 prepare stmt3 from ' describe t2 ';
392 execute stmt3;
393 Field Type Null Key Default Extra
394 a int(11) NO PRI NULL
395 b char(10) YES MUL NULL
396 drop table t2 ;
397 execute stmt3;
398 ERROR 42S02: Table 'test.t2' doesn't exist
399 prepare stmt3 from ' lock tables t1 read ' ;
400 ERROR HY000: This command is not supported in the prepared statement protocol yet
401 prepare stmt3 from ' unlock tables ' ;
402 ERROR HY000: This command is not supported in the prepared statement protocol yet
403 prepare stmt1 from ' load data infile ''<MYSQLTEST_VARDIR>/tmp/data.txt''
404 into table t1 fields terminated by ''\t'' ';
405 ERROR HY000: This command is not supported in the prepared statement protocol yet
406 prepare stmt1 from ' select * into outfile ''<MYSQLTEST_VARDIR>/tmp/data.txt'' from t1 ';
407 execute stmt1 ;
408 prepare stmt1 from ' optimize table t1 ' ;
409 prepare stmt1 from ' analyze table t1 ' ;
410 prepare stmt1 from ' checksum table t1 ' ;
411 prepare stmt1 from ' repair table t1 ' ;
412 prepare stmt1 from ' restore table t1 from ''<MYSQLTEST_VARDIR>/tmp/data.txt'' ' ;
413 ERROR HY000: This command is not supported in the prepared statement protocol yet
414 prepare stmt1 from ' handler t1 open ';
415 ERROR HY000: This command is not supported in the prepared statement protocol yet
416 prepare stmt3 from ' commit ' ;
417 prepare stmt3 from ' rollback ' ;
418 prepare stmt4 from ' SET sql_mode=ansi ';
419 execute stmt4;
420 select 'a' || 'b' ;
421 'a' || 'b'
422 ab
423 prepare stmt4 from ' SET sql_mode="" ';
424 execute stmt4;
425 select '2' || '3' ;
426 '2' || '3'
427 1
428 prepare stmt5 from ' select ''2'' || ''3'' ' ;
429 execute stmt5;
430 '2' || '3'
431 1
432 SET sql_mode=ansi;
433 execute stmt5;
434 '2' || '3'
435 1
436 SET sql_mode="";
437 prepare stmt1 from ' flush local privileges ' ;
438 prepare stmt1 from ' reset query cache ' ;
439 prepare stmt1 from ' KILL 0 ';
440 prepare stmt1 from ' explain select a from t1 order by b ';
441 execute stmt1;
442 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
443 def id 8 3 1 N 32929 0 63
444 def select_type 253 19 6 N 1 31 8
445 def table 253 64 2 Y 0 31 8
446 def type 253 10 3 Y 0 31 8
447 def possible_keys 253 4096 0 Y 0 31 8
448 def key 253 64 0 Y 0 31 8
449 def key_len 253 4096 0 Y 0 31 8
450 def ref 253 1024 0 Y 0 31 8
451 def rows 8 10 1 Y 32928 0 63
452 def Extra 253 255 14 N 1 31 8
453 id select_type table type possible_keys key key_len ref rows Extra
454 1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using filesort
455 SET @arg00=1 ;
456 prepare stmt1 from ' explain select a from t1 where a > ? order by b ';
457 execute stmt1 using @arg00;
458 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
459 def id 8 3 1 N 32929 0 63
460 def select_type 253 19 6 N 1 31 8
461 def table 253 64 2 Y 0 31 8
462 def type 253 10 5 Y 0 31 8
463 def possible_keys 253 4096 7 Y 0 31 8
464 def key 253 64 7 Y 0 31 8
465 def key_len 253 4096 1 Y 0 31 8
466 def ref 253 1024 0 Y 0 31 8
467 def rows 8 10 1 Y 32928 0 63
468 def Extra 253 255 27 N 1 31 8
469 id select_type table type possible_keys key key_len ref rows Extra
470 1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL 3 Using where; Using filesort
471 drop table if exists t2;
472 create table t2 (id smallint, name varchar(20)) ;
473 prepare stmt1 from ' insert into t2 values(?, ?) ' ;
474 set @id= 9876 ;
475 set @arg00= 'MySQL - Open Source Database' ;
476 set @arg01= "'" ;
477 set @arg02= '"' ;
478 set @arg03= "my'sql'" ;
479 set @arg04= 'my"sql"' ;
480 insert into t2 values ( @id , @arg00 );
481 Warnings:
482 Warning 1265 Data truncated for column 'name' at row 1
483 insert into t2 values ( @id , @arg01 );
484 insert into t2 values ( @id , @arg02 );
485 insert into t2 values ( @id , @arg03 );
486 insert into t2 values ( @id , @arg04 );
487 prepare stmt1 from ' select * from t2 where id= ? and name= ? ';
488 execute stmt1 using @id, @arg00 ;
489 id name
490 execute stmt1 using @id, @arg01 ;
491 id name
492 9876 '
493 execute stmt1 using @id, @arg02 ;
494 id name
495 9876 "
496 execute stmt1 using @id, @arg03 ;
497 id name
498 9876 my'sql'
499 execute stmt1 using @id, @arg04 ;
500 id name
501 9876 my"sql"
502 drop table t2;
503 test_sequence
504 ------ create/drop/alter/rename tests ------
505 drop table if exists t2, t3;
506 prepare stmt_drop from ' drop table if exists t2 ' ;
507 execute stmt_drop;
508 prepare stmt_create from ' create table t2 (
509 a int primary key, b char(10)) ';
510 execute stmt_create;
511 prepare stmt3 from ' create table t3 like t2 ';
512 execute stmt3;
513 drop table t3;
514 set @arg00=1;
515 prepare stmt3 from ' create table t3 (m int) select ? as m ' ;
516 execute stmt3 using @arg00;
517 select m from t3;
518 m
519 1
520 drop table t3;
521 prepare stmt3 from ' create index t2_idx on t2(b) ';
522 prepare stmt3 from ' drop index t2_idx on t2 ' ;
523 prepare stmt3 from ' alter table t2 drop primary key ';
524 drop table if exists new_t2;
525 prepare stmt3 from ' rename table t2 to new_t2 ';
526 execute stmt3;
527 execute stmt3;
528 ERROR 42S01: Table 'new_t2' already exists
529 rename table new_t2 to t2;
530 drop table t2;
531 prepare stmt1 from ' rename table t5 to t6, t7 to t8 ' ;
532 create table t5 (a int) ;
533 execute stmt1 ;
534 ERROR HY000: Can't find file: './test/t7' (errno: 2)
535 create table t7 (a int) ;
536 execute stmt1 ;
537 execute stmt1 ;
538 ERROR 42S01: Table 't6' already exists
539 rename table t6 to t5, t8 to t7 ;
540 execute stmt1 ;
541 drop table t6, t8 ;
542 test_sequence
543 ------ big statement tests ------
544 (select 'ABC' as my_const_col from t1 where
545 1 = 1 AND
546 1 = 1 AND
547 1 = 1 AND
548 1 = 1 AND
549 1 = 1 AND
550 1 = 1 AND
551 1 = 1 AND
552 1 = 1 AND
553 1 = 1 AND
554 1 = 1 AND
555 1 = 1 AND
556 1 = 1 AND
557 1 = 1 AND
558 1 = 1 AND
559 1 = 1 AND
560 1 = 1 AND
561 1 = 1 AND
562 1 = 1 AND
563 1 = 1 AND
564 1 = 1 AND
565 1 = 1 AND
566 1 = 1 AND
567 1 = 1 AND
568 1 = 1 AND
569 1 = 1 AND
570 1 = 1 AND
571 1 = 1 AND
572 1 = 1 AND
573 1 = 1 AND
574 1 = 1 AND
575 1 = 1 AND
576 1 = 1 AND
577 1 = 1 AND
578 1 = 1 AND
579 1 = 1 AND
580 1 = 1 AND
581 1 = 1 AND
582 1 = 1 AND
583 1 = 1 AND
584 1 = 1 AND
585 1 = 1 AND
586 1 = 1 AND
587 1 = 1 AND
588 1 = 1 AND
589 1 = 1 AND
590 1 = 1 AND
591 1 = 1 AND
592 1 = 1 AND
593 1 = 1 ) ;
594 my_const_col
595 ABC
596 ABC
597 ABC
598 ABC
599 prepare stmt1 from "select 'ABC' as my_const_col from t1 where
600 1 = 1 AND
601 1 = 1 AND
602 1 = 1 AND
603 1 = 1 AND
604 1 = 1 AND
605 1 = 1 AND
606 1 = 1 AND
607 1 = 1 AND
608 1 = 1 AND
609 1 = 1 AND
610 1 = 1 AND
611 1 = 1 AND
612 1 = 1 AND
613 1 = 1 AND
614 1 = 1 AND
615 1 = 1 AND
616 1 = 1 AND
617 1 = 1 AND
618 1 = 1 AND
619 1 = 1 AND
620 1 = 1 AND
621 1 = 1 AND
622 1 = 1 AND
623 1 = 1 AND
624 1 = 1 AND
625 1 = 1 AND
626 1 = 1 AND
627 1 = 1 AND
628 1 = 1 AND
629 1 = 1 AND
630 1 = 1 AND
631 1 = 1 AND
632 1 = 1 AND
633 1 = 1 AND
634 1 = 1 AND
635 1 = 1 AND
636 1 = 1 AND
637 1 = 1 AND
638 1 = 1 AND
639 1 = 1 AND
640 1 = 1 AND
641 1 = 1 AND
642 1 = 1 AND
643 1 = 1 AND
644 1 = 1 AND
645 1 = 1 AND
646 1 = 1 AND
647 1 = 1 AND
648 1 = 1 " ;
649 execute stmt1 ;
650 my_const_col
651 ABC
652 ABC
653 ABC
654 ABC
655 execute stmt1 ;
656 my_const_col
657 ABC
658 ABC
659 ABC
660 ABC
661 (select 'ABC' as my_const_col FROM t1 WHERE
662 '1234567890123456789012345678901234567890123456789012345678901234567890'
663 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
664 '1234567890123456789012345678901234567890123456789012345678901234567890'
665 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
666 '1234567890123456789012345678901234567890123456789012345678901234567890'
667 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
668 '1234567890123456789012345678901234567890123456789012345678901234567890'
669 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
670 '1234567890123456789012345678901234567890123456789012345678901234567890'
671 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
672 '1234567890123456789012345678901234567890123456789012345678901234567890'
673 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
674 '1234567890123456789012345678901234567890123456789012345678901234567890'
675 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
676 '1234567890123456789012345678901234567890123456789012345678901234567890'
677 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
678 '1234567890123456789012345678901234567890123456789012345678901234567890'
679 = '1234567890123456789012345678901234567890123456789012345678901234567890' ) ;
680 my_const_col
681 ABC
682 ABC
683 ABC
684 ABC
685 prepare stmt1 from "select 'ABC' as my_const_col FROM t1 WHERE
686 '1234567890123456789012345678901234567890123456789012345678901234567890'
687 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
688 '1234567890123456789012345678901234567890123456789012345678901234567890'
689 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
690 '1234567890123456789012345678901234567890123456789012345678901234567890'
691 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
692 '1234567890123456789012345678901234567890123456789012345678901234567890'
693 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
694 '1234567890123456789012345678901234567890123456789012345678901234567890'
695 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
696 '1234567890123456789012345678901234567890123456789012345678901234567890'
697 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
698 '1234567890123456789012345678901234567890123456789012345678901234567890'
699 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
700 '1234567890123456789012345678901234567890123456789012345678901234567890'
701 = '1234567890123456789012345678901234567890123456789012345678901234567890' AND
702 '1234567890123456789012345678901234567890123456789012345678901234567890'
703 = '1234567890123456789012345678901234567890123456789012345678901234567890' " ;
704 execute stmt1 ;
705 my_const_col
706 ABC
707 ABC
708 ABC
709 ABC
710 execute stmt1 ;
711 my_const_col
712 ABC
713 ABC
714 ABC
715 ABC
716 select 'ABC' as my_const_col FROM t1 WHERE
717 @arg00=@arg00 and @arg00=@arg00 and @arg00=@arg00 and @arg00=@arg00 and
718 @arg00=@arg00 and @arg00=@arg00 and @arg00=@arg00 and @arg00=@arg00 and
719 @arg00=@arg00 and @arg00=@arg00 and @arg00=@arg00 and @arg00=@arg00 and
720 @arg00=@arg00 and @arg00=@arg00 and @arg00=@arg00 and @arg00=@arg00 and
721 @arg00=@arg00 and @arg00=@arg00 and @arg00=@arg00 and @arg00=@arg00 and
722 @arg00=@arg00 and @arg00=@arg00 and @arg00=@arg00 and @arg00=@arg00 and
723 @arg00=@arg00 ;
724 my_const_col
725 ABC
726 ABC
727 ABC
728 ABC
729 prepare stmt1 from ' select ''ABC'' as my_const_col FROM t1 WHERE
730 ? = ? and ? = ? and ? = ? and ? = ? and
731 ? = ? and ? = ? and ? = ? and ? = ? and
732 ? = ? and ? = ? and ? = ? and ? = ? and
733 ? = ? and ? = ? and ? = ? and ? = ? and
734 ? = ? and ? = ? and ? = ? and ? = ? and
735 ? = ? and ? = ? and ? = ? and ? = ? and
736 ? = ? ' ;
737 execute stmt1 using
738 @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
739 @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
740 @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
741 @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
742 @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
743 @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
744 @arg00, @arg00;
745 my_const_col
746 ABC
747 ABC
748 ABC
749 ABC
750 execute stmt1 using
751 @arg00, @arg01, @arg02, @arg03, @arg04, @arg05, @arg06, @arg07,
752 @arg10, @arg11, @arg12, @arg13, @arg14, @arg15, @arg16, @arg17,
753 @arg20, @arg21, @arg22, @arg23, @arg24, @arg25, @arg26, @arg27,
754 @arg30, @arg31, @arg32, @arg33, @arg34, @arg35, @arg36, @arg37,
755 @arg40, @arg41, @arg42, @arg43, @arg44, @arg45, @arg46, @arg47,
756 @arg50, @arg51, @arg52, @arg53, @arg54, @arg55, @arg56, @arg57,
757 @arg60, @arg61 ;
758 my_const_col
759 ABC
760 ABC
761 ABC
762 ABC
763 drop table if exists t5 ;
764 set @col_num= 1000 ;
765 select @string as "" ;
767 create table t5( c999 int,c998 int,c997 int,c996 int,c995 int,c994 int,c993 int,c992 int,c991 int,c990 int,c989 int,c988 int,c987 int,c986 int,c985 int,c984 int,c983 int,c982 int,c981 int,c980 int,c979 int,c978 int,c977 int,c976 int,c975 int,c974 int,c973 int,c972 int,c971 int,c970 int,c969 int,c968 int,c967 int,c966 int,c965 int,c964 int,c963 int,c962 int,c961 int,c960 int,c959 int,c958 int,c957 int,c956 int,c955 int,c954 int,c953 int,c952 int,c951 int,c950 int,c949 int,c948 int,c947 int,c946 int,c945 int,c944 int,c943 int,c942 int,c941 int,c940 int,c939 int,c938 int,c937 int,c936 int,c935 int,c934 int,c933 int,c932 int,c931 int,c930 int,c929 int,c928 int,c927 int,c926 int,c925 int,c924 int,c923 int,c922 int,c921 int,c920 int,c919 int,c918 int,c917 int,c916 int,c915 int,c914 int,c913 int,c912 int,c911 int,c910 int,c909 int,c908 int,c907 int,c906 int,c905 int,c904 int,c903 int,c902 int,c901 int,c900 int,c899 int,c898 int,c897 int,c896 int,c895 int,c894 int,c893 int,c892 int,c891 int,c890 int,c889 int,c888 int,c887 int,c886 int,c885 int,c884 int,c883 int,c882 int,c881 int,c880 int,c879 int,c878 int,c877 int,c876 int,c875 int,c874 int,c873 int,c872 int,c871 int,c870 int,c869 int,c868 int,c867 int,c866 int,c865 int,c864 int,c863 int,c862 int,c861 int,c860 int,c859 int,c858 int,c857 int,c856 int,c855 int,c854 int,c853 int,c852 int,c851 int,c850 int,c849 int,c848 int,c847 int,c846 int,c845 int,c844 int,c843 int,c842 int,c841 int,c840 int,c839 int,c838 int,c837 int,c836 int,c835 int,c834 int,c833 int,c832 int,c831 int,c830 int,c829 int,c828 int,c827 int,c826 int,c825 int,c824 int,c823 int,c822 int,c821 int,c820 int,c819 int,c818 int,c817 int,c816 int,c815 int,c814 int,c813 int,c812 int,c811 int,c810 int,c809 int,c808 int,c807 int,c806 int,c805 int,c804 int,c803 int,c802 int,c801 int,c800 int,c799 int,c798 int,c797 int,c796 int,c795 int,c794 int,c793 int,c792 int,c791 int,c790 int,c789 int,c788 int,c787 int,c786 int,c785 int,c784 int,c783 int,c782 int,c781 int,c780 int,c779 int,c778 int,c777 int,c776 int,c775 int,c774 int,c773 int,c772 int,c771 int,c770 int,c769 int,c768 int,c767 int,c766 int,c765 int,c764 int,c763 int,c762 int,c761 int,c760 int,c759 int,c758 int,c757 int,c756 int,c755 int,c754 int,c753 int,c752 int,c751 int,c750 int,c749 int,c748 int,c747 int,c746 int,c745 int,c744 int,c743 int,c742 int,c741 int,c740 int,c739 int,c738 int,c737 int,c736 int,c735 int,c734 int,c733 int,c732 int,c731 int,c730 int,c729 int,c728 int,c727 int,c726 int,c725 int,c724 int,c723 int,c722 int,c721 int,c720 int,c719 int,c718 int,c717 int,c716 int,c715 int,c714 int,c713 int,c712 int,c711 int,c710 int,c709 int,c708 int,c707 int,c706 int,c705 int,c704 int,c703 int,c702 int,c701 int,c700 int,c699 int,c698 int,c697 int,c696 int,c695 int,c694 int,c693 int,c692 int,c691 int,c690 int,c689 int,c688 int,c687 int,c686 int,c685 int,c684 int,c683 int,c682 int,c681 int,c680 int,c679 int,c678 int,c677 int,c676 int,c675 int,c674 int,c673 int,c672 int,c671 int,c670 int,c669 int,c668 int,c667 int,c666 int,c665 int,c664 int,c663 int,c662 int,c661 int,c660 int,c659 int,c658 int,c657 int,c656 int,c655 int,c654 int,c653 int,c652 int,c651 int,c650 int,c649 int,c648 int,c647 int,c646 int,c645 int,c644 int,c643 int,c642 int,c641 int,c640 int,c639 int,c638 int,c637 int,c636 int,c635 int,c634 int,c633 int,c632 int,c631 int,c630 int,c629 int,c628 int,c627 int,c626 int,c625 int,c624 int,c623 int,c622 int,c621 int,c620 int,c619 int,c618 int,c617 int,c616 int,c615 int,c614 int,c613 int,c612 int,c611 int,c610 int,c609 int,c608 int,c607 int,c606 int,c605 int,c604 int,c603 int,c602 int,c601 int,c600 int,c599 int,c598 int,c597 int,c596 int,c595 int,c594 int,c593 int,c592 int,c591 int,c590 int,c589 int,c588 int,c587 int,c586 int,c585 int,c584 int,c583 int,c582 int,c581 int,c580 int,c579 int,c578 int,c577 int,c576 int,c575 int,c574 int,c573 int,c572 int,c571 int,c570 int,c569 int,c568 int,c567 int,c566 int,c565 int,c564 int,c563 int,c562 int,c561 int,c560 int,c559 int,c558 int,c557 int,c556 int,c555 int,c554 int,c553 int,c552 int,c551 int,c550 int,c549 int,c548 int,c547 int,c546 int,c545 int,c544 int,c543 int,c542 int,c541 int,c540 int,c539 int,c538 int,c537 int,c536 int,c535 int,c534 int,c533 int,c532 int,c531 int,c530 int,c529 int,c528 int,c527 int,c526 int,c525 int,c524 int,c523 int,c522 int,c521 int,c520 int,c519 int,c518 int,c517 int,c516 int,c515 int,c514 int,c513 int,c512 int,c511 int,c510 int,c509 int,c508 int,c507 int,c506 int,c505 int,c504 int,c503 int,c502 int,c501 int,c500 int,c499 int,c498 int,c497 int,c496 int,c495 int,c494 int,c493 int,c492 int,c491 int,c490 int,c489 int,c488 int,c487 int,c486 int,c485 int,c484 int,c483 int,c482 int,c481 int,c480 int,c479 int,c478 int,c477 int,c476 int,c475 int,c474 int,c473 int,c472 int,c471 int,c470 int,c469 int,c468 int,c467 int,c466 int,c465 int,c464 int,c463 int,c462 int,c461 int,c460 int,c459 int,c458 int,c457 int,c456 int,c455 int,c454 int,c453 int,c452 int,c451 int,c450 int,c449 int,c448 int,c447 int,c446 int,c445 int,c444 int,c443 int,c442 int,c441 int,c440 int,c439 int,c438 int,c437 int,c436 int,c435 int,c434 int,c433 int,c432 int,c431 int,c430 int,c429 int,c428 int,c427 int,c426 int,c425 int,c424 int,c423 int,c422 int,c421 int,c420 int,c419 int,c418 int,c417 int,c416 int,c415 int,c414 int,c413 int,c412 int,c411 int,c410 int,c409 int,c408 int,c407 int,c406 int,c405 int,c404 int,c403 int,c402 int,c401 int,c400 int,c399 int,c398 int,c397 int,c396 int,c395 int,c394 int,c393 int,c392 int,c391 int,c390 int,c389 int,c388 int,c387 int,c386 int,c385 int,c384 int,c383 int,c382 int,c381 int,c380 int,c379 int,c378 int,c377 int,c376 int,c375 int,c374 int,c373 int,c372 int,c371 int,c370 int,c369 int,c368 int,c367 int,c366 int,c365 int,c364 int,c363 int,c362 int,c361 int,c360 int,c359 int,c358 int,c357 int,c356 int,c355 int,c354 int,c353 int,c352 int,c351 int,c350 int,c349 int,c348 int,c347 int,c346 int,c345 int,c344 int,c343 int,c342 int,c341 int,c340 int,c339 int,c338 int,c337 int,c336 int,c335 int,c334 int,c333 int,c332 int,c331 int,c330 int,c329 int,c328 int,c327 int,c326 int,c325 int,c324 int,c323 int,c322 int,c321 int,c320 int,c319 int,c318 int,c317 int,c316 int,c315 int,c314 int,c313 int,c312 int,c311 int,c310 int,c309 int,c308 int,c307 int,c306 int,c305 int,c304 int,c303 int,c302 int,c301 int,c300 int,c299 int,c298 int,c297 int,c296 int,c295 int,c294 int,c293 int,c292 int,c291 int,c290 int,c289 int,c288 int,c287 int,c286 int,c285 int,c284 int,c283 int,c282 int,c281 int,c280 int,c279 int,c278 int,c277 int,c276 int,c275 int,c274 int,c273 int,c272 int,c271 int,c270 int,c269 int,c268 int,c267 int,c266 int,c265 int,c264 int,c263 int,c262 int,c261 int,c260 int,c259 int,c258 int,c257 int,c256 int,c255 int,c254 int,c253 int,c252 int,c251 int,c250 int,c249 int,c248 int,c247 int,c246 int,c245 int,c244 int,c243 int,c242 int,c241 int,c240 int,c239 int,c238 int,c237 int,c236 int,c235 int,c234 int,c233 int,c232 int,c231 int,c230 int,c229 int,c228 int,c227 int,c226 int,c225 int,c224 int,c223 int,c222 int,c221 int,c220 int,c219 int,c218 int,c217 int,c216 int,c215 int,c214 int,c213 int,c212 int,c211 int,c210 int,c209 int,c208 int,c207 int,c206 int,c205 int,c204 int,c203 int,c202 int,c201 int,c200 int,c199 int,c198 int,c197 int,c196 int,c195 int,c194 int,c193 int,c192 int,c191 int,c190 int,c189 int,c188 int,c187 int,c186 int,c185 int,c184 int,c183 int,c182 int,c181 int,c180 int,c179 int,c178 int,c177 int,c176 int,c175 int,c174 int,c173 int,c172 int,c171 int,c170 int,c169 int,c168 int,c167 int,c166 int,c165 int,c164 int,c163 int,c162 int,c161 int,c160 int,c159 int,c158 int,c157 int,c156 int,c155 int,c154 int,c153 int,c152 int,c151 int,c150 int,c149 int,c148 int,c147 int,c146 int,c145 int,c144 int,c143 int,c142 int,c141 int,c140 int,c139 int,c138 int,c137 int,c136 int,c135 int,c134 int,c133 int,c132 int,c131 int,c130 int,c129 int,c128 int,c127 int,c126 int,c125 int,c124 int,c123 int,c122 int,c121 int,c120 int,c119 int,c118 int,c117 int,c116 int,c115 int,c114 int,c113 int,c112 int,c111 int,c110 int,c109 int,c108 int,c107 int,c106 int,c105 int,c104 int,c103 int,c102 int,c101 int,c100 int,c99 int,c98 int,c97 int,c96 int,c95 int,c94 int,c93 int,c92 int,c91 int,c90 int,c89 int,c88 int,c87 int,c86 int,c85 int,c84 int,c83 int,c82 int,c81 int,c80 int,c79 int,c78 int,c77 int,c76 int,c75 int,c74 int,c73 int,c72 int,c71 int,c70 int,c69 int,c68 int,c67 int,c66 int,c65 int,c64 int,c63 int,c62 int,c61 int,c60 int,c59 int,c58 int,c57 int,c56 int,c55 int,c54 int,c53 int,c52 int,c51 int,c50 int,c49 int,c48 int,c47 int,c46 int,c45 int,c44 int,c43 int,c42 int,c41 int,c40 int,c39 int,c38 int,c37 int,c36 int,c35 int,c34 int,c33 int,c32 int,c31 int,c30 int,c29 int,c28 int,c27 int,c26 int,c25 int,c24 int,c23 int,c22 int,c21 int,c20 int,c19 int,c18 int,c17 int,c16 int,c15 int,c14 int,c13 int,c12 int,c11 int,c10 int,c9 int,c8 int,c7 int,c6 int,c5 int,c4 int,c3 int,c2 int,c1 int,c0 int)
768 prepare stmt1 from @string ;
769 execute stmt1 ;
770 select @string as "" ;
772 insert into t5 values(1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 ,1 )
773 prepare stmt1 from @string ;
774 execute stmt1 ;
775 prepare stmt1 from ' select * from t5 ' ;
776 execute stmt1 ;
777 drop table t1, t5, t9;