diff options
Diffstat (limited to 'mysql-test/r/merge.result')
| -rw-r--r-- | mysql-test/r/merge.result | 42 |
1 files changed, 28 insertions, 14 deletions
diff --git a/mysql-test/r/merge.result b/mysql-test/r/merge.result index f468f47c4c9..6da7eb38655 100644 --- a/mysql-test/r/merge.result +++ b/mysql-test/r/merge.result @@ -3743,33 +3743,47 @@ ERROR HY000: The definition of table 'v1' prevents operation UPDATE on table 'm1 update m1 set a = ((select max(a) from tmp, v1)); ERROR HY000: The definition of table 'v1' prevents operation UPDATE on table 'm1' delete from m1 where a = (select max(a) from m1); -ERROR HY000: Table 'm1' is specified twice, both as a target for 'DELETE' and as a separate source for data +insert into t1 (a) values (1); +insert into t2 (a) values (1); delete from m1 where a = (select max(a) from m2); -ERROR HY000: Table 'm1' is specified twice, both as a target for 'DELETE' and as a separate source for data +insert into t1 (a) values (1); +insert into t2 (a) values (1); delete from m1 where a = (select max(a) from t1); -ERROR HY000: Table 'm1' is specified twice, both as a target for 'DELETE' and as a separate source for data +insert into t1 (a) values (1); +insert into t2 (a) values (1); delete from m1 where a = (select max(a) from t2); -ERROR HY000: Table 'm1' is specified twice, both as a target for 'DELETE' and as a separate source for data +insert into t1 (a) values (1); +insert into t2 (a) values (1); delete from m1 where a = (select max(a) from t3, m1); -ERROR HY000: Table 'm1' is specified twice, both as a target for 'DELETE' and as a separate source for data +insert into t1 (a) values (1); +insert into t2 (a) values (1); delete from m1 where a = (select max(a) from t3, m2); -ERROR HY000: Table 'm1' is specified twice, both as a target for 'DELETE' and as a separate source for data +insert into t1 (a) values (1); +insert into t2 (a) values (1); delete from m1 where a = (select max(a) from t3, t1); -ERROR HY000: Table 'm1' is specified twice, both as a target for 'DELETE' and as a separate source for data +insert into t1 (a) values (1); +insert into t2 (a) values (1); delete from m1 where a = (select max(a) from t3, t2); -ERROR HY000: Table 'm1' is specified twice, both as a target for 'DELETE' and as a separate source for data +insert into t1 (a) values (1); +insert into t2 (a) values (1); delete from m1 where a = (select max(a) from tmp, m1); -ERROR HY000: Table 'm1' is specified twice, both as a target for 'DELETE' and as a separate source for data +insert into t1 (a) values (1); +insert into t2 (a) values (1); delete from m1 where a = (select max(a) from tmp, m2); -ERROR HY000: Table 'm1' is specified twice, both as a target for 'DELETE' and as a separate source for data +insert into t1 (a) values (1); +insert into t2 (a) values (1); delete from m1 where a = (select max(a) from tmp, t1); -ERROR HY000: Table 'm1' is specified twice, both as a target for 'DELETE' and as a separate source for data +insert into t1 (a) values (1); +insert into t2 (a) values (1); delete from m1 where a = (select max(a) from tmp, t2); -ERROR HY000: Table 'm1' is specified twice, both as a target for 'DELETE' and as a separate source for data +insert into t1 (a) values (1); +insert into t2 (a) values (1); delete from m1 where a = (select max(a) from v1); -ERROR HY000: The definition of table 'v1' prevents operation DELETE on table 'm1' +insert into t1 (a) values (1); +insert into t2 (a) values (1); delete from m1 where a = (select max(a) from tmp, v1); -ERROR HY000: The definition of table 'v1' prevents operation DELETE on table 'm1' +insert into t1 (a) values (1); +insert into t2 (a) values (1); drop view v1; drop temporary table tmp; drop table t1, t2, t3, m1, m2; |