MySQL Bugs: #19550: MYSQL_OPT_RECONNECT documentation

Bug #19550	MYSQL_OPT_RECONNECT documentation
Submitted:	4 May 2006 22:45	Modified:	10 May 2006 14:35
Reporter:	Olaf van der Spek (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	*	OS:	Any (*)
Assigned to:	Magnus Blåudd	CPU Architecture:	Any

Description:
Hi,

> mysql_options() should be called after mysql_init() and before mysql_connect() or mysql_real_connect().

For MYSQL_OPT_RECONNECT, mysql_options() should be called after mysql_real_connect(). So the documentation should mention that.

How to repeat:
-

Thank you for the bug report. 
Please see comments on bug: http://bugs.mysql.com/bug.php?id=15719

 [25 Jan 10:46] Magnus Svensson

>Reconnect does not seem to work as expected on Windows.

A correction, reconnect works if mysql_option(mysql, MYSQL_OPT_RECONNECT) is
called after mysql_real_connect.

Does this mean opt_reconnect can also be set before connect now?

> -Category:         Server
> +Category:         Server: Docs

I've reported this before but it got ignored. There's a bug in the bug tracker that prevents you from setting the right sub category when you submit bugs.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

The reconnect flag is now initialiseded to it's default value when mysql_init is called. After mysql_init, it can be changed by calling mysql_option(mysql, MYSQL_OPT_RECONNECT, ..).

Whenever the connection to MySQL Server it will look at this value and try to reconnect if the value is true.

Before the fix the reconnect variable was reset by mysql_real_connect, so that is why it had to be changed after the mysql_real_connect.

Ok, the bug is fixed but we should update the docs as I explained in previous message.

This was fixed by patch for bug#15719. Documentation has been checked and it reflects that mysql_options(mysql, MYSQL_OPT_RECONNECT) should be called between mysql_init and mysql_real_connect just as any other option.