mirror of
https://github.com/MariaDB/server.git
synced 2025-08-05 10:01:36 +02:00
f0be022cf0
The bug was fixed by Serg earlier by including Sphinx 2.2.6, but he forgot to update the test case.
11 lines
629 B
Text
11 lines
629 B
Text
#
|
|
# MDEV-5539 Empty results in UNION with Sphinx engine
|
|
#
|
|
--replace_result $SPHINXSEARCH_PORT PORT
|
|
eval create table ts (id bigint unsigned not null, w int not null, query varchar(255) not null, index(query)) engine=sphinx connection="sphinx://127.0.0.1:$SPHINXSEARCH_PORT/*";
|
|
let $q1=SELECT * FROM ts si WHERE si.query=';mode=extended2;limit=1000000;maxmatches=500';
|
|
let $q2=SELECT * FROM ts si WHERE si.query='@* 123nothingtofind123;mode=extended2;limit=1000000;maxmatches=500';
|
|
eval SELECT a.* FROM ($q1) AS a UNION SELECT b.* FROM ($q2) AS b;
|
|
eval SELECT a.* FROM ($q2) AS a UNION SELECT b.* FROM ($q1) AS b;
|
|
drop table ts;
|
|
|