Gecko [ www.jdcpatala.org ]

Name	Size	Permission
basic.test	8.74 KB	-rw-r--r--
bug_32831765.test	7.42 KB	-rw-r--r--
compatibility.test	7.83 KB	-rw-r--r--
compatibility_win.test	7.67 KB	-rw-r--r--
ddl.test	9.31 KB	-rw-r--r--
disabled.def	404 B	-rw-r--r--
fic.test	7.35 KB	-rw-r--r--
foreign_key_check.test	868 B	-rw-r--r--
foreign_key_update.test	704 B	-rw-r--r--
fulltext.test	22.17 KB	-rw-r--r--
fulltext2.test	9.21 KB	-rw-r--r--
fulltext3.test	2.4 KB	-rw-r--r--
fulltext_cache.test	1.58 KB	-rw-r--r--
fulltext_distinct.test	1.28 KB	-rw-r--r--
fulltext_left_join.test	4.58 KB	-rw-r--r--
fulltext_misc.test	5.6 KB	-rw-r--r--
fulltext_multi.test	953 B	-rw-r--r--
fulltext_order_by.test	5.7 KB	-rw-r--r--
fulltext_plugin-master.opt	19 B	-rw-r--r--
fulltext_table_evict.test	1.17 KB	-rw-r--r--
fulltext_update.test	1.12 KB	-rw-r--r--
fulltext_var.test	1.39 KB	-rw-r--r--
index_table.test	3.32 KB	-rw-r--r--
innobase_drop_fts_index_table....	407 B	-rw-r--r--
large_records.test	12.23 KB	-rw-r--r--
limit_union.test	4.88 KB	-rw-r--r--
mecab_sjis-master.opt	40 B	-rw-r--r--
mecab_sjis.test	364 B	-rw-r--r--
mecab_ujis-master.opt	40 B	-rw-r--r--
mecab_ujis.test	368 B	-rw-r--r--
mecab_utf8-master.opt	40 B	-rw-r--r--
mecab_utf8.test	335 B	-rw-r--r--
misc.test	56.53 KB	-rw-r--r--
misc_1.test	33.18 KB	-rw-r--r--
misc_debug.test	5.17 KB	-rw-r--r--
multiple_index.test	6.37 KB	-rw-r--r--
ngram-master.opt	19 B	-rw-r--r--
ngram.test	13.15 KB	-rw-r--r--
ngram_1.test	2.01 KB	-rw-r--r--
ngram_2-master.opt	19 B	-rw-r--r--
ngram_2.test	4.18 KB	-rw-r--r--
ngram_debug.test	6.61 KB	-rw-r--r--
opt-master.opt	21 B	-rw-r--r--
opt.test	34.27 KB	-rw-r--r--
phrase.test	1 KB	-rw-r--r--
phrase_clear_no_match.test	2.41 KB	-rw-r--r--
plugin-master.opt	19 B	-rw-r--r--
plugin.test	6.69 KB	-rw-r--r--
plugin_1-master.opt	19 B	-rw-r--r--
plugin_1.test	11.22 KB	-rw-r--r--
plugin_debug-master.opt	19 B	-rw-r--r--
plugin_debug.test	9.57 KB	-rw-r--r--
proximity.test	7.89 KB	-rw-r--r--
result_cache_limit.test	1.76 KB	-rw-r--r--
savepoint.test	9.09 KB	-rw-r--r--
stopword.test	30.68 KB	-rw-r--r--
subexpr.test	2.09 KB	-rw-r--r--
sync.test	5.37 KB	-rw-r--r--
sync_block.test	3.36 KB	-rw-r--r--
sync_ddl.test	5.32 KB	-rw-r--r--
tablespace_location.test	5.06 KB	-rw-r--r--
tablespace_location_error.test	494 B	-rw-r--r--
transaction.test	31.15 KB	-rw-r--r--
truncate.opt	29 B	-rw-r--r--
truncate.test	1.51 KB	-rw-r--r--

Code Editor : ngram_2.test

#
#   InnoDB FULLTEXT SEARCH: CJK support - ngram parser
#
#

--source include/have_innodb.inc
--source include/not_embedded.inc

#Test 3 scenarios:
#1. CREATE a CJK fulltext index with ngram parser when ngram parser is loaded,
# restart without ngram parser, do SELECT/INSERT;
#2. CREATE a CJK fulltext index with ngram parser when ngram parser is not loaded.
#3. CREATE a CJK fulltext index without ngram parser when ngram parser is not loaded.

SET NAMES utf8;

# t1 with default parser
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;

SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国');
SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国上海');

SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国');
SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国上海');

DROP TABLE t1;

# t1 with ngram parser
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;

SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国');
SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国上海');

SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国');
SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国上海');

# t2 with ngram parser
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 without ngram.
let $restart_parameters = restart: --ngram=OFF;
--source include/restart_mysqld.inc

# t1
CHECK TABLE t1;

--error ER_PLUGIN_IS_NOT_LOADED
SELECT * FROM t1;

--error ER_PLUGIN_IS_NOT_LOADED
SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国');

--error ER_PLUGIN_IS_NOT_LOADED
SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国上海');

--error ER_PLUGIN_IS_NOT_LOADED
SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国');

--error ER_PLUGIN_IS_NOT_LOADED
SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国上海');

--error ER_PLUGIN_IS_NOT_LOADED
INSERT INTO t1 (title, content) VALUES  ('中国', '中国');

--error ER_PLUGIN_IS_NOT_LOADED
DROP INDEX ft_title ON t1;

--error ER_PLUGIN_IS_NOT_LOADED
DROP INDEX ft_content ON t1;

--error ER_PLUGIN_IS_NOT_LOADED
TRUNCATE TABLE t1;

--error ER_PLUGIN_IS_NOT_LOADED
ALTER TABLE t1 RENAME TO t3;

# t2
RENAME TABLE t2 to t3;

DROP TABLE t3;

--error ER_FUNCTION_NOT_DEFINED
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;

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;

--error ER_FUNCTION_NOT_DEFINED
ALTER TABLE t2 ADD FULLTEXT INDEX ft_title (title) WITH PARSER ngram;

ALTER TABLE t2 ADD FULLTEXT INDEX ft_title (title);

INSERT INTO t2 (title) VALUES  ('中国');

SELECT * FROM t2 WHERE MATCH(title) AGAINST('中国');
SELECT * FROM t2 WHERE MATCH(title) AGAINST('中国上海');

DROP TABLE t2;

# Restart with ngram.
let $restart_parameters = restart;
--source include/restart_mysqld.inc

CHECK TABLE t1;

SELECT * FROM t1;

SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国');
SELECT * FROM t1 WHERE MATCH(title) AGAINST('中国上海');

SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国');
SELECT * FROM t1 WHERE MATCH(content) AGAINST('中国上海');

DROP TABLE t1;

${this.title}

Code Editor : ngram_2.test