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

--source include/have_innodb.inc

#
# Fulltext configurable parameters
#
--disable_warnings
drop table if exists t1;
--enable_warnings

--echo #
--echo # Bug#56814 Explain + subselect + fulltext crashes server
--echo #

CREATE TABLE t1(f1 VARCHAR(6) NOT NULL,FULLTEXT KEY(f1),UNIQUE(f1)) ENGINE = InnoDB;
INSERT INTO t1 VALUES ('test');
EXPLAIN SELECT 1 FROM t1
WHERE 1 > ALL((SELECT 1 FROM t1 JOIN t1 a ON (MATCH(t1.f1) AGAINST (""))
WHERE t1.f1 GROUP BY t1.f1));

PREPARE stmt FROM
'EXPLAIN SELECT 1 FROM t1
 WHERE 1 > ALL((SELECT 1 FROM t1 RIGHT OUTER JOIN t1 a
 ON (MATCH(t1.f1) AGAINST (""))
 WHERE t1.f1 GROUP BY t1.f1))';

EXECUTE stmt;
EXECUTE stmt;

DEALLOCATE PREPARE stmt;

PREPARE stmt FROM
'EXPLAIN SELECT 1 FROM t1
 WHERE 1 > ALL((SELECT 1 FROM t1 JOIN t1 a
 ON (MATCH(t1.f1) AGAINST (""))
 WHERE t1.f1 GROUP BY t1.f1))';

EXECUTE stmt;
EXECUTE stmt;

DEALLOCATE PREPARE stmt;

DROP TABLE t1;

#try to crash gcc 2.96
--disable_warnings
drop table if exists t1;
--enable_warnings

CREATE TABLE t1 (
  kodoboru varchar(10) default NULL,
  obor tinytext,
  aobor tinytext,
  UNIQUE INDEX kodoboru (kodoboru),
  FULLTEXT KEY obor (obor),
  FULLTEXT KEY aobor (aobor)
) ENGINE = InnoDB;

drop table t1;

CREATE TABLE t1 (
  kodoboru varchar(10) default NULL,
  obor tinytext,
  aobor tinytext,
  UNIQUE INDEX kodoboru (kodoboru),
  FULLTEXT KEY obor (obor)
) ENGINE = InnoDB;
INSERT INTO t1 VALUES ('0101000000','aaa','AAA');
INSERT INTO t1 VALUES ('0102000000','bbb','BBB');
INSERT INTO t1 VALUES ('0103000000','ccc','CCC');
INSERT INTO t1 VALUES ('0104000000','xxx','XXX');

select * from t1;
drop table t1;

# End of 4.1 tests

#
# Bug#20503: Server crash due to the ORDER clause isn't taken into account
#            while space allocation
#
create table t1 (c1 varchar(1), c2 int, c3 int, c4 int, c5 int, c6 int,
c7 int, c8 int, c9 int, fulltext key (`c1`)) ENGINE = InnoDB;
select distinct match (`c1`) against ('z') , c2, c3, c4,c5, c6,c7, c8
  from t1 where c9=1 order by c2, c2;
drop table t1;

#
# VIEW with full text
#
CREATE TABLE t1 (c1 int not null auto_increment primary key, c2 varchar(20), fulltext(c2)) ENGINE = InnoDB;
insert into t1 (c2) VALUES ('real Beer'),('Water'),('Kossu'),('Coca-Cola'),('Vodka'),('Wine'),('almost real Beer');
select * from t1 WHERE match (c2) against ('Beer');
CREATE VIEW v1 AS SELECT  * from t1 WHERE match (c2) against ('Beer');
select * from v1;
drop view v1;
drop table t1;

# Test case for bug 6447
create table t1 (mytext text, FULLTEXT (mytext)) ENGINE = InnoDB;
insert t1 values ('aaabbb');

# INNODB_FTS: These variables are not support in InnoDB
check table t1;
# set @my_key_cache_block_size= @@global.key_cache_block_size;
# set GLOBAL key_cache_block_size=2048;
check table t1;
drop table t1;
# Restore the changed variable value
#set global key_cache_block_size= @my_key_cache_block_size;

