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/t | |
| 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/t')
| -rw-r--r-- | mysql-test/t/fulltext.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index ea92ec944ed..a90344784cd 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -357,4 +357,12 @@ SELECT a FROM t1 WHERE MATCH a AGAINST('testword' IN BOOLEAN MODE); SELECT a FROM t1 WHERE MATCH a AGAINST('testword\'\'' IN BOOLEAN MODE); DROP TABLE t1; +# +# BUG#13835: max key length is 1000 bytes when trying to create +# a fulltext index +# +CREATE TABLE t1 (a VARCHAR(10000), FULLTEXT(a)); +SHOW CREATE TABLE t1; +DROP TABLE t1; + # End of 4.1 tests |