diff options
Diffstat (limited to 'mysql-test/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 53 |
1 files changed, 53 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index e8a4d87f680..6d17261b227 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -1,18 +1,53 @@ +drop table if exists t1,t2,t3; +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"); a b Only MyISAM tables support collections Full-text indexes are called collections +select * from t1 where MATCH(a,b) AGAINST ("indexes"); a b Full-text indexes are called collections +select * from t1 where MATCH(a,b) AGAINST ("indexes collections"); a b Full-text indexes are called collections Only MyISAM tables support collections +delete from t1 where a like "MySQL%"; +drop table t1; +CREATE TABLE t1 ( +id int(11), +ticket int(11), +KEY ti (id), +KEY tit (ticket) +); +INSERT INTO t1 VALUES (2,3),(1,2); +CREATE TABLE t2 ( +ticket int(11), +inhalt text, +KEY tig (ticket), +fulltext index tix (inhalt) +); +INSERT INTO t2 VALUES (1,'foo'),(2,'bar'),(3,'foobar'); +select t1.id FROM t2 as ttxt,t1,t1 as ticket2 +WHERE ticket2.id = ttxt.ticket AND t1.id = ticket2.ticket and +match(ttxt.inhalt) against ('foobar'); id +select t1.id FROM t2 as ttxt,t1 INNER JOIN t1 as ticket2 ON +ticket2.id = ttxt.ticket +WHERE t1.id = ticket2.ticket and match(ttxt.inhalt) against ('foobar'); id +INSERT INTO t1 VALUES (3,3); +select t1.id FROM t2 as ttxt,t1 +INNER JOIN t1 as ticket2 ON ticket2.id = ttxt.ticket +WHERE t1.id = ticket2.ticket and +match(ttxt.inhalt) against ('foobar'); id 3 +show keys from t2; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment t2 1 tig 1 ticket A NULL NULL NULL t2 1 tix 1 inhalt A NULL 1 NULL FULLTEXT +show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `ticket` int(11) default NULL, @@ -20,8 +55,26 @@ t2 CREATE TABLE `t2` ( KEY `tig` (`ticket`), FULLTEXT KEY `tix` (`inhalt`) ) TYPE=MyISAM +select * from t2 where MATCH inhalt AGAINST (NULL); ticket inhalt +select * from t2 where MATCH inhalt AGAINST ('foobar'); ticket inhalt 3 foobar +select * from t2 having MATCH inhalt AGAINST ('foobar'); ticket inhalt 3 foobar +CREATE TABLE t3 ( +ticket int(11), +inhalt text, +KEY tig (ticket), +fulltext index tix (inhalt) +); +select * from t2 where MATCH inhalt AGAINST (t2.inhalt); +Wrong arguments to AGAINST +select * from t2 where MATCH inhalt AGAINST (t2.inhalt); +Wrong arguments to AGAINST +select * from t2 where MATCH ticket AGAINST ('foobar'); +Can't find FULLTEXT index matching the column list +select * from t2,t3 where MATCH (t2.inhalt,t3.inhalt) AGAINST ('foobar'); +Wrong arguments to MATCH +drop table t1,t2,t3; |