use test;
drop table if exists t1, t9 ;
create table t1
(
a int, b varchar(30),
primary key(a)
) engine = 'MYISAM';
create table t9
(
c1 tinyint, c2 smallint, c3 mediumint, c4 int,
c5 integer, c6 bigint, c7 float, c8 double,
c9 double precision, c10 real, c11 decimal(7, 4), c12 numeric(8, 4),
c13 date, c14 datetime, c15 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP, c16 time,
c17 year, c18 tinyint, c19 bool, c20 char,
c21 char(10), c22 varchar(30), c23 tinyblob, c24 tinytext,
c25 blob, c26 text, c27 mediumblob, c28 mediumtext,
c29 longblob, c30 longtext, c31 enum('one', 'two', 'three'),
c32 set('monday', 'tuesday', 'wednesday'),
primary key(c1)
) engine = 'MYISAM';
delete from t1 ;
insert into t1 values (1,'one');
insert into t1 values (2,'two');
insert into t1 values (3,'three');
insert into t1 values (4,'four');
commit ;
delete from t9 ;
insert into t9 set c1= 1, c2= 1, c3= 1, c4= 1, c5= 1, c6= 1, c7= 1, c8= 1, c9= 1,
c10= 1, c11= 1, c12 = 1,
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
c16= '11:11:11', c17= '2004',
c18= 1, c19=true, c20= 'a', c21= '123456789a',
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
c29= 'longblob', c30= 'longtext', c31='one', c32= 'monday';
insert into t9 set c1= 9, c2= 9, c3= 9, c4= 9, c5= 9, c6= 9, c7= 9, c8= 9, c9= 9,
c10= 9, c11= 9, c12 = 9,
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
c16= '11:11:11', c17= '2004',
c18= 1, c19=false, c20= 'a', c21= '123456789a',
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
c29= 'longblob', c30= 'longtext', c31='two', c32= 'tuesday';
commit ;
test_sequence
------ simple select tests ------
prepare stmt1 from ' select * from t9 order by c1 ';
execute stmt1;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
def test t9 t9 c1 c1 141 N 53251063
def test t9 t9 c2 c2 261 Y 32768063
def test t9 t9 c3 c3 991 Y 32768063
def test t9 t9 c4 c4 3111 Y 32768063
def test t9 t9 c5 c5 3111 Y 32768063
def test t9 t9 c6 c6 8201 Y 32768063
def test t9 t9 c7 c7 4121 Y 327683163
def test t9 t9 c8 c8 5221 Y 327683163
def test t9 t9 c9 c9 5221 Y 327683163
def test t9 t9 c10 c10 5221 Y 327683163
def test t9 t9 c11 c11 24696 Y 32768463
def test t9 t9 c12 c12 246106 Y 32768463
def test t9 t9 c13 c13 101010 Y 128063
def test t9 t9 c14 c14 121919 Y 128063
def test t9 t9 c15 c15 71919 N 9377063
def test t9 t9 c16 c16 11108 Y 128063
def test t9 t9 c17 c17 1344 Y 32864063
def test t9 t9 c18 c18 141 Y 32768063
def test t9 t9 c19 c19 111 Y 32768063
def test t9 t9 c20 c20 25411 Y 008
def test t9 t9 c21 c21 2541010 Y 008
def test t9 t9 c22 c22 2533030 Y 008
def test t9 t9 c23 c23 2522558 Y 144063
def test t9 t9 c24 c24 2522558 Y 1608
def test t9 t9 c25 c25 252655354 Y 144063
def test t9 t9 c26 c26 252655354 Y 1608
def test t9 t9 c27 c27 2521677721510 Y 144063
def test t9 t9 c28 c28 2521677721510 Y 1608
def test t9 t9 c29 c29 25242949672958 Y 144063
def test t9 t9 c30 c30 25242949672958 Y 1608
def test t9 t9 c31 c31 25453 Y 25608
def test t9 t9 c32 c32 254247 Y 204808
c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21 c22 c23 c24 c25 c26 c27 c28 c29 c30 c31 c32 11111111111.00001.00002004-02-292004-02-2911:11:112004-02-2911:11:1111:11:11200411 a 123456789a 123456789a123456789b123456789c tinyblob tinytext blob text mediumblob mediumtext longblob longtext one monday 99999999999.00009.00002004-02-292004-02-2911:11:112004-02-2911:11:1111:11:11200410 a 123456789a 123456789a123456789b123456789c tinyblob tinytext blob text mediumblob mediumtext longblob longtext two tuesday set @arg00='SELECT';
@arg00 a from t1 where a=1; ERROR42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@arg00 a from t1 where a=1' at line 1
prepare stmt1 from ' ? a from t1 where a=1 '; ERROR42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? a from t1 where a=1' at line 1 set @arg00=1;
select @arg00, b from t1 where a=1;
@arg00 b 1 one
prepare stmt1 from ' select ?, b from t1 where a=1 ';
execute stmt1 using @arg00 ;
? b 1 one set @arg00='lion';
select @arg00, b from t1 where a=1;
@arg00 b
lion one
prepare stmt1 from ' select ?, b from t1 where a=1 ';
execute stmt1 using @arg00 ;
? b
lion one set @arg00=NULL ;
select @arg00, b from t1 where a=1;
@arg00 b
NULL one
prepare stmt1 from ' select ?, b from t1 where a=1 ';
execute stmt1 using @arg00 ;
? b
NULL one set @arg00=1;
select b, a - @arg00 from t1 where a=1;
b a - @arg00
one 0
prepare stmt1 from ' select b, a - ? from t1 where a=1 ';
execute stmt1 using @arg00 ;
b a - ?
one 0 set @arg00=null ;
select @arg00 as my_col ;
my_col
NULL
prepare stmt1 from ' select ? as my_col';
execute stmt1 using @arg00 ;
my_col
NULL
select @arg00 + 1 as my_col ;
my_col
NULL
prepare stmt1 from ' select ? + 1 as my_col';
execute stmt1 using @arg00 ;
my_col
NULL
select 1 + @arg00 as my_col ;
my_col
NULL
prepare stmt1 from ' select 1 + ? as my_col';
execute stmt1 using @arg00 ;
my_col
NULL set @arg00='MySQL';
select substr(@arg00,1,2) from t1 where a=1;
substr(@arg00,1,2)
My
prepare stmt1 from ' select substr(?,1,2) from t1 where a=1 ';
execute stmt1 using @arg00 ;
substr(?,1,2)
My set @arg00=3;
select substr('MySQL',@arg00,5) from t1 where a=1;
substr('MySQL',@arg00,5)
SQL
prepare stmt1 from ' select substr(''MySQL'',?,5) from t1 where a=1 ';
execute stmt1 using @arg00 ;
substr('MySQL',?,5)
SQL
select substr('MySQL',1,@arg00) from t1 where a=1;
substr('MySQL',1,@arg00)
MyS
prepare stmt1 from ' select substr(''MySQL'',1,?) from t1 where a=1 ';
execute stmt1 using @arg00 ;
substr('MySQL',1,?)
MyS set @arg00='MySQL';
select a , concat(@arg00,b) from t1 order by a;
a concat(@arg00,b) 1 MySQLone 2 MySQLtwo 3 MySQLthree 4 MySQLfour
prepare stmt1 from ' select a , concat(?,b) from t1 order by a ';
execute stmt1 using @arg00;
a concat(?,b) 1 MySQLone 2 MySQLtwo 3 MySQLthree 4 MySQLfour
select a , concat(b,@arg00) from t1 order by a ;
a concat(b,@arg00) 1 oneMySQL 2 twoMySQL 3 threeMySQL 4 fourMySQL
prepare stmt1 from ' select a , concat(b,?) from t1 order by a ';
execute stmt1 using @arg00;
a concat(b,?) 1 oneMySQL 2 twoMySQL 3 threeMySQL 4 fourMySQL set @arg00='MySQL';
select group_concat(@arg00,b order by a) from t1
group by 'a';
group_concat(@arg00,b order by a)
MySQLone,MySQLtwo,MySQLthree,MySQLfour
prepare stmt1 from ' select group_concat(?,b order by a) from t1
group by ''a''' ;
execute stmt1 using @arg00;
group_concat(?,b order by a)
MySQLone,MySQLtwo,MySQLthree,MySQLfour
select group_concat(b,@arg00 order by a) from t1
group by 'a';
group_concat(b,@arg00 order by a)
oneMySQL,twoMySQL,threeMySQL,fourMySQL
prepare stmt1 from ' select group_concat(b,? order by a) from t1
group by ''a''' ;
execute stmt1 using @arg00;
group_concat(b,? order by a)
oneMySQL,twoMySQL,threeMySQL,fourMySQL set @arg00='first'; set @arg01='second'; set @arg02=NULL;
select @arg00, @arg01 from t1 where a=1;
@arg00 @arg01
first second
prepare stmt1 from ' select ?, ? from t1 where a=1 ';
execute stmt1 using @arg00, @arg01 ;
? ?
first second
execute stmt1 using @arg02, @arg01 ;
? ?
NULL second
execute stmt1 using @arg00, @arg02 ;
? ?
first NULL
execute stmt1 using @arg02, @arg02 ;
? ?
NULL NULL
drop table if exists t5 ;
create table t5 (id1 int(11) not null default '0',
value2 varchar(100), value1 varchar(100)) ;
insert into t5 values (1,'hh','hh'),(2,'hh','hh'),
(1,'ii','ii'),(2,'ii','ii') ;
prepare stmt1 from ' select id1,value1 from t5 where id1=? or value1=? order by id1,value1 '; set @arg00=1; set @arg01='hh';
execute stmt1 using @arg00, @arg01 ;
id1 value1 1 hh 1 ii 2 hh
drop table t5 ;
drop table if exists t5 ;
create table t5(session_id char(9) not null) ;
insert into t5 values ('abc') ;
prepare stmt1 from ' select * from t5
where ?=''1111''and session_id = ''abc''' ; set @arg00='abc';
execute stmt1 using @arg00 ;
session_id set @arg00='1111';
execute stmt1 using @arg00 ;
session_id
abc set @arg00='abc';
execute stmt1 using @arg00 ;
session_id
drop table t5 ; set @arg00='FROM';
select a @arg00 t1 where a=1; ERROR42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@arg00 t1 where a=1' at line 1
prepare stmt1 from ' select a ? t1 where a=1 '; ERROR42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? t1 where a=1' at line 1 set @arg00='t1';
select a from @arg00 where a=1; ERROR42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@arg00 where a=1' at line 1
prepare stmt1 from ' select a from ? where a=1 '; ERROR42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? where a=1' at line 1 set @arg00='WHERE';
select a from t1 @arg00 a=1; ERROR42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@arg00 a=1' at line 1
prepare stmt1 from ' select a from t1 ? a=1 '; ERROR42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? a=1' at line 1 set @arg00=1;
select a FROM t1 where a=@arg00 ;
a 1
prepare stmt1 from ' select a FROM t1 where a=? ';
execute stmt1 using @arg00 ;
a 1 set @arg00=1000;
execute stmt1 using @arg00 ;
a set @arg00=NULL ;
select a FROM t1 where a=@arg00 ;
a
prepare stmt1 from ' select a FROM t1 where a=? ';
execute stmt1 using @arg00 ;
a set @arg00=4;
select a FROM t1 where a=sqrt(@arg00) ;
a 2
prepare stmt1 from ' select a FROM t1 where a=sqrt(?) ';
execute stmt1 using @arg00 ;
a 2 set @arg00=NULL ;
select a FROM t1 where a=sqrt(@arg00) ;
a
prepare stmt1 from ' select a FROM t1 where a=sqrt(?) ';
execute stmt1 using @arg00 ;
a set @arg00=2; set @arg01=3;
select a FROM t1 where a in (@arg00,@arg01) order by a;
a 2 3
prepare stmt1 from ' select a FROM t1 where a in (?,?) order by a ';
execute stmt1 using @arg00, @arg01;
a 2 3 set @arg00= 'one'; set @arg01= 'two'; set @arg02= 'five';
prepare stmt1 from ' select b FROM t1 where b in (?,?,?) order by b ';
execute stmt1 using @arg00, @arg01, @arg02 ;
b
one
two
prepare stmt1 from ' select b FROM t1 where b like ? '; set @arg00='two';
execute stmt1 using @arg00 ;
b
two set @arg00='tw%';
execute stmt1 using @arg00 ;
b
two set @arg00='%wo';
execute stmt1 using @arg00 ;
b
two set @arg00=null ;
insert into t9 set c1= 0, c5 = NULL ;
select c5 from t9 where c5 > NULL ;
c5
prepare stmt1 from ' select c5 from t9 where c5 > ? ';
execute stmt1 using @arg00 ;
c5
select c5 from t9 where c5 < NULL ;
c5
prepare stmt1 from ' select c5 from t9 where c5 < ? ';
execute stmt1 using @arg00 ;
c5
select c5 from t9 where c5 = NULL ;
c5
prepare stmt1 from ' select c5 from t9 where c5 = ? ';
execute stmt1 using @arg00 ;
c5
select c5 from t9 where c5 <=> NULL ;
c5
NULL
prepare stmt1 from ' select c5 from t9 where c5 <=> ? ';
execute stmt1 using @arg00 ;
c5
NULL
delete from t9 where c1= 0; set @arg00='>';
select a FROM t1 where a @arg00 1; ERROR42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@arg00 1' at line 1
prepare stmt1 from ' select a FROM t1 where a ? 1 '; ERROR42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? 1' at line 1 set @arg00=1;
select a,b FROM t1 where a is not NULL AND b is not NULL group by a - @arg00 ;
a b 1 one 2 two 3 three 4 four
prepare stmt1 from ' select a,b FROM t1 where a is not NULL AND b is not NULL group by a - ? ' ;
execute stmt1 using @arg00 ;
a b 1 one 2 two 3 three 4 four set @arg00='two';
select a,b FROM t1 where a is not NULL AND b is not NULL having b <> @arg00 order by a ;
a b 1 one 3 three 4 four
prepare stmt1 from ' select a,b FROM t1 where a is not NULL AND b is not NULL having b <> ? order by a ' ;
execute stmt1 using @arg00 ;
a b 1 one 3 three 4 four set @arg00=1;
select a,b FROM t1 where a is not NULL AND b is not NULL order by a - @arg00 ;
a b 1 one 2 two 3 three 4 four
prepare stmt1 from ' select a,b FROM t1 where a is not NULL AND b is not NULL order by a - ? ' ;
execute stmt1 using @arg00 ;
a b 1 one 2 two 3 three 4 four set @arg00=2;
select a,b from t1 order by 2;
a b 4 four 1 one 3 three 2 two
prepare stmt1 from ' select a,b from t1
order by ? ';
execute stmt1 using @arg00;
a b 4 four 1 one 3 three 2 two set @arg00=1;
execute stmt1 using @arg00;
a b 1 one 2 two 3 three 4 four set @arg00=0;
execute stmt1 using @arg00; ERROR42S22: Unknown column '0' in 'ORDER BY' set @arg00=1;
prepare stmt1 from ' select a,b from t1 order by a
limit 1';
execute stmt1 ;
a b 1 one
prepare stmt1 from ' select a,b from t1 order by a limit ? ';
execute stmt1 using @arg00;
a b 1 one set @arg00='b'; set @arg01=0; set @arg02=2; set @arg03=2;
select sum(a), @arg00 from t1 where a > @arg01 and b is not null group by substr(b,@arg02)
having sum(a) <> @arg03 ;
sum(a) @arg00 3 b 1 b 4 b
prepare stmt1 from ' select sum(a), ? from t1 where a > ? and b is not null group by substr(b,?)
having sum(a) <> ? ';
execute stmt1 using @arg00, @arg01, @arg02, @arg03;
sum(a) ? 3 b 1 b 4 b
test_sequence
------ join tests ------
select first.a as a1, second.a as a2
from t1 first, t1 second
where first.a = second.a order by a1 ;
a1 a2 11 22 33 44
prepare stmt1 from ' select first.a as a1, second.a as a2
from t1 first, t1 second
where first.a = second.a order by a1 ';
execute stmt1 ;
a1 a2 11 22 33 44 set @arg00='ABC'; set @arg01='two'; set @arg02='one';
select first.a, @arg00, second.a FROM t1 first, t1 second
where @arg01 = first.b or first.a = second.a or second.b = @arg02
order by second.a, first.a;
a @arg00 a 1 ABC 1 2 ABC 1 3 ABC 1 4 ABC 1 2 ABC 2 2 ABC 3 3 ABC 3 2 ABC 4 4 ABC 4
prepare stmt1 from ' select first.a, ?, second.a FROM t1 first, t1 second
where ? = first.b or first.a = second.a or second.b = ?
order by second.a, first.a';
execute stmt1 using @arg00, @arg01, @arg02;
a ? a 1 ABC 1 2 ABC 1 3 ABC 1 4 ABC 1 2 ABC 2 2 ABC 3 3 ABC 3 2 ABC 4 4 ABC 4
drop table if exists t2 ;
create table t2 as select * from t1 ; set @query1= 'SELECT * FROM t2 join t1 on (t1.a=t2.a) order by t2.a '; set @query2= 'SELECT * FROM t2 natural join t1 order by t2.a '; set @query3= 'SELECT * FROM t2 join t1 using(a) order by t2.a '; set @query4= 'SELECT * FROM t2 left join t1 on(t1.a=t2.a) order by t2.a '; set @query5= 'SELECT * FROM t2 natural left join t1 order by t2.a '; set @query6= 'SELECT * FROM t2 left join t1 using(a) order by t2.a '; set @query7= 'SELECT * FROM t2 right join t1 on(t1.a=t2.a) order by t2.a '; set @query8= 'SELECT * FROM t2 natural right join t1 order by t2.a '; set @query9= 'SELECT * FROM t2 right join t1 using(a) order by t2.a ';
the join statement is:
SELECT * FROM t2 right join t1 using(a) order by t2.a
prepare stmt1 from @query9 ;
execute stmt1 ;
a b b 1 one one 2 two two 3 three three 4 four four
execute stmt1 ;
a b b 1 one one 2 two two 3 three three 4 four four
execute stmt1 ;
a b b 1 one one 2 two two 3 three three 4 four four
the join statement is:
SELECT * FROM t2 natural right join t1 order by t2.a
prepare stmt1 from @query8 ;
execute stmt1 ;
a b 1 one 2 two 3 three 4 four
execute stmt1 ;
a b 1 one 2 two 3 three 4 four
execute stmt1 ;
a b 1 one 2 two 3 three 4 four
the join statement is:
SELECT * FROM t2 right join t1 on(t1.a=t2.a) order by t2.a
prepare stmt1 from @query7 ;
execute stmt1 ;
a b a b 1 one 1 one 2 two 2 two 3 three 3 three 4 four 4 four
execute stmt1 ;
a b a b 1 one 1 one 2 two 2 two 3 three 3 three 4 four 4 four
execute stmt1 ;
a b a b 1 one 1 one 2 two 2 two 3 three 3 three 4 four 4 four
the join statement is:
SELECT * FROM t2 left join t1 using(a) order by t2.a
prepare stmt1 from @query6 ;
execute stmt1 ;
a b b 1 one one 2 two two 3 three three 4 four four
execute stmt1 ;
a b b 1 one one 2 two two 3 three three 4 four four
execute stmt1 ;
a b b 1 one one 2 two two 3 three three 4 four four
the join statement is:
SELECT * FROM t2 natural left join t1 order by t2.a
prepare stmt1 from @query5 ;
execute stmt1 ;
a b 1 one 2 two 3 three 4 four
execute stmt1 ;
a b 1 one 2 two 3 three 4 four
execute stmt1 ;
a b 1 one 2 two 3 three 4 four
the join statement is:
SELECT * FROM t2 left join t1 on(t1.a=t2.a) order by t2.a
prepare stmt1 from @query4 ;
execute stmt1 ;
a b a b 1 one 1 one 2 two 2 two 3 three 3 three 4 four 4 four
execute stmt1 ;
a b a b 1 one 1 one 2 two 2 two 3 three 3 three 4 four 4 four
execute stmt1 ;
a b a b 1 one 1 one 2 two 2 two 3 three 3 three 4 four 4 four
the join statement is:
SELECT * FROM t2 join t1 using(a) order by t2.a
prepare stmt1 from @query3 ;
execute stmt1 ;
a b b 1 one one 2 two two 3 three three 4 four four
execute stmt1 ;
a b b 1 one one 2 two two 3 three three 4 four four
execute stmt1 ;
a b b 1 one one 2 two two 3 three three 4 four four
the join statement is:
SELECT * FROM t2 natural join t1 order by t2.a
prepare stmt1 from @query2 ;
execute stmt1 ;
a b 1 one 2 two 3 three 4 four
execute stmt1 ;
a b 1 one 2 two 3 three 4 four
execute stmt1 ;
a b 1 one 2 two 3 three 4 four
the join statement is:
SELECT * FROM t2 join t1 on (t1.a=t2.a) order by t2.a
prepare stmt1 from @query1 ;
execute stmt1 ;
a b a b 1 one 1 one 2 two 2 two 3 three 3 three 4 four 4 four
execute stmt1 ;
a b a b 1 one 1 one 2 two 2 two 3 three 3 three 4 four 4 four
execute stmt1 ;
a b a b 1 one 1 one 2 two 2 two 3 three 3 three 4 four 4 four
drop table t2 ;
test_sequence
------ subquery tests ------
prepare stmt1 from ' select a, b FROM t1 outer_table where
a = (select a from t1 where b = ''two'') ';
execute stmt1 ;
a b 2 two set @arg00='two';
select a, b FROM t1 outer_table where
a = (select a from t1 where b = 'two' ) and b=@arg00 ;
a b 2 two
prepare stmt1 from ' select a, b FROM t1 outer_table where
a = (select a from t1 where b = ''two'') and b=? ';
execute stmt1 using @arg00;
a b 2 two set @arg00='two';
select a, b FROM t1 outer_table where
a = (select a from t1 where b = @arg00 ) and b='two';
a b 2 two
prepare stmt1 from ' select a, b FROM t1 outer_table where
a = (select a from t1 where b = ? ) and b=''two''' ;
execute stmt1 using @arg00;
a b 2 two set @arg00=3; set @arg01='three';
select a,b FROM t1 where (a,b) in (select 3, 'three');
a b 3 three
select a FROM t1 where (a,b) in (select @arg00,@arg01);
a 3
prepare stmt1 from ' select a FROM t1 where (a,b) in (select ?, ?) ';
execute stmt1 using @arg00, @arg01;
a 3 set @arg00=1; set @arg01='two'; set @arg02=2; set @arg03='two';
select a, @arg00, b FROM t1 outer_table where
b=@arg01 and a = (select @arg02 from t1 where b = @arg03 ) ;
a @arg00 b 21 two
prepare stmt1 from ' select a, ?, b FROM t1 outer_table where
b=? and a = (select ? from t1 where b = ? ) ' ;
execute stmt1 using @arg00, @arg01, @arg02, @arg03 ;
a ? b 21 two
prepare stmt1 from 'select c4 FROM t9 where
c13 = (select MAX(b) from t1 where a = ?) and c22 = ? ' ;
execute stmt1 using @arg01, @arg02;
c4
prepare stmt1 from ' select a, b FROM t1 outer_table where
a = (select a from t1 where b = outer_table.b ) order by a ';
execute stmt1 ;
a b 1 one 2 two 3 three 4 four
prepare stmt1 from ' SELECT a as ccc from t1 outr where a+1=
(SELECT 1+outr.a from t1 where outr.a+1=a+1and a=1) ';
execute stmt1 ;
ccc 1
deallocate prepare stmt1 ;
prepare stmt1 from ' SELECT a as ccc from t1 outr where a+1=
(SELECT 1+outr.a from t1 where outr.a+1=a+1and a=1) ';
execute stmt1 ;
ccc 1
deallocate prepare stmt1 ;
prepare stmt1 from ' SELECT a as ccc from t1 outr where a+1=
(SELECT 1+outr.a from t1 where outr.a+1=a+1and a=1) ';
execute stmt1 ;
ccc 1
deallocate prepare stmt1 ; set @arg00='two';
select a, b FROM t1 outer_table where
a = (select a from t1 where b = outer_table.b ) and b=@arg00 ;
a b 2 two
prepare stmt1 from ' select a, b FROM t1 outer_table where
a = (select a from t1 where b = outer_table.b) and b=? ';
execute stmt1 using @arg00;
a b 2 two set @arg00=2;
select a, b FROM t1 outer_table where
a = (select a from t1 where a = @arg00 and b = outer_table.b) and b='two';
a b 2 two
prepare stmt1 from ' select a, b FROM t1 outer_table where
a = (select a from t1 where a = ? and b = outer_table.b) and b=''two''' ;
execute stmt1 using @arg00;
a b 2 two set @arg00=2;
select a, b FROM t1 outer_table where
a = (select a from t1 where outer_table.a = @arg00 and a=2) and b='two';
a b 2 two
prepare stmt1 from ' select a, b FROM t1 outer_table where
a = (select a from t1 where outer_table.a = ? and a=2) and b=''two''' ;
execute stmt1 using @arg00;
a b 2 two set @arg00=1; set @arg01='two'; set @arg02=2; set @arg03='two';
select a, @arg00, b FROM t1 outer_table where
b=@arg01 and a = (select @arg02 from t1 where outer_table.b = @arg03 and outer_table.a=a ) ;
a @arg00 b 21 two
prepare stmt1 from ' select a, ?, b FROM t1 outer_table where
b=? and a = (select ? from t1 where outer_table.b = ? and outer_table.a=a ) ' ;
execute stmt1 using @arg00, @arg01, @arg02, @arg03 ;
a ? b 21 two set @arg00=1; set @arg01=0;
select a, @arg00
from ( select a - @arg00 as a from t1 where a=@arg00 ) as t2
where a=@arg01;
a @arg00 01
prepare stmt1 from ' select a, ?
from ( select a - ? as a from t1 where a=? ) as t2
where a=? ';
execute stmt1 using @arg00, @arg00, @arg00, @arg01 ;
a ? 01
drop table if exists t2 ;
create table t2 as select * from t1;
prepare stmt1 from ' select a in (select a from t2) from t1 ';
execute stmt1 ;
a in (select a from t2) 1 1 1 1
drop table if exists t5, t6, t7 ;
create table t5 (a int , b int) ;
create table t6 like t5 ;
create table t7 like t5 ;
insert into t5 values (0, 100), (1, 2), (1, 3), (2, 2), (2, 7),
(2, -1), (3, 10) ;
insert into t6 values (0, 0), (1, 1), (2, 1), (3, 1), (4, 1) ;
insert into t7 values (3, 3), (2, 2), (1, 1) ;
prepare stmt1 from ' select a, (select count(distinct t5.b) as sum from t5, t6
where t5.a=t6.a and t6.b > 0and t5.a <= t7.b
group by t5.a order by sum limit 1) from t7 ' ;
execute stmt1 ;
a (select count(distinct t5.b) as sum from t5, t6
where t5.a=t6.a and t6.b > 0and t5.a <= t7.b
group by t5.a order by sum limit 1) 31 22 12
execute stmt1 ;
a (select count(distinct t5.b) as sum from t5, t6
where t5.a=t6.a and t6.b > 0and t5.a <= t7.b
group by t5.a order by sum limit 1) 31 22 12
execute stmt1 ;
a (select count(distinct t5.b) as sum from t5, t6
where t5.a=t6.a and t6.b > 0and t5.a <= t7.b
group by t5.a order by sum limit 1) 31 22 12
drop table t5, t6, t7 ;
drop table if exists t2 ;
create table t2 as select * from t9; set @stmt= ' SELECT
(SELECT SUM(c1 + c12 + 0.0) FROM t2
where (t9.c2 - 0e-3) = t2.c2
GROUP BY t9.c15 LIMIT 1) as scalar_s,
exists (select 1.0e+0 from t2
where t2.c3 * 9.0000000000 = t9.c4) as exists_s,
c5 * 4 in (select c6 + 0.3e+1 from t2) as in_s,
(c7 - 4, c8 - 4) in (select c9 + 4.0, c10 + 40e-1 from t2) as in_row_s
FROM t9,
(select c25 x, c32 y from t2) tt WHERE x = c25 ' ;
prepare stmt1 from @stmt ;
execute stmt1 ;
execute stmt1 ; set @stmt= concat('explain ',@stmt);
prepare stmt1 from @stmt ;
execute stmt1 ;
execute stmt1 ; set @stmt= ' SELECT
(SELECT SUM(c1+c12+?) FROM t2 where (t9.c2-?)=t2.c2
GROUP BY t9.c15 LIMIT 1) as scalar_s,
exists (select ? from t2
where t2.c3*?=t9.c4) as exists_s,
c5*? in (select c6+? from t2) as in_s,
(c7-?, c8-?) in (select c9+?, c10+? from t2) as in_row_s
FROM t9,
(select c25 x, c32 y from t2) tt WHERE x =c25 ' ; set @arg00= 0.0; set @arg01= 0e-3; set @arg02= 1.0e+0; set @arg03= 9.0000000000; set @arg04= 4; set @arg05= 0.3e+1; set @arg06= 4; set @arg07= 4; set @arg08= 4.0; set @arg09= 40e-1;
prepare stmt1 from @stmt ;
execute stmt1 using @arg00, @arg01, @arg02, @arg03, @arg04, @arg05, @arg06,
@arg07, @arg08, @arg09 ;
execute stmt1 using @arg00, @arg01, @arg02, @arg03, @arg04, @arg05, @arg06,
@arg07, @arg08, @arg09 ; set @stmt= concat('explain ',@stmt);
prepare stmt1 from @stmt ;
execute stmt1 using @arg00, @arg01, @arg02, @arg03, @arg04, @arg05, @arg06,
@arg07, @arg08, @arg09 ;
execute stmt1 using @arg00, @arg01, @arg02, @arg03, @arg04, @arg05, @arg06,
@arg07, @arg08, @arg09 ;
drop table t2 ;
select 1 < (select a from t1) ; ERROR21000: Subquery returns more than 1 row
prepare stmt1 from ' select 1 < (select a from t1) ';
execute stmt1 ; ERROR21000: Subquery returns more than 1 row
select 1 as my_col ;
my_col 1
test_sequence
------ union tests ------
prepare stmt1 from ' select a FROM t1 where a=1
union distinct
select a FROM t1 where a=1';
execute stmt1 ;
a 1
execute stmt1 ;
a 1
prepare stmt1 from ' select a FROM t1 where a=1
union all
select a FROM t1 where a=1';
execute stmt1 ;
a 1 1
prepare stmt1 from ' SELECT 1, 2 union SELECT 1 '; ERROR21000: The used SELECT statements have a different number of columns
prepare stmt1 from ' SELECT 1 union SELECT 1, 2 '; ERROR21000: The used SELECT statements have a different number of columns
prepare stmt1 from ' SELECT * from t1 union SELECT 1 '; ERROR21000: The used SELECT statements have a different number of columns
prepare stmt1 from ' SELECT 1 union SELECT * from t1 '; ERROR21000: The used SELECT statements have a different number of columns set @arg00=1;
select @arg00 FROM t1 where a=1
union distinct
select 1 FROM t1 where a=1;
@arg00 1
prepare stmt1 from ' select ? FROM t1 where a=1
union distinct
select 1 FROM t1 where a=1' ;
execute stmt1 using @arg00;
? 1 set @arg00=1;
select 1 FROM t1 where a=1
union distinct
select @arg00 FROM t1 where a=1; 1 1
prepare stmt1 from ' select 1 FROM t1 where a=1
union distinct
select ? FROM t1 where a=1' ;
execute stmt1 using @arg00; 1 1 set @arg00='a';
select @arg00 FROM t1 where a=1
union distinct
select @arg00 FROM t1 where a=1;
@arg00
a
prepare stmt1 from ' select ? FROM t1 where a=1
union distinct
select ? FROM t1 where a=1';
execute stmt1 using @arg00, @arg00;
?
a
prepare stmt1 from ' select ?
union distinct
select ? ';
execute stmt1 using @arg00, @arg00;
?
a set @arg00='a'; set @arg01=1; set @arg02='a'; set @arg03=2;
select @arg00 FROM t1 where a=@arg01
union distinct
select @arg02 FROM t1 where a=@arg03;
@arg00
a
prepare stmt1 from ' select ? FROM t1 where a=?
union distinct
select ? FROM t1 where a=? ' ;
execute stmt1 using @arg00, @arg01, @arg02, @arg03;
?
a set @arg00=1;
prepare stmt1 from ' select sum(a) + 200, ? from t1
union distinct
select sum(a) + 200, 1 from t1
group by b ' ;
execute stmt1 using @arg00;
sum(a) + 200 ? 2101 2041 2011 2031 2021 set @Oporto='Oporto'; set @Lisboa='Lisboa'; set @0=0; set @1=1; set @2=2; set @3=3; set @4=4;
select @Oporto,@Lisboa,@0,@1,@2,@3,@4;
@Oporto @Lisboa @0 @1 @2 @3 @4
Oporto Lisboa 01234
select sum(a) + 200 as the_sum, @Oporto as the_town from t1
group by b
union distinct
select sum(a) + 200, @Lisboa from t1
group by b ;
the_sum the_town 204 Oporto 201 Oporto 203 Oporto 202 Oporto 204 Lisboa 201 Lisboa 203 Lisboa 202 Lisboa
prepare stmt1 from ' select sum(a) + 200 as the_sum, ? as the_town from t1
group by b
union distinct
select sum(a) + 200, ? from t1
group by b ' ;
execute stmt1 using @Oporto, @Lisboa;
the_sum the_town 204 Oporto 201 Oporto 203 Oporto 202 Oporto 204 Lisboa 201 Lisboa 203 Lisboa 202 Lisboa
select sum(a) + 200 as the_sum, @Oporto as the_town from t1
where a > @1
group by b
union distinct
select sum(a) + 200, @Lisboa from t1
where a > @2
group by b ;
the_sum the_town 204 Oporto 203 Oporto 202 Oporto 204 Lisboa 203 Lisboa
prepare stmt1 from ' select sum(a) + 200 as the_sum, ? as the_town from t1
where a > ?
group by b
union distinct
select sum(a) + 200, ? from t1
where a > ?
group by b ' ;
execute stmt1 using @Oporto, @1, @Lisboa, @2;
the_sum the_town 204 Oporto 203 Oporto 202 Oporto 204 Lisboa 203 Lisboa
select sum(a) + 200 as the_sum, @Oporto as the_town from t1
where a > @1
group by b
having avg(a) > @2
union distinct
select sum(a) + 200, @Lisboa from t1
where a > @2
group by b
having avg(a) > @3;
the_sum the_town 204 Oporto 203 Oporto 204 Lisboa
prepare stmt1 from ' select sum(a) + 200 as the_sum, ? as the_town from t1
where a > ?
group by b
having avg(a) > ?
union distinct
select sum(a) + 200, ? from t1
where a > ?
group by b
having avg(a) > ? ';
execute stmt1 using @Oporto, @1, @2, @Lisboa, @2, @3;
the_sum the_town 204 Oporto 203 Oporto 204 Lisboa
test_sequence
------ explain select tests ------
prepare stmt1 from ' explain select * from t9 ';
execute stmt1;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
def id 831 Y 32928063
def select_type 253196 N 1398
def table 253642 Y 0398
def type 253103 Y 0398
def possible_keys 2534_OR_8_K 0 Y 0398
def key 253640 Y 0398
def key_len 2534_OR_8_K 0 Y 0398
def ref 25320480 Y 0398
def rows 253641 Y 0398
def Extra 2532550 N 1398
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t9 ALL NULL NULL NULL NULL 2
drop table if exists t2 ;
create table t2 (s varchar(25), fulltext(s))
ENGINE = 'MYISAM';
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 ;
s
Hollow Dogs
prepare stmt1 from ' SELECT s FROM t2
where match (s) against (concat(?,''digger'')) '; set @arg00='Grave';
execute stmt1 using @arg00 ;
s
Gravedigger
drop table t2 ;
test_sequence
------ delete tests ------
delete from t1 ;
insert into t1 values (1,'one');
insert into t1 values (2,'two');
insert into t1 values (3,'three');
insert into t1 values (4,'four');
commit ;
delete from t9 ;
insert into t9 set c1= 1, c2= 1, c3= 1, c4= 1, c5= 1, c6= 1, c7= 1, c8= 1, c9= 1,
c10= 1, c11= 1, c12 = 1,
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
c16= '11:11:11', c17= '2004',
c18= 1, c19=true, c20= 'a', c21= '123456789a',
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
c29= 'longblob', c30= 'longtext', c31='one', c32= 'monday';
insert into t9 set c1= 9, c2= 9, c3= 9, c4= 9, c5= 9, c6= 9, c7= 9, c8= 9, c9= 9,
c10= 9, c11= 9, c12 = 9,
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
c16= '11:11:11', c17= '2004',
c18= 1, c19=false, c20= 'a', c21= '123456789a',
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
c29= 'longblob', c30= 'longtext', c31='two', c32= 'tuesday';
commit ;
prepare stmt1 from 'delete from t1 where a=2';
execute stmt1;
select a,b from t1 where a=2;
a b
execute stmt1;
insert into t1 values(0,NULL); set @arg00=NULL;
prepare stmt1 from 'delete from t1 where b=?';
execute stmt1 using @arg00;
select a,b from t1 where b is NULL ;
a b 0 NULL set @arg00='one';
execute stmt1 using @arg00;
select a,b from t1 where b=@arg00;
a b
prepare stmt1 from 'truncate table t1';
test_sequence
------ update tests ------
delete from t1 ;
insert into t1 values (1,'one');
insert into t1 values (2,'two');
insert into t1 values (3,'three');
insert into t1 values (4,'four');
commit ;
delete from t9 ;
insert into t9 set c1= 1, c2= 1, c3= 1, c4= 1, c5= 1, c6= 1, c7= 1, c8= 1, c9= 1,
c10= 1, c11= 1, c12 = 1,
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
c16= '11:11:11', c17= '2004',
c18= 1, c19=true, c20= 'a', c21= '123456789a',
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
c29= 'longblob', c30= 'longtext', c31='one', c32= 'monday';
insert into t9 set c1= 9, c2= 9, c3= 9, c4= 9, c5= 9, c6= 9, c7= 9, c8= 9, c9= 9,
c10= 9, c11= 9, c12 = 9,
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
c16= '11:11:11', c17= '2004',
c18= 1, c19=false, c20= 'a', c21= '123456789a',
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
c29= 'longblob', c30= 'longtext', c31='two', c32= 'tuesday';
commit ;
prepare stmt1 from 'update t1 set b=''a=two'' where a=2';
execute stmt1;
select a,b from t1 where a=2;
a b 2 a=two
execute stmt1;
select a,b from t1 where a=2;
a b 2 a=two set @arg00=NULL;
prepare stmt1 from 'update t1 set b=? where a=2';
execute stmt1 using @arg00;
select a,b from t1 where a=2;
a b 2 NULL set @arg00='two';
execute stmt1 using @arg00;
select a,b from t1 where a=2;
a b 2 two set @arg00=2;
prepare stmt1 from 'update t1 set b=NULL where a=?';
execute stmt1 using @arg00;
select a,b from t1 where a=@arg00;
a b 2 NULL
update t1 set b='two' where a=@arg00; set @arg00=2000;
execute stmt1 using @arg00;
select a,b from t1 where a=@arg00;
a b set @arg00=2; set @arg01=22;
prepare stmt1 from 'update t1 set a=? where a=?';
execute stmt1 using @arg00, @arg00;
select a,b from t1 where a=@arg00;
a b 2 two
execute stmt1 using @arg01, @arg00;
select a,b from t1 where a=@arg01;
a b 22 two
execute stmt1 using @arg00, @arg01;
select a,b from t1 where a=@arg00;
a b 2 two set @arg00=NULL; set @arg01=2; set sql_mode = '';
execute stmt1 using @arg00, @arg01;
Warnings:
Warning 1048 Column 'a' cannot be null set sql_mode = default;
select a,b from t1 order by a;
a b 0 two 1 one 3 three 4 four set @arg00=0;
execute stmt1 using @arg01, @arg00;
select a,b from t1 order by a;
a b 1 one 2 two 3 three 4 four set @arg00=23; set @arg01='two'; set @arg02=2; set @arg03='two'; set @arg04=2;
drop table if exists t2;
create table t2 as select a,b from t1 ;
prepare stmt1 from 'update t1 set a=? where b=? and a in (select ? from t2
where b = ? or a = ?)';
execute stmt1 using @arg00, @arg01, @arg02, @arg03, @arg04 ;
affected rows: 1
info: Rows matched: 1 Changed: 1 Warnings: 0
select a,b from t1 where a = @arg00 ;
a b 23 two
prepare stmt1 from 'update t1 set a=? where b=? and a not in (select ? from t2
where b = ? or a = ?)';
execute stmt1 using @arg04, @arg01, @arg02, @arg03, @arg00 ;
affected rows: 1
info: Rows matched: 1 Changed: 1 Warnings: 0
select a,b from t1 order by a ;
a b 1 one 2 two 3 three 4 four
drop table t2 ;
create table t2
(
a int, b varchar(30),
primary key(a)
) engine = 'MYISAM';
insert into t2(a,b) select a, b from t1 ;
prepare stmt1 from 'update t1 set a=? where b=? and a in (select ? from t2
where b = ? or a = ?)';
execute stmt1 using @arg00, @arg01, @arg02, @arg03, @arg04 ;
affected rows: 1
info: Rows matched: 1 Changed: 1 Warnings: 0
select a,b from t1 where a = @arg00 ;
a b 23 two
prepare stmt1 from 'update t1 set a=? where b=? and a not in (select ? from t2
where b = ? or a = ?)';
execute stmt1 using @arg04, @arg01, @arg02, @arg03, @arg00 ;
affected rows: 1
info: Rows matched: 1 Changed: 1 Warnings: 0
select a,b from t1 order by a ;
a b 1 one 2 two 3 three 4 four
drop table t2 ; set @arg00=1;
prepare stmt1 from 'update t1 set b=''bla''
where a=2
limit 1';
execute stmt1 ;
select a,b from t1 where b = 'bla';
a b 2 bla
prepare stmt1 from 'update t1 set b=''bla'' where a=2 limit ?';
execute stmt1 using @arg00;
test_sequence
------ insert tests ------
delete from t1 ;
insert into t1 values (1,'one');
insert into t1 values (2,'two');
insert into t1 values (3,'three');
insert into t1 values (4,'four');
commit ;
delete from t9 ;
insert into t9 set c1= 1, c2= 1, c3= 1, c4= 1, c5= 1, c6= 1, c7= 1, c8= 1, c9= 1,
c10= 1, c11= 1, c12 = 1,
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
c16= '11:11:11', c17= '2004',
c18= 1, c19=true, c20= 'a', c21= '123456789a',
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
c29= 'longblob', c30= 'longtext', c31='one', c32= 'monday';
insert into t9 set c1= 9, c2= 9, c3= 9, c4= 9, c5= 9, c6= 9, c7= 9, c8= 9, c9= 9,
c10= 9, c11= 9, c12 = 9,
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
c16= '11:11:11', c17= '2004',
c18= 1, c19=false, c20= 'a', c21= '123456789a',
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
c29= 'longblob', c30= 'longtext', c31='two', c32= 'tuesday';
commit ;
prepare stmt1 from 'insert into t1 values(5, ''five'' )';
execute stmt1;
select a,b from t1 where a = 5;
a b 5 five set @arg00='six';
prepare stmt1 from 'insert into t1 values(6, ? )';
execute stmt1 using @arg00;
select a,b from t1 where b = @arg00;
a b 6 six
execute stmt1 using @arg00; ERROR23000: Duplicate entry '6' for key 'PRIMARY' set @arg00=NULL ;
prepare stmt1 from 'insert into t1 values(0, ? )';
execute stmt1 using @arg00;
select a,b from t1 where b is NULL;
a b 0 NULL set @arg00=8; set @arg01='eight';
prepare stmt1 from 'insert into t1 values(?, ? )';
execute stmt1 using @arg00, @arg01 ;
select a,b from t1 where b = @arg01;
a b 8 eight set @NULL= null ; set @arg00= 'abc';
execute stmt1 using @NULL, @NULL ; ERROR23000: Column 'a' cannot be null
execute stmt1 using @NULL, @NULL ; ERROR23000: Column 'a' cannot be null
execute stmt1 using @NULL, @arg00 ; ERROR23000: Column 'a' cannot be null
execute stmt1 using @NULL, @arg00 ; ERROR23000: Column 'a' cannot be null set @arg01= 10000 + 2;
execute stmt1 using @arg01, @arg00 ; set @arg01= 10000 + 1;
execute stmt1 using @arg01, @arg00 ;
select * from t1 where a > 10000 order by a ;
a b 10001 abc 10002 abc
delete from t1 where a > 10000; set @arg01= 10000 + 2;
execute stmt1 using @arg01, @NULL ; set @arg01= 10000 + 1;
execute stmt1 using @arg01, @NULL ;
select * from t1 where a > 10000 order by a ;
a b 10001 NULL 10002 NULL
delete from t1 where a > 10000; set @arg01= 10000 + 10;
execute stmt1 using @arg01, @arg01 ; set @arg01= 10000 + 9;
execute stmt1 using @arg01, @arg01 ; set @arg01= 10000 + 8;
execute stmt1 using @arg01, @arg01 ; set @arg01= 10000 + 7;
execute stmt1 using @arg01, @arg01 ; set @arg01= 10000 + 6;
execute stmt1 using @arg01, @arg01 ; set @arg01= 10000 + 5;
execute stmt1 using @arg01, @arg01 ; set @arg01= 10000 + 4;
execute stmt1 using @arg01, @arg01 ; set @arg01= 10000 + 3;
execute stmt1 using @arg01, @arg01 ; set @arg01= 10000 + 2;
execute stmt1 using @arg01, @arg01 ; set @arg01= 10000 + 1;
execute stmt1 using @arg01, @arg01 ;
select * from t1 where a > 10000 order by a ;
a b 1000110001 1000210002 1000310003 1000410004 1000510005 1000610006 1000710007 1000810008 1000910009 1001010010
delete from t1 where a > 10000; set @arg00=81; set @arg01='8-1'; set @arg02=82; set @arg03='8-2';
prepare stmt1 from 'insert into t1 values(?,?),(?,?)';
execute stmt1 using @arg00, @arg01, @arg02, @arg03 ;
select a,b from t1 where a in (@arg00,@arg02) ;
a b 818-1 828-2 set @arg00=9; set @arg01='nine';
prepare stmt1 from 'insert into t1 set a=?, b=? ';
execute stmt1 using @arg00, @arg01 ;
select a,b from t1 where a = @arg00 ;
a b 9 nine set @arg00=6; set @arg01=1;
prepare stmt1 from 'insert into t1 set a=?, b=''sechs''
on duplicate key update a=a + ?, b=concat(b,''modified'') ';
execute stmt1 using @arg00, @arg01;
select * from t1 order by a;
a b 0 NULL 1 one 2 two 3 three 4 four 5 five 7 sixmodified 8 eight 9 nine 818-1 828-2 set @arg00=81; set @arg01=1;
execute stmt1 using @arg00, @arg01; ERROR23000: Duplicate entry '82' for key 'PRIMARY'
drop table if exists t2 ;
create table t2 (id int auto_increment primary key)
ENGINE= 'MYISAM';
prepare stmt1 from ' select last_insert_id() ';
insert into t2 values (NULL) ;
execute stmt1 ;
last_insert_id() 1
insert into t2 values (NULL) ;
execute stmt1 ;
last_insert_id() 2
drop table t2 ; set @1000=1000; set @x1000_2="x1000_2"; set @x1000_3="x1000_3"; set @x1000="x1000"; set @1100=1100; set @x1100="x1100"; set @100=100; set @updated="updated";
insert into t1 values(1000,'x1000_1') ;
insert into t1 values(@1000,@x1000_2),(@1000,@x1000_3)
on duplicate key update a = a + @100, b = concat(b,@updated) ;
select a,b from t1 where a >= 1000 order by a ;
a b 1000 x1000_3 1100 x1000_1updated
delete from t1 where a >= 1000;
insert into t1 values(1000,'x1000_1') ;
prepare stmt1 from ' insert into t1 values(?,?),(?,?)
on duplicate key update a = a + ?, b = concat(b,?) ';
execute stmt1 using @1000, @x1000_2, @1000, @x1000_3, @100, @updated ;
select a,b from t1 where a >= 1000 order by a ;
a b 1000 x1000_3 1100 x1000_1updated
delete from t1 where a >= 1000;
insert into t1 values(1000,'x1000_1') ;
execute stmt1 using @1000, @x1000_2, @1100, @x1000_3, @100, @updated ;
select a,b from t1 where a >= 1000 order by a ;
a b 1200 x1000_1updatedupdated
delete from t1 where a >= 1000;
prepare stmt1 from ' replace into t1 (a,b) select 100, ''hundred'' ';
execute stmt1;
execute stmt1;
execute stmt1;
test_sequence
------ multi table tests ------
delete from t1 ;
delete from t9 ;
insert into t1(a,b) values (1, 'one'), (2, 'two'), (3, 'three') ;
insert into t9 (c1,c21)
values (1, 'one'), (2, 'two'), (3, 'three') ;
prepare stmt_delete from " delete t1, t9
from t1, t9 where t1.a=t9.c1 and t1.b='updated'";
prepare stmt_update from " update t1, t9 set t1.b='updated', t9.c21='updated'
where t1.a=t9.c1 and t1.a=? ";
prepare stmt_select1 from " select a, b from t1 order by a";
prepare stmt_select2 from " select c1, c21 from t9 order by c1"; set @arg00= 1;
execute stmt_update using @arg00 ;
execute stmt_delete ;
execute stmt_select1 ;
a b 2 two 3 three
execute stmt_select2 ;
c1 c21 2 two 3 three set @arg00= @arg00 + 1;
execute stmt_update using @arg00 ;
execute stmt_delete ;
execute stmt_select1 ;
a b 3 three
execute stmt_select2 ;
c1 c21 3 three set @arg00= @arg00 + 1;
execute stmt_update using @arg00 ;
execute stmt_delete ;
execute stmt_select1 ;
a b
execute stmt_select2 ;
c1 c21 set @arg00= @arg00 + 1;
delete from t1 ;
insert into t1 values (1,'one');
insert into t1 values (2,'two');
insert into t1 values (3,'three');
insert into t1 values (4,'four');
commit ;
delete from t9 ;
insert into t9 set c1= 1, c2= 1, c3= 1, c4= 1, c5= 1, c6= 1, c7= 1, c8= 1, c9= 1,
c10= 1, c11= 1, c12 = 1,
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
c16= '11:11:11', c17= '2004',
c18= 1, c19=true, c20= 'a', c21= '123456789a',
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
c29= 'longblob', c30= 'longtext', c31='one', c32= 'monday';
insert into t9 set c1= 9, c2= 9, c3= 9, c4= 9, c5= 9, c6= 9, c7= 9, c8= 9, c9= 9,
c10= 9, c11= 9, c12 = 9,
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
c16= '11:11:11', c17= '2004',
c18= 1, c19=false, c20= 'a', c21= '123456789a',
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
c29= 'longblob', c30= 'longtext', c31='two', c32= 'tuesday';
commit ;
insert into t1 values(0,NULL) ; set @duplicate='duplicate '; set @1000=1000; set @5=5;
select a,b from t1 where a < 5 order by a ;
a b 0 NULL 1 one 2 two 3 three 4 four
insert into t1 select a + @1000, concat(@duplicate,b) from t1
where a < @5;
affected rows: 5
info: Records: 5 Duplicates: 0 Warnings: 0
select a,b from t1 where a >= 1000 order by a ;
a b 1000 NULL 1001 duplicate one 1002 duplicate two 1003 duplicate three 1004 duplicate four
delete from t1 where a >= 1000;
prepare stmt1 from ' insert into t1 select a + ?, concat(?,b) from t1
where a < ? ' ;
execute stmt1 using @1000, @duplicate, @5;
affected rows: 5
info: Records: 5 Duplicates: 0 Warnings: 0
select a,b from t1 where a >= 1000 order by a ;
a b 1000 NULL 1001 duplicate one 1002 duplicate two 1003 duplicate three 1004 duplicate four
delete from t1 where a >= 1000; set @1=1; set @2=2; set @100=100; set @float=1.00; set @five='five';
drop table if exists t2;
create table t2 like t1 ;
insert into t2 (b,a)
select @duplicate, sum(first.a) from t1 first, t1 second
where first.a <> @5and second.b = first.b and second.b <> @five
group by second.b
having sum(second.a) > @2
union
select b, a + @100 from t1
where (a,b) in ( select sqrt(a+@1)+CAST(@float AS signed),b
from t1);
affected rows: 3
info: Records: 3 Duplicates: 0 Warnings: 0
select a,b from t2 order by a ;
a b 3 duplicate 4 duplicate 103 three
delete from t2 ;
prepare stmt1 from ' insert into t2 (b,a)
select ?, sum(first.a)
from t1 first, t1 second
where first.a <> ? and second.b = first.b and second.b <> ?
group by second.b
having sum(second.a) > ?
union
select b, a + ? from t1
where (a,b) in ( select sqrt(a+?)+CAST(? AS signed),b
from t1 ) ' ;
execute stmt1 using @duplicate, @5, @five, @2, @100, @1, @float ;
affected rows: 3
info: Records: 3 Duplicates: 0 Warnings: 0
select a,b from t2 order by a ;
a b 3 duplicate 4 duplicate 103 three
drop table t2;
drop table if exists t5 ; set @arg01= 8; set @arg02= 8.0; set @arg03= 80.00000000000e-1; set @arg04= 'abc'; set @arg05= CAST('abc' as binary) ; set @arg06= '1991-08-05'; set @arg07= CAST('1991-08-05' as date); set @arg08= '1991-08-05 01:01:01'; set @arg09= CAST('1991-08-05 01:01:01' as datetime) ; set @arg10= unix_timestamp('1991-01-01 01:01:01'); set @arg11= YEAR('1991-01-01 01:01:01'); set @arg12= 8; set @arg12= NULL ; set @arg13= 8.0; set @arg13= NULL ; set @arg14= 'abc'; set @arg14= NULL ; set @arg15= CAST('abc' as binary) ; set @arg15= NULL ;
create table t5 engine = MyISAM as select 8 as const01, @arg01 as param01, 8.0 as const02, @arg02 as param02, 80.00000000000e-1 as const03, @arg03 as param03, 'abc' as const04, @arg04 as param04,
CAST('abc' as binary) as const05, @arg05 as param05, '1991-08-05' as const06, @arg06 as param06,
CAST('1991-08-05' as date) as const07, @arg07 as param07, '1991-08-05 01:01:01' as const08, @arg08 as param08,
CAST('1991-08-05 01:01:01' as datetime) as const09, @arg09 as param09,
unix_timestamp('1991-01-01 01:01:01') as const10, @arg10 as param10,
YEAR('1991-01-01 01:01:01') as const11, @arg11 as param11,
NULL as const12, @arg12 as param12,
@arg13 as param13,
@arg14 as param14,
@arg15 as param15;
show create table t5 ;
Table Create Table
t5 CREATE TABLE `t5` (
`const01` int(1) NOT NULL,
`param01` bigint(20) DEFAULT NULL,
`const02` decimal(2,1) NOT NULL,
`param02` decimal(65,38) DEFAULT NULL,
`const03` double NOT NULL,
`param03` double DEFAULT NULL,
`const04` varchar(3) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`param04` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`const05` varbinary(3) DEFAULT NULL,
`param05` longblob DEFAULT NULL,
`const06` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`param06` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`const07` date DEFAULT NULL,
`param07` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`const08` varchar(19) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`param08` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`const09` datetime DEFAULT NULL,
`param09` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`const10` bigint(17) DEFAULT NULL,
`param10` bigint(20) DEFAULT NULL,
`const11` int(5) DEFAULT NULL,
`param11` bigint(20) DEFAULT NULL,
`const12` binary(0) DEFAULT NULL,
`param12` bigint(20) DEFAULT NULL,
`param13` decimal(65,38) DEFAULT NULL,
`param14` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`param15` longblob DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
select * from t5 ;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
def test t5 t5 const01 const01 311 N 36865063
def test t5 t5 param01 param01 8201 Y 32768063
def test t5 t5 const02 const02 24643 N 36865163
def test t5 t5 param02 param02 2466740 Y 327683863
def test t5 t5 const03 const03 5171 N 368653163
def test t5 t5 param03 param03 5231 Y 327683163
def test t5 t5 const04 const04 25333 N 409708
def test t5 t5 param04 param04 25242949672953 Y 1608
def test t5 t5 const05 const05 25333 Y 128063
def test t5 t5 param05 param05 25242949672953 Y 144063
def test t5 t5 const06 const06 2531010 N 409708
def test t5 t5 param06 param06 252429496729510 Y 1608
def test t5 t5 const07 const07 101010 Y 128063
def test t5 t5 param07 param07 252429496729510 Y 1608
def test t5 t5 const08 const08 2531919 N 409708
def test t5 t5 param08 param08 252429496729519 Y 1608
def test t5 t5 const09 const09 121919 Y 128063
def test t5 t5 param09 param09 252429496729519 Y 1608
def test t5 t5 const10 const10 8179 Y 32768063
def test t5 t5 param10 param10 8209 Y 32768063
def test t5 t5 const11 const11 354 Y 32768063
def test t5 t5 param11 param11 8204 Y 32768063
def test t5 t5 const12 const12 25400 Y 128063
def test t5 t5 param12 param12 8200 Y 32768063
def test t5 t5 param13 param13 246670 Y 327683863
def test t5 t5 param14 param14 25242949672950 Y 1608
def test t5 t5 param15 param15 25242949672950 Y 144063
const01 8
param01 8
const02 8.0
param02 8.00000000000000000000000000000000000000
const03 8
param03 8
const04 abc
param04 abc
const05 abc
param05 abc
const06 1991-08-05
param06 1991-08-05
const07 1991-08-05
param07 1991-08-05
const08 1991-08-0501:01:01
param08 1991-08-0501:01:01
const09 1991-08-0501:01:01
param09 1991-08-0501:01:01
const10 662680861
param10 662680861
const11 1991
param11 1991
const12 NULL
param12 NULL
param13 NULL
param14 NULL
param15 NULL
drop table t5 ;
test_sequence
------ data type conversion tests ------
delete from t1 ;
insert into t1 values (1,'one');
insert into t1 values (2,'two');
insert into t1 values (3,'three');
insert into t1 values (4,'four');
commit ;
delete from t9 ;
insert into t9 set c1= 1, c2= 1, c3= 1, c4= 1, c5= 1, c6= 1, c7= 1, c8= 1, c9= 1,
c10= 1, c11= 1, c12 = 1,
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
c16= '11:11:11', c17= '2004',
c18= 1, c19=true, c20= 'a', c21= '123456789a',
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
c29= 'longblob', c30= 'longtext', c31='one', c32= 'monday';
insert into t9 set c1= 9, c2= 9, c3= 9, c4= 9, c5= 9, c6= 9, c7= 9, c8= 9, c9= 9,
c10= 9, c11= 9, c12 = 9,
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
c16= '11:11:11', c17= '2004',
c18= 1, c19=false, c20= 'a', c21= '123456789a',
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
c29= 'longblob', c30= 'longtext', c31='two', c32= 'tuesday';
commit ;
insert into t9 set c1= 0, c15= '1991-01-01 01:01:01';
select * from t9 order by c1 ;
c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21 c22 c23 c24 c25 c26 c27 c28 c29 c30 c31 c32 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1991-01-0101:01:01 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 11111111111.00001.00002004-02-292004-02-2911:11:112004-02-2911:11:1111:11:11200411 a 123456789a 123456789a123456789b123456789c tinyblob tinytext blob text mediumblob mediumtext longblob longtext one monday 99999999999.00009.00002004-02-292004-02-2911:11:112004-02-2911:11:1111:11:11200410 a 123456789a 123456789a123456789b123456789c tinyblob tinytext blob text mediumblob mediumtext longblob longtext two tuesday
test_sequence
------ select @parameter:= column ------
prepare full_info from "select @arg01, @arg02, @arg03, @arg04,
@arg05, @arg06, @arg07, @arg08,
@arg09, @arg10, @arg11, @arg12,
@arg13, @arg14, @arg15, @arg16,
@arg17, @arg18, @arg19, @arg20,
@arg21, @arg22, @arg23, @arg24,
@arg25, @arg26, @arg27, @arg28,
@arg29, @arg30, @arg31, @arg32" ;
select @arg01:= c1, @arg02:= c2, @arg03:= c3, @arg04:= c4,
@arg05:= c5, @arg06:= c6, @arg07:= c7, @arg08:= c8,
@arg09:= c9, @arg10:= c10, @arg11:= c11, @arg12:= c12,
@arg13:= c13, @arg14:= c14, @arg15:= c15, @arg16:= c16,
@arg17:= c17, @arg18:= c18, @arg19:= c19, @arg20:= c20,
@arg21:= c21, @arg22:= c22, @arg23:= c23, @arg24:= c24,
@arg25:= c25, @arg26:= c26, @arg27:= c27, @arg28:= c28,
@arg29:= c29, @arg30:= c30, @arg31:= c31, @arg32:= c32
from t9 where c1= 1;
@arg01:= c1 @arg02:= c2 @arg03:= c3 @arg04:= c4 @arg05:= c5 @arg06:= c6 @arg07:= c7 @arg08:= c8 @arg09:= c9 @arg10:= c10 @arg11:= c11 @arg12:= c12 @arg13:= c13 @arg14:= c14 @arg15:= c15 @arg16:= c16 @arg17:= c17 @arg18:= c18 @arg19:= c19 @arg20:= c20 @arg21:= c21 @arg22:= c22 @arg23:= c23 @arg24:= c24 @arg25:= c25 @arg26:= c26 @arg27:= c27 @arg28:= c28 @arg29:= c29 @arg30:= c30 @arg31:= c31 @arg32:= c32 11111111111.00001.00002004-02-292004-02-2911:11:112004-02-2911:11:1111:11:11200411 a 123456789a 123456789a123456789b123456789c tinyblob tinytext blob text mediumblob mediumtext longblob longtext one monday
execute full_info ;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
def @arg01 8201 Y 32896063
def @arg02 8201 Y 32896063
def @arg03 8201 Y 32896063
def @arg04 8201 Y 32896063
def @arg05 8201 Y 32896063
def @arg06 8201 Y 32896063
def @arg07 5231 Y 328963163
def @arg08 5231 Y 328963163
def @arg09 5231 Y 328963163
def @arg10 5231 Y 328963163
def @arg11 246836 Y 328963863
def @arg12 246836 Y 328963863
def @arg13 2511677721510 Y 0398
def @arg14 2511677721519 Y 0398
def @arg15 2511677721519 Y 0398
def @arg16 251167772158 Y 0398
def @arg17 8204 Y 32928063
def @arg18 8201 Y 32896063
def @arg19 8201 Y 32896063
def @arg20 251167772151 Y 0398
def @arg21 2511677721510 Y 0398
def @arg22 2511677721530 Y 0398
def @arg23 251167772158 Y 1283963
def @arg24 251167772158 Y 0398
def @arg25 251167772154 Y 1283963
def @arg26 251167772154 Y 0398
def @arg27 2511677721510 Y 1283963
def @arg28 2511677721510 Y 0398
def @arg29 251167772158 Y 1283963
def @arg30 251167772158 Y 0398
def @arg31 251167772153 Y 0398
def @arg32 251167772156 Y 0398
@arg01 @arg02 @arg03 @arg04 @arg05 @arg06 @arg07 @arg08 @arg09 @arg10 @arg11 @arg12 @arg13 @arg14 @arg15 @arg16 @arg17 @arg18 @arg19 @arg20 @arg21 @arg22 @arg23 @arg24 @arg25 @arg26 @arg27 @arg28 @arg29 @arg30 @arg31 @arg32 11111111111.00001.00002004-02-292004-02-2911:11:112004-02-2911:11:1111:11:11200411 a 123456789a 123456789a123456789b123456789c tinyblob tinytext blob text mediumblob mediumtext longblob longtext one monday
select @arg01:= c1, @arg02:= c2, @arg03:= c3, @arg04:= c4,
@arg05:= c5, @arg06:= c6, @arg07:= c7, @arg08:= c8,
@arg09:= c9, @arg10:= c10, @arg11:= c11, @arg12:= c12,
@arg13:= c13, @arg14:= c14, @arg15:= c15, @arg16:= c16,
@arg17:= c17, @arg18:= c18, @arg19:= c19, @arg20:= c20,
@arg21:= c21, @arg22:= c22, @arg23:= c23, @arg24:= c24,
@arg25:= c25, @arg26:= c26, @arg27:= c27, @arg28:= c28,
@arg29:= c29, @arg30:= c30, @arg31:= c31, @arg32:= c32
from t9 where c1= 0;
@arg01:= c1 @arg02:= c2 @arg03:= c3 @arg04:= c4 @arg05:= c5 @arg06:= c6 @arg07:= c7 @arg08:= c8 @arg09:= c9 @arg10:= c10 @arg11:= c11 @arg12:= c12 @arg13:= c13 @arg14:= c14 @arg15:= c15 @arg16:= c16 @arg17:= c17 @arg18:= c18 @arg19:= c19 @arg20:= c20 @arg21:= c21 @arg22:= c22 @arg23:= c23 @arg24:= c24 @arg25:= c25 @arg26:= c26 @arg27:= c27 @arg28:= c28 @arg29:= c29 @arg30:= c30 @arg31:= c31 @arg32:= c32 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1991-01-0101:01:01 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
execute full_info ;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
def @arg01 8201 Y 32896063
def @arg02 8200 Y 32896063
def @arg03 8200 Y 32896063
def @arg04 8200 Y 32896063
def @arg05 8200 Y 32896063
def @arg06 8200 Y 32896063
def @arg07 5230 Y 328963163
def @arg08 5230 Y 328963163
def @arg09 5230 Y 328963163
def @arg10 5230 Y 328963163
def @arg11 246830 Y 328963863
def @arg12 246830 Y 328963863
def @arg13 251167772150 Y 0398
def @arg14 251167772150 Y 0398
def @arg15 2511677721519 Y 0398
def @arg16 251167772150 Y 0398
def @arg17 8200 Y 32928063
def @arg18 8200 Y 32896063
def @arg19 8200 Y 32896063
def @arg20 251167772150 Y 0398
def @arg21 251167772150 Y 0398
def @arg22 251167772150 Y 0398
def @arg23 251167772150 Y 1283963
def @arg24 251167772150 Y 0398
def @arg25 251167772150 Y 1283963
def @arg26 251167772150 Y 0398
def @arg27 251167772150 Y 1283963
def @arg28 251167772150 Y 0398
def @arg29 251167772150 Y 1283963
def @arg30 251167772150 Y 0398
def @arg31 251167772150 Y 0398
def @arg32 251167772150 Y 0398
@arg01 @arg02 @arg03 @arg04 @arg05 @arg06 @arg07 @arg08 @arg09 @arg10 @arg11 @arg12 @arg13 @arg14 @arg15 @arg16 @arg17 @arg18 @arg19 @arg20 @arg21 @arg22 @arg23 @arg24 @arg25 @arg26 @arg27 @arg28 @arg29 @arg30 @arg31 @arg32 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1991-01-0101:01:01 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
prepare stmt1 from "select
@arg01:= c1, @arg02:= c2, @arg03:= c3, @arg04:= c4,
@arg05:= c5, @arg06:= c6, @arg07:= c7, @arg08:= c8,
@arg09:= c9, @arg10:= c10, @arg11:= c11, @arg12:= c12,
@arg13:= c13, @arg14:= c14, @arg15:= c15, @arg16:= c16,
@arg17:= c17, @arg18:= c18, @arg19:= c19, @arg20:= c20,
@arg21:= c21, @arg22:= c22, @arg23:= c23, @arg24:= c24,
@arg25:= c25, @arg26:= c26, @arg27:= c27, @arg28:= c28,
@arg29:= c29, @arg30:= c30, @arg31:= c31, @arg32:= c32
from t9 where c1= ?" ; set @my_key= 1;
execute stmt1 using @my_key ;
@arg01:= c1 @arg02:= c2 @arg03:= c3 @arg04:= c4 @arg05:= c5 @arg06:= c6 @arg07:= c7 @arg08:= c8 @arg09:= c9 @arg10:= c10 @arg11:= c11 @arg12:= c12 @arg13:= c13 @arg14:= c14 @arg15:= c15 @arg16:= c16 @arg17:= c17 @arg18:= c18 @arg19:= c19 @arg20:= c20 @arg21:= c21 @arg22:= c22 @arg23:= c23 @arg24:= c24 @arg25:= c25 @arg26:= c26 @arg27:= c27 @arg28:= c28 @arg29:= c29 @arg30:= c30 @arg31:= c31 @arg32:= c32 11111111111.00001.00002004-02-292004-02-2911:11:112004-02-2911:11:1111:11:11200411 a 123456789a 123456789a123456789b123456789c tinyblob tinytext blob text mediumblob mediumtext longblob longtext one monday
execute full_info ;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
def @arg01 8201 Y 32896063
def @arg02 8201 Y 32896063
def @arg03 8201 Y 32896063
def @arg04 8201 Y 32896063
def @arg05 8201 Y 32896063
def @arg06 8201 Y 32896063
def @arg07 5231 Y 328963163
def @arg08 5231 Y 328963163
def @arg09 5231 Y 328963163
def @arg10 5231 Y 328963163
def @arg11 246836 Y 328963863
def @arg12 246836 Y 328963863
def @arg13 2511677721510 Y 0398
def @arg14 2511677721519 Y 0398
def @arg15 2511677721519 Y 0398
def @arg16 251167772158 Y 0398
def @arg17 8204 Y 32928063
def @arg18 8201 Y 32896063
def @arg19 8201 Y 32896063
def @arg20 251167772151 Y 0398
def @arg21 2511677721510 Y 0398
def @arg22 2511677721530 Y 0398
def @arg23 251167772158 Y 1283963
def @arg24 251167772158 Y 0398
def @arg25 251167772154 Y 1283963
def @arg26 251167772154 Y 0398
def @arg27 2511677721510 Y 1283963
def @arg28 2511677721510 Y 0398
def @arg29 251167772158 Y 1283963
def @arg30 251167772158 Y 0398
def @arg31 251167772153 Y 0398
def @arg32 251167772156 Y 0398
@arg01 @arg02 @arg03 @arg04 @arg05 @arg06 @arg07 @arg08 @arg09 @arg10 @arg11 @arg12 @arg13 @arg14 @arg15 @arg16 @arg17 @arg18 @arg19 @arg20 @arg21 @arg22 @arg23 @arg24 @arg25 @arg26 @arg27 @arg28 @arg29 @arg30 @arg31 @arg32 11111111111.00001.00002004-02-292004-02-2911:11:112004-02-2911:11:1111:11:11200411 a 123456789a 123456789a123456789b123456789c tinyblob tinytext blob text mediumblob mediumtext longblob longtext one monday set @my_key= 0;
execute stmt1 using @my_key ;
@arg01:= c1 @arg02:= c2 @arg03:= c3 @arg04:= c4 @arg05:= c5 @arg06:= c6 @arg07:= c7 @arg08:= c8 @arg09:= c9 @arg10:= c10 @arg11:= c11 @arg12:= c12 @arg13:= c13 @arg14:= c14 @arg15:= c15 @arg16:= c16 @arg17:= c17 @arg18:= c18 @arg19:= c19 @arg20:= c20 @arg21:= c21 @arg22:= c22 @arg23:= c23 @arg24:= c24 @arg25:= c25 @arg26:= c26 @arg27:= c27 @arg28:= c28 @arg29:= c29 @arg30:= c30 @arg31:= c31 @arg32:= c32 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1991-01-0101:01:01 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
execute full_info ;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
def @arg01 8201 Y 32896063
def @arg02 8200 Y 32896063
def @arg03 8200 Y 32896063
def @arg04 8200 Y 32896063
def @arg05 8200 Y 32896063
def @arg06 8200 Y 32896063
def @arg07 5230 Y 328963163
def @arg08 5230 Y 328963163
def @arg09 5230 Y 328963163
def @arg10 5230 Y 328963163
def @arg11 246830 Y 328963863
def @arg12 246830 Y 328963863
def @arg13 251167772150 Y 0398
def @arg14 251167772150 Y 0398
def @arg15 2511677721519 Y 0398
def @arg16 251167772150 Y 0398
def @arg17 8200 Y 32928063
def @arg18 8200 Y 32896063
def @arg19 8200 Y 32896063
def @arg20 251167772150 Y 0398
def @arg21 251167772150 Y 0398
def @arg22 251167772150 Y 0398
def @arg23 251167772150 Y 1283963
def @arg24 251167772150 Y 0398
def @arg25 251167772150 Y 1283963
def @arg26 251167772150 Y 0398
def @arg27 251167772150 Y 1283963
def @arg28 251167772150 Y 0398
def @arg29 251167772150 Y 1283963
def @arg30 251167772150 Y 0398
def @arg31 251167772150 Y 0398
def @arg32 251167772150 Y 0398
@arg01 @arg02 @arg03 @arg04 @arg05 @arg06 @arg07 @arg08 @arg09 @arg10 @arg11 @arg12 @arg13 @arg14 @arg15 @arg16 @arg17 @arg18 @arg19 @arg20 @arg21 @arg22 @arg23 @arg24 @arg25 @arg26 @arg27 @arg28 @arg29 @arg30 @arg31 @arg32 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1991-01-0101:01:01 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
prepare stmt1 from "select ? := c1 from t9 where c1= 1"; ERROR42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':= c1 from t9 where c1= 1' at line 1
test_sequence
------ select column, .. into @parm,.. ------
select c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12,
c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24,
c25, c26, c27, c28, c29, c30, c31, c32
into @arg01, @arg02, @arg03, @arg04, @arg05, @arg06, @arg07, @arg08,
@arg09, @arg10, @arg11, @arg12, @arg13, @arg14, @arg15, @arg16,
@arg17, @arg18, @arg19, @arg20, @arg21, @arg22, @arg23, @arg24,
@arg25, @arg26, @arg27, @arg28, @arg29, @arg30, @arg31, @arg32
from t9 where c1= 1;
execute full_info ;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
def @arg01 8201 Y 32896063
def @arg02 8201 Y 32896063
def @arg03 8201 Y 32896063
def @arg04 8201 Y 32896063
def @arg05 8201 Y 32896063
def @arg06 8201 Y 32896063
def @arg07 5231 Y 328963163
def @arg08 5231 Y 328963163
def @arg09 5231 Y 328963163
def @arg10 5231 Y 328963163
def @arg11 246836 Y 328963863
def @arg12 246836 Y 328963863
def @arg13 2511677721510 Y 0398
def @arg14 2511677721519 Y 0398
def @arg15 2511677721519 Y 0398
def @arg16 251167772158 Y 0398
def @arg17 8204 Y 32928063
def @arg18 8201 Y 32896063
def @arg19 8201 Y 32896063
def @arg20 251167772151 Y 0398
def @arg21 2511677721510 Y 0398
def @arg22 2511677721530 Y 0398
def @arg23 251167772158 Y 1283963
def @arg24 251167772158 Y 0398
def @arg25 251167772154 Y 1283963
def @arg26 251167772154 Y 0398
def @arg27 2511677721510 Y 1283963
def @arg28 2511677721510 Y 0398
def @arg29 251167772158 Y 1283963
def @arg30 251167772158 Y 0398
def @arg31 251167772153 Y 0398
def @arg32 251167772156 Y 0398
@arg01 @arg02 @arg03 @arg04 @arg05 @arg06 @arg07 @arg08 @arg09 @arg10 @arg11 @arg12 @arg13 @arg14 @arg15 @arg16 @arg17 @arg18 @arg19 @arg20 @arg21 @arg22 @arg23 @arg24 @arg25 @arg26 @arg27 @arg28 @arg29 @arg30 @arg31 @arg32 11111111111.00001.00002004-02-292004-02-2911:11:112004-02-2911:11:1111:11:11200411 a 123456789a 123456789a123456789b123456789c tinyblob tinytext blob text mediumblob mediumtext longblob longtext one monday
select c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12,
c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24,
c25, c26, c27, c28, c29, c30, c31, c32
into @arg01, @arg02, @arg03, @arg04, @arg05, @arg06, @arg07, @arg08,
@arg09, @arg10, @arg11, @arg12, @arg13, @arg14, @arg15, @arg16,
@arg17, @arg18, @arg19, @arg20, @arg21, @arg22, @arg23, @arg24,
@arg25, @arg26, @arg27, @arg28, @arg29, @arg30, @arg31, @arg32
from t9 where c1= 0;
execute full_info ;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
def @arg01 8201 Y 32896063
def @arg02 8200 Y 32896063
def @arg03 8200 Y 32896063
def @arg04 8200 Y 32896063
def @arg05 8200 Y 32896063
def @arg06 8200 Y 32896063
def @arg07 5230 Y 328963163
def @arg08 5230 Y 328963163
def @arg09 5230 Y 328963163
def @arg10 5230 Y 328963163
def @arg11 246830 Y 328963863
def @arg12 246830 Y 328963863
def @arg13 251167772150 Y 0398
def @arg14 251167772150 Y 0398
def @arg15 2511677721519 Y 0398
def @arg16 251167772150 Y 0398
def @arg17 8200 Y 32928063
def @arg18 8200 Y 32896063
def @arg19 8200 Y 32896063
def @arg20 251167772150 Y 0398
def @arg21 251167772150 Y 0398
def @arg22 251167772150 Y 0398
def @arg23 251167772150 Y 1283963
def @arg24 251167772150 Y 0398
def @arg25 251167772150 Y 1283963
def @arg26 251167772150 Y 0398
def @arg27 251167772150 Y 1283963
def @arg28 251167772150 Y 0398
def @arg29 251167772150 Y 1283963
def @arg30 251167772150 Y 0398
def @arg31 251167772150 Y 0398
def @arg32 251167772150 Y 0398
@arg01 @arg02 @arg03 @arg04 @arg05 @arg06 @arg07 @arg08 @arg09 @arg10 @arg11 @arg12 @arg13 @arg14 @arg15 @arg16 @arg17 @arg18 @arg19 @arg20 @arg21 @arg22 @arg23 @arg24 @arg25 @arg26 @arg27 @arg28 @arg29 @arg30 @arg31 @arg32 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1991-01-0101:01:01 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
prepare stmt1 from "select c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12,
c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24,
c25, c26, c27, c28, c29, c30, c31, c32
into @arg01, @arg02, @arg03, @arg04, @arg05, @arg06, @arg07, @arg08,
@arg09, @arg10, @arg11, @arg12, @arg13, @arg14, @arg15, @arg16,
@arg17, @arg18, @arg19, @arg20, @arg21, @arg22, @arg23, @arg24,
@arg25, @arg26, @arg27, @arg28, @arg29, @arg30, @arg31, @arg32
from t9 where c1= ?" ; set @my_key= 1;
execute stmt1 using @my_key ;
execute full_info ;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
def @arg01 8201 Y 32896063
def @arg02 8201 Y 32896063
def @arg03 8201 Y 32896063
def @arg04 8201 Y 32896063
def @arg05 8201 Y 32896063
def @arg06 8201 Y 32896063
def @arg07 5231 Y 328963163
def @arg08 5231 Y 328963163
def @arg09 5231 Y 328963163
def @arg10 5231 Y 328963163
def @arg11 246836 Y 328963863
def @arg12 246836 Y 328963863
def @arg13 2511677721510 Y 0398
def @arg14 2511677721519 Y 0398
def @arg15 2511677721519 Y 0398
def @arg16 251167772158 Y 0398
def @arg17 8204 Y 32928063
def @arg18 8201 Y 32896063
def @arg19 8201 Y 32896063
def @arg20 251167772151 Y 0398
def @arg21 2511677721510 Y 0398
def @arg22 2511677721530 Y 0398
def @arg23 251167772158 Y 1283963
def @arg24 251167772158 Y 0398
def @arg25 251167772154 Y 1283963
def @arg26 251167772154 Y 0398
def @arg27 2511677721510 Y 1283963
def @arg28 2511677721510 Y 0398
def @arg29 251167772158 Y 1283963
def @arg30 251167772158 Y 0398
def @arg31 251167772153 Y 0398
def @arg32 251167772156 Y 0398
@arg01 @arg02 @arg03 @arg04 @arg05 @arg06 @arg07 @arg08 @arg09 @arg10 @arg11 @arg12 @arg13 @arg14 @arg15 @arg16 @arg17 @arg18 @arg19 @arg20 @arg21 @arg22 @arg23 @arg24 @arg25 @arg26 @arg27 @arg28 @arg29 @arg30 @arg31 @arg32 11111111111.00001.00002004-02-292004-02-2911:11:112004-02-2911:11:1111:11:11200411 a 123456789a 123456789a123456789b123456789c tinyblob tinytext blob text mediumblob mediumtext longblob longtext one monday set @my_key= 0;
execute stmt1 using @my_key ;
execute full_info ;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
def @arg01 8201 Y 32896063
def @arg02 8200 Y 32896063
def @arg03 8200 Y 32896063
def @arg04 8200 Y 32896063
def @arg05 8200 Y 32896063
def @arg06 8200 Y 32896063
def @arg07 5230 Y 328963163
def @arg08 5230 Y 328963163
def @arg09 5230 Y 328963163
def @arg10 5230 Y 328963163
def @arg11 246830 Y 328963863
def @arg12 246830 Y 328963863
def @arg13 251167772150 Y 0398
def @arg14 251167772150 Y 0398
def @arg15 2511677721519 Y 0398
def @arg16 251167772150 Y 0398
def @arg17 8200 Y 32928063
def @arg18 8200 Y 32896063
def @arg19 8200 Y 32896063
def @arg20 251167772150 Y 0398
def @arg21 251167772150 Y 0398
def @arg22 251167772150 Y 0398
def @arg23 251167772150 Y 1283963
def @arg24 251167772150 Y 0398
def @arg25 251167772150 Y 1283963
def @arg26 251167772150 Y 0398
def @arg27 251167772150 Y 1283963
def @arg28 251167772150 Y 0398
def @arg29 251167772150 Y 1283963
def @arg30 251167772150 Y 0398
def @arg31 251167772150 Y 0398
def @arg32 251167772150 Y 0398
@arg01 @arg02 @arg03 @arg04 @arg05 @arg06 @arg07 @arg08 @arg09 @arg10 @arg11 @arg12 @arg13 @arg14 @arg15 @arg16 @arg17 @arg18 @arg19 @arg20 @arg21 @arg22 @arg23 @arg24 @arg25 @arg26 @arg27 @arg28 @arg29 @arg30 @arg31 @arg32 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1991-01-0101:01:01 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
prepare stmt1 from "select c1 into ? from t9 where c1= 1"; ERROR42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? from t9 where c1= 1' at line 1
test_sequence
-- insert into numeric columns --
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20 ) ; set @arg00= 21;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22 )" ;
execute stmt1 ; set @arg00= 23;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0, 30.0 ) ; set @arg00= 31.0;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0, 32.0 )" ;
execute stmt1 ; set @arg00= 33.0;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( '40', '40', '40', '40', '40', '40', '40', '40', '40', '40', '40' ) ; set @arg00= '41';
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( '42', '42', '42', '42', '42', '42', '42', '42', '42', '42', '42' )" ;
execute stmt1 ; set @arg00= '43';
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( CAST('50' as binary), CAST('50' as binary),
CAST('50' as binary), CAST('50' as binary), CAST('50' as binary),
CAST('50' as binary), CAST('50' as binary), CAST('50' as binary),
CAST('50' as binary), CAST('50' as binary), CAST('50' as binary) ) ; set @arg00= CAST('51' as binary) ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( CAST('52' as binary), CAST('52' as binary),
CAST('52' as binary), CAST('52' as binary), CAST('52' as binary),
CAST('52' as binary), CAST('52' as binary), CAST('52' as binary),
CAST('52' as binary), CAST('52' as binary), CAST('52' as binary) )" ;
execute stmt1 ; set @arg00= CAST('53' as binary) ;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ; set @arg00= 2; set @arg00= NULL ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ) ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( 61, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
prepare stmt1 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( 62, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL )" ;
execute stmt1 ;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( 63, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ; set @arg00= 8.0; set @arg00= NULL ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( 71, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( 73, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ; set @arg00= 'abc'; set @arg00= NULL ;
insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( 81, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ) ;
prepare stmt2 from "insert into t9
( c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( 83, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
select c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12
from t9 where c1 >= 20
order by c1 ;
c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c12 2020202020202020202020.0000 2121212121212121212121.0000 2222222222222222222222.0000 2323232323232323232323.0000 3030303030303030303030.0000 3131313131313131313131.0000 3232323232323232323232.0000 3333333333333333333333.0000 4040404040404040404040.0000 4141414141414141414141.0000 4242424242424242424242.0000 4343434343434343434343.0000 5050505050505050505050.0000 5151515151515151515151.0000 5252525252525252525252.0000 5353535353535353535353.0000 60 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 61 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 62 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 63 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 71 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 73 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 81 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 83 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
test_sequence
-- select .. where numeric column = .. -- set @arg00= 20;
select 'true' as found from t9
where c1= 20and c2= 20and c3= 20and c4= 20and c5= 20and c6= 20and c7= 20 and c8= 20and c9= 20and c10= 20and c12= 20;
found
true
select 'true' as found from t9
where c1= @arg00 and c2= @arg00 and c3= @arg00 and c4= @arg00 and c5= @arg00 and c6= @arg00 and c7= @arg00 and c8= @arg00 and c9= @arg00 and c10= @arg00 and c12= @arg00;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and c2= 20and c3= 20and c4= 20and c5= 20and c6= 20and c7= 20 and c8= 20and c9= 20and c10= 20and c12= 20";
execute stmt1 ;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= ? and c2= ? and c3= ? and c4= ? and c5= ? and c6= ? and c7= ? and c8= ? and c9= ? and c10= ? and c12= ? ";
execute stmt1 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
found
true set @arg00= 20.0;
select 'true' as found from t9
where c1= 20.0and c2= 20.0and c3= 20.0and c4= 20.0and c5= 20.0and c6= 20.0 and c7= 20.0and c8= 20.0and c9= 20.0and c10= 20.0and c12= 20.0;
found
true
select 'true' as found from t9
where c1= @arg00 and c2= @arg00 and c3= @arg00 and c4= @arg00 and c5= @arg00 and c6= @arg00 and c7= @arg00 and c8= @arg00 and c9= @arg00 and c10= @arg00 and c12= @arg00;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20.0and c2= 20.0and c3= 20.0and c4= 20.0and c5= 20.0and c6= 20.0 and c7= 20.0and c8= 20.0and c9= 20.0and c10= 20.0and c12= 20.0";
execute stmt1 ;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= ? and c2= ? and c3= ? and c4= ? and c5= ? and c6= ? and c7= ? and c8= ? and c9= ? and c10= ? and c12= ? ";
execute stmt1 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
found
true
select 'true' as found from t9
where c1= '20'and c2= '20'and c3= '20'and c4= '20'and c5= '20'and c6= '20' and c7= '20'and c8= '20'and c9= '20'and c10= '20'and c12= '20';
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= '20'and c2= '20'and c3= '20'and c4= '20'and c5= '20'and c6= '20' and c7= '20'and c8= '20'and c9= '20'and c10= '20'and c12= '20'";
execute stmt1 ;
found
true set @arg00= '20';
select 'true' as found from t9
where c1= @arg00 and c2= @arg00 and c3= @arg00 and c4= @arg00 and c5= @arg00 and c6= @arg00 and c7= @arg00 and c8= @arg00 and c9= @arg00 and c10= @arg00 and c12= @arg00;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= ? and c2= ? and c3= ? and c4= ? and c5= ? and c6= ? and c7= ? and c8= ? and c9= ? and c10= ? and c12= ? ";
execute stmt1 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
found
true
select 'true' as found from t9
where c1= CAST('20' as binary) and c2= CAST('20' as binary) and
c3= CAST('20' as binary) and c4= CAST('20' as binary) and
c5= CAST('20' as binary) and c6= CAST('20' as binary) and
c7= CAST('20' as binary) and c8= CAST('20' as binary) and
c9= CAST('20' as binary) and c10= CAST('20' as binary) and
c12= CAST('20' as binary);
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= CAST('20' as binary) and c2= CAST('20' as binary) and
c3= CAST('20' as binary) and c4= CAST('20' as binary) and
c5= CAST('20' as binary) and c6= CAST('20' as binary) and
c7= CAST('20' as binary) and c8= CAST('20' as binary) and
c9= CAST('20' as binary) and c10= CAST('20' as binary) and
c12= CAST('20' as binary) ";
execute stmt1 ;
found
true set @arg00= CAST('20' as binary) ;
select 'true' as found from t9
where c1= @arg00 and c2= @arg00 and c3= @arg00 and c4= @arg00 and c5= @arg00 and c6= @arg00 and c7= @arg00 and c8= @arg00 and c9= @arg00 and c10= @arg00 and c12= @arg00;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= ? and c2= ? and c3= ? and c4= ? and c5= ? and c6= ? and c7= ? and c8= ? and c9= ? and c10= ? and c12= ? ";
execute stmt1 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
found
true
delete from t9 ;
test_sequence
-- some numeric overflow experiments --
prepare my_insert from "insert into t9
( c21, c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12 )
values
( 'O', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
prepare my_select from "select c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c12
from t9 where c21 = 'O'";
prepare my_delete from "delete from t9 where c21 = 'O' "; set @arg00= 9223372036854775807; set statement sql_mode = '' for
execute my_insert using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
Warning 1264 Out of range value for column 'c2' at row 1
Warning 1264 Out of range value for column 'c3' at row 1
Warning 1264 Out of range value for column 'c4' at row 1
Warning 1264 Out of range value for column 'c5' at row 1
Warning 1264 Out of range value for column 'c12' at row 1
execute my_select ;
c1 127
c2 32767
c3 8388607
c4 2147483647
c5 2147483647
c6 9223372036854775807
c7 9.22337e18
c8 9.223372036854776e18
c9 9.223372036854776e18
c10 9.223372036854776e18
c12 9999.9999
execute my_delete ; set @arg00= '9223372036854775807'; set statement sql_mode = '' for
execute my_insert using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
Warning 1264 Out of range value for column 'c2' at row 1
Warning 1264 Out of range value for column 'c3' at row 1
Warning 1264 Out of range value for column 'c4' at row 1
Warning 1264 Out of range value for column 'c5' at row 1
Warning 1264 Out of range value for column 'c12' at row 1
execute my_select ;
c1 127
c2 32767
c3 8388607
c4 2147483647
c5 2147483647
c6 9223372036854775807
c7 9.22337e18
c8 9.223372036854776e18
c9 9.223372036854776e18
c10 9.223372036854776e18
c12 9999.9999
execute my_delete ; set @arg00= -9223372036854775808; set statement sql_mode = '' for
execute my_insert using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
Warning 1264 Out of range value for column 'c2' at row 1
Warning 1264 Out of range value for column 'c3' at row 1
Warning 1264 Out of range value for column 'c4' at row 1
Warning 1264 Out of range value for column 'c5' at row 1
Warning 1264 Out of range value for column 'c12' at row 1
execute my_select ;
c1 -128
c2 -32768
c3 -8388608
c4 -2147483648
c5 -2147483648
c6 -9223372036854775808
c7 -9.22337e18
c8 -9.223372036854776e18
c9 -9.223372036854776e18
c10 -9.223372036854776e18
c12 -9999.9999
execute my_delete ; set @arg00= '-9223372036854775808'; set statement sql_mode = '' for
execute my_insert using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
Warning 1264 Out of range value for column 'c2' at row 1
Warning 1264 Out of range value for column 'c3' at row 1
Warning 1264 Out of range value for column 'c4' at row 1
Warning 1264 Out of range value for column 'c5' at row 1
Warning 1264 Out of range value for column 'c12' at row 1
execute my_select ;
c1 -128
c2 -32768
c3 -8388608
c4 -2147483648
c5 -2147483648
c6 -9223372036854775808
c7 -9.22337e18
c8 -9.223372036854776e18
c9 -9.223372036854776e18
c10 -9.223372036854776e18
c12 -9999.9999
execute my_delete ; set @arg00= 1.11111111111111111111e+50; set statement sql_mode = '' for
execute my_insert using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
Warning 1264 Out of range value for column 'c2' at row 1
Warning 1264 Out of range value for column 'c3' at row 1
Warning 1264 Out of range value for column 'c4' at row 1
Warning 1264 Out of range value for column 'c5' at row 1
Warning 1264 Out of range value for column 'c6' at row 1
Warning 1264 Out of range value for column 'c7' at row 1
Warning 1264 Out of range value for column 'c12' at row 1
execute my_select ;
c1 127
c2 32767
c3 8388607
c4 2147483647
c5 2147483647
c6 9223372036854775807
c7 3.40282e38
c8 1.111111111111111e50
c9 1.111111111111111e50
c10 1.111111111111111e50
c12 9999.9999
execute my_delete ; set @arg00= '1.11111111111111111111e+50'; set statement sql_mode = '' for
execute my_insert using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
Warning 1264 Out of range value for column 'c2' at row 1
Warning 1264 Out of range value for column 'c3' at row 1
Warning 1264 Out of range value for column 'c4' at row 1
Warning 1264 Out of range value for column 'c5' at row 1
Warning 1264 Out of range value for column 'c6' at row 1
Warning 1264 Out of range value for column 'c7' at row 1
Warning 1264 Out of range value for column 'c12' at row 1
execute my_select ;
c1 127
c2 32767
c3 8388607
c4 2147483647
c5 2147483647
c6 9223372036854775807
c7 3.40282e38
c8 1.111111111111111e50
c9 1.111111111111111e50
c10 1.111111111111111e50
c12 9999.9999
execute my_delete ; set @arg00= -1.11111111111111111111e+50; set statement sql_mode = '' for
execute my_insert using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
Warning 1264 Out of range value for column 'c2' at row 1
Warning 1264 Out of range value for column 'c3' at row 1
Warning 1264 Out of range value for column 'c4' at row 1
Warning 1264 Out of range value for column 'c5' at row 1
Warning 1264 Out of range value for column 'c6' at row 1
Warning 1264 Out of range value for column 'c7' at row 1
Warning 1264 Out of range value for column 'c12' at row 1
execute my_select ;
c1 -128
c2 -32768
c3 -8388608
c4 -2147483648
c5 -2147483648
c6 -9223372036854775808
c7 -3.40282e38
c8 -1.111111111111111e50
c9 -1.111111111111111e50
c10 -1.111111111111111e50
c12 -9999.9999
execute my_delete ; set @arg00= '-1.11111111111111111111e+50'; set statement sql_mode = '' for
execute my_insert using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1264 Out of range value for column 'c1' at row 1
Warning 1264 Out of range value for column 'c2' at row 1
Warning 1264 Out of range value for column 'c3' at row 1
Warning 1264 Out of range value for column 'c4' at row 1
Warning 1264 Out of range value for column 'c5' at row 1
Warning 1264 Out of range value for column 'c6' at row 1
Warning 1264 Out of range value for column 'c7' at row 1
Warning 1264 Out of range value for column 'c12' at row 1
execute my_select ;
c1 -128
c2 -32768
c3 -8388608
c4 -2147483648
c5 -2147483648
c6 -9223372036854775808
c7 -3.40282e38
c8 -1.111111111111111e50
c9 -1.111111111111111e50
c10 -1.111111111111111e50
c12 -9999.9999
execute my_delete ;
test_sequence
-- insert into string columns -- set sql_mode = '';
insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 20, '20', '20', '20', '20', '20', '20', '20', '20', '20', '20', '20' ) ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1 set @arg00= '21';
insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 21, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00 ) ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1
prepare stmt1 from "insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 22, '22', '22', '22', '22', '22', '22', '22', '22', '22', '22', '22' )" ;
execute stmt1 ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1 set @arg00= '23';
prepare stmt2 from "insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 23, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1
insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 30, CAST('30' as binary), CAST('30' as binary), CAST('30' as binary),
CAST('30' as binary), CAST('30' as binary), CAST('30' as binary),
CAST('30' as binary), CAST('30' as binary), CAST('30' as binary),
CAST('30' as binary), CAST('30' as binary) ) ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1 set @arg00= '31';
insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 31, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00 ) ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1
prepare stmt1 from "insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 32, CAST('32' as binary), CAST('32' as binary), CAST('32' as binary),
CAST('32' as binary), CAST('32' as binary), CAST('32' as binary),
CAST('32' as binary), CAST('32' as binary), CAST('32' as binary),
CAST('32' as binary), CAST('32' as binary) )" ;
execute stmt1 ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1 set @arg00= CAST('33' as binary);
prepare stmt2 from "insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 33, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1
insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40 ) ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1 set @arg00= 41;
insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 41, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00 ) ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1
prepare stmt1 from "insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 42, 42, 42, 42, 42, 42, 42, 42, 42, 42, 42, 42 )" ;
execute stmt1 ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1 set @arg00= 43;
prepare stmt2 from "insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 43, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1
insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 50, 50.0, 50.0, 50.0, 50.0, 50.0, 50.0, 50.0, 50.0, 50.0, 50.0, 50.0 ) ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1 set @arg00= 51.0;
insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 51, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00 ) ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1
prepare stmt1 from "insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 52, 52.0, 52.0, 52.0, 52.0, 52.0, 52.0, 52.0, 52.0, 52.0, 52.0, 52.0 )" ;
execute stmt1 ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1 set @arg00= 53.0;
prepare stmt2 from "insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 53, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1
insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 54, 5.4e+1, 5.4e+1, 5.4e+1, 5.4e+1, 5.4e+1, 5.4e+1, 5.4e+1, 5.4e+1, 5.4e+1, 5.4e+1, 5.4e+1 ) ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1 set @arg00= 5.5e+1;
insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 55, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00 ) ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1
prepare stmt1 from "insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 56, 5.6e+1, 5.6e+1, 5.6e+1, 5.6e+1, 5.6e+1, 5.6e+1, 5.6e+1, 5.6e+1, 5.6e+1, 5.6e+1, 5.6e+1 )" ;
execute stmt1 ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1 set @arg00= 5.7e+1;
prepare stmt2 from "insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 57, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1265 Data truncated for column 'c20' at row 1 set sql_mode = default; set @arg00= 'abc'; set @arg00= NULL ;
insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ) ;
insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 61, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00 ) ;
prepare stmt1 from "insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 62, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL )" ;
execute stmt1 ;
prepare stmt2 from "insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 63, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ; set @arg00= 2; set @arg00= NULL ;
insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 71, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00 ) ;
prepare stmt2 from "insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 73, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ; set @arg00= 8; set @arg00= NULL ;
insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 81, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00 ) ;
prepare stmt2 from "insert into t9
( c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30 )
values
( 83, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00 ;
select c1, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30
from t9 where c1 >= 20
order by c1 ;
c1 c20 c21 c22 c23 c24 c25 c26 c27 c28 c29 c30 20220202020202020202020 21221212121212121212121 22222222222222222222222 23223232323232323232323 30330303030303030303030 31331313131313131313131 32332323232323232323232 33333333333333333333333 40440404040404040404040 41441414141414141414141 42442424242424242424242 43443434343434343434343 50550.050.050.050.050.050.050.050.050.050.0 51551.051.051.051.051.051.051.051.051.051.0 52552.052.052.052.052.052.052.052.052.052.0 53553.053.053.053.053.053.053.053.053.053.0 54554545454545454545454 55655555555555555555555 56656565656565656565656 57657575757575757575757 60 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 61 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 62 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 63 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 71 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 73 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 81 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 83 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
test_sequence
-- select .. where string column = .. -- set @arg00= '20';
select 'true' as found from t9
where c1= 20and concat(c20,substr('20',1+length(c20)))= '20'and c21= '20'and
c22= '20'and c23= '20'and c24= '20'and c25= '20'and c26= '20'and
c27= '20'and c28= '20'and c29= '20'and c30= '20';
found
true
select 'true' as found from t9
where c1= 20and concat(c20,substr(@arg00,1+length(c20)))= @arg00 and
c21= @arg00 and c22= @arg00 and c23= @arg00 and c25= @arg00 and
c26= @arg00 and c27= @arg00 and c28= @arg00 and c29= @arg00 and c30= @arg00;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and concat(c20,substr('20',1+length(c20)))= '20'and c21= '20'and
c22= '20'and c23= '20'and c24= '20'and c25= '20'and c26= '20'and
c27= '20'and c28= '20'and c29= '20'and c30= '20'" ;
execute stmt1 ;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and concat(c20,substr(?,1+length(c20)))= ? and
c21= ? and c22= ? and c23= ? and c25= ? and
c26= ? and c27= ? and c28= ? and c29= ? and c30= ?" ;
execute stmt1 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ;
found
true set @arg00= CAST('20' as binary);
select 'true' as found from t9
where c1= 20and concat(c20,substr(CAST('20' as binary),1+length(c20)))
= CAST('20' as binary) and c21= CAST('20' as binary) and c22= CAST('20' as binary) and c23= CAST('20' as binary) and
c24= CAST('20' as binary) and c25= CAST('20' as binary) and
c26= CAST('20' as binary) and c27= CAST('20' as binary) and
c28= CAST('20' as binary) and c29= CAST('20' as binary) and
c30= CAST('20' as binary) ;
found
true
select 'true' as found from t9
where c1= 20and concat(c20,substr(@arg00,1+length(c20))) = @arg00 and
c21= @arg00 and c22= @arg00 and c23= @arg00 and c25= @arg00 and
c26= @arg00 and c27= @arg00 and c28= @arg00 and c29= @arg00 and
c30= @arg00;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and concat(c20,substr(CAST('20' as binary),1+length(c20)))
= CAST('20' as binary) and c21= CAST('20' as binary) and c22= CAST('20' as binary) and c23= CAST('20' as binary) and
c24= CAST('20' as binary) and c25= CAST('20' as binary) and
c26= CAST('20' as binary) and c27= CAST('20' as binary) and
c28= CAST('20' as binary) and c29= CAST('20' as binary) and
c30= CAST('20' as binary)" ;
execute stmt1 ;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and concat(c20,substr(?,1+length(c20))) = ? and c21= ? and
c22= ? and c23= ? and c25= ? and c26= ? and c27= ? and c28= ? and
c29= ? and c30= ?";
execute stmt1 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ;
found
true set @arg00= 20;
select 'true' as found from t9
where c1= 20and concat(c20,substr(20,1+length(c20)))= 20and c21= 20and
c22= 20and c23= 20and c24= 20and c25= 20and c26= 20and
c27= 20and c28= 20and c29= 20and c30= 20;
found
true
select 'true' as found from t9
where c1= 20and concat(c20,substr(@arg00,1+length(c20)))= @arg00 and
c21= @arg00 and c22= @arg00 and c23= @arg00 and c25= @arg00 and
c26= @arg00 and c27= @arg00 and c28= @arg00 and c29= @arg00 and c30= @arg00;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and concat(c20,substr(20,1+length(c20)))= 20and c21= 20and
c22= 20and c23= 20and c24= 20and c25= 20and c26= 20and
c27= 20and c28= 20and c29= 20and c30= 20" ;
execute stmt1 ;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and concat(c20,substr(?,1+length(c20)))= ? and
c21= ? and c22= ? and c23= ? and c25= ? and
c26= ? and c27= ? and c28= ? and c29= ? and c30= ?" ;
execute stmt1 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ;
found
true set @arg00= 20.0;
select 'true' as found from t9
where c1= 20and concat(c20,substr(20.0,1+length(c20)))= 20.0and c21= 20.0and
c22= 20.0and c23= 20.0and c24= 20.0and c25= 20.0and c26= 20.0and
c27= 20.0and c28= 20.0and c29= 20.0and c30= 20.0;
found
true
select 'true' as found from t9
where c1= 20and concat(c20,substr(@arg00,1+length(c20)))= @arg00 and
c21= @arg00 and c22= @arg00 and c23= @arg00 and c25= @arg00 and
c26= @arg00 and c27= @arg00 and c28= @arg00 and c29= @arg00 and c30= @arg00;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and concat(c20,substr(20.0,1+length(c20)))= 20.0and c21= 20.0and
c22= 20.0and c23= 20.0and c24= 20.0and c25= 20.0and c26= 20.0and
c27= 20.0and c28= 20.0and c29= 20.0and c30= 20.0" ;
execute stmt1 ;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and concat(c20,substr(?,1+length(c20)))= ? and
c21= ? and c22= ? and c23= ? and c25= ? and
c26= ? and c27= ? and c28= ? and c29= ? and c30= ?" ;
execute stmt1 using @arg00, @arg00, @arg00, @arg00, @arg00, @arg00,
@arg00, @arg00, @arg00, @arg00, @arg00 ;
found
true
delete from t9 ;
test_sequence
-- insert into date/time columns -- set sql_mode = ''; set @arg00= '1991-01-01 01:01:01';
insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 20, '1991-01-01 01:01:01', '1991-01-01 01:01:01', '1991-01-01 01:01:01', '1991-01-01 01:01:01', '1991-01-01 01:01:01') ;
Warnings:
Note 1265 Data truncated for column 'c13' at row 1
Note 1265 Data truncated for column 'c16' at row 1
Warning 1265 Data truncated for column 'c17' at row 1
insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 21, @arg00, @arg00, @arg00, @arg00, @arg00) ;
Warnings:
Note 1265 Data truncated for column 'c13' at row 1
Note 1265 Data truncated for column 'c16' at row 1
Warning 1265 Data truncated for column 'c17' at row 1
prepare stmt1 from "insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 22, '1991-01-01 01:01:01', '1991-01-01 01:01:01', '1991-01-01 01:01:01', '1991-01-01 01:01:01', '1991-01-01 01:01:01')" ;
execute stmt1 ;
Warnings:
Note 1265 Data truncated for column 'c13' at row 1
Note 1265 Data truncated for column 'c16' at row 1
Warning 1265 Data truncated for column 'c17' at row 1
prepare stmt2 from "insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 23, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00 ;
Warnings:
Note 1265 Data truncated for column 'c13' at row 1
Note 1265 Data truncated for column 'c16' at row 1
Warning 1265 Data truncated for column 'c17' at row 1 set @arg00= CAST('1991-01-01 01:01:01' as datetime) ;
insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 30, CAST('1991-01-01 01:01:01' as datetime),
CAST('1991-01-01 01:01:01' as datetime),
CAST('1991-01-01 01:01:01' as datetime),
CAST('1991-01-01 01:01:01' as datetime),
CAST('1991-01-01 01:01:01' as datetime)) ;
Warnings:
Note 1265 Data truncated for column 'c13' at row 1
Note 1265 Data truncated for column 'c16' at row 1
Warning 1265 Data truncated for column 'c17' at row 1
insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 31, @arg00, @arg00, @arg00, @arg00, @arg00) ;
Warnings:
Note 1265 Data truncated for column 'c13' at row 1
Note 1265 Data truncated for column 'c16' at row 1
Warning 1265 Data truncated for column 'c17' at row 1
prepare stmt1 from "insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 32, CAST('1991-01-01 01:01:01' as datetime),
CAST('1991-01-01 01:01:01' as datetime),
CAST('1991-01-01 01:01:01' as datetime),
CAST('1991-01-01 01:01:01' as datetime),
CAST('1991-01-01 01:01:01' as datetime))" ;
execute stmt1 ;
Warnings:
Note 1265 Data truncated for column 'c13' at row 1
Note 1265 Data truncated for column 'c16' at row 1
Warning 1265 Data truncated for column 'c17' at row 1
prepare stmt2 from "insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 33, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00 ;
Warnings:
Note 1265 Data truncated for column 'c13' at row 1
Note 1265 Data truncated for column 'c16' at row 1
Warning 1265 Data truncated for column 'c17' at row 1 set @arg00= 2000000000;
insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 40, 2000000000, 2000000000, 2000000000, 2000000000, 2000000000 ) ;
Warnings:
Warning 1265 Data truncated for column 'c13' at row 1
Warning 1265 Data truncated for column 'c14' at row 1
Warning 1265 Data truncated for column 'c15' at row 1
Warning 1265 Data truncated for column 'c16' at row 1
Warning 1264 Out of range value for column 'c17' at row 1
insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 41, @arg00, @arg00, @arg00, @arg00, @arg00) ;
Warnings:
Warning 1265 Data truncated for column 'c13' at row 1
Warning 1265 Data truncated for column 'c14' at row 1
Warning 1265 Data truncated for column 'c15' at row 1
Warning 1265 Data truncated for column 'c16' at row 1
Warning 1264 Out of range value for column 'c17' at row 1
prepare stmt1 from "insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 42, 2000000000, 2000000000, 2000000000, 2000000000, 2000000000 )" ;
execute stmt1 ;
Warnings:
Warning 1265 Data truncated for column 'c13' at row 1
Warning 1265 Data truncated for column 'c14' at row 1
Warning 1265 Data truncated for column 'c15' at row 1
Warning 1265 Data truncated for column 'c16' at row 1
Warning 1264 Out of range value for column 'c17' at row 1
prepare stmt2 from "insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 43, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1265 Data truncated for column 'c13' at row 1
Warning 1265 Data truncated for column 'c14' at row 1
Warning 1265 Data truncated for column 'c15' at row 1
Warning 1265 Data truncated for column 'c16' at row 1
Warning 1264 Out of range value for column 'c17' at row 1 set @arg00= 1.0e+10;
insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 50, 1.0e+10, 1.0e+10, 1.0e+10, 1.0e+10, 1.0e+10 ) ;
Warnings:
Warning 1265 Data truncated for column 'c15' at row 1
Note 1265 Data truncated for column 'c16' at row 1
Warning 1264 Out of range value for column 'c17' at row 1
insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 51, @arg00, @arg00, @arg00, @arg00, @arg00) ;
Warnings:
Warning 1265 Data truncated for column 'c15' at row 1
Note 1265 Data truncated for column 'c16' at row 1
Warning 1264 Out of range value for column 'c17' at row 1
prepare stmt1 from "insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 52, 1.0e+10, 1.0e+10, 1.0e+10, 1.0e+10, 1.0e+10 )" ;
execute stmt1 ;
Warnings:
Warning 1265 Data truncated for column 'c15' at row 1
Note 1265 Data truncated for column 'c16' at row 1
Warning 1264 Out of range value for column 'c17' at row 1
prepare stmt2 from "insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 53, ?, ?, ?, ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00, @arg00 ;
Warnings:
Warning 1265 Data truncated for column 'c15' at row 1
Note 1265 Data truncated for column 'c16' at row 1
Warning 1264 Out of range value for column 'c17' at row 1 set sql_mode = default; set @arg00= 'abc'; set @arg00= NULL ;
insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 60, NULL, NULL, '1991-01-01 01:01:01',
NULL, NULL) ;
insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 61, @arg00, @arg00, '1991-01-01 01:01:01', @arg00, @arg00) ;
prepare stmt1 from "insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 62, NULL, NULL, '1991-01-01 01:01:01',
NULL, NULL)" ;
execute stmt1 ;
prepare stmt2 from "insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 63, ?, ?, '1991-01-01 01:01:01', ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00 ; set @arg00= 8; set @arg00= NULL ;
insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 71, @arg00, @arg00, '1991-01-01 01:01:01', @arg00, @arg00) ;
prepare stmt2 from "insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 73, ?, ?, '1991-01-01 01:01:01', ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00 ; set @arg00= 8.0; set @arg00= NULL ;
insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 81, @arg00, @arg00, '1991-01-01 01:01:01', @arg00, @arg00) ;
prepare stmt2 from "insert into t9
( c1, c13, c14, c15, c16, c17 )
values
( 83, ?, ?, '1991-01-01 01:01:01', ?, ? )" ;
execute stmt2 using @arg00, @arg00, @arg00, @arg00 ;
select c1, c13, c14, c15, c16, c17 from t9 order by c1 ;
c1 c13 c14 c15 c16 c17 201991-01-011991-01-0101:01:011991-01-0101:01:0101:01:011991 211991-01-011991-01-0101:01:011991-01-0101:01:0101:01:011991 221991-01-011991-01-0101:01:011991-01-0101:01:0101:01:011991 231991-01-011991-01-0101:01:011991-01-0101:01:0101:01:011991 301991-01-011991-01-0101:01:011991-01-0101:01:0101:01:011991 311991-01-011991-01-0101:01:011991-01-0101:01:0101:01:011991 321991-01-011991-01-0101:01:011991-01-0101:01:0101:01:011991 331991-01-011991-01-0101:01:011991-01-0101:01:0101:01:011991 400000-00-000000-00-0000:00:000000-00-0000:00:0000:00:000000 410000-00-000000-00-0000:00:000000-00-0000:00:0000:00:000000 420000-00-000000-00-0000:00:000000-00-0000:00:0000:00:000000 430000-00-000000-00-0000:00:000000-00-0000:00:0000:00:000000 502001-00-002001-00-0000:00:000000-00-0000:00:0000:00:000000 512001-00-002001-00-0000:00:000000-00-0000:00:0000:00:000000 522001-00-002001-00-0000:00:000000-00-0000:00:0000:00:000000 532001-00-002001-00-0000:00:000000-00-0000:00:0000:00:000000 60 NULL NULL 1991-01-0101:01:01 NULL NULL 61 NULL NULL 1991-01-0101:01:01 NULL NULL 62 NULL NULL 1991-01-0101:01:01 NULL NULL 63 NULL NULL 1991-01-0101:01:01 NULL NULL 71 NULL NULL 1991-01-0101:01:01 NULL NULL 73 NULL NULL 1991-01-0101:01:01 NULL NULL 81 NULL NULL 1991-01-0101:01:01 NULL NULL 83 NULL NULL 1991-01-0101:01:01 NULL NULL
test_sequence
-- select .. where date/time column = .. -- set @arg00= '1991-01-01 01:01:01';
select 'true' as found from t9
where c1= 20and c13= CAST('1991-01-01 01:01:01' AS DATE) and c14= '1991-01-01 01:01:01'and
c15= '1991-01-01 01:01:01'and
c17= '1991-01-01 01:01:01';
found
true
select 'true' as found from t9
where c1= 20and c13= CAST(@arg00 AS DATE) and c14= @arg00 and c15= @arg00 and c17= @arg00 ;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and c13= CAST('1991-01-01 01:01:01' AS DATE) and c14= '1991-01-01 01:01:01'and
c15= '1991-01-01 01:01:01'and
c17= '1991-01-01 01:01:01'" ;
execute stmt1 ;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and c13= CAST(? AS DATE) and c14= ? and c15= ? and c17= ?" ;
execute stmt1 using @arg00, @arg00, @arg00, @arg00 ;
found
true set @arg00= CAST('1991-01-01 01:01:01' as datetime) ;
select 'true' as found from t9
where c1= 20and c13= CAST('1991-01-01 00:00:00' as datetime) and
c14= CAST('1991-01-01 01:01:01' as datetime) and
c15= CAST('1991-01-01 01:01:01' as datetime) and
c17= CAST('1991-01-01 01:01:01' as datetime) ;
found
true
select 'true' as found from t9
where c1= 20and c13= CAST(@arg00 AS DATE) and c14= @arg00 and c15= @arg00 and c17= @arg00 ;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and c13= CAST('1991-01-01 00:00:00' as datetime) and
c14= CAST('1991-01-01 01:01:01' as datetime) and
c15= CAST('1991-01-01 01:01:01' as datetime) and
c17= CAST('1991-01-01 01:01:01' as datetime)" ;
execute stmt1 ;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and c13= CAST(? AS DATE) and c14= ? and c15= ? and c17= ?" ;
execute stmt1 using @arg00, @arg00, @arg00, @arg00 ;
found
true set @arg00= '01:01:01';
select 'true' as found from t9 where c1= 20and c16= '01:01:01';
found
true
select 'true' as found from t9 where c1= 20and c16= @arg00 ;
found
true
prepare stmt1 from "select 'true' as found from t9 where c1= 20 and c16= '01:01:01'";
execute stmt1 ;
found
true
prepare stmt1 from "select 'true' as found from t9 where c1= 20 and c16= ?";
execute stmt1 using @arg00 ;
found
true set @arg00= CAST('01:01:01' as time) ;
select 'true' as found from t9 where c1= 20and c16= CAST('01:01:01' as time) ;
found
true
select 'true' as found from t9 where c1= 20and c16= @arg00 ;
found
true
prepare stmt1 from "select 'true' as found from t9 where c1= 20 and c16= CAST('01:01:01' as time)";
execute stmt1 ;
found
true
prepare stmt1 from "select 'true' as found from t9 where c1= 20 and c16= ?";
execute stmt1 using @arg00 ;
found
true set @arg00= 1991;
select 'true' as found from t9
where c1= 20and c17= 1991;
found
true
select 'true' as found from t9
where c1= 20and c17= @arg00 ;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and c17= 1991" ;
execute stmt1 ;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and c17= ?" ;
execute stmt1 using @arg00 ;
found
true set @arg00= 1.991e+3;
select 'true' as found from t9
where c1= 20and abs(c17 - 1.991e+3) < 0.01;
found
true
select 'true' as found from t9
where c1= 20and abs(c17 - @arg00) < 0.01;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and abs(c17 - 1.991e+3) < 0.01" ;
execute stmt1 ;
found
true
prepare stmt1 from "select 'true' as found from t9
where c1= 20and abs(c17 - ?) < 0.01" ;
execute stmt1 using @arg00 ;
found
true
drop table t1, t9;
Messung V0.5 in Prozent
¤ Dauer der Verarbeitung: 0.123 Sekunden
(vorverarbeitet am 2026-10-08)
¤
Die Informationen auf dieser Webseite wurden
nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit,
noch Qualität der bereit gestellten Informationen zugesichert.
Bemerkung:
Die farbliche Syntaxdarstellung und die Messung sind noch experimentell.
