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

# Bug #22709692	FTS QUERY EXCEEDS RESULT CACHE LIMIT
CREATE TABLE articles (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
body TEXT,
FULLTEXT (title,body),
FULLTEXT (body))ENGINE=InnoDB;
INSERT INTO articles (title,body) VALUES
('MySQL Tutorial','DBMS stands for DataBase ...'),
('How To Use MySQL Well','After you went through a ...'),
('Optimizing MySQL','In this tutorial we will show ...'),
('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
('MySQL vs. YourSQL','In the following database comparison ...'),
('MySQL Security','When configured properly, MySQL ...');
SET GLOBAL query_cache_size=0;
Warnings:
Warning	1287	'@@query_cache_size' is deprecated and will be removed in a future release.
# Query involves Ranking
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('MySQL' IN NATURAL LANGUAGE MODE) LIMIT 1;
id	title	body
6	MySQL Security	When configured properly, MySQL ...
# Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('MySQL' IN NATURAL LANGUAGE MODE) LIMIT 1;
id	title	body
6	MySQL Security	When configured properly, MySQL ...
SET DEBUG = '-d,fts_union_limit_off';
# Query involves No Ranking and fts_union operations
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('MySQL' IN BOOLEAN MODE) limit 1;
id	title	body
1	MySQL Tutorial	DBMS stands for DataBase ...
# Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('MySQL' IN BOOLEAN MODE) limit 1;
id	title	body
6	MySQL Security	When configured properly, MySQL ...
SET DEBUG = '-d,fts_union_limit_off';
# Query involves No ranking and fts_union, fts_ignore
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('MySQL -YourSQL' IN BOOLEAN MODE) limit 1;
id	title	body
6	MySQL Security	When configured properly, MySQL ...
# Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('MySQL -YourSQL' IN BOOLEAN MODE) limit 1;
id	title	body
6	MySQL Security	When configured properly, MySQL ...
SET DEBUG = '-d,fts_union_limit_off';
# Query with fts_intersect
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('MySQL +YourSQL' IN BOOLEAN MODE) limit 1;
id	title	body
5	MySQL vs. YourSQL	In the following database comparison ...
# Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('MySQL +YourSQL' IN BOOLEAN MODE) limit 1;
id	title	body
5	MySQL vs. YourSQL	In the following database comparison ...
SET DEBUG = '-d,fts_union_limit_off';
INSERT INTO articles (title,body) VALUES
('MySQL Tutorial','request doc@oraclehelp.com ...'),
('MySQL Tutorial','request support@oraclehelp.com ...'),
('Trial version','query performace @1255 minute on 2.1Hz
	  Memory 2GB...'),
('when To Use MySQL Well','for free faq  mail@xyz.com ...');
# Query with @distance
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('"MySQL request"@3' IN BOOLEAN MODE) limit 1;
id	title	body
7	MySQL Tutorial	request doc@oraclehelp.com ...
# Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('"MySQL request"@3' IN BOOLEAN MODE) limit 1;
id	title	body
7	MySQL Tutorial	request doc@oraclehelp.com ...
SET DEBUG = '-d,fts_union_limit_off';
# Query with subexpression
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('+MySQL +(-support +doc)' IN BOOLEAN MODE) limit 1;
id	title	body
7	MySQL Tutorial	request doc@oraclehelp.com ...
# Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('+MySQL +(-support +doc)' IN BOOLEAN MODE) limit 1;
id	title	body
7	MySQL Tutorial	request doc@oraclehelp.com ...
SET DEBUG = '-d,fts_union_limit_off';
# limit num1 OFFSET num2
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('MySQL' in boolean mode) limit 4 offset 2;
id	title	body
2	How To Use MySQL Well	After you went through a ...
3	Optimizing MySQL	In this tutorial we will show ...
4	1001 MySQL Tricks	1. Never run mysqld as root. 2. ...
5	MySQL vs. YourSQL	In the following database comparison ...
# Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('MySQL' in boolean mode) limit 4 offset 2;
id	title	body
2	How To Use MySQL Well	After you went through a ...
3	Optimizing MySQL	In this tutorial we will show ...
4	1001 MySQL Tricks	1. Never run mysqld as root. 2. ...
5	MySQL vs. YourSQL	In the following database comparison ...
SET DEBUG = '-d,fts_union_limit_off';
# wild card search
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('ru*' IN BOOLEAN MODE) limit 1;
id	title	body
4	1001 MySQL Tricks	1. Never run mysqld as root. 2. ...
# Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('ru*' IN BOOLEAN MODE) limit 1;
id	title	body
4	1001 MySQL Tricks	1. Never run mysqld as root. 2. ...
SET DEBUG = '-d,fts_union_limit_off';
# phrase search
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('"request support"' IN BOOLEAN MODE) limit 1;
id	title	body
8	MySQL Tutorial	request support@oraclehelp.com ...
# Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST ('"request support"' IN BOOLEAN MODE) limit 1;
id	title	body
8	MySQL Tutorial	request support@oraclehelp.com ...
SET DEBUG = '-d,fts_union_limit_off';
DROP TABLE articles;
Warnings:
Warning	1287	'@@query_cache_size' is deprecated and will be removed in a future release.
#
# Bug #31228694 FTS QUERY WITH LIMIT CRASH
#
# restart: --ngram_token_size=1
select @@ngram_token_size;
@@ngram_token_size
1
CREATE TABLE t1 (
id INT(10) unsigned NOT NULL AUTO_INCREMENT,
name VARCHAR(45) NOT NULL,
PRIMARY KEY (id) USING BTREE,
FULLTEXT KEY search_name (name)  WITH PARSER ngram
) ENGINE=InnoDB;
INSERT INTO t1(name) VALUES('x'), ('mx'), ('mx'), ('mx'), ('mx');
SELECT * FROM t1 WHERE MATCH (`name`) AGAINST ('mx*' IN BOOLEAN MODE) LIMIT 3;
id	name
2	mx
3	mx
4	mx
DROP TABLE t1;
# restart:

${this.title}

Code Editor : limit_union.result