Bug #508 autoReconnect / autoReconnectForPools broken since 3.0.11

• Submitted: 26 May 2003 12:18
• Modified: 16 Jun 2003 2:22
• Reporter: Oleg Ivanov
• Status: Closed
• Category: Connector / J Documentation
• Severity: S1 (Critical)
• Version: 3.0.14-production
• OS: 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.