diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2017-07-07 19:55:31 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2017-07-07 22:38:15 +0200 |
| commit | c65cce3698edde272b8452c1fecec3d9522cea6e (patch) | |
| tree | bddc69fadd7a800aaf0cea2d7cdc3e3008db0e8a /mysql-test/t/view.test | |
| parent | abf95afa2a1c23f3c7aa42f44fc665450ebeeea1 (diff) | |
| download | mariadb-git-c65cce3698edde272b8452c1fecec3d9522cea6e.tar.gz | |
MDEV-12137 DELETE statement with the same source and target
* various cleanups (mostly cosmetic)
* remove useless tests (that were tesing the error condition)
* optimize delete_use_source test (from 6 mins to 50 seconds,
mainly by removing two huge rollbacks at the end).
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 7 |
1 files changed, 0 insertions, 7 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 9ed37a2bf65..00a040ccfdc 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -914,13 +914,6 @@ update v3 set v3.col1 = (select max(col1) from t1); update v3 set v3.col1 = (select max(col1) from v2); -- error ER_UPDATE_TABLE_USED update v3 set v3.col1 = (select max(col1) from v3); -# Works since MDEV-12137 -# Previously error ER_VIEW_PREVENT_UPDATE -delete from v2 where col1 = (select max(col1) from v1); -# Previously error ER_VIEW_PREVENT_UPDATE -delete from v2 where col1 = (select max(col1) from t1); -# Previously error ER_UPDATE_TABLE_USED -delete from v2 where col1 = (select max(col1) from v2); -- error ER_VIEW_PREVENT_UPDATE delete v2 from v2,t2 where (select max(col1) from v1) > 0 and v2.col1 = t2.col1; -- error ER_VIEW_PREVENT_UPDATE |