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 b30eda7eb94..69d9e746ec0 100644 --- a/mysql-test/main/func_math.test +++ b/mysql-test/main/func_math.test @@ -1907,7 +1907,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 @@ -1917,7 +1917,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 |