diff options
Diffstat (limited to 'mysql-test/r/fulltext_distinct.result')
| -rw-r--r-- | mysql-test/r/fulltext_distinct.result | 24 |
1 files changed, 13 insertions, 11 deletions
diff --git a/mysql-test/r/fulltext_distinct.result b/mysql-test/r/fulltext_distinct.result index 801d82dc6a2..abb4929d0ec 100644 --- a/mysql-test/r/fulltext_distinct.result +++ b/mysql-test/r/fulltext_distinct.result @@ -1,4 +1,4 @@ -DROP TABLE IF EXISTS t1; +DROP TABLE IF EXISTS t1, t2; CREATE TABLE t1 ( id mediumint unsigned NOT NULL auto_increment, tag char(6) NOT NULL default '', @@ -8,7 +8,6 @@ KEY kt(tag), KEY kv(value(15)), FULLTEXT KEY kvf(value) ) TYPE=MyISAM; -DROP TABLE IF EXISTS t2; CREATE TABLE t2 ( id_t2 mediumint unsigned NOT NULL default '0', id_t1 mediumint unsigned NOT NULL default '0', @@ -17,25 +16,28 @@ PRIMARY KEY (id_t2,id_t1,field_number), KEY id_t1(id_t1) ) TYPE=MyISAM; INSERT INTO t1 (tag,value) VALUES ('foo123','bar111'); -INSERT INTO t2 VALUES (2231626,64280,0); INSERT INTO t1 (tag,value) VALUES ('foo123','bar222'); +INSERT INTO t1 (tag,value) VALUES ('bar345','baz333 ar'); +INSERT INTO t2 VALUES (2231626,64280,0); INSERT INTO t2 VALUES (2231626,64281,0); -insert into t1 (tag,value) values ('bar345','baz333 ar'); -insert into t2 values (12346, 3, 1); -select * from t1; +INSERT INTO t2 VALUES (12346, 3, 1); +SELECT * FROM t1; id tag value 1 foo123 bar111 2 foo123 bar222 3 bar345 baz333 ar -select * from t2; +SELECT * FROM t2; id_t2 id_t1 field_number 12346 3 1 2231626 64280 0 2231626 64281 0 -SELECT DISTINCT t2.id_t2 -FROM t2, t1 -WHERE MATCH (t1.value) AGAINST ('baz333') +SELECT DISTINCT t2.id_t2 FROM t2, t1 +WHERE MATCH (t1.value) AGAINST ('baz333') AND t1.id = t2.id_t1; +id_t2 +12346 +SELECT DISTINCT t2.id_t2 FROM t2, t1 +WHERE MATCH (t1.value) AGAINST ('baz333' IN BOOLEAN MODE) AND t1.id = t2.id_t1; id_t2 12346 -DROP TABLE t1,t2; +DROP TABLE t1, t2; |