Debian Codegraph @

mysql-test/suite/gcol/t/gcol_bug20746926.test

raw
1 --echo #Bug #20746926: GENERATED COLUMNS: INVALID READ OF THD WHEN WARNINGS
2 --echo #
3 --echo # Testing cmp_item_datetime
4 connect(con1,localhost,root,,);
5 --disable_warnings
6 set sql_mode='';
7 --enable_warnings
8 create table t1 (
9 a date not null,
10 b mediumtext generated always as ((a not in (a,a))) virtual,
11 c timestamp generated always as ((a not in (b,b))) stored not null
12 );
13 insert t1(a) values(7777777777);
14 show warnings;
15 disconnect con1;
16 --source include/wait_until_disconnected.inc
17
18 connect(con2,localhost,root,,);
19 --disable_warnings
20 set sql_mode='';
21 --enable_warnings
22 insert t1(a) values(6666666666);
23 show warnings;
24
25 drop table t1;
26 disconnect con2;
27 --source include/wait_until_disconnected.inc
28 connection default;