Debian Codegraph @

mysql-test/suite/gcol/r/gcol_bug20746926.result

raw
1 #Bug #20746926: GENERATED COLUMNS: INVALID READ OF THD WHEN WARNINGS
2 #
3 # Testing cmp_item_datetime
4 connect con1,localhost,root,,;
5 set sql_mode='';
6 create table t1 (
7 a date not null,
8 b mediumtext generated always as ((a not in (a,a))) virtual,
9 c timestamp generated always as ((a not in (b,b))) stored
10 );
11 insert t1(a) values(7777777777);
12 Warnings:
13 Warning 1265 Data truncated for column 'a' at row 1
14 Warning 1292 Incorrect datetime value: '0' for column `test`.`t1`.`b` at row 1
15 show warnings;
16 Level Code Message
17 Warning 1265 Data truncated for column 'a' at row 1
18 Warning 1292 Incorrect datetime value: '0' for column `test`.`t1`.`b` at row 1
19 disconnect con1;
20 connect con2,localhost,root,,;
21 set sql_mode='';
22 insert t1(a) values(6666666666);
23 Warnings:
24 Warning 1265 Data truncated for column 'a' at row 1
25 Warning 1292 Incorrect datetime value: '0' for column `test`.`t1`.`b` at row 1
26 show warnings;
27 Level Code Message
28 Warning 1265 Data truncated for column 'a' at row 1
29 Warning 1292 Incorrect datetime value: '0' for column `test`.`t1`.`b` at row 1
30 drop table t1;
31 disconnect con2;
32 connection default;