diff options
Diffstat (limited to 'mysql-test/main/func_math.test')
| -rw-r--r-- | mysql-test/main/func_math.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/func_math.test b/mysql-test/main/func_math.test index 02c5b872ea5..d4145a71912 100644 --- a/mysql-test/main/func_math.test +++ b/mysql-test/main/func_math.test @@ -1931,7 +1931,7 @@ DROP TABLE t1,t2; --echo # MDEV-21278 Assertion `is_unsigned() == attr.unsigned_flag' or Assertion `field.is_sane()' failed --echo # -CREATE TABLE t1 (a TIMESTAMP); +CREATE TABLE t1 (a TIMESTAMP NOT NULL DEFAULT NOW()); INSERT INTO t1 VALUES (NULL),(NULL); SET SESSION SQL_MODE= 'NO_UNSIGNED_SUBTRACTION'; --replace_column 1 xxx @@ -1941,7 +1941,7 @@ SHOW CREATE TABLE t2; DROP TABLE t2, t1; SET sql_mode=DEFAULT; -CREATE TABLE t1 (a TIMESTAMP); +CREATE TABLE t1 (a TIMESTAMP NOT NULL DEFAULT NOW()); INSERT INTO t1 VALUES (NULL),(NULL); SET SESSION SQL_MODE= 'NO_UNSIGNED_SUBTRACTION'; --replace_column 1 xxx |