Dear DBD::mysql users,
DBD::mysql version 3.0003 (stable, production) and 3.0003_1 (dev) have
been released!
Version 3.0003 is the production version with server-side prepare
statements turned off by default, and 3.0003_1 is the development
version with server-side prepare statements turned on by default.
The changes in 3.0003, as in the changelog, are:
* Fixed bug where if mysql_server_prepare is set and a prepare
fails, only a warning is issued and no error text is
available (Thanks Martin Evans!)
* Added support for ParamValues and associated test (Martin Evans)
* Removed declaration of int num_fields outside a block which
was causing compilation error with some C compilers.
* Fix to typo in Makefile.PL (Martin Evans)
* Added mysql_stmt_reset for when mysql_stmt_execute fails
* Added test for mysql_stmt_execute bug (Martin Evans)
* Fixed syntax for create table ENGINE=InnoDB instead of type=innobase
* Removed tests for old driver emulation
Note: to turn on server-side prepared statements, simply append
";mysql_server_prepare" to the connect string or via the driver handle.
Please refer to documentation for further details.
The changes in 3.0003_1 are:
* Removed old Msql-Mysql Driver emulation code - finally!!!
* Removed string testing code for unsupported
statements and now use error code returned from mysql_stmt_prepare,
if statement not
supported, toggle to mysql_emulated_prepare
* Fixed bug where failed stmt execution caused later statements
to fail with mysql_stmt_reset
* Added tests for unsupported statements
* Added test for test of failed statement with subsequent executes
(thanks to Martin Evans!)
* Added typo fix (Martin Evans)
* Added support for ParamValues and associated test (Martin Evans)
* Removed old emulated driver tests (HOORAY!)
* Cleaned up debug printing code
* Fixed syntax for create table ENGINE=InnoDB instead of type=innobase
* Cleaned up tests
Notes:
* This version supports multiple result sets from stored procedures
(Thanks to Guy Harrison!). Documentation and sample code (in the ./eg
dir) is now included on how to use multiple result sets.
* To turn off server-side prepare statements append
";mysql_emulated_prepare" in the connect string or via the driver handle.
*As listed in the second changelog, this code is now much better at
handling SQL statements that aren't supported in the prepared statement
C API, and silently deals with determining whether or not to use the
prepared statement calls.
I really appreciate the help of Martin Evans, as well as the rest of the
community in helping by giving patches and feedback about various issues
with the driver. Thank you!
The next version, I intend to stabilise the dev release and make that
the production release. This will make it so that server side prepared
statements are on by default. I intend to test this thoroughly prior to
making the switch, so that users don't have any problems when upgrading,
when the time comes. This prepared statement API is only available with
MySQL server versions 4.1 and above, so if you're using an older
version, you won't notice anything. Though, be assured that even for the
driver emulated handling of prepared statements, I will continue to make
sure the code is improved.
One last note: Please make sure you don't use a threaded Perl with this
driver on Solaris. This is something I will add to the INSTALL notes and
other documentation in the next release. Thanks to Leonid Kabanov for
pointing this out.
Please, if anyone has any problems or questions with the driver, please
feel free to email me, or especially post to [email protected] , and if
you find bugs, please report them to http://bugs.mysql.com
These versions for this module can be found at CPAN:
http://search.cpan.org/dist/DBD-mysql/
The files:
file: $CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0003.tar.gz
size: 111761 bytes
md5: 7aa7c182ac59ab39cb7a32a8f9d6e945
file: $CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0003_1.tar.gz
size: 109405 bytes
md5: e3d0e7f682e653d457c5f4d37a43f370
Thank you for using DBD::mysql!
Patrick Galbraith