#
# BUG#12075 - FULLTEXT non-functional for big5 strings
# 
# INNODB_FTS: Not yet support big5
#CREATE TABLE t1 (a CHAR(50) CHARACTER SET big5 NOT NULL, FULLTEXT(a)) ENGINE = InnoDB;
#INSERT INTO t1 VALUES(0xA741ADCCA66EB6DC20A7DAADCCABDCA66E);
#SELECT HEX(a) FROM t1 WHERE MATCH(a) AGAINST (0xA741ADCCA66EB6DC IN BOOLEAN MODE);
#DROP TABLE t1;

create table t1 (a varchar(10), fulltext key(a)) ENGINE = InnoDB;
insert into t1 values ('a');
select hex(concat(match (a) against ('a'))) from t1;
create table t2 ENGINE = InnoDB as select concat(match (a) against ('a')) as a from t1;
show create table t2;
drop table t1, t2;

#
# BUG#31159 - fulltext search on ucs2 column crashes server
#
CREATE TABLE t1(a TEXT CHARSET ucs2 COLLATE ucs2_unicode_ci) ENGINE = InnoDB;
INSERT INTO t1 VALUES('abcd');

# INNODB_FTS: Please Note this table do not have FTS. InnoDB return 1214 error
--error ER_FT_MATCHING_KEY_NOT_FOUND
SELECT * FROM t1 WHERE MATCH(a) AGAINST ('+abcd' IN BOOLEAN MODE);
DROP TABLE t1;

#
# Some other simple tests with the current character set
#
create table t1 (a varchar(10), key(a), fulltext (a)) ENGINE = InnoDB;
insert into t1 values ("a"),("abc"),("abcd"),("hello"),("test");
-- disable_result_log
ANALYZE TABLE t1;
-- enable_result_log
select * from t1 where a like "abc%";
select * from t1 where a like "test%";
select * from t1 where a like "te_t";
select * from t1 where match a against ("te*" in boolean mode)+0;
drop table t1;

--echo # 
--echo # Bug #49734: Crash on EXPLAIN EXTENDED UNION ... ORDER BY 
--echo #   <any non-const-function>
--echo #

CREATE TABLE t1 (a VARCHAR(10), FULLTEXT KEY a (a)) ENGINE = InnoDB;
INSERT INTO t1 VALUES (1),(2);
CREATE TABLE t2 (b INT) ENGINE = InnoDB;
INSERT INTO t2 VALUES (1),(2);

--echo # Should not crash
EXPLAIN EXTENDED
SELECT * FROM t1 UNION SELECT * FROM t1 ORDER BY a + 12;

--echo # Should not crash
SELECT * FROM t1 UNION SELECT * FROM t1 ORDER BY a + 12;

--echo # Should not crash

EXPLAIN EXTENDED
SELECT * FROM t1 UNION SELECT * FROM t1
  ORDER BY MATCH(a) AGAINST ('+abc' IN BOOLEAN MODE);

--echo # Should not crash

SELECT * FROM t1 UNION SELECT * FROM t1
  ORDER BY MATCH(a) AGAINST ('+abc' IN BOOLEAN MODE);

# FIXME: Valgrind in MySQL code _MI_WRITE_BLOB_RECORD, bug #13389854
#--echo # Should not crash
#(SELECT * FROM t1) UNION (SELECT * FROM t1)
#  ORDER BY MATCH(a) AGAINST ('+abc' IN BOOLEAN MODE);

--echo # Should not crash
EXPLAIN EXTENDED
SELECT * FROM t1 UNION SELECT * FROM t1
  ORDER BY (SELECT a FROM t2 WHERE b = 12);

--echo # Should not crash
--disable_result_log
SELECT * FROM t1 UNION SELECT * FROM t1
  ORDER BY (SELECT a FROM t2 WHERE b = 12);
--enable_result_log

--echo # Should not crash
SELECT * FROM t2 UNION SELECT * FROM t2
  ORDER BY (SELECT * FROM t1 WHERE MATCH(a) AGAINST ('+abc' IN BOOLEAN MODE));

DROP TABLE t1,t2;

--echo End of 5.1 tests

${this.title}

Code Editor : fulltext_misc.test