DBD::mysql 3.0007 and 3.0007_1 (Dev) released!

[email protected] (Patrick Galbraith) Mon, 11 Sep 2006 08:53:51 -0400
Newsgroups perl.dbi.users,perl.dbi.announce
Message-ID <[email protected]>
Dear DBD::mysql users and developers,

DBD::mysql version 3.0007 (stable, production) and 3.0007_1 (dev) have 
been released!

Version 3.0007 is the production version with server-side prepare
statements turned off by default, and 3.0007_1 is the development
version with server-side prepare statements turned on by default.

Changes in 3.0007/3.0007_1, from ChangeLog:

* Make sure to call dbd_st_finish when all rows from a statement handle
    have been fetched. (Bug #20153, Bug# 21607, as rt.cpan.org ticket #s
    20464, 21241) Jim Winstead
  * Patch from Steve Hay to fix bind_param to deal properly with insertion
    of a NULL into an INT or DOUBLE column using server-side prepare.
    Converted Steve's dbi.pl script to expose this problem to 40bindparam2
    test.
  * Fix to mysql_st_internal_execute to keep from passing undefined dbh
    handle member (bind_type_guessing) to parse_param causing crash on
    OpenBSD. Reported on rt.cpan.org (#20868) by Kyle Georg, as well as
    info from Sam Smith and Federico Giannici
  * Cleaned up tests to make sure test table is dropped at end of test.

Notes:

* To turn ON server-side prepared statements (only in 3.0007 non-dev 
release),
simply append ";mysql_server_prepare=1" to the connect string or via the 
driver
handle. Server-side prepared statements are turned off (emulated) by 
default in 3.0007.
Please refer to documentation for further details.

* To turn OFF server-side prepare statements (only in 3.0007_1 dev 
release) to have
emulated prepared statements, append ";mysql_emulated_prepare=1" in the 
connect string or
via the driver handle. Server-side prepared statements are turned on by 
default in 3.0007_1.
Please refer to documentation for further details.

* Very soon, I intend to turn on  server side prepared statement on by
 default. I will 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.

As the community, one think you can do if you are interested in helping
is to turn on server side prepare statements in 3.0007, or try the
development driver, 3.0007_1 to see if there are any problems. I've
tested the code as much as I can, but I know nothing tests code like
1000s of developers thinking of unique ways of using the driver that I
never could have imagined. If you find a bug, please report it to me, or
at http://bugs.mysql.com. There is also the rt.cpan.org website for 
reporting
issues, but I prefer http://bugs.mysql.com, since there is a good 
verification
process when a bug is reported there, and it's more visible to me.

Coveat: Please make sure you don't use a threaded Perl with this driver
on Solaris.

Again, 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/

Again, thanks to all who helped to report bugs for this release and 
provided patches.

Please feel free to email me directly if you need to get my attention to 
something that needs
attention, as well as if you feel that you would like to contribute to 
DBD::mysql.

Also, thank you for using MySQL and DBD::mysql!

Kind regards,

Patrick Galbraith