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 : ngram_2.result

SET NAMES utf8;
CREATE TABLE t1 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
content TEXT,
FULLTEXT INDEX ft_content (content)
) ENGINE=InnoDB DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
INSERT INTO t1 (title, content) VALUES  ('中国', '中国'), ('中国上海', '中国上海');
ALTER TABLE t1 ADD FULLTEXT INDEX ft_title (title);
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `content` text,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `ft_content` (`content`),
  FULLTEXT KEY `ft_title` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312
SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国');
id	title	content
SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国上海');
id	title	content
2	中国上海	中国上海
SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国');
id	title	content
SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国上海');
id	title	content
2	中国上海	中国上海
DROP TABLE t1;
CREATE TABLE t1 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
content TEXT,
FULLTEXT INDEX ft_content (content) WITH PARSER ngram
) ENGINE=InnoDB DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
INSERT INTO t1 (title, content) VALUES  ('中国', '中国'), ('中国上海', '中国上海');
ALTER TABLE t1 ADD FULLTEXT INDEX ft_title (title) WITH PARSER ngram;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `content` text,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `ft_content` (`content`) /*!50100 WITH PARSER `ngram` */ ,
  FULLTEXT KEY `ft_title` (`title`) /*!50100 WITH PARSER `ngram` */ 
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312
SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国');
id	title	content
1	中国	中国
2	中国上海	中国上海
SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国上海');
id	title	content
2	中国上海	中国上海
1	中国	中国
SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国');
id	title	content
1	中国	中国
2	中国上海	中国上海
SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国上海');
id	title	content
2	中国上海	中国上海
1	中国	中国
CREATE TABLE t2 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
content TEXT,
FULLTEXT INDEX ft_content (content) WITH PARSER ngram
) ENGINE=InnoDB DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
ALTER TABLE t2 ADD FULLTEXT INDEX ft_title (title) WITH PARSER ngram;
# restart: --ngram=OFF
CHECK TABLE t1;
Table	Op	Msg_type	Msg_text
test.t1	check	Error	Plugin 'ngram' is not loaded
test.t1	check	Error	Incorrect information in file: './test/t1.frm'
test.t1	check	error	Corrupt
SELECT * FROM t1;
ERROR HY000: Plugin 'ngram' is not loaded
SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国');
ERROR HY000: Plugin 'ngram' is not loaded
SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国上海');
ERROR HY000: Plugin 'ngram' is not loaded
SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国');
ERROR HY000: Plugin 'ngram' is not loaded
SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国上海');
ERROR HY000: Plugin 'ngram' is not loaded
INSERT INTO t1 (title, content) VALUES  ('中国', '中国');
ERROR HY000: Plugin 'ngram' is not loaded
DROP INDEX ft_title ON t1;
ERROR HY000: Plugin 'ngram' is not loaded
DROP INDEX ft_content ON t1;
ERROR HY000: Plugin 'ngram' is not loaded
TRUNCATE TABLE t1;
ERROR HY000: Plugin 'ngram' is not loaded
ALTER TABLE t1 RENAME TO t3;
ERROR HY000: Plugin 'ngram' is not loaded
RENAME TABLE t2 to t3;
DROP TABLE t3;
CREATE TABLE t2 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
FULLTEXT INDEX ft_title (title) WITH PARSER ngram
) ENGINE=InnoDB DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
ERROR HY000: Function 'ngram' is not defined
CREATE TABLE t2 (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200)
) ENGINE=InnoDB DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
ALTER TABLE t2 ADD FULLTEXT INDEX ft_title (title) WITH PARSER ngram;
ERROR HY000: Function 'ngram' is not defined
ALTER TABLE t2 ADD FULLTEXT INDEX ft_title (title);
Warnings:
Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
INSERT INTO t2 (title) VALUES  ('中国');
SELECT * FROM t2 WHERE MATCH(title) AGAINST('中国');
id	title
SELECT * FROM t2 WHERE MATCH(title) AGAINST('中国上海');
id	title
DROP TABLE t2;
# restart
CHECK TABLE t1;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
SELECT * FROM t1;
id	title	content
1	中国	中国
2	中国上海	中国上海
SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国');
id	title	content
1	中国	中国
2	中国上海	中国上海
SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国上海');
id	title	content
2	中国上海	中国上海
1	中国	中国
SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国');
id	title	content
1	中国	中国
2	中国上海	中国上海
SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国上海');
id	title	content
2	中国上海	中国上海
1	中国	中国
DROP TABLE t1;

${this.title}

Code Editor : ngram_2.result