EVOLUTION-MANAGER

Edit File: union-5539.test

# # 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;