diff options
| author | Marc Alff <marc.alff@sun.com> | 2009-11-02 09:31:00 -0700 |
|---|---|---|
| committer | Marc Alff <marc.alff@sun.com> | 2009-11-02 09:31:00 -0700 |
| commit | 587a696a82402dc246acfb0e41d40016c2c30ef8 (patch) | |
| tree | 7a6bb218b937aaeaab0ee4794a23a8bea1bb2529 /mysql-test/r/fulltext.result | |
| parent | e1be32db5a9c1aaf3e193e9443b9af1742b67bac (diff) | |
| download | mariadb-git-587a696a82402dc246acfb0e41d40016c2c30ef8.tar.gz | |
Bug#9801 Views: imperfect error message
Backport for 5.5
The root cause of this bug is that the grammar for GROUP BY clauses,
when using WITH CUBE or WITH ROLLUP, cause conflicts with the grammar
for VIEW, when using WITH CHECK OPTION.
The solution is to implement two token look ahead when parsing a WITH token,
to disambiguate the non standard WITH CUBE and WITH ROLLUP syntaxes.
Patch based on code from Marc Alff and Antony Curtis
Diffstat (limited to 'mysql-test/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index abab18e0e99..40f408b0fc8 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -49,7 +49,7 @@ a b Full-text indexes are called collections Only MyISAM tables support collections select * from t1 where MATCH(a,b) AGAINST ("indexes" IN BOOLEAN MODE WITH QUERY EXPANSION); -ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WITH QUERY EXPANSION)' at line 1 +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'QUERY EXPANSION)' at line 1 explain select * from t1 where MATCH(a,b) AGAINST ("collections"); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 fulltext a a 0 1 Using where |