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 Warnings:
12 Warning 1681 Integer display width is deprecated and will be removed in a future release.
13 drop table t1;
14 CREATE TABLE t1 (
15 a int(11) NOT NULL auto_increment,
16 b text,
17 c varchar(254) default NULL,
18 PRIMARY KEY (a),
19 FULLTEXT KEY a(b,c)
20 ) ENGINE = InnoDB;
21 Warnings:
22 Warning 1681 Integer display width is deprecated and will be removed in a future release.
23 INSERT INTO t1 VALUES (1,'lala lolo lili','oooo aaaa pppp');
24 INSERT INTO t1 VALUES (2,'asdf fdsa','lkjh fghj');
25 INSERT INTO t1 VALUES (3,'qpwoei','zmxnvb');
26 ANALYZE TABLE t1;
27 SELECT a, round(MATCH b,c AGAINST ('lala lkjh'),5) FROM t1;
28 a round(MATCH b,c AGAINST ('lala lkjh'),5)
29 1 0.22764
30 2 0.22764
31 3 0
32 SELECT a, round(MATCH c,c AGAINST ('lala lkjh'),5) FROM t1;
33 a round(MATCH c,c AGAINST ('lala lkjh'),5)
34 1 0.22764
35 2 0.22764
36 3 0
37 SELECT a, round(MATCH b,c AGAINST ('lala lkjh'),5) FROM t1;
38 a round(MATCH b,c AGAINST ('lala lkjh'),5)
39 1 0.22764
40 2 0.22764
41 3 0
42 drop table t1;