Debian Codegraph @

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

raw
1 #
2 # Bugreport due to Roy Nasser <[email protected]>
3 #
4 --source include/have_innodb.inc
5 --source include/maybe_versioning.inc
6
7 --disable_warnings
8 drop table if exists t1, t2;
9 --enable_warnings
10
11 CREATE TABLE t1 (
12 id int(10) unsigned NOT NULL auto_increment,
13 q varchar(255) default NULL,
14 PRIMARY KEY (id)
15 ) ENGINE = InnoDB;
16
17 INSERT INTO t1 VALUES (1,'aaaaaaaaa dsaass de');
18 INSERT INTO t1 VALUES (2,'ssde df s fsda sad er');
19
20 CREATE TABLE t2 (
21 id int(10) unsigned NOT NULL auto_increment,
22 id2 int(10) unsigned default NULL,
23 item varchar(255) default NULL,
24 PRIMARY KEY (id),
25 FULLTEXT KEY item(item)
26 ) ENGINE = InnoDB;
27
28 INSERT INTO t2 VALUES (1,1,'sushi');
29 INSERT INTO t2 VALUES (2,1,'Bolo de Chocolate');
30 INSERT INTO t2 VALUES (3,1,'Feijoada');
31 INSERT INTO t2 VALUES (4,1,'Mousse de Chocolate');
32 INSERT INTO t2 VALUES (5,2,'um copo de Vodka');
33 INSERT INTO t2 VALUES (6,2,'um chocolate Snickers');
34 INSERT INTO t2 VALUES (7,1,'Bife');
35 INSERT INTO t2 VALUES (8,1,'Pizza de Salmao');
36
37 -- disable_result_log
38 ANALYZE TABLE t1;
39 ANALYZE TABLE t2;
40 -- enable_result_log
41
42 SELECT t1.q, t2.item, t2.id, round(MATCH t2.item AGAINST ('sushi'),6)
43 as x FROM t1, t2 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id;
44
45 SELECT t1.q, t2.item, t2.id, MATCH t2.item AGAINST ('sushi' IN BOOLEAN MODE)
46 as x FROM t1, t2 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id;
47
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
51 SELECT t1.q, t2.item, t2.id, MATCH t2.item AGAINST ('sushi' IN BOOLEAN MODE)
52 as x FROM t2, t1 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id;
53
54 drop table t1, t2;
55
56 # End of 4.1 tests