diff options
| author | unknown <svoj@april.(none)> | 2006-01-13 21:25:12 +0400 |
|---|---|---|
| committer | unknown <svoj@april.(none)> | 2006-01-13 21:25:12 +0400 |
| commit | 7f397ffd957f83670eeaf86d534478b07272b5b4 (patch) | |
| tree | 7b4ed0ebb6fc2e507a0c6b44a5d919e6811f9382 /mysql-test/r | |
| parent | b5a72e4a0b2ba32bc14e1f5cc37a262d7dc22d49 (diff) | |
| download | mariadb-git-7f397ffd957f83670eeaf86d534478b07272b5b4.tar.gz | |
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.
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/fulltext.result | 8 |
1 files changed, 8 insertions, 0 deletions
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; |