4721
# Bug #52711: Segfault when doing EXPLAIN SELECT with
4722
# union...order by (select... where...)
4724
CREATE TABLE t1 (a VARCHAR(10), FULLTEXT KEY a (a));
4725
INSERT INTO t1 VALUES (1),(2);
4726
CREATE TABLE t2 (b INT);
4727
INSERT INTO t2 VALUES (1),(2);
4730
SELECT * FROM t2 UNION SELECT * FROM t2
4731
ORDER BY (SELECT * FROM t1 WHERE MATCH(a) AGAINST ('+abc' IN BOOLEAN MODE));
4733
SELECT * FROM t2 UNION SELECT * FROM t2
4734
ORDER BY (SELECT * FROM t1 WHERE MATCH(a) AGAINST ('+abc' IN BOOLEAN MODE));