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 set sql_mode='';
5 create table t1 (
6 a date not null,
7 b mediumtext generated always as ((a not in (a,a))) virtual,
8 c timestamp generated always as ((a not in (b,b))) stored not null
9 );
10 insert t1(a) values(7777777777);
11 Warnings:
12 Warning 1265 Data truncated for column 'a' at row 1
13 Warning 1292 Incorrect date value: '0' for column 'a' at row 1
14 show warnings;
15 Level Code Message
16 Warning 1265 Data truncated for column 'a' at row 1
17 Warning 1292 Incorrect date value: '0' for column 'a' at row 1
18 set sql_mode='';
19 insert t1(a) values(6666666666);
20 Warnings:
21 Warning 1265 Data truncated for column 'a' at row 1
22 Warning 1292 Incorrect date value: '0' for column 'a' at row 1
23 show warnings;
24 Level Code Message
25 Warning 1265 Data truncated for column 'a' at row 1
26 Warning 1292 Incorrect date value: '0' for column 'a' at row 1
27 drop table t1;