diff options
Diffstat (limited to 'mysql-test/t/default.test')
| -rw-r--r-- | mysql-test/t/default.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/default.test b/mysql-test/t/default.test index 85f99806fc9..84ef620de04 100644 --- a/mysql-test/t/default.test +++ b/mysql-test/t/default.test @@ -1289,6 +1289,20 @@ INSERT INTO t1 (a,b) VALUES ('2003-02-01','2003-05-01 12:05:55'); SELECT * FROM t1; DROP TABLE t1; +# +# MDEV-10355 Weird error message upon CREATE TABLE with DEFAULT +# +# Column default value expression that includes a temporal function +# +CREATE OR REPLACE TABLE t1 ( col INT DEFAULT ( 1 LIKE ( NOW() BETWEEN '2000-01-01' AND '2012-12-12' ) ) ); +SHOW CREATE TABLE t1; +SET timestamp = UNIX_TIMESTAMP( '2004-04-04' ); +INSERT INTO t1 VALUES( DEFAULT ); +SET timestamp = DEFAULT; +INSERT INTO t1 VALUES( DEFAULT ); +SELECT * FROM t1; +DROP TABLE t1; + --echo # --echo # Hybrid type functions |