| Bug #40897 | server crashes if fulltext index added to custom UCA collation | ||
|---|---|---|---|
| Submitted: | 20 Nov 2008 17:05 | Modified: | 27 Nov 2008 13:09 |
| Reporter: | Miguel K | Email Updates: | |
| Status: | Won't fix | Impact on me: | |
| Category: | MySQL Server: Charsets | Severity: | S3 (Non-critical) |
| Version: | 5.0.67 | OS: | Windows (XP) |
| Assigned to: | CPU Architecture: | Any | |
[20 Nov 2008 18:01]
MySQL Verification Team
Thank you for the bug report. Verified as described on 5.0 server only.
Description: With a custom UTF-8 character set, I can't add a full-text index if the table has at least one row. How to repeat: Add after <charset name="utf8"> to Index.xml: <collation name="utf8_dquote_ci" id="252"> <rules> <reset>\u0000</reset> <s>\u0022</s> <!-- double quote --> </rules> </collation> CREATE TABLE test2 ( `col1` varchar(100) character set utf8 collate utf8_dquote_ci NOT NULL, PRIMARY KEY (`col1`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; INSERT INTO test2 (col1) VALUES('one'); -- this crashes the server: ALTER TABLE test2 ADD FULLTEXT INDEX (`col1`);