diff options
author | Georgi Kodinov <joro@sun.com> | 2009-12-10 11:28:38 +0200 |
---|---|---|
committer | Georgi Kodinov <joro@sun.com> | 2009-12-10 11:28:38 +0200 |
commit | 30e51fe8540026f00c2c599098257c1e33c9b94f (patch) | |
tree | f38546a01badb3a2a1241fb2a1992ae1258932f7 /mysql-test/t/fulltext.test | |
parent | bd308d1256fa7af7128c24f4a5e2abfb8274437a (diff) | |
download | mariadb-git-30e51fe8540026f00c2c599098257c1e33c9b94f.tar.gz |
Bug #49250 : spatial btree index corruption and crash
SPATIAL and FULLTEXT indexes don't support algorithm
selection.
Disabled by creating a special grammar rule for these
in the parser.
Added some encasulation of duplicate parser code.
Diffstat (limited to 'mysql-test/t/fulltext.test')
-rw-r--r-- | mysql-test/t/fulltext.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 9551c98f143..bcd27e51f24 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -455,3 +455,20 @@ EXECUTE s; DEALLOCATE PREPARE s; DROP TABLE t1; +--echo # +--echo # Bug #49250 : spatial btree index corruption and crash +--echo # Part two : fulltext syntax check +--echo # + +--error ER_PARSE_ERROR +CREATE TABLE t1(col1 TEXT, + FULLTEXT INDEX USING BTREE (col1)); +CREATE TABLE t2(col1 TEXT); +--error ER_PARSE_ERROR +CREATE FULLTEXT INDEX USING BTREE ON t2(col); +--error ER_PARSE_ERROR +ALTER TABLE t2 ADD FULLTEXT INDEX USING BTREE (col1); + +DROP TABLE t2; + +--echo End of 5.0 tests |