From 7f397ffd957f83670eeaf86d534478b07272b5b4 Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 13 Jan 2006 21:25:12 +0400 Subject: BUG#13835: max key length is 1000 bytes when trying to create a fulltext index Allow fulltext index on VARCHAR columns longer than max key length. mysql-test/r/fulltext.result: A test case for BUG#13835 added. mysql-test/t/fulltext.test: A test case for BUG#13835 added. sql/sql_table.cc: Allow fulltext index on VARCHAR columns longer than max key length. --- mysql-test/r/fulltext.result | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'mysql-test/r/fulltext.result') diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index 7e2e0a56212..3e6dd896ed8 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -437,3 +437,11 @@ SELECT a FROM t1 WHERE MATCH a AGAINST('testword\'\'' IN BOOLEAN MODE); a testword'' DROP TABLE t1; +CREATE TABLE t1 (a VARCHAR(10000), FULLTEXT(a)); +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(10000) default NULL, + FULLTEXT KEY `a` (`a`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +DROP TABLE t1; -- cgit v1.2.1