diff options
| author | Georgi Kodinov <joro@sun.com> | 2009-12-11 16:02:47 +0200 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2009-12-11 16:02:47 +0200 |
| commit | 7df06658c4f5acc100ab403ea155610f2dc3492b (patch) | |
| tree | b0429a55cc7533019dbc37b87f53a7608686cf95 /mysql-test/r/fulltext.result | |
| parent | 772aa6951f27a2bcc9c633efc7be0119bcafe1a5 (diff) | |
| parent | ee06414b5a4d1d2f8e2644228349e94f35ad5808 (diff) | |
| download | mariadb-git-7df06658c4f5acc100ab403ea155610f2dc3492b.tar.gz | |
merge of bug #49250 to 5.1-bugteam
Diffstat (limited to 'mysql-test/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index 6022231907b..1ef6656e7a4 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -552,6 +552,20 @@ MATCH (col) AGAINST('findme') DEALLOCATE PREPARE s; DROP TABLE t1; # +# Bug #49250 : spatial btree index corruption and crash +# Part two : fulltext syntax check +# +CREATE TABLE t1(col1 TEXT, +FULLTEXT INDEX USING BTREE (col1)); +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 'USING BTREE (col1))' at line 2 +CREATE TABLE t2(col1 TEXT); +CREATE FULLTEXT INDEX USING BTREE ON t2(col); +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 'USING BTREE ON t2(col)' at line 1 +ALTER TABLE t2 ADD FULLTEXT INDEX USING BTREE (col1); +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 'USING BTREE (col1)' at line 1 +DROP TABLE t2; +End of 5.0 tests +# # Bug #47930: MATCH IN BOOLEAN MODE returns too many results # inside subquery # |