Debian Codegraph @

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

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