Test main.subquery_sj_none_bkaunique is unstable

Bug #1678692 reported by Laurynas Biveinis
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: ci upstream
tags: added: ci upstream
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.