MySQL Bugs: #37179: Enable auto reconnect dont work in this version

Bug #37179	Enable auto reconnect dont work in this version
Submitted:	4 Jun 2008 1:02	Modified:	5 Jan 2009 16:51
Reporter:	Roberto Valente	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	5.1.4, 3.51	OS:	Any
Assigned to:	Jess Balint	CPU Architecture:	Any
Tags:	enable auto reconnect

Description:
The option Enable auto reconnect dont work in this version
I tested many applications at version 3.51 and when occurs 
connection fail, with, Enable auto reconnect, the connection
is restored.
Using connector 5.1, when connection fail, the connection can´t be
restored, and the errors are the same as if the option
was not marked.

How to repeat:
Open any application using the 5.1 connector
(with Enable auto reconnect option marked)
Connect to Mysql Database
Disable the network connection
Restore the network connection
Try to access the database (ex: a query)

An exception will occuour as if the the 
Enable auto reconnect option was not marked.

Thank you for a problem report. What exact version, 5.1.x, do you use? 5.1.4 is the latest.

Hi
The ODBC version is the latest (5.1.4)

Thanks

Verified by killing session while Access has connection open.

Problem caused by adding #ifdefs in headers:

#ifdef MYSQL_OPT_RECONNECT /* disabled if not included in build header */
...
#endif /* MYSQL_OPT_RECONNECT */

Enum values from mysql.h not visible as cpp macros.

Fix committed as rev 1141 and will be released in 3.51.27.

An entry was added to both the 3.51.27 and 5.1.6 changelogs:

The connection string option Enable Auto-reconnect did not work. When the connection failed, it could not be restored, and the errors generated were the same as if the option had not been selected.