Test main.subquery_sj_mat_bka_nixbnl is unstable

Bug #1670378 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
Triaged
Low
Unassigned
5.7
New
Low
Unassigned

Bug Description

On 5.6 trunk:

main.subquery_sj_mat_bka_nixbnl w4 [ fail ]
        Test ended at 2017-03-05 08:39:09

CURRENT_TEST: main.subquery_sj_mat_bka_nixbnl
--- /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/ubuntu-precise-64bit/mysql-test/r/subquery_sj_mat_bka_nixbnl.result 2017-02-21 15:07:16.015863805 +0300
+++ /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/ubuntu-precise-64bit/build/mysql-test/var/4/log/subquery_sj_mat_bka_nixbnl.reject 2017-03-05 16:39:09.358700612 +0300
@@ -7737,7 +7737,7 @@
 FROM t2)
 ORDER BY col_datetime_key LIMIT 4;
 id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 ALL col_varchar_key NULL NULL NULL 20 Using where; Using filesort
+1 SIMPLE t1 index col_varchar_key col_datetime_key 5 NULL 4 Using where
 1 SIMPLE <subquery2> eq_ref <auto_key> <auto_key> 3 test.t1.col_varchar_key 1 NULL
 2 MATERIALIZED t2 ALL NULL NULL NULL NULL 6 NULL
 SELECT col_varchar_key

mysqltest: Result content mismatch

safe_process[22999]: Child process: 23000, exit: 1

Server [mysqld.1 - pid: 20409, winpid: 20409] log:
Server log from this test:
----------SERVER LOG START-----------
----------SERVER LOG END-------------

Tags: ci upstream
tags: added: ci upstream
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-2241

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.