1# 2# MDEV-15738 Server crashes in my_strcasecmp_utf8 on query from I_S with UNION 3# executed as PS 4# 5 6PREPARE stmt1 FROM " 7SELECT table_name FROM information_schema.tables 8WHERE table_name = 't1_first' 9UNION ALL 10SELECT table_name FROM information_schema.tables 11WHERE table_name = 't1_second'"; 12execute stmt1; 13execute stmt1; 14 15create or replace table t1 (a int primary key, table_name char(40)); 16insert into t1 values(1,"t1_first"); 17insert into t1 values(2,"t1_second"); 18 19PREPARE stmt2 FROM " 20SELECT table_name FROM t1 21WHERE table_name = 't1_first' 22UNION ALL 23SELECT table_name FROM t1 24WHERE table_name = 't1_second'"; 25 26execute stmt2; 27execute stmt2; 28flush tables; 29execute stmt2; 30alter table t1 add column b int; 31execute stmt2; 32execute stmt2; 33drop table t1; 34--error ER_NO_SUCH_TABLE 35execute stmt2; 36create or replace table t1 (a int primary key, table_name char(40)); 37insert into t1 values(1,"t1_first"); 38execute stmt2; 39 40deallocate prepare stmt1; 41deallocate prepare stmt2; 42drop table t1; 43 44--echo # 45--echo # MDEV-25808 PREPARE/EXECUTE makes signed integer out of unsigned 46--echo # 47prepare p1 from 'select concat(?)'; 48execute p1 using 17864960750176564435; 49prepare p1 from 'select SQRT(?) is not null'; 50execute p1 using 17864960750176564435; 51 52--echo # 53--echo # End of 10.3 tests 54--echo # 55