diff options
Diffstat (limited to 'mysql-test/main/func_math.result')
| -rw-r--r-- | mysql-test/main/func_math.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/func_math.result b/mysql-test/main/func_math.result index 746dd9169ca..a465199c49c 100644 --- a/mysql-test/main/func_math.result +++ b/mysql-test/main/func_math.result @@ -3648,7 +3648,7 @@ DROP TABLE t1,t2; # # MDEV-21278 Assertion `is_unsigned() == attr.unsigned_flag' or Assertion `field.is_sane()' failed # -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'; SELECT DISTINCT UUID_SHORT() - a FROM t1; @@ -3663,7 +3663,7 @@ t2 CREATE TABLE `t2` ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci 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'; SELECT UUID_SHORT() - a FROM t1; |