Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.3(EOL)
-
None
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-amd64/builds/2583/steps/mtr/logs/stdio
main.delete_use_source 'innodb' w1 [ fail ]
|
Test ended at 2017-07-08 01:42:52
|
|
CURRENT_TEST: main.delete_use_source
|
--- /usr/local/mariadb-10.2.7-linux-x86_64/mysql-test/r/delete_use_source.result 2017-07-07 23:42:11.000000000 +0300
|
+++ /usr/local/mariadb-10.2.7-linux-x86_64/mysql-test/r/delete_use_source.reject 2017-07-08 01:42:52.427051960 +0300
|
@@ -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
|
The test has been failing in buildbot ever since it was pushed to bb-10.2-ext here:
https://buildbot.askmonty.org/buildbot/builders/kvm-bintar-quantal-amd64/builds/6431/steps/test/logs/stdio . As of now, there are 1263 recorded failures.
It also failed for me when I ran it locally on the current 10.3 tree.
Attachments
Issue Links
- duplicates
-
MDEV-13429 main.delete_use_source fails sporadically in buildbot with wrong execution plan
- Closed