diff options
author | Sergei Golubchik <serg@mariadb.org> | 2019-09-24 19:47:45 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2019-10-14 10:29:30 +0200 |
commit | c7320830a62b0ed3245c476f074c534d3cd20027 (patch) | |
tree | 2e4386e647286b0a53be85f751758b92cdecf88e /mysql-test/main/insert.result | |
parent | 173ae63114d3c36ce8366d50ac17c18765ab2ceb (diff) | |
download | mariadb-git-c7320830a62b0ed3245c476f074c534d3cd20027.tar.gz |
outer references in subqueries in INSERT
remove inconsistent limitation
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; |