diff options
| author | Sergey Glukhov <sergey.glukhov@oracle.com> | 2010-11-08 13:51:39 +0300 |
|---|---|---|
| committer | Sergey Glukhov <sergey.glukhov@oracle.com> | 2010-11-08 13:51:39 +0300 |
| commit | 50a3c55ee7e378b36bca5940e382fb18674dbd9b (patch) | |
| tree | 4e297b3f9938c5fc429efccf740555cb6966054f /mysql-test/r/subselect.result | |
| parent | 0a29baba4bae36b947aba9001956f3c800f4205f (diff) | |
| download | mariadb-git-50a3c55ee7e378b36bca5940e382fb18674dbd9b.tar.gz | |
Bug#52711 Segfault when doing EXPLAIN SELECT with union...order by (select... where...)
backport from 5.1
mysql-test/r/subselect.result:
backport from 5.1
mysql-test/t/subselect.test:
backport from 5.1
sql/sql_select.cc:
backport from 5.1
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 09a650c722b..7fbe4c08b08 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -4527,4 +4527,20 @@ pk int_key 3 3 7 3 DROP TABLE t1,t2; +# +# Bug #52711: Segfault when doing EXPLAIN SELECT with +# union...order by (select... where...) +# +CREATE TABLE t1 (a VARCHAR(10), FULLTEXT KEY a (a)); +INSERT INTO t1 VALUES (1),(2); +CREATE TABLE t2 (b INT); +INSERT INTO t2 VALUES (1),(2); +# Should not crash +EXPLAIN +SELECT * FROM t2 UNION SELECT * FROM t2 +ORDER BY (SELECT * FROM t1 WHERE MATCH(a) AGAINST ('+abc' IN BOOLEAN MODE)); +# Should not crash +SELECT * FROM t2 UNION SELECT * FROM t2 +ORDER BY (SELECT * FROM t1 WHERE MATCH(a) AGAINST ('+abc' IN BOOLEAN MODE)); +DROP TABLE t1,t2; End of 5.0 tests. |