diff options
Diffstat (limited to 'mysql-test/suite/gcol/r/gcol_ins_upd_myisam.result')
| -rw-r--r-- | mysql-test/suite/gcol/r/gcol_ins_upd_myisam.result | 14 |
1 files changed, 5 insertions, 9 deletions
diff --git a/mysql-test/suite/gcol/r/gcol_ins_upd_myisam.result b/mysql-test/suite/gcol/r/gcol_ins_upd_myisam.result index 210c6450b70..e5f512d5029 100644 --- a/mysql-test/suite/gcol/r/gcol_ins_upd_myisam.result +++ b/mysql-test/suite/gcol/r/gcol_ins_upd_myisam.result @@ -549,16 +549,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; # |