diff options
Diffstat (limited to 'mysql-test/t/merge.test')
| -rw-r--r-- | mysql-test/t/merge.test | 33 |
1 files changed, 0 insertions, 33 deletions
diff --git a/mysql-test/t/merge.test b/mysql-test/t/merge.test index 09f313616f1..95c78caf034 100644 --- a/mysql-test/t/merge.test +++ b/mysql-test/t/merge.test @@ -2764,39 +2764,6 @@ update m1 set a = ((select max(a) from v1)); --error ER_VIEW_PREVENT_UPDATE update m1 set a = ((select max(a) from tmp, v1)); - ---error ER_UPDATE_TABLE_USED -delete from m1 where a = (select max(a) from m1); ---error ER_UPDATE_TABLE_USED -delete from m1 where a = (select max(a) from m2); ---error ER_UPDATE_TABLE_USED -delete from m1 where a = (select max(a) from t1); ---error ER_UPDATE_TABLE_USED -delete from m1 where a = (select max(a) from t2); - ---error ER_UPDATE_TABLE_USED -delete from m1 where a = (select max(a) from t3, m1); ---error ER_UPDATE_TABLE_USED -delete from m1 where a = (select max(a) from t3, m2); ---error ER_UPDATE_TABLE_USED -delete from m1 where a = (select max(a) from t3, t1); ---error ER_UPDATE_TABLE_USED -delete from m1 where a = (select max(a) from t3, t2); - ---error ER_UPDATE_TABLE_USED -delete from m1 where a = (select max(a) from tmp, m1); ---error ER_UPDATE_TABLE_USED -delete from m1 where a = (select max(a) from tmp, m2); ---error ER_UPDATE_TABLE_USED -delete from m1 where a = (select max(a) from tmp, t1); ---error ER_UPDATE_TABLE_USED -delete from m1 where a = (select max(a) from tmp, t2); - ---error ER_VIEW_PREVENT_UPDATE -delete from m1 where a = (select max(a) from v1); ---error ER_VIEW_PREVENT_UPDATE -delete from m1 where a = (select max(a) from tmp, v1); - drop view v1; drop temporary table tmp; drop table t1, t2, t3, m1, m2; |