Debian Codegraph @

mysql-test/suite/innodb_fts/r/fulltext_multi.result

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