diff options
| author | Monty <monty@mariadb.org> | 2022-10-04 16:16:06 +0300 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2022-10-04 21:46:44 +0300 |
| commit | 30f3d767ef4a8789860452127d8e04b92fadaabc (patch) | |
| tree | 4a2c0b88479e3812e98bbbe849b3123f4cc0dd75 /mysql-test/main/ignored_index.test | |
| parent | a35f715f440eb9ce93e4245cb1e4e5bc6f6972a2 (diff) | |
| download | mariadb-git-10.7-selectivity.tar.gz | |
Added test cases for preceding test10.7-selectivity
This includes all test changes from
"Changing all cost calculation to be given in milliseconds"
and forwards
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 |