Dear DBD::mysql developers and users,
DBD::mysql version 3.0008 (stable, production) and 3.0008_1 (dev) have
been released!
Version 3.0008 is the production version with server-side prepare
statements turned off by default, and 3.0008_1 is the development
version with server-side prepare statements turned on by default.
Changes in 3.0008
* Added multiple fixes to dbd_st_prepare which fixed variable overwrite
and unset increment counter. Also improved loop which checks
statements for presence of "LIMIT" by using a pointer as opposed to
char array increment variable. These errors were showing up in OpenBSD
and other Unixen (which I think all BSD-based) (Thanks to Kyle
George!)
* Added fix to Makefile.PL to obtain correct build flags on VMS (Thanks
to Eric Milkie!)
* Fixed declaration of "row" in mysql_st_internal_execute which caused
compile errors on some platforms
* Fixed casting of num_params to unsigned int in calls to NewZ in
mysql.xs
* Fixed typo in Makefile.PL for test_user which was supposed to be
testuser
Changes in 3.0008_1, (also in 3.0007_2) from ChangeLog:
* Added patch for SSL Verify Certificate (Thanks Eric Chen!)
* Added multiple fixes to dbd_st_prepare which fixed variable overwrite
and unset increment counter. Also improved loop which checks
statements for presence of "LIMIT" by using a pointer as opposed to
char array increment variable. These errors were showing up in
OpenBSD
and other Unixen (which I think all BSD-based) (Thanks to Kyle
George!)
* Added fix to Makefile.PL to obtain correct build flags on VMS
(Thanks to Eric Milkie!)
* Fixed casting of num_params to unsigned int in calls to NewZ in
mysql.xs
* Added UTF8 patch from Dominic Mitchell (Thanks!)
* Fixed declaration of "row" in mysql_st_internal_execute which caused
compile errors on some platforms
* Fix documentation for _ListDBs to remove incorrect information about
limitations of data_sources(). (RT #20843, patch by Ann Barcomb)
* Fix typo in example (missing quote). (RT #15086)
* Mention in POD that 'localhost' always means to connect via UNIX
socket, and 127.0.0.1 must be used for TCP/IP to localhost (RT #14942,
reported by Alessandro Ranellucci)
* Fix typos in Makefile.PL (RT#16178, reported by Gavin Shelley)
Notes:
* To turn ON server-side prepared statements (only in 3.0008 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.0008. Please refer to documentation for
further details.
* To turn OFF server-side prepare statements (only in 3.0008_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.0008_1. Please refer to documentation for further details.
* In one more version (3.0009 will be the last) I intend to turn on
server side prepared statement on by default. In other words, the code
that comprises 3.0008_1 will become the stable tree. 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.
As the community, the best way to help the project move forward is to
turn on server side prepare statements in 3.0008, or try the
development driver, 3.0008_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
better verification process when a bug is reported there, and it's more
visible to me.
To this list in particular - those of you who would like to send patches
and be able to contribute, please feel free to contact me with your CPAN
info which I can give you SVN write access. It would be great to have
more developers contributing to DBD::mysql!
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 dbi-dev@perl.org , 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. Special thanks to:
Kyle George
Eric Milkie
Eric Chen
Ann Barcomb
Alessandro Ranellucci
Gavin Shelley
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.
The files:
file: $CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0008.tar.gz
size: 116159 bytes
md5: 82b1f898ec26c1a12cc87e00b30f313f
file: $CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0008_1.tar.gz
size: 115514 bytes
md5: 1175a095bc71ff736f05ec437832c8b8
Thank you for using MySQL and DBD::mysql!
Kind regards,
Patrick Galbraith
