Test main.subquery_sj_none_bkaunique is unstable

Bug #1678692 reported by Laurynas Biveinis on 2017-04-03
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.5
Invalid
Undecided
Unassigned
5.6
Fix Released
Low
Laurynas Biveinis
5.7
Fix Released
Low
Laurynas Biveinis

Bug Description

On 5.6 trunk:

main.subquery_sj_none_bkaunique w1 [ fail ]
        Test ended at 2017-03-31 09:31:46

CURRENT_TEST: main.subquery_sj_none_bkaunique
--- /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/centos6-64/mysql-test/r/subquery_sj_none_bkaunique.result 2017-03-07 15:06:23.259964092 +0300
+++ /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/centos6-64/build/mysql-test/var/1/log/subquery_sj_none_bkaunique.reject 2017-03-31 16:31:46.739258790 +0300
@@ -7640,8 +7640,8 @@
 );
 id select_type table type possible_keys key key_len ref rows Extra
 1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using where
-2 DEPENDENT SUBQUERY grandparent1 ALL col_varchar_key NULL NULL NULL 20 Using where
-3 DEPENDENT SUBQUERY parent1 ALL NULL NULL NULL NULL 20 Using where
+2 DEPENDENT SUBQUERY grandparent1 ALL col_varchar_key NULL NULL NULL 21 Using where
+3 DEPENDENT SUBQUERY parent1 ALL NULL NULL NULL NULL 21 Using where
 3 DEPENDENT SUBQUERY parent2 eq_ref PRIMARY PRIMARY 4 test.parent1.pk 1 Using index
 SELECT *
 FROM t1

mysqltest: Result content mismatch

tags: added: ci upstream

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2256

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers