diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2016-07-23 16:55:52 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-08-27 16:59:12 +0200 |
| commit | 12d2c4fcd0bc3fbe74759e8285f2c93ad348e749 (patch) | |
| tree | e8f0ec7fab2a8ec1365e10a5ddde62e7af2e885d /mysql-test/t/default.test | |
| parent | 4070d55735f1642e563b8d60fc2e9771f4963a3f (diff) | |
| download | mariadb-git-12d2c4fcd0bc3fbe74759e8285f2c93ad348e749.tar.gz | |
optimize constant default expressions
to be calculated at the CREATE TABLE time and stored in
the default row image.
Diffstat (limited to 'mysql-test/t/default.test')
| -rw-r--r-- | mysql-test/t/default.test | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/mysql-test/t/default.test b/mysql-test/t/default.test index 47de4a00a50..6c871527212 100644 --- a/mysql-test/t/default.test +++ b/mysql-test/t/default.test @@ -295,7 +295,6 @@ create or replace table t1 (a int not null, b int default (a+1)); --error ER_EXPRESSION_REFERS_TO_UNINIT_FIELD create or replace table t1 (a int default a); ---error ER_EXPRESSION_REFERS_TO_UNINIT_FIELD 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)); @@ -1810,7 +1809,7 @@ DROP TABLE t1; # # Order of evaluation: # -create table t1 (a int default 1, b int default (1+1), c int); +create table t1 (a int default 1, b int default (rand()*0+2), c int); insert t1 (c) values (a); insert t1 (c) values (b); select * from t1; |