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.