summaryrefslogtreecommitdiff
path: root/mysql-test/t/fulltext2.test
diff options
context:
space:
mode:
authorunknown <svoj@april.(none)>2006-01-23 17:15:33 +0400
committerunknown <svoj@april.(none)>2006-01-23 17:15:33 +0400
commit0ee28e1a4daca25f85ced473b2014e868ae341f8 (patch)
tree7013861d559c88de296287529f44f879fce85354 /mysql-test/t/fulltext2.test
parentffe11393c9ce64a064faa2b85d3fb78de9adc013 (diff)
downloadmariadb-git-0ee28e1a4daca25f85ced473b2014e868ae341f8.tar.gz
BUG#16489 - utf8 + fulltext leads to corrupt index file.
Fixed that UPDATE statement crashes multi-byte charset fulltext index. myisam/ft_update.c: Fixed that UPDATE statement crashes multi-byte charset fulltext index. While updating, always rewrite multi-byte charset fulltext index. mysql-test/r/fulltext2.result: Added a testcase for BUG#16489. mysql-test/t/fulltext2.test: Added a testcase for BUG#16489.
Diffstat (limited to 'mysql-test/t/fulltext2.test')
-rw-r--r--mysql-test/t/fulltext2.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext2.test b/mysql-test/t/fulltext2.test
index 7a7b572d58f..fd97f795534 100644
--- a/mysql-test/t/fulltext2.test
+++ b/mysql-test/t/fulltext2.test
@@ -209,6 +209,14 @@ insert into t1 values('test test '),('test'),('test'),('test'),
('test'),('test'),('test'),('test'),('test'),('test'),('test'),('test'),
('test'),('test'),('test'),('test'),('test'),('test'),('test'),('test');
delete from t1 limit 1;
+
+#
+# BUG#16489: utf8 + fulltext leads to corrupt index file.
+#
+truncate table t1;
+insert into t1 values('ab c d');
+update t1 set a='ab c d';
+select * from t1 where match a against('ab c' in boolean mode);
drop table t1;
set names latin1;