diff options
Diffstat (limited to '')
| -rw-r--r-- | mysql-test/main/ignored_index.result | 14 |
1 files changed, 6 insertions, 8 deletions
diff --git a/mysql-test/main/ignored_index.result b/mysql-test/main/ignored_index.result index 03748d48..176ca61d 100644 --- a/mysql-test/main/ignored_index.result +++ b/mysql-test/main/ignored_index.result @@ -255,17 +255,15 @@ DROP TABLE t1; # IGNORED fulltext indexes. # CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)); -INSERT INTO t1 VALUES('Some data', 'for full-text search'); -ANALYZE TABLE t1; -Table Op Msg_type Msg_text -test.t1 analyze status Engine-independent statistics collected -test.t1 analyze Warning Engine-independent statistics are not collected for column 'b' -test.t1 analyze status OK -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"); +SELECT * FROM t1 WHERE MATCH(a, b) AGAINST ("search"); +a b +Some data for full-text search +EXPLAIN SELECT * FROM t1 WHERE MATCH(a, b) AGAINST ("search"); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 fulltext a a 0 1 Using where ALTER TABLE t1 ALTER INDEX a IGNORED; -EXPLAIN SELECT * FROM t1 WHERE MATCH(a, b) AGAINST ("collections"); +SELECT * FROM t1 WHERE MATCH(a, b) AGAINST ("search"); ERROR HY000: Can't find FULLTEXT index matching the column list DROP TABLE t1; # |