summaryrefslogtreecommitdiff
path: root/mysql-test/t/fulltext.test
diff options
context:
space:
mode:
authorGeorgi Kodinov <joro@sun.com>2009-12-11 16:02:47 +0200
committerGeorgi Kodinov <joro@sun.com>2009-12-11 16:02:47 +0200
commit97620e3ba8353b62e90c56f800b230a7ebd15e4f (patch)
treeb0429a55cc7533019dbc37b87f53a7608686cf95 /mysql-test/t/fulltext.test
parent7b174dcafcab24582f7d3f255482bcc460e6b451 (diff)
parent30e51fe8540026f00c2c599098257c1e33c9b94f (diff)
downloadmariadb-git-97620e3ba8353b62e90c56f800b230a7ebd15e4f.tar.gz
merge of bug #49250 to 5.1-bugteam
Diffstat (limited to 'mysql-test/t/fulltext.test')
-rw-r--r--mysql-test/t/fulltext.test21
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test
index 4537559509d..3853a224fd5 100644
--- a/mysql-test/t/fulltext.test
+++ b/mysql-test/t/fulltext.test
@@ -485,6 +485,27 @@ 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
+
+
--echo #
--echo # Bug #47930: MATCH IN BOOLEAN MODE returns too many results
--echo # inside subquery