diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2015-12-16 19:33:41 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2016-01-22 18:07:11 +0100 |
| commit | 825f51d1aab51d363dc07ec9fe0829af33063883 (patch) | |
| tree | 3e9da3522d9f532799207f23b3e4cc0e1a41a04c /mysql-test/suite/innodb_fts | |
| parent | 45920d3d4a8ee28af8ca64b281db95ae3876bb70 (diff) | |
| download | mariadb-git-825f51d1aab51d363dc07ec9fe0829af33063883.tar.gz | |
MDEV-9118 ANALYZE TABLE for Engine independent status fetchs blob/text columns without use
Do not include BLOB fields by default.
Diffstat (limited to 'mysql-test/suite/innodb_fts')
| -rw-r--r-- | mysql-test/suite/innodb_fts/r/innodb-fts-fic.result | 1 | ||||
| -rw-r--r-- | mysql-test/suite/innodb_fts/r/innodb-fts-stopword.result | 2 |
2 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb_fts/r/innodb-fts-fic.result b/mysql-test/suite/innodb_fts/r/innodb-fts-fic.result index e5df6ca8b05..ee7277af640 100644 --- a/mysql-test/suite/innodb_fts/r/innodb-fts-fic.result +++ b/mysql-test/suite/innodb_fts/r/innodb-fts-fic.result @@ -36,6 +36,7 @@ count 2 ANALYZE TABLE articles; Table Op Msg_type Msg_text +test.articles analyze Warning Engine-independent statistics are not collected for column 'body' test.articles analyze status OK SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+MySQL -YourSQL' IN BOOLEAN MODE); diff --git a/mysql-test/suite/innodb_fts/r/innodb-fts-stopword.result b/mysql-test/suite/innodb_fts/r/innodb-fts-stopword.result index ea0ec381faa..e0ba456b51c 100644 --- a/mysql-test/suite/innodb_fts/r/innodb-fts-stopword.result +++ b/mysql-test/suite/innodb_fts/r/innodb-fts-stopword.result @@ -247,6 +247,7 @@ articles CREATE TABLE `articles` ( ALTER TABLE articles ADD FULLTEXT INDEX idx (title,body); ANALYZE TABLE articles; Table Op Msg_type Msg_text +test.articles analyze Warning Engine-independent statistics are not collected for column 'body' test.articles analyze status OK SELECT * FROM articles WHERE MATCH(title,body) AGAINST ("where will"); id title body @@ -569,6 +570,7 @@ select @@innodb_ft_enable_stopword; 1 ANALYZE TABLE articles; Table Op Msg_type Msg_text +test.articles analyze Warning Engine-independent statistics are not collected for column 'body' test.articles analyze status OK SELECT * FROM articles WHERE MATCH(title,body) AGAINST ("where will"); id title body |