Debian Codegraph @

mysql-test/suite/innodb_fts/t/fulltext_multi.test

raw
1
2 # several FULLTEXT indexes in one table test
3 --disable_warnings
4 DROP TABLE IF EXISTS t1;
5 --enable_warnings
6
7 CREATE TABLE t1 (
8 a int(11) NOT NULL auto_increment,
9 b text,
10 c varchar(254) default NULL,
11 PRIMARY KEY (a),
12 FULLTEXT KEY bb(b),
13 FULLTEXT KEY cc(c),
14 FULLTEXT KEY a(b,c)
15 ) ENGINE = InnoDB;
16
17 drop table t1;
18
19 CREATE TABLE t1 (
20 a int(11) NOT NULL auto_increment,
21 b text,
22 c varchar(254) default NULL,
23 PRIMARY KEY (a),
24 FULLTEXT KEY a(b,c)
25 ) ENGINE = InnoDB;
26
27 INSERT INTO t1 VALUES (1,'lala lolo lili','oooo aaaa pppp');
28 INSERT INTO t1 VALUES (2,'asdf fdsa','lkjh fghj');
29 INSERT INTO t1 VALUES (3,'qpwoei','zmxnvb');
30
31 -- disable_result_log
32 ANALYZE TABLE t1;
33 -- enable_result_log
34
35 SELECT a, round(MATCH b,c AGAINST ('lala lkjh'),5) FROM t1;
36 SELECT a, round(MATCH c,c AGAINST ('lala lkjh'),5) FROM t1;
37 SELECT a, round(MATCH b,c AGAINST ('lala lkjh'),5) FROM t1;
38 drop table t1;
39
40 # End of 4.1 tests