diff options
Diffstat (limited to 'mysql-test/suite/gcol/r/gcol_ins_upd_innodb.result')
-rw-r--r-- | mysql-test/suite/gcol/r/gcol_ins_upd_innodb.result | 14 |
1 files changed, 5 insertions, 9 deletions
diff --git a/mysql-test/suite/gcol/r/gcol_ins_upd_innodb.result b/mysql-test/suite/gcol/r/gcol_ins_upd_innodb.result index ec5e8c0d70d..193ef064da8 100644 --- a/mysql-test/suite/gcol/r/gcol_ins_upd_innodb.result +++ b/mysql-test/suite/gcol/r/gcol_ins_upd_innodb.result @@ -627,16 +627,12 @@ a BLOB GENERATED ALWAYS AS ('') VIRTUAL, b TIMESTAMP(4) GENERATED ALWAYS AS ('') VIRTUAL, KEY (a(183),b) ); -Warnings: -Warning 1901 Function or expression '''' cannot be used in the GENERATED ALWAYS AS clause of `b` -Warning 1105 Expression depends on the @@sql_mode value TIME_ROUND_FRACTIONAL +ERROR HY000: Function or expression '''' cannot be used in the GENERATED ALWAYS AS clause of `b` +CREATE TABLE t ( +a BLOB GENERATED ALWAYS AS ('') VIRTUAL, +b TIMESTAMP(4) GENERATED ALWAYS AS ('') VIRTUAL +); INSERT IGNORE INTO t VALUES(), (), (); -Warnings: -Warning 1901 Function or expression '''' cannot be used in the GENERATED ALWAYS AS clause of `b` -Warning 1105 Expression depends on the @@sql_mode value TIME_ROUND_FRACTIONAL -Warning 1265 Data truncated for column 'b' at row 1 -Warning 1265 Data truncated for column 'b' at row 2 -Warning 1265 Data truncated for column 'b' at row 3 DELETE IGNORE FROM t; DROP TABLE t; # |