main.delete_use_source 'innodb' w2 [ fail ]
|
Test ended at 2017-08-01 13:18:28
|
|
CURRENT_TEST: main.delete_use_source
|
--- /usr/share/mysql/mysql-test/r/delete_use_source.result 2017-08-01 08:31:50.000000000 -0400
|
+++ /dev/shm/var/2/log/delete_use_source.reject 2017-08-01 13:18:27.839087197 -0400
|
@@ -44,8 +44,8 @@
|
start transaction;
|
explain delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500 limit 1;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 PRIMARY t1 range c1 c1 4 NULL 550 Using where
|
-2 DEPENDENT SUBQUERY b ref c1 c1 4 test.t1.c1 82 Using index
|
+1 PRIMARY t1 ALL c1 NULL NULL NULL 472 Using where
|
+2 DEPENDENT SUBQUERY b ref c1 c1 4 test.t1.c1 113 Using index
|
delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500 limit 1;
|
affected rows: 1
|
delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500 limit 1;
|
@@ -60,8 +60,8 @@
|
start transaction;
|
explain delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 PRIMARY t1 ALL c1 NULL NULL NULL 717 Using where
|
-2 DEPENDENT SUBQUERY b ref c1 c1 4 test.t1.c1 82 Using index
|
+1 PRIMARY t1 ALL c1 NULL NULL NULL 472 Using where
|
+2 DEPENDENT SUBQUERY b ref c1 c1 4 test.t1.c1 113 Using index
|
delete from v1 where (select count(*) from t1 b where b.c1=v1.c1) = 500 ;
|
affected rows: 500
|
select count(*) from v1 where c1=0;
|
|
mysqltest: Result length mismatch
|