From bab42f674d95186ccc7a3fdb4901fbb0b00a1b96 Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 26 Feb 2007 16:52:54 +0400 Subject: after merge fix --- mysql-test/t/insert_select.test | 13 ------------- mysql-test/t/subselect.test | 4 +--- 2 files changed, 1 insertion(+), 16 deletions(-) (limited to 'mysql-test/t') diff --git a/mysql-test/t/insert_select.test b/mysql-test/t/insert_select.test index 93a7a3e5ab8..0f9a0ca4872 100644 --- a/mysql-test/t/insert_select.test +++ b/mysql-test/t/insert_select.test @@ -280,19 +280,6 @@ insert into t1 values (1,1) on duplicate key update f2=2; select * from t1; drop table t1; -# -# Bug#23170: LAST_INSERT_ID isn't reset to 0 in INSERT .. SELECT if no rows -# were inserted. -# -create table t1(f1 int primary key auto_increment, f2 int unique); -insert into t1(f2) values(1); -select @@identity; -insert ignore t1(f2) values(1); -select @@identity; -insert ignore t1(f2) select 1; -select @@identity; -drop table t1; - # # Bug#16630: wrong result, when INSERT t1 SELECT ... FROM t1 ON DUPLICATE # diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index abf6273ad7e..0ce3d1d78c6 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -2599,8 +2599,6 @@ SELECT * FROM t1 WHERE EXISTS (SELECT t2.c FROM t2 JOIN t3 ON t2.c=t3.c WHERE t2.c=1 UNION SELECT c from t2 WHERE c=t1.c); - - DROP TABLE t1,t2,t3; # @@ -2610,7 +2608,7 @@ CREATE TABLE t1 (s1 char(1)); INSERT INTO t1 VALUES ('a'); SELECT * FROM t1 WHERE _utf8'a' = ANY (SELECT s1 FROM t1); DROP TABLE t1; -DROP TABLE t1,t2,t3; + # # Bug#23800: Outer fields in correlated subqueries is used in a temporary # table created for sorting. -- cgit v1.2.1