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

INSTALL PLUGIN simple_parser SONAME 'mypluglib.so';
# 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');
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('mysql');
id	title	body
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
2	How To Use MySQL Well	After you went through a ...
3	Optimizing MySQL	In this tutorial we will show ...
4	1001 MySQL Tricks	How to use full-text search engine
5	Go MySQL Tricks	How to use full text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('will go');
id	title	body
# Test plugin parser tokenizer difference
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('full-text');
id	title	body
4	1001 MySQL Tricks	How to use full-text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('full text');
id	title	body
5	Go MySQL Tricks	How to use full text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);
id	title	body
DROP TABLE articles;
# 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;
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');
ALTER TABLE articles ADD FULLTEXT INDEX (title, body) WITH PARSER simple_parser;
Warnings:
Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('mysql');
id	title	body
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
2	How To Use MySQL Well	After you went through a ...
3	Optimizing MySQL	In this tutorial we will show ...
4	1001 MySQL Tricks	How to use full-text search engine
5	Go MySQL Tricks	How to use full text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('will go');
id	title	body
# Test plugin parser tokenizer difference
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('full-text');
id	title	body
4	1001 MySQL Tricks	How to use full-text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('full text');
id	title	body
5	Go MySQL Tricks	How to use full text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('full-text' WITH QUERY EXPANSION);
id	title	body
4	1001 MySQL Tricks	How to use full-text search engine
5	Go MySQL Tricks	How to use full text search engine
2	How To Use MySQL Well	After you went through a ...
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
3	Optimizing MySQL	In this tutorial we will show ...
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('full text' WITH QUERY EXPANSION);
id	title	body
5	Go MySQL Tricks	How to use full text search engine
4	1001 MySQL Tricks	How to use full-text search engine
2	How To Use MySQL Well	After you went through a ...
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
3	Optimizing MySQL	In this tutorial we will show ...
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);
id	title	body
DROP TABLE articles;
# Test Part 3 END
SET SESSION debug="+d,fts_instrument_use_default_parser";
# 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;
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');
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('mysql');
id	title	body
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
2	How To Use MySQL Well	After you went through a ...
3	Optimizing MySQL	In this tutorial we will show ...
4	1001 MySQL Tricks	How to use full-text search engine
5	Go MySQL Tricks	How to use full text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('will go');
id	title	body
# Test plugin parser tokenizer difference
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('full-text');
id	title	body
4	1001 MySQL Tricks	How to use full-text search engine
5	Go MySQL Tricks	How to use full text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('full text');
id	title	body
4	1001 MySQL Tricks	How to use full-text search engine
5	Go MySQL Tricks	How to use full text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);
id	title	body
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
DROP TABLE articles;
# 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;
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');
ALTER TABLE articles ADD FULLTEXT INDEX (title, body) WITH PARSER simple_parser;
Warnings:
Warning	124	InnoDB rebuilding table to add column FTS_DOC_ID
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('mysql');
id	title	body
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
2	How To Use MySQL Well	After you went through a ...
3	Optimizing MySQL	In this tutorial we will show ...
4	1001 MySQL Tricks	How to use full-text search engine
5	Go MySQL Tricks	How to use full text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('will go');
id	title	body
# Test plugin parser tokenizer difference
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('full-text');
id	title	body
4	1001 MySQL Tricks	How to use full-text search engine
5	Go MySQL Tricks	How to use full text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('full text');
id	title	body
4	1001 MySQL Tricks	How to use full-text search engine
5	Go MySQL Tricks	How to use full text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);
id	title	body
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
DROP TABLE articles;
# Test Part 6: Test Query Parser with Default/Internal Parser
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);
id	title	body
3	How To Use MySQL Well	After you went through a ...
4	Optimizing MySQL	In this tutorial we will show ...
5	1001 MySQL Tricks	How to use full-text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('>mysql <database ~search' IN BOOLEAN MODE);
id	title	body
3	How To Use MySQL Well	After you went through a ...
4	Optimizing MySQL	In this tutorial we will show ...
5	1001 MySQL Tricks	How to use full-text search engine
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
2	MySQL Tutorial	DBMS stands for MySQL good one DataBase ...
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('+(mysql database) -engine' IN BOOLEAN MODE);
id	title	body
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
2	MySQL Tutorial	DBMS stands for MySQL good one DataBase ...
3	How To Use MySQL Well	After you went through a ...
4	Optimizing MySQL	In this tutorial we will show ...
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('+(mysql database -engine' IN BOOLEAN MODE);
id	title	body
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('"mysql"' IN BOOLEAN MODE);
id	title	body
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
2	MySQL Tutorial	DBMS stands for MySQL good one DataBase ...
3	How To Use MySQL Well	After you went through a ...
4	Optimizing MySQL	In this tutorial we will show ...
5	1001 MySQL Tricks	How to use full-text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('"for mysql"' IN BOOLEAN MODE);
id	title	body
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
2	MySQL Tutorial	DBMS stands for MySQL good one DataBase ...
3	How To Use MySQL Well	After you went through a ...
4	Optimizing MySQL	In this tutorial we will show ...
5	1001 MySQL Tricks	How to use full-text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('"mysql database"' IN BOOLEAN MODE);
id	title	body
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('"full text search"' IN BOOLEAN MODE);
id	title	body
5	1001 MySQL Tricks	How to use full-text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('"full text search engine"' IN BOOLEAN MODE);
id	title	body
5	1001 MySQL Tricks	How to use full-text search engine
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('+"dbms stands" -good' IN BOOLEAN MODE);
id	title	body
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('+("dbms stands") -good' IN BOOLEAN MODE);
id	title	body
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('+("dbms stands" search) -good' IN BOOLEAN MODE);
id	title	body
5	1001 MySQL Tricks	How to use full-text search engine
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('+("dbms stands" "full text") -good' IN BOOLEAN MODE);
id	title	body
5	1001 MySQL Tricks	How to use full-text search engine
1	MySQL Tutorial	DBMS stands for MySQL DataBase ...
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('("msyql database")@3' IN BOOLEAN MODE);
id	title	body
DROP TABLE articles;
SET NAMES utf8;
# 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('数据库');
id	title	body
3	要 想 将 数据 添加 到 数据库	或 访问、处理 计算机 数据库 中 保存 的 数据
1	数据库 是 数据 的 结构化 集合	它 可以 是 任何 东西
4	需要 使用 数据库 管理系统	计算机 是 处理 大量 数据 的 理想 工具
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('数据');
id	title	body
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('数据*');
id	title	body
3	要 想 将 数据 添加 到 数据库	或 访问、处理 计算机 数据库 中 保存 的 数据
1	数据库 是 数据 的 结构化 集合	它 可以 是 任何 东西
4	需要 使用 数据库 管理系统	计算机 是 处理 大量 数据 的 理想 工具
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('+数据库 -计算机');
id	title	body
1	数据库 是 数据 的 结构化 集合	它 可以 是 任何 东西
SELECT * FROM articles WHERE
MATCH(title, body) AGAINST('"计算机 数据库"' IN BOOLEAN MODE);
id	title	body
3	要 想 将 数据 添加 到 数据库	或 访问、处理 计算机 数据库 中 保存 的 数据
DROP TABLE articles;
SET GLOBAL innodb_ft_enable_diag_print = 0;
SET SESSION debug="-d,fts_instrument_use_default_parser";
# Test Part 9:# Abort the operation in dict_create_index_step
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";
CREATE FULLTEXT INDEX idx ON articles(body);
ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
SET SESSION debug="-d,ib_dict_create_index_tree_fail";
DROP TABLE articles;
UNINSTALL PLUGIN simple_parser;

${this.title}

Code Editor : plugin_debug.result