Test main.range_all 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 |
Fix Released
|
Low
|
Laurynas Biveinis | |||
5.7 |
Invalid
|
Undecided
|
Unassigned |
Bug Description
On 5.6 trunk:
main.range_all w2 [ fail ]
...
--- /mnt/workspace/
+++ /mnt/workspace/
@@ -2480,7 +2480,7 @@
(c1 = 1 AND c2 = 2 AND c3 = 2) OR
(c1 = 1 AND c2 = 2 AND c3 = 3);
id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 range PRIMARY PRIMARY 12 NULL 3 Using where; Using index
+1 SIMPLE t1 ref PRIMARY PRIMARY 4 const 3 Using where; Using index
DROP TABLE t1;
#
# Bug#21139683: ASSERTION FAILED: TYPE_ARG == MAYBE_KEY ||
mysqltest: Result length mismatch
5.7 has added ANALYZE TABLE in the following commit, which should be backported:
commit 26d7ccc9b802c75
Author: Chaithra Gopalareddy <email address hidden>
Date: Thu Oct 8 15:42:19 2015 +0530
Bug#21964455: MAIN.RANGE_
Number of rows estimated for ref access was sometime showing one
more than that was present in the result file. Added analyze table.
tags: | added: ci upstream |
description: | updated |
https:/ /github. com/percona/ percona- server/ pull/1250 /github. com/percona/ percona- server/ pull/1251
https:/