diff options
Diffstat (limited to 'mysql-test/suite/gcol/r/gcol_bug20746926.result')
| -rw-r--r-- | mysql-test/suite/gcol/r/gcol_bug20746926.result | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/suite/gcol/r/gcol_bug20746926.result b/mysql-test/suite/gcol/r/gcol_bug20746926.result new file mode 100644 index 00000000..590caf02 --- /dev/null +++ b/mysql-test/suite/gcol/r/gcol_bug20746926.result @@ -0,0 +1,32 @@ +#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 Truncated incorrect datetime value: '0' +show warnings; +Level Code Message +Warning 1265 Data truncated for column 'a' at row 1 +Warning 1292 Truncated 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 Truncated incorrect datetime value: '0' +show warnings; +Level Code Message +Warning 1265 Data truncated for column 'a' at row 1 +Warning 1292 Truncated incorrect datetime value: '0' +drop table t1; +disconnect con2; +connection default; |