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

--source include/have_debug.inc

--echo # 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 ...');

let $default_cache_size = `select @@query_cache_size`;
SET GLOBAL query_cache_size=0;

--echo # Query involves Ranking
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('MySQL' IN NATURAL LANGUAGE MODE) LIMIT 1;

--echo # Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('MySQL' IN NATURAL LANGUAGE MODE) LIMIT 1;
SET DEBUG = '-d,fts_union_limit_off';

--echo # Query involves No Ranking and fts_union operations
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('MySQL' IN BOOLEAN MODE) limit 1;

--echo # Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('MySQL' IN BOOLEAN MODE) limit 1;

SET DEBUG = '-d,fts_union_limit_off';

--echo # Query involves No ranking and fts_union, fts_ignore
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('MySQL -YourSQL' IN BOOLEAN MODE) limit 1;

--echo # Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('MySQL -YourSQL' IN BOOLEAN MODE) limit 1;
SET DEBUG = '-d,fts_union_limit_off';

--echo # Query with fts_intersect
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('MySQL +YourSQL' IN BOOLEAN MODE) limit 1;

--echo # Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('MySQL +YourSQL' IN BOOLEAN MODE) limit 1;
SET DEBUG = '-d,fts_union_limit_off';

# insert record with @ character which is used in proximity search
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 ...');

--echo # Query with @distance
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('"MySQL request"@3' IN BOOLEAN MODE) limit 1;

--echo # 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;
SET DEBUG = '-d,fts_union_limit_off';

--echo # Query with subexpression
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('+MySQL +(-support +doc)' IN BOOLEAN MODE) limit 1;

--echo # 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;
SET DEBUG = '-d,fts_union_limit_off';

--echo # limit num1 OFFSET num2
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('MySQL' in boolean mode) limit 4 offset 2;

--echo # 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;
SET DEBUG = '-d,fts_union_limit_off';

--echo # wild card search
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('ru*' IN BOOLEAN MODE) limit 1;

--echo # Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('ru*' IN BOOLEAN MODE) limit 1;
SET DEBUG = '-d,fts_union_limit_off';

--echo # phrase search
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('"request support"' IN BOOLEAN MODE) limit 1;

--echo # Without optimization
SET DEBUG = '+d,fts_union_limit_off';
SELECT * FROM articles
	WHERE MATCH (title,body)
	AGAINST ('"request support"' IN BOOLEAN MODE) limit 1;
SET DEBUG = '-d,fts_union_limit_off';

DROP TABLE articles;
--disable_query_log
--eval SET GLOBAL query_cache_size = $default_cache_size
--enable_query_log

--echo #
--echo # Bug #31228694 FTS QUERY WITH LIMIT CRASH
--echo #

let $restart_parameters = restart: --ngram_token_size=1;
--source include/restart_mysqld.inc
select @@ngram_token_size;

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;
DROP TABLE t1;

# restore config
let $restart_parameters = restart: ;
--source include/restart_mysqld.inc

${this.title}

Code Editor : limit_union.test