diff options
Diffstat (limited to 'mysql-test/suite/innodb_fts/r/innodb_fts_plugin.result')
-rw-r--r-- | mysql-test/suite/innodb_fts/r/innodb_fts_plugin.result | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb_fts/r/innodb_fts_plugin.result b/mysql-test/suite/innodb_fts/r/innodb_fts_plugin.result index dc71156b7a1..ec417af97c5 100644 --- a/mysql-test/suite/innodb_fts/r/innodb_fts_plugin.result +++ b/mysql-test/suite/innodb_fts/r/innodb_fts_plugin.result @@ -122,6 +122,7 @@ INSERT INTO articles (title, body) VALUES ('Optimizing MySQL','In this tutorial we will show ...'), ('1001 MySQL Tricks','How to use full-text search engine'), ('Go MySQL Tricks','How to use full text search engine'); +# restart SELECT COUNT(*) FROM articles; COUNT(*) 0 @@ -134,6 +135,7 @@ INSERT INTO articles (title, body) VALUES ('Optimizing MySQL','In this tutorial we will show ...'), ('1001 MySQL Tricks','How to use full-text search engine'), ('Go MariaDB Tricks','How to use full text search engine'); +# restart SELECT * FROM articles WHERE MATCH(title, body) AGAINST('MySQL'); id title body |