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 : plugin_debug.test

--source include/have_innodb.inc
--source include/have_debug.inc
--source include/have_simple_parser.inc

# Install fts parser plugin
--replace_regex /\.dll/.so/
eval INSTALL PLUGIN simple_parser SONAME '$SIMPLE_PARSER';

-- echo # Test Part 2: Create Index Test(CREATE TABLE WITH FULLTEXT INDEX)
CREATE TABLE articles (
	id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
	title VARCHAR(200),
	body TEXT,
	FULLTEXT (title, body) WITH PARSER simple_parser
	) ENGINE=InnoDB;

INSERT INTO articles (title, body) VALUES
  ('MySQL Tutorial','DBMS stands for MySQL DataBase ...'),
  ('How To Use MySQL Well','After you went through a ...'),
  ('Optimizing MySQL','In this tutorial we will show ...'),
  ('1001 MySQL Tricks','How to use full-text search engine'),
  ('Go MySQL Tricks','How to use full text search engine');

# Simple term search
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('mysql');

# Test stopword and word len less than fts_min_token_size
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('will go');

-- echo # Test plugin parser tokenizer difference
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('full-text');

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('full text');

# No result here, we get '"mysql' 'database"' by simple parser
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);

DROP TABLE articles;

-- echo # Test Part 3: Row Merge Create Index Test(ALTER TABLE ADD FULLTEXT INDEX)
CREATE TABLE articles (
	id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
	title VARCHAR(200),
	body TEXT
	) ENGINE=InnoDB;

# Create fulltext index
ALTER TABLE articles ADD FULLTEXT INDEX (title, body) WITH PARSER simple_parser;

# Simple term search
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('mysql');

# Test stopword and word len less than fts_min_token_size
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('will go');

-- echo # Test plugin parser tokenizer difference
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('full-text');

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('full text');

# Test query expansion
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('full-text' WITH QUERY EXPANSION);

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('full text' WITH QUERY EXPANSION);

# No result here, we get '"mysql' 'database"' by simple parser
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);

DROP TABLE articles;
-- echo # Test Part 3 END

# Use default parser
SET SESSION debug="+d,fts_instrument_use_default_parser";

-- echo # Test Part 4: Create Index Test with Default/Internal Parser
CREATE TABLE articles (
	id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
	title VARCHAR(200),
	body TEXT,
	FULLTEXT (title, body) WITH PARSER simple_parser
	) ENGINE=InnoDB;

# Simple term search
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('mysql');

# Test stopword and word len less than fts_min_token_size
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('will go');

-- echo # Test plugin parser tokenizer difference
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('full-text');

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('full text');

# Phrase search
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);

DROP TABLE articles;

# Disable query parse using plugin parser
-- echo # Test Part 5: Row Merge Create Index Test with Default/Internal Parser
CREATE TABLE articles (
	id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
	title VARCHAR(200),
	body TEXT
	) ENGINE=InnoDB;

# Create fulltext index
ALTER TABLE articles ADD FULLTEXT INDEX (title, body) WITH PARSER simple_parser;

# Simple term search
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('mysql');

# Test stopword and word len less than fts_min_token_size
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('will go');

-- echo # Test plugin parser tokenizer difference
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('full-text');

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('full text');

# Phrase search
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);

DROP TABLE articles;

-- echo # Test Part 6: Test Query Parser with Default/Internal Parser
let $innodb_ft_enable_diag_print_orig = `SELECT @@innodb_ft_enable_diag_print`;
# Enable diag print to print query parse tree
SET GLOBAL innodb_ft_enable_diag_print = 1;

CREATE TABLE articles (
	id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
	title VARCHAR(200),
	body TEXT,
	FULLTEXT (title, body) WITH PARSER simple_parser
	) ENGINE=InnoDB;

INSERT INTO articles (title, body) VALUES
  ('MySQL Tutorial','DBMS stands for MySQL DataBase ...'),
  ('MySQL Tutorial','DBMS stands for MySQL good one DataBase ...'),
  ('How To Use MySQL Well','After you went through a ...'),
  ('Optimizing MySQL','In this tutorial we will show ...'),
  ('1001 MySQL Tricks','How to use full-text search engine');

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('+mysql -database' IN BOOLEAN MODE);

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('>mysql <database ~search' IN BOOLEAN MODE);

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('+(mysql database) -engine' IN BOOLEAN MODE);

# The will be no result because of parsing error.
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('+(mysql database -engine' IN BOOLEAN MODE);

# Test phrase match
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('"mysql"' IN BOOLEAN MODE);

# Test stopword or word less than fts_min_token_size
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('"for mysql"' IN BOOLEAN MODE);

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('"full text search"' IN BOOLEAN MODE);

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('"full text search engine"' IN BOOLEAN MODE);

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('+"dbms stands" -good' IN BOOLEAN MODE);

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('+("dbms stands") -good' IN BOOLEAN MODE);

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('+("dbms stands" search) -good' IN BOOLEAN MODE);

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('+("dbms stands" "full text") -good' IN BOOLEAN MODE);

# Test proximity match
# It will be treated as phrase match
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('("msyql database")@3' IN BOOLEAN MODE);

DROP TABLE articles;

SET NAMES utf8;

-- echo # Test Part 7: Test Different Charset
CREATE TABLE articles (
	id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
	title VARCHAR(200),
	body TEXT,
	FULLTEXT (title, body) WITH PARSER simple_parser
	) ENGINE=InnoDB DEFAULT CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;

INSERT INTO articles (title, body) VALUES
  ('数据库 是 数据 的 结构化 集合','它 可以 是 任何 东西'),
  ('从 简单 的 购物清单 到 画展','或 企业网络 中 的 海量信息'),
  ('要 想 将 数据 添加 到 数据库','或 访问、处理 计算机 数据库 中 保存 的 数据'),
  ('需要 使用 数据库 管理系统','计算机 是 处理 大量 数据 的 理想 工具');

SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('数据库');

# Test word len less than fts_min_token_size
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('数据');

# Test wildcard
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('数据*');

# Test operator
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('+数据库 -计算机');

# Test phrase search
SELECT * FROM articles WHERE
	MATCH(title, body) AGAINST('"计算机 数据库"' IN BOOLEAN MODE);

DROP TABLE articles;

eval SET GLOBAL innodb_ft_enable_diag_print = $innodb_ft_enable_diag_print_orig;

# Disable use default parser
SET SESSION debug="-d,fts_instrument_use_default_parser";

-- echo # Test Part 9:# Abort the operation in dict_create_index_step
# by setting return status of dict_create_index_tree_step() to DB_OUT_OF_MEMORY
# # The newly create dict_index_t should be removed from fts cache

CREATE TABLE articles (
       id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
       title VARCHAR(200),
       body TEXT,
       FULLTEXT (title, body) WITH PARSER simple_parser
) ENGINE=InnoDB;
#
SET SESSION debug="+d,ib_dict_create_index_tree_fail";
--error ER_OUT_OF_RESOURCES
CREATE FULLTEXT INDEX idx ON articles(body);
SET SESSION debug="-d,ib_dict_create_index_tree_fail";
#
DROP TABLE articles;

UNINSTALL PLUGIN simple_parser;

${this.title}

Code Editor : plugin_debug.test