Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1

into sanja.is.com.ua:/home/bell/mysql/bk/work-delete-4.1


mysql-test/r/subselect.result:
  Auto merged
sql/sql_delete.cc:
  Auto merged
sql/sql_yacc.yy:
  Auto merged

1 files changed, 0 insertions, 29 deletions

diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result
index e6e6d568fee..95638cbee41 100644
--- a/mysql-test/r/subselect.result
+++ b/mysql-test/r/subselect.result
@@ -1569,32 +1569,3 @@ INSERT INTO t2 VALUES (100, 200, 'C');
 SELECT DISTINCT COLC FROM t1 WHERE COLA = (SELECT COLA FROM t2 WHERE COLB = 200 AND COLC ='C' LIMIT 1);
 COLC
 DROP TABLE t1, t2;
-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));
-insert into t11 values (0, 10),(1, 11),(2, 12);
-insert into t12 values (33, 10),(22, 11),(2, 12);
-insert into t2 values (1, 21),(2, 12),(3, 23);
-select * from t11;
-a	b
-0	10
-1	11
-2	12
-select * from t12;
-a	b
-33	10
-22	11
-2	12
-select * from t2;
-a	b
-1	21
-2	12
-3	23
-delete t11.*, t12.* from t11,t12 where t11.a = t12.a and t11.b > (select b from t2);
-ERROR 21000: Subquery returns more than 1 row
-select * from t2;
-a	b
-1	21
-2	12
-3	23
-drop table t11, t12, t2;