[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