diff options
| author | monty@donna.mysql.com <> | 2000-12-28 03:56:38 +0200 |
|---|---|---|
| committer | monty@donna.mysql.com <> | 2000-12-28 03:56:38 +0200 |
| commit | c0f40d14cc36f56f5b4dba288583acd345429e4e (patch) | |
| tree | c27e400395741740f2e230395445236b38db27c1 /mysql-test/t/fulltext.test | |
| parent | 361067e9150f7fa57d5b2ac722ed55df9c14cc53 (diff) | |
| download | mariadb-git-c0f40d14cc36f56f5b4dba288583acd345429e4e.tar.gz | |
Added support for hex strings to mysqlimport
A lot of new tests to mysqltest
Fixed bug with BDB tables and autocommit
Diffstat (limited to 'mysql-test/t/fulltext.test')
| -rw-r--r-- | mysql-test/t/fulltext.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test new file mode 100644 index 00000000000..ad7c97022f5 --- /dev/null +++ b/mysql-test/t/fulltext.test @@ -0,0 +1,11 @@ +# +# Test of fulltext index +# + +CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)); +INSERT INTO t1 VALUES('MySQL has now support', 'for full-text search'),('Full-text indexes', 'are called collections'),('Only MyISAM tables','support collections'),('Function MATCH ... AGAINST()','is used to do a search'),('Full-text search in MySQL', 'implements vector space model'); +select * from t1 where MATCH(a,b) AGAINST ("collections"); +select * from t1 where MATCH(a,b) AGAINST ("indexes"); +select * from t1 where MATCH(a,b) AGAINST ("indexes collections"); +delete from t1 where a like "MySQL%"; +drop table t1; |