Debian Codegraph @

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

raw
1 drop table if exists t1, t2;
2 CREATE TABLE t1 (
3 id int(10) unsigned NOT NULL auto_increment,
4 q varchar(255) default NULL,
5 PRIMARY KEY (id)
6 ) ENGINE = InnoDB;
7 INSERT INTO t1 VALUES (1,'aaaaaaaaa dsaass de');
8 INSERT INTO t1 VALUES (2,'ssde df s fsda sad er');
9 CREATE TABLE t2 (
10 id int(10) unsigned NOT NULL auto_increment,
11 id2 int(10) unsigned default NULL,
12 item varchar(255) default NULL,
13 PRIMARY KEY (id),
14 FULLTEXT KEY item(item)
15 ) ENGINE = InnoDB;
16 INSERT INTO t2 VALUES (1,1,'sushi');
17 INSERT INTO t2 VALUES (2,1,'Bolo de Chocolate');
18 INSERT INTO t2 VALUES (3,1,'Feijoada');
19 INSERT INTO t2 VALUES (4,1,'Mousse de Chocolate');
20 INSERT INTO t2 VALUES (5,2,'um copo de Vodka');
21 INSERT INTO t2 VALUES (6,2,'um chocolate Snickers');
22 INSERT INTO t2 VALUES (7,1,'Bife');
23 INSERT INTO t2 VALUES (8,1,'Pizza de Salmao');
24 ANALYZE TABLE t1;
25 ANALYZE TABLE t2;
26 SELECT t1.q, t2.item, t2.id, round(MATCH t2.item AGAINST ('sushi'),6)
27 as x FROM t1, t2 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id;
28 q item id x
29 aaaaaaaaa dsaass de sushi 1 0.815572
30 aaaaaaaaa dsaass de Bolo de Chocolate 2 0.000000
31 aaaaaaaaa dsaass de Feijoada 3 0.000000
32 aaaaaaaaa dsaass de Mousse de Chocolate 4 0.000000
33 ssde df s fsda sad er um copo de Vodka 5 0.000000
34 ssde df s fsda sad er um chocolate Snickers 6 0.000000
35 aaaaaaaaa dsaass de Bife 7 0.000000
36 aaaaaaaaa dsaass de Pizza de Salmao 8 0.000000
37 SELECT t1.q, t2.item, t2.id, MATCH t2.item AGAINST ('sushi' IN BOOLEAN MODE)
38 as x FROM t1, t2 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id;
39 q item id x
40 aaaaaaaaa dsaass de sushi 1 0.8155715465545654
41 aaaaaaaaa dsaass de Bolo de Chocolate 2 0
42 aaaaaaaaa dsaass de Feijoada 3 0
43 aaaaaaaaa dsaass de Mousse de Chocolate 4 0
44 ssde df s fsda sad er um copo de Vodka 5 0
45 ssde df s fsda sad er um chocolate Snickers 6 0
46 aaaaaaaaa dsaass de Bife 7 0
47 aaaaaaaaa dsaass de Pizza de Salmao 8 0
48 SELECT t1.q, t2.item, t2.id, round(MATCH t2.item AGAINST ('sushi'),6)
49 as x FROM t2, t1 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id;
50 q item id x
51 aaaaaaaaa dsaass de sushi 1 0.815572
52 aaaaaaaaa dsaass de Bolo de Chocolate 2 0.000000
53 aaaaaaaaa dsaass de Feijoada 3 0.000000
54 aaaaaaaaa dsaass de Mousse de Chocolate 4 0.000000
55 ssde df s fsda sad er um copo de Vodka 5 0.000000
56 ssde df s fsda sad er um chocolate Snickers 6 0.000000
57 aaaaaaaaa dsaass de Bife 7 0.000000
58 aaaaaaaaa dsaass de Pizza de Salmao 8 0.000000
59 SELECT t1.q, t2.item, t2.id, MATCH t2.item AGAINST ('sushi' IN BOOLEAN MODE)
60 as x FROM t2, t1 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id;
61 q item id x
62 aaaaaaaaa dsaass de sushi 1 0.8155715465545654
63 aaaaaaaaa dsaass de Bolo de Chocolate 2 0
64 aaaaaaaaa dsaass de Feijoada 3 0
65 aaaaaaaaa dsaass de Mousse de Chocolate 4 0
66 ssde df s fsda sad er um copo de Vodka 5 0
67 ssde df s fsda sad er um chocolate Snickers 6 0
68 aaaaaaaaa dsaass de Bife 7 0
69 aaaaaaaaa dsaass de Pizza de Salmao 8 0
70 drop table t1, t2;