diff options
| author | Sergey Vojtovich <svoj@mysql.com> | 2009-02-12 13:49:44 +0400 |
|---|---|---|
| committer | Sergey Vojtovich <svoj@mysql.com> | 2009-02-12 13:49:44 +0400 |
| commit | 659a2183dd3eae92d1510b2d0efc32590b9cfbf8 (patch) | |
| tree | 620ef9dd8ce2966b58d01d3b068774d591629171 /mysql-test/t/fulltext.test | |
| parent | 4f0c557340cc4eb6f46a3b1a2cd17b7447aa39cd (diff) | |
| download | mariadb-git-659a2183dd3eae92d1510b2d0efc32590b9cfbf8.tar.gz | |
BUG#36737 - having + full text operator crashes mysql
MATCH() function accepts column list as an argument. It was possible to override
this requirement with aliased non-column select expression. Which results in
server crash.
With this fix aliased non-column select expressions are not accepted by MATCH()
function, returning an error.
Diffstat (limited to 'mysql-test/t/fulltext.test')
| -rw-r--r-- | mysql-test/t/fulltext.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 77d84c730d9..76661ba4e63 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -432,3 +432,11 @@ INSERT INTO t1 VALUES('aaa15'); SELECT MATCH(a) AGAINST('aaa1* aaa14 aaa16' IN BOOLEAN MODE) FROM t1; SELECT MATCH(a) AGAINST('aaa1* aaa14 aaa15 aaa16' IN BOOLEAN MODE) FROM t1; DROP TABLE t1; + +# +# BUG#36737 - having + full text operator crashes mysql +# +CREATE TABLE t1(a TEXT); +--error ER_WRONG_ARGUMENTS +SELECT GROUP_CONCAT(a) AS st FROM t1 HAVING MATCH(st) AGAINST('test' IN BOOLEAN MODE); +DROP TABLE t1; |