mtr errors with index_intersect_innodb
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
New
|
Undecided
|
Igor Babaev |
Bug Description
From time to time, index_intersect
--- c:/buildbot/
+++ c:\buildbot\
@@ -372,7 +372,7 @@
SELECT * FROM City
WHERE Name BETWEEN 'G' AND 'K' AND Population > 500000 AND Country LIKE 'C%';
id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE City index_merge Population,
+1 SIMPLE City index_merge Population,
SELECT * FROM City USE INDEX ()
WHERE Name BETWEEN 'M' AND 'N' AND Population > 1000000 AND Country LIKE 'C%';
ID Name Country Population
Note the changed order of fields (Population,
Example of failure: http://
Changed in maria: | |
assignee: | nobody → Igor Babaev (igorb-seattle) |