Gecko [ www.jdcpatala.org ]

Name	Size	Permission
basic.result	12.32 KB	-rw-r--r--
bug_32831765.result	6.29 KB	-rw-r--r--
compatibility.result	9.81 KB	-rw-r--r--
compatibility_win.result	9.81 KB	-rw-r--r--
ddl.result	10.34 KB	-rw-r--r--
fic.result	8.01 KB	-rw-r--r--
foreign_key_check.result	808 B	-rw-r--r--
foreign_key_update.result	663 B	-rw-r--r--
fulltext.result	28.64 KB	-rw-r--r--
fulltext2.result	8.45 KB	-rw-r--r--
fulltext3.result	1.79 KB	-rw-r--r--
fulltext_cache.result	2.77 KB	-rw-r--r--
fulltext_distinct.result	1.45 KB	-rw-r--r--
fulltext_left_join.result	4.27 KB	-rw-r--r--
fulltext_misc.result	8.19 KB	-rw-r--r--
fulltext_multi.result	965 B	-rw-r--r--
fulltext_order_by.result	6.42 KB	-rw-r--r--
fulltext_table_evict.result	688 B	-rw-r--r--
fulltext_update.result	1.12 KB	-rw-r--r--
fulltext_var.result	1.33 KB	-rw-r--r--
index_table.result	6.84 KB	-rw-r--r--
innobase_drop_fts_index_table....	209 B	-rw-r--r--
large_records.result	9.04 KB	-rw-r--r--
limit_union.result	6 KB	-rw-r--r--
mecab_sjis.result	6.62 KB	-rw-r--r--
mecab_ujis.result	6.62 KB	-rw-r--r--
mecab_utf8.result	6.65 KB	-rw-r--r--
misc.result	62.97 KB	-rw-r--r--
misc_1.result	38.56 KB	-rw-r--r--
misc_debug.result	3.72 KB	-rw-r--r--
multiple_index.result	9.16 KB	-rw-r--r--
ngram.result	38.03 KB	-rw-r--r--
ngram_1.result	395.4 KB	-rw-r--r--
ngram_2.result	5.11 KB	-rw-r--r--
ngram_debug.result	8.63 KB	-rw-r--r--
opt.result	68.87 KB	-rw-r--r--
phrase.result	2.1 KB	-rw-r--r--
phrase_clear_no_match.result	2.68 KB	-rw-r--r--
plugin.result	7.52 KB	-rw-r--r--
plugin_1.result	14.8 KB	-rw-r--r--
plugin_debug.result	13.39 KB	-rw-r--r--
proximity.result	7.33 KB	-rw-r--r--
result_cache_limit.result	1.48 KB	-rw-r--r--
savepoint.result	8.69 KB	-rw-r--r--
stopword.result	31.83 KB	-rw-r--r--
stopword_charset.result	10.47 KB	-rw-r--r--
subexpr.result	3.88 KB	-rw-r--r--
sync.result	5.56 KB	-rw-r--r--
sync_block.result	2.64 KB	-rw-r--r--
sync_ddl.result	4.61 KB	-rw-r--r--
tablespace_location.result	43.89 KB	-rw-r--r--
tablespace_location_error.resu...	16.93 KB	-rw-r--r--
transaction.result	42.15 KB	-rw-r--r--
truncate.result	1.22 KB	-rw-r--r--

Code Editor : fulltext_cache.result

