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/subselect.test | |
| parent | 173ae63114d3c36ce8366d50ac17c18765ab2ceb (diff) | |
| download | mariadb-git-c7320830a62b0ed3245c476f074c534d3cd20027.tar.gz | |
outer references in subqueries in INSERT
remove inconsistent limitation
Diffstat (limited to 'mysql-test/main/subselect.test')
| -rw-r--r-- | mysql-test/main/subselect.test | 2 |
1 files changed, 0 insertions, 2 deletions
diff --git a/mysql-test/main/subselect.test b/mysql-test/main/subselect.test index 8b34e32740b..f6333c22684 100644 --- a/mysql-test/main/subselect.test +++ b/mysql-test/main/subselect.test @@ -394,8 +394,6 @@ select * from t1; # After this, only data based on old t1 records should have been added. INSERT INTO t1 (x) select (SELECT SUM(x)+2 FROM t1) FROM t2; select * from t1; --- error ER_BAD_FIELD_ERROR -INSERT DELAYED INTO t1 (x) VALUES ((SELECT SUM(x) FROM t2)); let $row_count_before= `SELECT COUNT(*) FROM t1`; INSERT DELAYED INTO t1 (x) VALUES ((SELECT SUM(a) FROM t2)); let $wait_condition= SELECT COUNT(*) <> $row_count_before FROM t1; |