Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.5.5, 10.11.5
-
None
Description
While importing MariaDB 10.5.5 to Debian.org, I noticed that the hppa build failed with:
main.index_intersect [ fail ]
|
Test ended at 2020-10-08 13:21:09
|
|
CURRENT_TEST: main.index_intersect
|
--- /<<PKGBUILDDIR>>/mysql-test/main/index_intersect.result 2020-08-07 12:57:35.000000000 +0000
|
+++ /<<PKGBUILDDIR>>/mysql-test/main/index_intersect.reject 2020-10-08 13:21:09.031562286 +0000
|
@@ -715,7 +715,7 @@
|
SELECT * FROM City
|
WHERE Name BETWEEN 'G' AND 'J' AND Population > 500000 AND Country LIKE 'C%';
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE City range Population,Country,Name Name 35 NULL # Using index condition; Using where
|
+1 SIMPLE City index_merge Population,Country,Name Name,Country 35,3 NULL # Using sort_intersect(Name,Country); Using where
|
EXPLAIN
|
SELECT * FROM City
|
WHERE ID BETWEEN 1 AND 500 AND Population > 700000 AND Country LIKE 'C%';
|
I noticed very similar issue https://jira.mariadb.org/browse/MDEV-615 (fixed by igor) from 2014 where also the words 'Country,Name' were in wrong order.