summaryrefslogtreecommitdiff
path: root/mysql-test/t/fulltext.test
diff options
context:
space:
mode:
authorsvoj@april.(none) <>2006-01-13 21:25:12 +0400
committersvoj@april.(none) <>2006-01-13 21:25:12 +0400
commit5581ef960ab2a8e013ac21f057c489d1a1b35ff3 (patch)
tree7b4ed0ebb6fc2e507a0c6b44a5d919e6811f9382 /mysql-test/t/fulltext.test
parent0e2fac2d8c992ec88c3f00426143e909cff85d6d (diff)
downloadmariadb-git-5581ef960ab2a8e013ac21f057c489d1a1b35ff3.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.
Diffstat (limited to 'mysql-test/t/fulltext.test')
-rw-r--r--mysql-test/t/fulltext.test8
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