diff options
| author | Alexander Barkov <bar@mariadb.org> | 2017-05-05 16:12:54 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-05-05 16:12:54 +0400 |
| commit | ac53b49b1be807f588aebd83883ec93b764f5d54 (patch) | |
| tree | c86cbdb535eefb15e2077a7ac2ffaeff9d76955e /mysql-test/t/default.test | |
| parent | 583b68e89961c35fa95a06c38988f82e33c73f4a (diff) | |
| parent | db0917f68f2681882974afd53935aa8cba29c6b8 (diff) | |
| download | mariadb-git-ac53b49b1be807f588aebd83883ec93b764f5d54.tar.gz | |
Merge remote-tracking branch 'origin/10.2' into bb-10.2-ext
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 2a043e78ea9..a3b349bb384 100644 --- a/mysql-test/t/default.test +++ b/mysql-test/t/default.test @@ -1287,6 +1287,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 |