[debian-mysql] Bug#968915: Test failure in main.index_intersect on hppa
Otto Kekäläinen
otto at kekalainen.net
Sun Oct 4 21:27:46 BST 2020
Hello!
I already asked this on Zulip but did not get anywhere, so re-posting
here on the mailing list.
The basic test suite run directly after the build fails with the
following test on hppa on Debian:
https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.5&arch=hppa&ver=1%3A10.5.5-1&stamp=1601225060&raw=0
******************
main.index_intersect w3 [ fail ]
Test ended at 2020-09-27 16:41:38
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-09-27
16:41:38.035115473 +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%';
mysqltest: Result l
******************
Any suggestions what this 'range' -> 'index_merge' word change in the
result might step from?
More information about the pkg-mysql-maint
mailing list