diff options
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 6 |
1 files changed, 0 insertions, 6 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index fa130afc84b..00a040ccfdc 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -915,12 +915,6 @@ 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); -- error ER_VIEW_PREVENT_UPDATE -delete from v2 where col1 = (select max(col1) from v1); --- error ER_VIEW_PREVENT_UPDATE -delete from v2 where col1 = (select max(col1) from t1); --- 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 delete t1 from t1,t2 where (select max(col1) from v1) > 0 and t1.col1 = t2.col1; |