diff options
Diffstat (limited to 'mysql-test/main/ignored_index.test')
| -rw-r--r-- | mysql-test/main/ignored_index.test | 8 |
1 files changed, 3 insertions, 5 deletions
diff --git a/mysql-test/main/ignored_index.test b/mysql-test/main/ignored_index.test index a3d46fe6046..b2fadcd5862 100644 --- a/mysql-test/main/ignored_index.test +++ b/mysql-test/main/ignored_index.test @@ -222,13 +222,11 @@ DROP TABLE t1; --echo # IGNORED fulltext indexes. --echo # CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)); -INSERT INTO t1 VALUES('Some data', 'for full-text search'); -ANALYZE TABLE t1; - -let $query= -EXPLAIN SELECT * FROM t1 WHERE MATCH(a, b) AGAINST ("collections"); +INSERT INTO t1 VALUES('Some data', 'for full-text search'),("hello","hello world"),("mars","here I come"); +let $query=SELECT * FROM t1 WHERE MATCH(a, b) AGAINST ("search"); --eval $query +--eval EXPLAIN $query ALTER TABLE t1 ALTER INDEX a IGNORED; --error ER_FT_MATCHING_KEY_NOT_FOUND |