From: Date: October 18 2006 11:17pm
Subject: DBD::mysql 3.0008 and 3.0008 (Dev) released!
List-Archive: http://lists.mysql.com/announce/403
Message-Id: <453699FF.5050800@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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@stripped , 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