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: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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.