Test main.subquery_sj_mat_bka_nixbnl is unstable
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_
Test ended at 2017-03-05 08:39:09
CURRENT_TEST: main.subquery_
--- /mnt/workspace/
+++ /mnt/workspace/
@@ -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.
2 MATERIALIZED t2 ALL NULL NULL NULL NULL 6 NULL
SELECT col_varchar_key
mysqltest: Result content mismatch
safe_process[
Server [mysqld.1 - pid: 20409, winpid: 20409] log:
Server log from this test:
----------SERVER LOG START-----------
----------SERVER LOG END-------------
tags: | added: ci upstream |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-2241