diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2016-06-26 20:50:28 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-06-30 11:43:02 +0200 |
| commit | e8bdb73adee78253424fbb1ff782ad12700939a1 (patch) | |
| tree | 2b4db8961bf30957812ef8257fbeb82310eedf4d /mysql-test/t/default.test | |
| parent | 3205da712440ccc755281850b9e62d38b6133b33 (diff) | |
| download | mariadb-git-e8bdb73adee78253424fbb1ff782ad12700939a1.tar.gz | |
function DEFAULT(x) now works for expression defaults
Diffstat (limited to 'mysql-test/t/default.test')
| -rw-r--r-- | mysql-test/t/default.test | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/mysql-test/t/default.test b/mysql-test/t/default.test index 4219e0fd11a..1d3487abd9c 100644 --- a/mysql-test/t/default.test +++ b/mysql-test/t/default.test @@ -299,11 +299,11 @@ create or replace table t1 (a int default a); create or replace table t1 (a int default b, b int default (1+1)); --error ER_EXPRESSION_REFERS_TO_UNINIT_FIELD create or replace table t1 (a int default 1, b int as (c), c int as (a+1)); ---error ER_NO_DEFAULT_FOR_FIELD +--error ER_EXPRESSION_REFERS_TO_UNINIT_FIELD CREATE TABLE t1 (a INT DEFAULT (DEFAULT(a))); ---error ER_NO_DEFAULT_FOR_FIELD +--error ER_EXPRESSION_REFERS_TO_UNINIT_FIELD CREATE TABLE t1 (a INT DEFAULT(DEFAULT(b)), b INT DEFAULT(DEFAULT(a))); ---error ER_NO_DEFAULT_FOR_FIELD +--error ER_EXPRESSION_REFERS_TO_UNINIT_FIELD CREATE TABLE t1 (a INT DEFAULT(DEFAULT(b)) NOT NULL, b INT DEFAULT(DEFAULT(a)) NOT NULL); --echo # @@ -879,7 +879,6 @@ SHOW CREATE TABLE t1; insert into t1 values (1,1),(2,2); insert into t1 values (default,default); select * from t1; ---error ER_NO_DEFAULT_FOR_FIELD select default(a),b from t1; select a,default(b) from t1; drop table t1; |