EVOLUTION-MANAGER

Edit File: gcol_bug20746926.result

#Bug #20746926: GENERATED COLUMNS: INVALID READ OF THD WHEN WARNINGS # # Testing cmp_item_datetime connect con1,localhost,root,,; set sql_mode=''; create table t1 ( a date not null, b mediumtext generated always as ((a not in (a,a))) virtual, c timestamp generated always as ((a not in (b,b))) stored ); insert t1(a) values(7777777777); Warnings: Warning 1265 Data truncated for column 'a' at row 1 Warning 1292 Incorrect datetime value: '0' show warnings; Level Code Message Warning 1265 Data truncated for column 'a' at row 1 Warning 1292 Incorrect datetime value: '0' disconnect con1; connect con2,localhost,root,,; set sql_mode=''; insert t1(a) values(6666666666); Warnings: Warning 1265 Data truncated for column 'a' at row 1 Warning 1292 Incorrect datetime value: '0' show warnings; Level Code Message Warning 1265 Data truncated for column 'a' at row 1 Warning 1292 Incorrect datetime value: '0' drop table t1; disconnect con2; connection default;