Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3(EOL)
-
None
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-amd64/builds/2517/steps/mtr/logs/stdio
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
|
Reproducible locally by running the test with --repeat=N.
Attachments
Issue Links
- is duplicated by
-
MDEV-13510 main.delete_use_source fails in buildbot and outside with wrong plan
- Closed
- relates to
-
MDEV-12137 DELETE statement with the same source and target
- Closed