2
# Test of fulltext index
3
# bug reported by Tibor Simko <tibor.simko@cern.ch>
6
DROP TABLE IF EXISTS t1;
8
id mediumint unsigned NOT NULL auto_increment,
9
tag char(6) NOT NULL default '',
10
value text NOT NULL default '',
14
FULLTEXT KEY kvf(value)
16
DROP TABLE IF EXISTS t2;
18
id_t2 mediumint unsigned NOT NULL default '0',
19
id_t1 mediumint unsigned NOT NULL default '0',
20
field_number tinyint unsigned NOT NULL default '0',
21
PRIMARY KEY (id_t2,id_t1,field_number),
25
INSERT INTO t1 (tag,value) VALUES ('foo123','bar111');
26
INSERT INTO t2 VALUES (2231626,64280,0);
27
INSERT INTO t1 (tag,value) VALUES ('foo123','bar222');
28
INSERT INTO t2 VALUES (2231626,64281,0);
29
insert into t1 (tag,value) values ('bar345','baz333 ar');
30
insert into t2 values (12346, 3, 1);
32
select * from t1; select * from t2;
34
SELECT DISTINCT t2.id_t2
36
WHERE MATCH (t1.value) AGAINST ('baz333')