drop table if exists t1, t2;
CREATE TABLE t1 (
id int(10) unsigned NOT NULL auto_increment,
q varchar(255) default NULL,
PRIMARY KEY (id)
) ENGINE = InnoDB;
INSERT INTO t1 VALUES (1,'aaaaaaaaa dsaass de');
INSERT INTO t1 VALUES (2,'ssde df s fsda sad er');
CREATE TABLE t2 (
id int(10) unsigned NOT NULL auto_increment,
id2 int(10) unsigned default NULL,
item varchar(255) default NULL,
PRIMARY KEY (id),
FULLTEXT KEY item(item)
) ENGINE = InnoDB;
INSERT INTO t2 VALUES (1,1,'sushi');
INSERT INTO t2 VALUES (2,1,'Bolo de Chocolate');
INSERT INTO t2 VALUES (3,1,'Feijoada');
INSERT INTO t2 VALUES (4,1,'Mousse de Chocolate');
INSERT INTO t2 VALUES (5,2,'um copo de Vodka');
INSERT INTO t2 VALUES (6,2,'um chocolate Snickers');
INSERT INTO t2 VALUES (7,1,'Bife');
INSERT INTO t2 VALUES (8,1,'Pizza de Salmao');
ANALYZE TABLE t1;
ANALYZE TABLE t2;
SELECT t1.q, t2.item, t2.id, round(MATCH t2.item AGAINST ('sushi'),6)
as x FROM t1, t2 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id;
q	item	id	x
aaaaaaaaa dsaass de	sushi	1	0.815572
aaaaaaaaa dsaass de	Bolo de Chocolate	2	0.000000
aaaaaaaaa dsaass de	Feijoada	3	0.000000
aaaaaaaaa dsaass de	Mousse de Chocolate	4	0.000000
ssde df s fsda sad er	um copo de Vodka	5	0.000000
ssde df s fsda sad er	um chocolate Snickers	6	0.000000
aaaaaaaaa dsaass de	Bife	7	0.000000
aaaaaaaaa dsaass de	Pizza de Salmao	8	0.000000
SELECT t1.q, t2.item, t2.id, MATCH t2.item AGAINST ('sushi' IN BOOLEAN MODE)
as x FROM t1, t2 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id;
q	item	id	x
aaaaaaaaa dsaass de	sushi	1	0.8155715465545654
aaaaaaaaa dsaass de	Bolo de Chocolate	2	0
aaaaaaaaa dsaass de	Feijoada	3	0
aaaaaaaaa dsaass de	Mousse de Chocolate	4	0
ssde df s fsda sad er	um copo de Vodka	5	0
ssde df s fsda sad er	um chocolate Snickers	6	0
aaaaaaaaa dsaass de	Bife	7	0
aaaaaaaaa dsaass de	Pizza de Salmao	8	0
SELECT t1.q, t2.item, t2.id, round(MATCH t2.item AGAINST ('sushi'),6)
as x FROM t2, t1 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id;
q	item	id	x
aaaaaaaaa dsaass de	sushi	1	0.815572
aaaaaaaaa dsaass de	Bolo de Chocolate	2	0.000000
aaaaaaaaa dsaass de	Feijoada	3	0.000000
aaaaaaaaa dsaass de	Mousse de Chocolate	4	0.000000
ssde df s fsda sad er	um copo de Vodka	5	0.000000
ssde df s fsda sad er	um chocolate Snickers	6	0.000000
aaaaaaaaa dsaass de	Bife	7	0.000000
aaaaaaaaa dsaass de	Pizza de Salmao	8	0.000000
SELECT t1.q, t2.item, t2.id, MATCH t2.item AGAINST ('sushi' IN BOOLEAN MODE)
as x FROM t2, t1 WHERE (t2.id2 = t1.id) ORDER BY x DESC,t2.id;
q	item	id	x
aaaaaaaaa dsaass de	sushi	1	0.8155715465545654
aaaaaaaaa dsaass de	Bolo de Chocolate	2	0
aaaaaaaaa dsaass de	Feijoada	3	0
aaaaaaaaa dsaass de	Mousse de Chocolate	4	0
ssde df s fsda sad er	um copo de Vodka	5	0
ssde df s fsda sad er	um chocolate Snickers	6	0
aaaaaaaaa dsaass de	Bife	7	0
aaaaaaaaa dsaass de	Pizza de Salmao	8	0
drop table t1, t2;

${this.title}

Code Editor : fulltext_cache.result