diff options
Diffstat (limited to 'mysql-test/main/insert.result')
-rw-r--r-- | mysql-test/main/insert.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/main/insert.result b/mysql-test/main/insert.result index 4aea81262d2..d8f40b7383a 100644 --- a/mysql-test/main/insert.result +++ b/mysql-test/main/insert.result @@ -751,3 +751,19 @@ REPLACE INTO v1 SET f = NULL; ERROR 22007: Truncated incorrect DOUBLE value: 'foo' DROP VIEW v1; DROP TABLE t1; +create table t1 (a int default 5); +insert t1 values (1); +insert t1 values (a); +insert t1 values ((select a+1)); +insert t1 set a=2; +insert t1 set a=a+2; +insert t1 set a=(select a+3); +select * from t1; +a +1 +5 +6 +2 +7 +8 +drop table t1; |