diff options
Diffstat (limited to 'mysql-test/main/delete.result')
-rw-r--r-- | mysql-test/main/delete.result | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/mysql-test/main/delete.result b/mysql-test/main/delete.result index ed3683d52f9..830f60aa3c7 100644 --- a/mysql-test/main/delete.result +++ b/mysql-test/main/delete.result @@ -92,6 +92,9 @@ select * from t1; a b 1 apple drop table t1; +# +# IGNORE option +# create table t11 (a int NOT NULL, b int, primary key (a)); create table t12 (a int NOT NULL, b int, primary key (a)); create table t2 (a int NOT NULL, b int, primary key (a)); @@ -125,10 +128,14 @@ a b 33 10 0 11 2 12 +explain delete ignore t11.*, t12.* from t11,t12 where t11.a = t12.a and t11.b <> (select b from t2 where t11.a < t2.a); +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY t12 ALL PRIMARY NULL NULL NULL 3 +1 PRIMARY t11 eq_ref PRIMARY PRIMARY 4 test.t12.a 1 Using where +2 DEPENDENT SUBQUERY t2 ALL PRIMARY NULL NULL NULL 3 Using where delete ignore t11.*, t12.* from t11,t12 where t11.a = t12.a and t11.b <> (select b from t2 where t11.a < t2.a); Warnings: Warning 1242 Subquery returns more than 1 row -Warning 1242 Subquery returns more than 1 row select * from t11; a b 0 10 |