Perlを中心とした技術系の話などをつらつら

2004年11月02日

DBD::mysql2.9005_3

DBD::mysqlがバージョンアップしたみたいです。変更点はこんな感じです。

  • DBI1.43が必要になった。
  • $dbh->last_insert_id()が使えるようになった。
  • mysql_unsafe_bind_type_guessingオプションをセットすると数字っぽいスカラー値を数字として扱い、クオートしない。(自己責任で使ってね。)
  • 最近のmysqlでカラムが壊れるのを修正した。
  • Makefile.PL実行時、5.008ではLANGがCに設定されてない場合、文句を言ってCに変えまて実行します。

うーむ、カラムが壊れるって何でしょうか。。

以下実際のChangelogです。

2004-10-27 Rudolf Lippan (2.9005_3)

  • Removed requirement that mysql.mtest be included in the distribution.
  • DBI 1.43 is required -- It is needed for support of $dbh->last_insert_id().
  • Added $dbh->{mysql_unsafe_bind_type_guessing} = 2 which will look at each bind_param and make guess based on whether it looks like a number, and if the parameter looks like a number, it will not be quoted. [thanks to dragonchild for cleaning up the initial rough draft impementation making it ready for prime time]
  • Applied patch to fix column which broke with later version of mysql [Tim Bunce]
  • Merged $dbh->last_inert_id() from the 3.0 dev tree
  • If you are using perl 5.008 without a $ENV{LANG} of "C". Makefile.PL will now 1. Complain loudly, and 2. set LANG to "C" and then exec itself with the new lang setting.
  • Added '$dbh->{mysql_unsafe_bind_type_guessing}'. When this flag is enabled any scalar that is passed to execute() and was used innumeric context will be treated as a number when being sent to the database backend. This can be a secuity problem in that if you use a string in numeric context, it will NOT be quoted before being passed to the database -- use at your own risk. The default is off.
  • fixed typo in pod changing failed_auto_reconnects_failed to auto_reconnects_failed [Paul DuBois ]

Technorati TAGTechnorati TAG ,

Posted by horiuchi at 2004年11月02日 09:49

Continuing the discussion...

このエントリーのトラックバックURL:
http://hori-uchi.com/mt/trackback/218

Comments

Post a comment




Remember personal info?