オリジナル版：http://blog.gmane.org/gmane.comp.lang.perl.modules.dbi.sybase.devel?set_lines=100000
DBD::mysql Version 3.0008(stable, production) と3.0008_1 (dev)がリリースされました。
バージョン3.0008はデフォルトでサーバー側のプリペアドステートメントがオフになっている商品バージョンです。また3.0008_1は、デフォルトでサーバー側のプリペアドステートメントをオンになっている開発バージョンです。
このモジュールに対するこれらのバージョンは、CPAN (http://search.cpan.org/dist/DBD-mysql/) で見つかります。
ファイルは、
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
です。
以下は、3.0008における変更点および注意点です。
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.