3707
--echo # Bug #52711: Segfault when doing EXPLAIN SELECT with
3708
--echo # union...order by (select... where...)
3711
CREATE TABLE t1 (a VARCHAR(10), FULLTEXT KEY a (a));
3712
INSERT INTO t1 VALUES (1),(2);
3713
CREATE TABLE t2 (b INT);
3714
INSERT INTO t2 VALUES (1),(2);
3716
--echo # Should not crash
3717
--disable_result_log
3719
SELECT * FROM t2 UNION SELECT * FROM t2
3720
ORDER BY (SELECT * FROM t1 WHERE MATCH(a) AGAINST ('+abc' IN BOOLEAN MODE));
3722
--echo # Should not crash
3723
SELECT * FROM t2 UNION SELECT * FROM t2
3724
ORDER BY (SELECT * FROM t1 WHERE MATCH(a) AGAINST ('+abc' IN BOOLEAN MODE));
3728
--echo End of 5.1 tests