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