Bug #508 autoReconnect / autoReconnectForPools broken since 3.0.11
Submitted: 26 May 2003 12:18 Modified: 16 Jun 2003 2:22
Reporter: Oleg Ivanov Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / J Documentation Severity:S1 (Critical)
Version:3.0.14-production OS:Microsoft Windows (Windows XP SP2)
Assigned to: Mark Matthews CPU Architecture:Any

[26 May 2003 12:18] Oleg Ivanov
Description:
CREATE FULLTEXT INDEX ms_long_idx ON MSG(TEXT); - not work;
alter table msg ADD FULLTEXT ms_long_idx (TEXT); - work;

the same time all of this statements work in 4.0.13 release.

How to repeat:
put character_set = cp1251 in my.ini (may be not needed), use mysqld-nt.exe
===========================================
CREATE TABLE MS (TEXT MEDIUMTEXT);

OK

CREATE FULLTEXT INDEX ms_long_idx ON MS(TEXT);

ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FULLTEXT INDEX ms_long_idx ON MS(TEXT)' at line 1

alter table ms ADD FULLTEXT ms_long_idx (TEXT);

OK

Suggested fix:
statements work in 4.0.13 release - check code changes
[15 Jun 2003 12:00] Sergei Golubchik
fixed in 4.1.1
[2 Aug 2006 8:37] MC Brown
A note on the potential issues with autoReconnect, and advice not to use it, has been added to the Connector/J documentation.