perl.dbi.announce

perl.dbi.announce http://www.nntp.perl.org/group/perl.dbi.announce/ ... Copyright 1998-2013 perl.org Sun, 19 May 2013 15:18:51 +0000 ask@perl.org ANNOUNCE DBI-1.627 by Tim Bunce file: $CPAN/authors/id/T/TI/TIMB/DBI-1.627.tar.gz size: 585833 bytes md5: aab49be51b0f4867a1894145b023d2c5 The primary DBI repository is now on github under the ownership of the "perl5-dbi" team: https://github.com/perl5-dbi/dbi https://github.com/perl5-dbi?tab=members =head2 Changes in DBI 1.627 - 16th May 2013 Fixed VERSION regression in DBI::SQL::Nano [Tim Bunce] =head2 Changes in DBI 1.626 - 15th May 2013 Fixed pod text/link was reversed in a few cases RT#85168 [H.Merijn Brand] Handle aliasing of STORE'd attributes in DBI::DBD::SqlEngine [Jens Rehsack] Updated repository URI to git [Jens Rehsack] Fixed skip() count arg in t/48dbi_dbd_sqlengine.t [Tim Bunce] =head2 Changes in DBI 1.625 (svn r15595) 28th March 2013 Fixed heap-use-after-free during global destruction RT#75614 thanks to Reini Urban. Fixed ignoring RootClass attribute during connect() by DBI::DBD::SqlEngine reported in RT#84260 by Michael Schout =head2 Changes in DBI 1.624 (svn r15576) 22nd March 2013 Fixed Gofer for hash randomization in perl 5.17.10+ RT#84146 Clarify docs for can() re RT#83207 =cut Enjoy! Tim. http://www.nntp.perl.org/group/perl.dbi.announce/2013/05/msg444.html Fri, 17 May 2013 11:42:03 +0000 Re: DBD::Oracle v1.61_00 on its way to CPAN by Michael Portnoy The trial version has been promoted to 1.62 (changelog below) and is now on CPAN. 1.62 2013-04-30 - promote 1.61_00 to official release Thanks to everyone who contributed to this release! Michael -- *Michael Portnoy * Software Developer Pythian love your data www.pythian.com office: +1 613 565 8696 x 381 mobile : +1 613 325 3788 On Mon, Apr 15, 2013 at 3:41 PM, Yanick Champoux <champoux@pythian.com>wrote: > > This one is a minor release (changelog's below). As usual, if no issue > is found with this trial version, it's going to be promoted to 1.62 and > stable in two weeks' time. > > 1.61_00 2013-04-15 > > [BUG FIXES] > - Adjust the privs needed for the DROP/CREATE table test. [GH#35] > (Joe Crotty) > > - Fixed RT84170 - when using scrollable cursors and you've done a > positioned fetch and then keep fetching until the end of the > result-set calls to fetch never return undef and you keep getting > the last row forever. Also added test case to the 51scroll.t test > (Martin J. Evans). > > > Enjoy, > `/anick > > -- > Yanick Champoux > Senior Perl Developer > Pythian - Love your data > > champoux@pythian.com > > Tel: +1 613 565 8696 x 274 > www.pythian.com > > > -- > > > -- > > > > -- -- http://www.nntp.perl.org/group/perl.dbi.announce/2013/04/msg443.html Tue, 30 Apr 2013 20:07:55 +0000 DBD::mysql 4.023 released by Patrick Galbraith Hi all, I'm pleased to announce the release of DBD::mysql 4.023. Many pull requests this time around that I am most grateful for! Per ChangeLog: * Fix primary_key_info result ordering - https://github.com/CaptTofu/DBD-mysql/pull/39 - Dagfinn Ilmari Mannsåker * allow compilation with msvc - https://github.com/CaptTofu/DBD-mysql/pull/37 - Walde Christian * just to set MYSQL_OPT_WRITE_TIMEOUT and MYSQL_OPT_READ_TIMEOUT by dsn - https://github.com/CaptTofu/DBD-mysql/pull/36 - Naosuke Yokoe * just remove unnecessary "my" - https://github.com/CaptTofu/DBD-mysql/pull/34 - Shoichi Kaji * eval $ExtUtils::MakeMaker::VERSION requires for old ExtUtils::MakeMaker - https://github.com/CaptTofu/DBD-mysql/pull/32 - Daisuke Murase * Updated documentation to reflect that bugs will be reported at rt.cpan.org * Updated version * Chased tail finding issue with -1 being converted to max unsigned int in PS mode The code: https://github.com/CaptTofu/DBD-mysql The project: http://search.cpan.org/~capttofu/DBD-mysql-4.023/ Again, many uber-mega-gig thanks to those who submitted pull requests and to those who use DBD::mysql! Also, I want to thank Sveta Smirnova of Oracle for the painstaking work she did in manually copying bugs from Oracle's bug system to http://rt.cpan.org. Please do note that this is where all DBD::mysql bugs need to be filed. Thank you! Patrick http://www.nntp.perl.org/group/perl.dbi.announce/2013/04/msg442.html Fri, 19 Apr 2013 20:44:29 +0000 DBD::Oracle v1.61_00 on its way to CPAN by Yanick Champoux This one is a minor release (changelog's below). As usual, if no issue is found with this trial version, it's going to be promoted to 1.62 and stable in two weeks' time. 1.61_00 2013-04-15 [BUG FIXES] - Adjust the privs needed for the DROP/CREATE table test. [GH#35] (Joe Crotty) - Fixed RT84170 - when using scrollable cursors and you've done a positioned fetch and then keep fetching until the end of the result-set calls to fetch never return undef and you keep getting the last row forever. Also added test case to the 51scroll.t test (Martin J. Evans). Enjoy, `/anick -- Yanick Champoux Senior Perl Developer Pythian - Love your data champoux@pythian.com Tel: +1 613 565 8696 x 274 www.pythian.com -- -- http://www.nntp.perl.org/group/perl.dbi.announce/2013/04/msg441.html Mon, 15 Apr 2013 21:33:42 +0000 dev release DBD::Oracle 1.57_00 is on its way to CPAN by Yanick Champoux DBD::Oracle version 1.57_00 is on its way to CPAN. This release is small, but should make some Win32 users happy. The changelog is pasted below. As usual, the dev release will be promoted to general use in two weeks, assuming no problem is found. Enjoy, `/anick 1.57_00 2013-02-07 [BUG FIXES] - fix RT46628 - bind_param_inout ORA_RSET causes MSWin32 access violation and RT82663 - Errors if a returned SYS_REFCURSOR is not opened (Martin J. Evans) If a procedure/function returns a SYS_REFCURSOR which was never opened DBD::Oracle magics a DBI statement handle into existence and attempts to describe it (which fails). This change examines a returned SYS_REFCURSOR and if it it is initialised but not executed does not create a DBI statement handle and returns undef instead. So now if you have a procedure/function which returns a SYS_REFCURSOR and never open it you'll get undef back instead of a useless statement handle. Extended 50cursor.t test to check the above fix. [DOCUMENTATION] - Update Lion instructions for 64-bit Instant Client. (GH#37, patch by theory) -- -- http://www.nntp.perl.org/group/perl.dbi.announce/2013/02/msg440.html Fri, 08 Feb 2013 09:23:24 +0000 ANNOUNCE: IBM Informix Database Driver for Perl DBI Version 2013.0118(2013-01-18) released by Jonathan Leffler IBM Informix Database Driver for Perl DBI Version 2013.0118 (2013-01-18) has been uploaded to CPAN. IBM Informix Database Driver for Perl (also known as DBD::Informix) is the driver code that enables Perl 5.6.1 or later to access Informix databases via the DBI module (but if you are not already using Perl 5.10.0 - or any later version - you should be planning to upgrade to Perl 5.16.2 or later). You will need the code for DBI version 1.38 or later as well (v1.623 - or any later version - is recommended). The code for DBD::Informix is available for download via: http://www.perl.org/CPAN/modules/by-category/07_Database_Interfaces http://dbi.perl.org/ ** When you successfully build this module, use the ItWorks (Perl) ** script to report your configuration to the maintenance team (meaning ** Jonathan Leffler) at dbd.informix@gmail.com. ** The ItWorks script does not send email to anybody; you have to do ** that yourself. New in release 2013.0118: * Bug fix release. * Workaround for bug in ESQL/C 3.70 and earlier that generates error -1820 when reopening a cursor that previously fetched LVARCHAR data. * Fix for INFORMIXDIR containing Perl regex metacharacters. * Other minor improvements as documented in the ChangeLog. * Formal support for ESQL/C 7.x and 8.x (don't ask why the current version numbers are smaller) will be dropped after this release. The code won't go away yet, but it is beyond time to get off those versions. ESQL/C 5.20 is nominally supported for those still using Informix OnLine 5.20, but there is no testing on that platform. New in release 2011.0612: * Minor bug fix release. * Main change is related to Perl internals and avoids the need for PERL_POLLUTE. This change is not visible to users except that Perl 5.14.x can use the fixed code. * Fixed problem with string that is not null terminated by ESQL/C library. * Clean up some 64-bit compilation warnings. * Build on AIX. * Evade problem with a DISTINCT type of LVARCHAR with NOT NULL (probably ESQL/C bug). * Fewer versions of Informix products are supported. You may try building DBD::Informix with other versions. If it works, great; if not, please upgrade to a supported Informix version. Support email address: * This release is supported by Jonathan Leffler <dbd.informix@gmail.com>. * You may also report your bugs via the CPAN resolution tracking system: http://rt.cpan.org/ * Such bug reports can be sent by email to bug-DBD-Informix@rt.cpan.org; they also get sent to dbd.informix@gmail.com, etc. As always, see the ChangeLog file for details about what has changed. Jonathan Leffler (jleffler@us.ibm.com, jonathan.leffler@gmail.com) @(#)$Id: Announce,v 2013.2 2013/01/18 19:55:18 jleffler Exp $ -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." http://www.nntp.perl.org/group/perl.dbi.announce/2013/01/msg439.html Sun, 20 Jan 2013 16:12:48 +0000 DBD::Oracle v1.54 on its way to CPAN by Yanick Champoux Hi all, DBD::Oracle v1.54 is on its way to CPAN. In this iteration, no new feature, but a large amount of bug fixes. (see full changelog below) As usual, a big thank to the peeps who actually reported the bugs and did the work: Pierre-Alain Blanc, Alexandr Ciornii, Joe Crotty, Rob Davies, Dave Mitchell, and John Scoles, with a special shout-out to Steffen Goeldner and Martin J. Evans, who are indisputably patching kings. Joy, `/anick 1.54 2013-01-03 [BUG FIXES] - Fix RT69350 - 31lob.t was using $lob after destroying its parent $sth (Rob Davies) - Fix memory leak in execute_array (John Scoles, Pierre-Alain Blanc) - Fix RT80349 - The error message in execute_for_fetch when a row fails can contain the wrong error count. Thanks to Steffen Goeldner for RT and patch. - Fix RT80375 - no exception when execute_for_fetch fails and ArrayTupleStatus is not specified. Also the tuple count calculation resulted in an undefined warning. Thanks to Steffen Goeldner for RT and patch. - Fix RT80487. Skip XMLType tests if Oracle less than V9. Thanks to Steffen Goeldner for RT and patch. - Fix RT80486 for 31lob_extended.t. In old old Oracle8, SYS_REFCURSOR is not defined. Instead of CREATE/DROP PROCEDURE, use anonymous block. Thanks to Steffen Goeldner for RT and patch. - Fix bug in 39attr.t which could fail if using an Oracle Client > 11 but not >= 11.2 (Martin J. Evans) - ora_server_version was not documented. - Fix RT80566. 70meta.t test fails with Oracle 8 because ALL_TAB_COLUMNS.CHAR_LENGTH is new in Oracle 9. Use DATA_LENGTH instead on pre-9 versions. Thanks to Steffen Goeldner for RT and patch. - Fix RT80704. 51scroll.t test checks scrollable cursors but assumes all Oracles support them (only 9 and above). Thanks to Steffen Goeldner for RT and patch. - Fix RT81067. 58object.t has some subtype tests and subtypes were introduced in Oracle 9. Skip if < Oracle 9. Thanks to Steffen Goeldner for RT and patch. - Fix RT81317. 34pres_lobs.t uses the Data Interface for Persistent LOBs which is new in Oracle 9. Skip if < Oracle 9. Thanks to Steffen Goeldner for RT and patch. [MISCELLANEOUS] - The original 26exe_array test was replaced some time ago with a copy of the one from DBD::ODBC. Since then I've fixed issues in the DBD::ODBC one and added more tests (like tests for some RTs above). To make keeping them in synch easier I've modularised the tests. Hence new ExecuteArray.pm. (Martin J. Evans) - simple code clean up, replacing 3 uses of safemalloc with Newz (John Scoles) - Add DBI as a configure prereq for the META* files (thanks to Joe Crotty) - New FAQ entry on Solaris and setting linker library path (Martin J. Evans) - Removed ineffective commit in 34pres_lobs.t (Martin J. Evans) - Remove dead README link in Win32 documentation. (pointed out by Alexandr Ciornii, RT#82040) - Changed any use of if SvUPGRADE to remove the if test as per email from Dave Mitchell and posting at http://www.xray.mpe.mpg.de/mailing-lists/perl5-porters/2012-12/msg00424.html (Martin J. Evans) -- Yanick Champoux, Senior Perl Developer The Pythian Group - love your data http://www.pythian.com -- -- http://www.nntp.perl.org/group/perl.dbi.announce/2013/01/msg438.html Thu, 03 Jan 2013 20:29:49 +0000 Announce: DBI 1.623 by Tim Bunce file: $CPAN/authors/id/T/TI/TIMB/DBI-1.623.tar.gz size: 596517 bytes md5: b45654dca3b495f3d496c359f0029d96 =head2 Changes in DBI 1.623 (svn r15547) 2nd Jan 2012 Fixed RT#64330 - ping wipes out errstr (Martin J. Evans). Fixed RT#75868 - DBD::Proxy shouldn't call connected() on the server. Fixed RT#80474 - segfault in DESTROY with threads. Fixed RT#81516 - Test failures due to hash randomisation in perl 5.17.6 thanks to Jens Rehsack and H.Merijn Brand and feedback on IRC Fixed RT#81724 - Handle copy-on-write scalars (sprout) Fixed unused variable / self-assignment compiler warnings. Fixed default table_info in DBI::DBD::SqlEngine which passed NAMES attribute instead of NAME to DBD::Sponge RT72343 (Martin J. Evans) Corrected a spelling error thanks to Chris Sanders. Corrected typo in DBI->installed_versions docs RT#78825 thanks to Jan Dubois. Refactored table meta information management from DBD::File into DBI::DBD::SqlEngine (H.Merijn Brand, Jens Rehsack) Pevent undefined f_dir being used in opendir (H.Merijn Brand) Added logic to force destruction of children before parents during global destruction. See RT#75614. Added DBD::File Plugin-Support for table names and data sources (Jens Rehsack, #dbi Team) Added new tests to 08keeperr for RT#64330 thanks to Kenichi Ishigaki. Added extra internal handle type check, RT#79952 thanks to Reini Urban. Added cubrid_ registered prefix for DBD::cubrid, RT#78453 Removed internal _not_impl method (Martin J. Evans). NOTE: The "old-style" DBD::DBM attributes 'dbm_ext' and 'dbm_lockfile' have been deprecated for several years and their use will now generate a warning. =cut Enjoy! Many thanks to all those who have contributed to the DBI and drivers this year, especially Jens Rehsack, H.Merijn Brand and Martin J. Evans. Happy New Year. Tim. http://www.nntp.perl.org/group/perl.dbi.announce/2013/01/msg437.html Wed, 02 Jan 2013 15:57:38 +0000 SQL::Statement 1.402 uploaded by Jens Rehsack Hi, SQL::Statement 1.402 has been uploaded to PAUSE and should be updated where ever possible. Version 1.402, released December 19, 2012 ------------------------------------------------- [Misc] * add Math::Complex 1.56 as recommendation (RT#81926, Sam Ferencik) * add Math::BigInt 1.88 as recommendation (RT#81927, Sam Ferencik) * clarify Test::Simple 1.90 is required for building (RT#81925, Sam Ferencik) [Bug fixes] * fix leaking reference to open tables outside SQL::Statement::execute (fixes RT#81523) * looks_like_number identifies 'nan' as number sometimes (add regex to t/06virtual.t) The bug described in RT#81523 might result in invalid (outdated) data return from SQL::Statement. Upgrading is strongly recommended. Cheers -- Jens Rehsack http://www.nntp.perl.org/group/perl.dbi.announce/2012/12/msg436.html Sat, 22 Dec 2012 08:54:07 +0000 DBIx-Table-TestDataGenerator-0.001 released by José Diaz Seng Hi, yesterday I have released the initial version of DBIx::Table::TestDataGenerator, see http://search.cpan.org/~jds/DBIx-Table-TestDataGenerator-0.001/ Its goal is to support testing database clients by adding test data to tables. The main features are the automatic handling of table constraints and dealing with parent child relations in tables. Currently Oracle, PostgreSQL and SQLite are supported,Â additional DBMSs are in the works. It has already been a real pleasure discussing things with the Perl community, I want to say a big thank you to all people involved, for detailed acknowledgements (and everything else) please see the README file. Hopefully the module will be useful to you. I am eagerly awaiting your comments, critique and feature requests! To all affected by the hurricane reaching the East Coast right now I hope itÂ  will not be half as bad as feared, good luck! Best regards JosÃ© Â  Â  http://www.nntp.perl.org/group/perl.dbi.announce/2012/10/msg435.html Mon, 29 Oct 2012 15:34:34 +0000 New 1.41 release of DBD::ODBC by Martin J. Evans I have just uploaded DBD::ODBC 1.41 to the CPAN. This is the full release of the 1.40 development series and the changes can be found below. I draw your attention to a number of changes in behaviour. Thank you to all contributors. =head2 Changes in DBD::ODBC 1.41 October 23 2012 A full release of the 1.40 development release series. =head2 Changes in DBD::ODBC 1.40_3 October 8 2012 [BUG FIXES] Oops, changes to some rt tests fail when not run to MS SQL Server and they should not be run for other drivers - there was a double done_testing call. [CHANGE IN BEHAVIOUR] As I warned literally years ago DBD::ODBC's private function DescribeCol has been removed. You can use DBI's statement attributes like NAME, PRECISION etc, instead. All test code has been changed to remove calls to DescribeCol and GetTypeInfo. [MISCELLANEOUS] New example sqlserver_supplementary_chrs.pl added which shows that in MS SQL Server 2012 you can now store unicode characters over 0xFFFF (ones which are surrogate pairs). More documentation for odbc_out_connect_string. =head2 Changes in DBD::ODBC 1.40_2 September 6 2012 [BUG FIXES] Fixed rt 78838 - bind_param does not correctly stringify blessed objects when connected to MS SQL Server Fix issue in dbd_bind_ph where if you passed a sql type and were also attempting to change from in to out or vice versa or increasing the size of an output bound param it would not spot this error. Allowed the test cases to spot DB2 driver as libXXXdb2. [MISCELLANEOUS] New test cases added for some rts. Added Test::NoWarnings to some tests where it was missing. =head2 Changes in DBD::ODBC 1.40_1 September 4 2012 [BUG FIXES] Debian/Ubuntu have moved unixODBC into /usr/lib/i386-linux-gnu so look in this dir for unixODBC as well - thanks to Meastro for finding. Fixed rt 78838 I had a sequence point error which is only seen with some compilers as it is sometimes optimized=head2 Changes in DBD::ODBC 1.41 October 23 2012 A full release of the 1.40 development release series. =head2 Changes in DBD::ODBC 1.40_3 October 8 2012 [BUG FIXES] Oops, changes to some rt tests fail when not run to MS SQL Server and they should not be run for other drivers - there was a double done_testing call. [CHANGE IN BEHAVIOUR] As I warned literally years ago DBD::ODBC's private function DescribeCol has been removed. You can use DBI's statement attributes like NAME, PRECISION etc, instead. All test code has been changed to remove calls to DescribeCol and GetTypeInfo. [MISCELLANEOUS] New example sqlserver_supplementary_chrs.pl added which shows that in MS SQL Server 2012 you can now store unicode characters over 0xFFFF (ones which are surrogate pairs). More documentation for odbc_out_connect_string. =head2 Changes in DBD::ODBC 1.40_2 September 6 2012 [BUG FIXES] Fixed rt 78838 - bind_param does not correctly stringify blessed objects when connected to MS SQL Server Fix issue in dbd_bind_ph where if you passed a sql type and were also attempting to change from in to out or vice versa or increasing the size of an output bound param it would not spot this error. Allowed the test cases to spot DB2 driver as libXXXdb2. [MISCELLANEOUS] New test cases added for some rts. Added Test::NoWarnings to some tests where it was missing. =head2 Changes in DBD::ODBC 1.40_1 September 4 2012 [BUG FIXES] Debian/Ubuntu have moved unixODBC into /usr/lib/i386-linux-gnu so look in this dir for unixODBC as well - thanks to Meastro for finding. Fixed rt 78838 I had a sequence point error which is only seen with some compilers as it is sometimes optimized out. It could cause DBD::ODBC to omit adding the UID/PWD to the end of the connection string when using DSN=. Thanks to Zsolt Cserna for spotting it and to ilmari and Leon for explaining it to me. Fixed rt 79397 Output bound parameters may be incorrectly bound if changed after bind_param_inout is called. If you start with an undef bound param and change it to a defined string/number less than 28 characters before calling execute the original undef will probably be bound. Thanks to runrig on perl monks for providing an example. [CHANGE IN BEHAVIOUR] If you attempt to bind an rv without amagic DBD::ODBC will now croak - related to rt 78838. out. It could cause DBD::ODBC to omit adding the UID/PWD to the end of the connection string when using DSN=. Thanks to Zsolt Cserna for spotting it and to ilmari and Leon for explaining it to me. Fixed rt 79397 Output bound parameters may be incorrectly bound if changed after bind_param_inout is called. If you start with an undef bound param and change it to a defined string/number less than 28 characters before calling execute the original undef will probably be bound. Thanks to runrig on perl monks for providing an example. [CHANGE IN BEHAVIOUR] If you attempt to bind an rv without amagic DBD::ODBC will now croak - related to rt 78838. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com http://www.nntp.perl.org/group/perl.dbi.announce/2012/10/msg434.html Tue, 23 Oct 2012 13:07:52 +0000 DBD::Oracle v1.52 is on CPAN by Yanick Champoux The announcement was sent to the other mailing lists, but I shamefully forgot this one. Thanks to Tim Bounce++ for the reminding poke. So, yes, a new version of DBD::Oracle is out.I'm pasting the changelog below for convenience, but this release is basically Martin Evans heroically making TAF work, with some additional awesomeness sprinkled by Merijn, Douglas and David. Enjoy! `/anick 1.52 [BUG FIXES] - fix serious memory corruption in TAF support (Martin J. Evans) - fix finding client in situation where client and server both installed but different architectures (patch by H.Merijn Brand) - fix memory leak in TAF handling - the TAF function was leaked (Martin J. Evans) - fix issue with taf_function being set to a scalar which goes out of scope before the callback is made (Martin J. Evans) - fix RT46739 if a connection breaks the environment handle is not thrown away (Martin J. Evans) - ora_driver_name was not defaulted to the correct DBD::Oracle version (Martin J. Evans) - ora_driver_name, ora_client_info, ora_client_identifier, ora_action and ora_oci_success_warn were set twice (if specified) on connect as they were not deleted from the connect attributes once handled. Code now leaves the setting to the later STORE DBI calls (Martin J. Evans) - fixed some compiler warnings for %lf (Martin J. Evans) - fixed RT78700 - column_info reports wrong size for char semantic char type columns (Douglas Wilson). [CHANGE IN BEHAVIOUR] - ora_taf and ora_taf_sleep were redundant and have been removed. To enable/disable TAF simply set ora_taf_function and if you want to sleep do it in your callback (Martin J. Evans) - ora_taf_function can now be a code reference as well as a string (Martin J. Evans) [ENHANCEMENTS] - the ora_can_taf method was virtually useless since you can only call it after connecting and to enable TAF you had to do it in the connect call. Now you can enable and disable TAF at any time by simply setting or clearing the ora_taf_function (see RT78811) (Martin J. Evans) - the ora_taf_function is now passed a third argument of the connection handle (Martin J. Evans) - RT78987 - removed Oraperl.pm and oraperl.ph; these files will be available in a separate distribution named "Oraperl" (David Perry) [MISCELLANEOUS] - hide dr, db and st packages from PAUSE (Martin J. Evans) - added a few more simple TAF tests (Martin J. Evans) -- -- http://www.nntp.perl.org/group/perl.dbi.announce/2012/10/msg433.html Tue, 23 Oct 2012 04:17:34 +0000 DBD::mysql 4.022 released by Patrick Galbraith Greetings, I am pleased to announce the release of DBD::mysql 4.022. This release contains several fixes from the community, as outlined in the change log: * Fixes for Win32 from Rom Hoelz (https://github.com/hoelzro) * Pulling back in work for 4.021 that didn't get pushed and much other work from Chip Salzenberg (https://github.com/chipdude) * Column info order fix from Tokuhiro Matsuno (https://github.com/tokuhirom) * Fix AutoCommit comparison logic to avoid spurious commands to mysql from Matthew Horsfall (https://github.com/wolfsage) * server_preapre can't bind placeholder on comment. from Misahiro Chiba (https://github.com/nihen) * server_prepare; data is null, allocate big memory bug. from Misahiro Chiba (https://github.com/nihen) Also thank you to Kris Davey for point out to me this link for installing DBD::mysql on OS X: https://discussions.apple.com/thread/3932531?start=0&tstart=0&fb_source=message I have updated the README file to point people in this direction. Thank you to everyone for using this and especially those who submitted pull requests on github! The CPAN link is: http://search.cpan.org/~capttofu/DBD-mysql-4.021/lib/DBD/mysql.pm And Github, for latest code and pull requests: https://github.com/CaptTofu/DBD-mysql Regards, Patrick http://www.nntp.perl.org/group/perl.dbi.announce/2012/08/msg432.html Fri, 31 Aug 2012 05:53:23 +0000 New 1.39 release of DBD::ODBC by Martin J. Evans I've just sent to the CPAN the 1.39 release of DBD::ODBC. This contains some bug fixes, one major enhancement to support TAF and one change in behaviour you should note. =head2 Changes in DBD::ODBC 1.39 July 7 2012 [BUG FIXES] Manifest mentioned 2 files in examples which do not exist - they should have been execute_for_fetch.pl. execute_for_fetch.pl example had not be changed since odbc_disable_array_operations became odbc_array_operations. =head2 Changes in DBD::ODBC 1.38_3 June 25 2012 [BUG FIXES] Added encoding line to this file to stop pod test from complaining. [DOCUMENTATION] Added link to 64 bit ODBC article. Fixed some typos in the pod. [MISCELLANEOUS] Made pod.t an author test. =head2 Changes in DBD::ODBC 1.38_2 May 24 2012 [ENHANCEMENTS] Added support for Oracle TAF (assuming your ODBC driver supports it) - see odbc_taf_callback. =head2 Changes in DBD::ODBC 1.38_1 May 19 2012 [BUG FIXES] Fixed rt 77283. If you overrode the bind type as SQL_INTEGER in a bind_col call AFTER previously binding as another type (or not specifying a type) you would not get the right value back. This also fixes the DiscardString bind_col attribute for SQL_INTEGER binds (however, see below as DiscardString is no longer required for SQL_INTEGER). Fixed some format specifiers in trace calls. [CHANGE IN BEHAVIOUR] DBD::ODBC allowed you to change the bound column type in bind_col after the column was already bound. It now does not allow this and issues a warning. You can nolonger override the bound column type (except with SQL_NUMERIC and SQL_DOUBLE). All columns are now bound as either SQL_C_LONG (integer columns) or SQL_C_[W]CHAR (all other columns). If you are calling bind_col with a TYPE => xxx it most likely did not do what you expected and you should examine it carefully with a view to removing it altogether. As a result you no longer have to override the bind type for MS SQL Server XML columns - these will be bound as SQL_C_CHAR or SQL_C_WCHAR depending on whether Unicode is enabled. Integer columns are now bound as SQL_C_LONGs and not as before, SQL_C_CHAR. This should not matter to you but if you were adding 0 to your integer columns retrieved to make them behave like integers you should nolonger need to do it. [OTHER] Added some missing SQL_C_xxx types to S_SqlCTypeToString internal function. This only affects tracing. Some tests in 08bind were skipped when they did not need to be. sql_type_cast tests rewritten due to fixes above. Martin http://www.nntp.perl.org/group/perl.dbi.announce/2012/07/msg431.html Sat, 07 Jul 2012 10:45:28 +0000 ANNOUNCE: DBI 1.622 by Tim Bunce file: $CPAN/authors/id/T/TI/TIMB/DBI-1.622.tar.gz size: 585651 bytes md5: 9836bcf1b9acc842089aa10b16736909 =head2 Changes in DBI 1.622 (svn r15327) 6th June 2012 Fixed lack of =encoding in non-ASCII pod docs. RT#77588 Corrected typo in DBI::ProfileDumper thanks to Finn Hakansson. =cut Enjoy! Tim. http://www.nntp.perl.org/group/perl.dbi.announce/2012/06/msg430.html Thu, 07 Jun 2012 05:50:39 +0000 ANNOUNCE: DBI 1.621 by Tim Bunce file: $CPAN/authors/id/T/TI/TIMB/DBI-1.621.tar.gz size: 585080 bytes md5: f44d84f8bdbabc14839eae0bd37e5509 =head2 Changes in DBI 1.621 (svn r15315) 21st May 2012 Fixed segmentation fault when a thread is created from within another thread RT#77137, thanks to Dave Mitchell. Updated previous Changes to credit Booking.com for sponsoring Dave Mitchell's recent DBI optimization work. =cut Enjoy! Tim. http://www.nntp.perl.org/group/perl.dbi.announce/2012/05/msg429.html Wed, 23 May 2012 08:09:58 +0000 DBD::mysql 4.021 released by Patrick Galbraith Hi all, I am pleased to announce the release of DBD::mysql 4.021! This release includes the following fixes per change log: 2011-08-15 Patrick Galbraith (work of others) <patg at patg dot net> (4.021) * Fix to enable PERL_NO_GET_CONTEXT to speed up DBD performance on thread Perls (Dave Mitchell <davem at iabyn dot com>) Thank you! * Fix to is_prefix not being exported by mysql Aran Deltax <bluefeet at gmail dot com> Thank you! * Eliminate DBIS usage Dagfinn Ilmari Mannsåker <ilmari at ilmari dot org> Thank you! * Enhanced / Fixed server side prepared statement checks (Steven Hartland) Thank you! * Fix missprint in doc of DBD::mysql of mysql_bind_type_guessing (Perlover http://blog.perloever.com) Thank you! * Misprint in lib/DBD/mysql.pm (Perlover) Thank you! Thank you for all the great contributions to DBD::mysql, greatly appreciated! http://search.cpan.org/~capttofu/DBD-mysql-4.021/lib/DBD/mysql.pm And https://github.com/CaptTofu/DBD-mysql Regards, Patrick http://www.nntp.perl.org/group/perl.dbi.announce/2012/04/msg428.html Mon, 30 Apr 2012 11:59:05 +0000 ANNOUNCE DBI 1.620 by Tim Bunce file: $CPAN/authors/id/T/TI/TIMB/DBI-1.620.tar.gz size: 584922 bytes md5: 2dfcff5b3b7afc53be402ef5f133da00 =head2 Changes in DBI 1.620 (svn r15300) 25th April 2012 Modified column renaming in fetchall_arrayref, added in 1.619, to work on column index numbers not names (an incompatible change). Reworked the fetchall_arrayref documentation. Hash slices in fetchall_arrayref now detect invalid column names. =head2 Changes in DBI 1.619 (svn r15294) 23rd April 2012 Fixed the connected method to stop showing the password in trace file (Martin J. Evans). Fixed _install_method to set CvFILE correctly thanks to sprout RT#76296 Fixed SqlEngine "list_tables" thanks to David McMath and Norbert Gruener. RT#67223 RT#69260 Optimized DBI method dispatch thanks to Dave Mitchell. Optimized driver access to DBI internal state thanks to Dave Mitchell. Optimized driver access to handle data thanks to Dave Mitchell. Optimized fetchall_arrayref with hash slice thanks to Dagfinn Ilmari Mannsåker. RT#76520 Allow renaming columns in fetchall_arrayref hash slices thanks to Dagfinn Ilmari Mannsåker. RT#76572 Reserved snmp_ and tree_ for DBD::SNMP and DBD::TreeData =cut Many thanks to the contributors, especially Dave Mitchell (via Booking.com) and Ilmari. Dave's work has yielded a significant reduction in some of the DBI overheads. For users of perls configured with thread support it is recommended, but not required, that you recompile your drivers after installing this release in order to get full benefit. Ilmari's changes implement ideas that came from discussions I'd had with Peter Rabbitson on IRC about fetch performance in DBIx::Class. Hopefully a future release of DBIx::Class will make full use of these changes. Enjoy! Tim. http://www.nntp.perl.org/group/perl.dbi.announce/2012/04/msg427.html Wed, 25 Apr 2012 07:09:29 +0000 ANNOUNCE: IBM DB2 Database Driver for Perl DBI Version 1.84 released by Open Source Application Development IBM DB2 Database Driver for Perl DBI Version 1.84 has been uploaded on CPAN. Testers are please welcome to test the new features and report the bugs. DBI is an open standard application programming interface (API) that provides database access for client applications written in Perl. DBI defines a set of functions, variables, and conventions that provide a platform-independent database interface. The DBD::DB2 driver works with DBI and a DB2 client to access databases. **New In Release -Implemented usage of SQLDataSources ODBC API in dbd_data_sources to remove dependency of instance based DB2 client. Download Link http://search.cpan.org/CPAN/authors/id/I/IB/IBMTORDB2/DBD-DB2-1.84.tar.gz Installation Instructions http://www-306.ibm.com/software/data/db2/perl/ Support Email Addresses * This release is supported by Open Source Application Development Team * You may also report your bugs via the CPAN resolution tracking system: http://rt.cpan.org/ by searching for module DBD-DB2 * Such bug reports can be sent by email to bug-DBD-DB2@rt.cpan.org; they also get sent to opendev@us.ibm.com, etc. Download DB2 Express-C for free, go to: http://www-01.ibm.com/software/data/db2/express/download.html?S_CMP=ECDDWW01&S_TACT=ACDB201 Getting started with DB2 Express-C: http://www.ibm.com/developerworks/wikis/display/DB2/FREE+Book-+Getting+Started+with+DB2+Express-C Thanks, IBM OpenSource Application Development Team India Software Labs, Bangalore (India) http://www.nntp.perl.org/group/perl.dbi.announce/2012/03/msg426.html Wed, 28 Mar 2012 05:34:42 +0000 DBD::Pg version 2.19.1 released by Greg Sabino Mullane -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 Version 2.19.1 of DBD::Pg, the Perl interface to PostgreSQL, has just been released. This (and 2.19.0) fixes some serious bugs, so upgrading is recommended for all users. You can find it at your local CPAN mirror, or at: http://search.cpan.org/~turnstep/DBD-Pg-2.19.1/ Checksums, MD5 and SHA1: 3a86ac826f5285003b87c6a8b225e0c4 DBD-Pg-2.19.1.tar.gz 0d0bd7daf2c24758716fbbde686e4d66cf81a206 DBD-Pg-2.19.1.tar.gz Complete list of changes for 2.19.0 and 2.19.1: - Fix crash when passing in an array with undefined elements. [GSM] - Use proper formatting for warn() and croak() (CPAN bug #75642) [Niko Tyni] - Fix localized regex in test (CPAN bug #70759) - Fix for named placeholders (CPAN bug #70953) [Jan Pazdziora] - Various fixes to the array-marshalling code [Noah Misch, Mark Stosberg, and David Christensen] (CPAN bug #58552) - Allow hi-bit chars in dollar-quoted identifiers [David Christensen] (CPAN bug #73832) - Have do() return count for things such as CREATE TABLE .. AS SELECT Will only work on 9.0 or better. (CPAN bug #71073) [Pavel Stehule] - Better error message when trying to do things post-disconnect [GSM] - Always respect pg_server_prepare=0 by using PQexec not PQexecParams. [GSM] - Fix error in async docs (CPAN bug #72812) - Switch from subversion to git. git clone git://bucardo.org/dbdpg.git [GSM] - -- Greg Sabino Mullane greg@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201203111859 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAk9dLl4ACgkQvJuQZxSWSsiqtACfUBGbghDPyorMezq6iNADtI+L Z68AoOnW3LshJjLCb5N8xlFU8k6NNpVO =0LA5 -----END PGP SIGNATURE----- http://www.nntp.perl.org/group/perl.dbi.announce/2012/03/msg425.html Mon, 12 Mar 2012 02:45:48 +0000 DBD::ODBC 1.35 released by Martin J. Evans I've just uploaded DBD::ODBC 1.35 to CPAN. This is the culmination of 7 development releases in the 1.34 chain and is a significant release containing a lot of changes and enhancements. As always I would like to thank everyone who has helped and especially CPAN testers. The full list of changes since the last official release is below. I particularly want to draw your attention to a native execute_for_fetch method (which is much faster than the default DBI method) and the new odbc_getdiagrec and odbc_getdiagfield methods. However, be aware that some ODBC drivers (e.g., SQLite and there are probably others) cannot do execute_for_fetch successfully. I've contacted driver writers where I've found this but as yet I've not got any resolution. If you are using a Windows ODBC driver or some proprietary UNIX ODBC drivers (like the Easysoft ones - disclaimer, I work for Easysoft) you are likely to have a lot more success with the native execute_for_fetch as Windows applications seem to have been doing this for longer so have ironed out the issues. Also note there are some changes in behaviour in this release. =head2 Changes in DBD::ODBC 1.35 March 6 2012 Full release of the 1.34 development releases =head2 Changes in DBD::ODBC 1.34_7 March 2 2012 [BUG FIXES] * Fixed more compiler errors highlighed by a smoker using MS Visual C where some code come before a variable definition. =head2 Changes in DBD::ODBC 1.34_6 February 27 2012 [BUG FIXES] * Fixed some compiler warnings and a compile error highlighed by a smoker using MS Visual C where some code come before a variable definition. =head2 Changes in DBD::ODBC 1.34_5 February 17 2012 [BUG FIXES] * The 40UnicodeRoundTrip tests counts could be 1 off in some cases. * Fix for t/03batt.t which could fail a test if the data source had no table - Kenichi Ishigaki * If a driver misbehaves during global destruction e.g. SQLFreeStmt fails but no error is available DBD::ODBC issues an error saying an error occurred but no error diagnostics could be found. This is pointless and irritating during global destruction. This stems from a change in 1.28. Thanks to Peter Rabbitson for reporting and suggested fix. [CHANGE IN BEHAVIOUR] * Prior to this release if you called selectall_* methods with a non-select statement DBD::ODBC would raise an error saying "no select statement currently executing". See RT 68720. After discussions on dbi-dev the concensus seems to be that issuing a warning in this case is better so that is what I've done. As a result t/rt_68720.t has been removed and t/85_selectall_non_select.t has been added. [DOCUMENTATION] * odbc_getdiagfield was incorrectly named odbc_getdiagrec in the pod * add DBI version required for StrictlyTyped and DiscardString to pod * Added new FAQ on why a transaction may be committed when AutoCommit is turned off. [OTHER] * Make examples\odbc_diag.pl more tolerant of drivers which do not handle diagnostic calls properly. * Make t/40UnicodeRoundTrip.t work with SQLite - Kenichi Ishigaki * Make t/odbc_describe_parameter.t work with SQLite - Kenichi Ishigaki * Add 80_odbc_diags.t based on the same file in examples =head2 Changes in DBD::ODBC 1.34_4 February 5 2012 [BUG FIXES] * When odbc_getdiag* methods were added they installed themselves into DBI but did not set IMP_KEEP_ERR so calling them cleared DBI's errors. =head2 Changes in DBD::ODBC 1.34_3 February 3 2012 [BUG FIXES] * Linking against unixODBC was working by accident on most UNIX machines and depended on the order of the files in /usr/lib (or wherever) and what files there were (e.g. an archive or a shared object). Same applied to iODBC but it was more broken especially on machines where libiodbc.so.N.N existed but there was no libiodbc.so which could lead to no adding the shared object at all. I doubt anyone really noticed this but I did eventually on Ubuntu where libiodbc.so.N.N existed but libiodbc.so did not. [ENHANCEMENTS] * Added experimental odbc_getdiagrec and odbc_getdiagrec methods, examples/odbc_diag.pl and examples/params_in_error.pl. [DOCUMENTATION] * New FAQ entries. =head2 Changes in DBD::ODBC 1.34_2 January 25 2012 [BUG FIXES] * Fixed rt73734 - debian moved where unixODBC libs are stored. * Fixed memory leak of the parameter status array introduced in previous release when execute_for_fetch used. When the statement handle is destroyed the parameter status array was not freed. [ENHANCEMENTS] * Added environment variable PERL_DBD_ODBC_PREFER_UNIXODBC as a synonym for -x from Rafael Kitover (Caelum). [DOCUMENTATION] * Add a deviation from DBI spec for type_info_all. [OTHER] * Added example execute_for_fetch.pl =head2 Changes in DBD::ODBC 1.34_1 December 11 2011 [ENHANCEMENTS] * Added experimental execute_for_fetch support and associated attributes odbc_batch_size and odbc_disable_array_operations. Martin http://www.nntp.perl.org/group/perl.dbi.announce/2012/03/msg424.html Tue, 06 Mar 2012 13:24:09 +0000 ANNOUNCE DBI 1.618 by Tim Bunce file: $CPAN/authors/id/T/TI/TIMB/DBI-1.618.tar.gz size: 583067 bytes md5: 5ad29b56f7457f22bd1ca1c871b30719 =head2 Changes in DBI 1.618 (svn r15170) 25rd February 2012 Fixed compiler warnings in Driver_xst.h (Martin J. Evans) Fixed compiler warning in DBI.xs (H.Merijn Brand) Fixed Gofer tests failing on Windows RT74975 (Manoj Kumar) Fixed my_ctx compile errors on Windows (Dave Mitchell) Significantly optimized method dispatch via cache (Dave Mitchell) Significantly optimized DBI internals for threads (Dave Mitchell) Xsub to xsub calling optimization now enabled for threaded perls. Corrected typo in example in docs (David Precious) Added note that calling clone() without an arg may warn in future. Minor changes to the install_method() docs in DBI::DBD. Updated dbipport.h from Devel::PPPort 3.20 (Martin J. Evans) =cut Many thanks to all who contributed to this release, especially Dave Mitchell for his optimization work. Enjoy! Tim. http://www.nntp.perl.org/group/perl.dbi.announce/2012/02/msg423.html Sun, 26 Feb 2012 04:11:58 +0000 ANNOUNCE: DBI 1.617 by Tim Bunce file: $CPAN/authors/id/T/TI/TIMB/DBI-1.617.tar.gz size: 579214 bytes md5: d59b16a1cf06a76154234287509882b9 =head2 Changes in DBI 1.617 (svn r15107) 30th January 2012 NOTE: The officially supported minimum perl version will change from perl 5.8.1 (2003) to perl 5.8.3 (2004) in a future release. (The last change, from perl 5.6 to 5.8.1, was announced in July 2008 and implemented in DBI 1.611 in April 2010.) Fixed ParamTypes example in the pod (Martin J. Evans) Fixed the definition of ArrayTupleStatus and remove confusion over rows affected in list context of execute_array (Martin J. Evans) Fixed sql_type_cast example and typo in errors (Martin J. Evans) Fixed Gofer error handling for keeperr methods like ping (Tim Bunce) Fixed $dbh->clone({}) RT73250 (Tim Bunce) Fixed is_nested_call logic error RT73118 (Reini Urban) Enhanced performance for threaded perls (Dave Mitchell, Tim Bunce) Enhanced and standardized driver trace level mechanism (Tim Bunce) Removed old code that was an inneffective attempt to detect people doing DBI->{Attrib}. Clear ParamValues on bind_param param count error RT66127 (Tim Bunce) Changed DBI::ProxyServer to require DBI at compile-time RT62672 (Tim Bunce) Added pod for default_user to DBI::DBD (Martin J. Evans) Added CON, ENC and DBD trace flags and extended 09trace.t (Martin J. Evans) Added TXN trace flags and applied CON and TXN to relevant methods (Tim Bunce) Added some more fetchall_arrayref(..., $maxrows) tests (Tim Bunce) Clarified docs for fetchall_arrayref called on an inactive handle. Clarified docs for clone method (Tim Bunce) Added note to DBI::Profile about async queries (Marcel Grünauer). Reserved spatialite_ as a driver prefix for DBD::Spatialite Reserved mo_ as a driver prefix for DBD::MO Updated link to the SQL Reunion 95 docs, RT69577 (Ash Daminato) Changed links for DBI recipes. RT73286 (Martin J. Evans) =cut Many thanks to all those who contributed to this release. Enjoy! Tim. http://www.nntp.perl.org/group/perl.dbi.announce/2012/01/msg422.html Tue, 31 Jan 2012 02:56:03 +0000 Development release of DBD::ODBC with native execute_for_fetch support by Martin J. Evans Hi, I have just uploaded DBD::ODBC 1.34_1 to CPAN. This release adds very experimental support for a native execute_for_fetch method to DBD::ODBC which means you can do multiple row inserts/updates/deletes much quicker than using DBI's default execute_for_fetch (so long as you are using execute_for_fetch or execute_array and using column-wise binding). By default DBD::ODBC will use the new execute_for_fetch and there are some differences between what happens when you use DBD::ODBC with DBI's default execute_for_fetch and DBD::ODBC's. To disable the ODBC one you can set the new odbc_disable_array_operations attribute. I've listed the potential difference below. I'd love people to test this. It may be missing some special workarounds for a few drivers but I'm working my way through those. From version 1.34_01 DBD::ODBC implements its own execute_for_fetch which binds arrays of parameters and can send multiple rows (L</odbc_batch_size>) of parameters through the ODBC driver in one go (this overrides DBI's default execute_for_fetch). This is much faster when inserting, updating or deleting many rows in one go. Note, execute_array uses execute_for_fetch when the parameters are passed for column-wise binding. However, there are a small number of differences between using DBD::ODBC's execute_for_fetch compared with using DBI's default implementation (which simply calls execute repeatedly once per row). The differences you may see are: o as DBI's execute_for_fetch does one row at a time the result from execute is for one row and just about all ODBC drivers can report the number of affected rows when SQLRowCount is called per execute. When batches of parameters are sent the driver can still return the number of affected rows but it is usually per batch rather than per row. As a result, the tuple_status array you may pass to execute_for_fetch (or execute_array) usually shows -1 (unknown) for each row although the total affected returned in array context is a correct total affected. o not all ODBC drivers have sufficient ODBC support (arguably a bug) for correct diagnostics support when using arrays. DBI dictates that if a row in the batch is in error the tuple_status will contain the state, native and error message text. However the batch may generate multiple errors per row (which DBI says nothing about) and more than one row may error. In ODBC we get a list of errors but to associate each one with a particular row we need to call SQLGetDiagField for SQL_DIAG_ROW_NUMBER and it should say which row in the batch the diagnostic is associated with. Some ODBC drivers do not support SQL_DIAG_ROW_NUMBER properly and then DBD::ODBC cannot know which row in the batch an error refers to. In this case DBD::ODBC will report an error saying "failed to retrieve diags", state of HY000 and a native of 1 so you'll still see an error but not necessarily the exact one. Also, when more than one diagnostic is found for a row DBD::ODBC picks the first one (which is usually most relevant) as there is no way to report more than one diagnostic per row in the tuple_status. If the first problem of SQL_DIAG_ROW_NUMBER proves to be a problem for you the DBD::ODBC tracing will show all errors and if that is still not sufficient I'd consider adding a method to show all diagnostics. o Binding parameters with execute_array and execute_for_fetch does not allow the parameter types to be set. However, as parameter types are sticky you can call bind_param(param_num, undef, {TYPE => sql_type}) before calling execute_for_fetch/execute_array and the TYPE should be sticky when the batch of parameters is bound. o Although you can insert very large columns execute_for_fetch will need L</odbc_batch_size> * max length of parameter per parameter so you may hit memory limits. If you use DBI's execute_for_fetch DBD::ODBC uses the ODBC API SQLPutData (see L</odbc_putdata_start) which does not require large amounts of memory as large columns are sent in pieces. Martin http://www.nntp.perl.org/group/perl.dbi.announce/2011/12/msg421.html Mon, 12 Dec 2011 01:23:03 +0000 New DBD::ODBC 1.33 release by Martin J. Evans I've just uploaded DBD::ODBC 1.33 to CPAN. This release contains no new changes since the 1.32_5 development release but is the official release for all the 1.32 dev series. The complete changes can be found below. The main thrust has been Unicode improvements. The most significant enhancements are: o unicode support for catalog/schema/table/column names in table_info and column_info o now using SQLGetTypeInfoW on unicode builds o new odbc_driver_complete attribute to allow interaction with ODBC dialogs on Windows I'd really like to hear from anyone who uses this as I've had no feedback so far - just drop me an email if you have and bug fixes: o remove a debugging printf - sorry, most embarrassing. I'm releasing this now because a) it is about time and b) I'm working on support for execute_for_fetch which will speed up any call to execute_array massively but it will be experimental in the next dev release. Thanks to all the people who have helped. =head2 Changes in DBD::ODBC 1.33 December 1 2011 This is simply the official release of the 1.32 development releases. =head2 Changes in DBD::ODBC 1.32_5 November 24 2011 [ENHANCEMENTS] * Enable multiple active statement support in 70execute_array.t for drivers we recognise which support MAS. * Change column_info to support Unicode catalog/schema/table/column names. =head2 Changes in DBD::ODBC 1.32_4 November 22 2011 [BUG FIXES] * remove debugging printf which output "HERE" in some rare cases. rt 72534 - thanks John Deighan for spotting this. * The test 70execute_array.t could fail due to warning being output if the driver does not support Multiple Active Statements. [ENHANCEMENTS] * Use SQLGetTypeInfoW on unicode builds. =head2 Changes in DBD::ODBC 1.32_3 November 15 2011 [BUG FIXES] * Fix bug in utf16_copy which was not adding a trailing NUL but I'm not sure this affected anyone until I changed table_info this release. [ENHANCEMENTS] * DBD::ODBC now allows unicode catalog/schema/table parameters to be passed to table_info. Of course they will only reliably work with a supporting Unicode ODBC driver. =head2 Changes in DBD::ODBC 1.32_2 October 22 2011 [ENHANCEMENTS] * Added new odbc_driver_complete attribute allowing the ODBC Driver Manager and ODBC Driver to throw dialogues for incomplete connection strings or expired passwords etc. [OTHER] * added more examples [DOCUMENTATION] * new FAQ entries * added note saying you cannot pass unicode schema/table/column names to metadata calls like table_info/column_info currently. =head2 Changes in DBD::ODBC 1.32_1 June 24 2011 [BUG FIXES] * I omitted rt_68720.t from the 1.31 distribution which leads to a warning as it is mentioned in the MANIFEST. [OTHER] * Changed line endings in README.af and README.unicode to be unix line endings and native eol-style in subversion. * Minor changes to Makefile.PL to save the opensuse guys patching. * Added unicode_sql.pl and unicode_params.pl examples Martin http://www.nntp.perl.org/group/perl.dbi.announce/2011/12/msg420.html Thu, 01 Dec 2011 12:34:56 +0000 DBD::ODBC 1.31 released by Martin J. Evans I have just uploaded DBD::ODBC 1.31 to pause. This is the culmination of 7 development releases and I thought it was time to do an official release. Due to personal issues I am unlikely to be doing another update to DBD::ODBC in the near future but if you find issues please report them on RT and I'll try my best. The changes since 1.29 are below. There are significant changes since the last official release and a few changes in behaviour. If you didn't test a development release and it now goes wrong I'm sorry but after 7 development releases you had your chance. I'm sorry if this sounds harsh but it is notoriously difficult to get feedback on development releases, few smokers actually have a database set up (but thank you anyway) and it is next to impossible for me to cover the dozens of ODBC drivers in existence. Thank you to all the people who have reported issues, tested releases and in particular to the DBIx::Class guys who yet again have provided invaluable testing (you know who you are and if we ever meet up it will be beers all round on me). =head2 Changes in DBD::ODBC 1.31 June 21, 2011 [BUG FIXES] Recently introduced test sql_type_cast.t cannot work with DBI less than 1.611. Minor change to Makefile.PL to avoid use of unitialised warning on $ENV{LD_LIBRARY_PATH} in warning when it is not set. =head2 Changes in DBD::ODBC 1.30_7 June 15, 2011 [BUG FIXES] Some time ago (I don't know when) a few internal errors generated by DBD::ODBC got ignored. There are about 5 of them but I seriously doubt anyone would hit any other than the data truncated error (which is reported by the ODBC driver anyway) and "no select statement currently executing". You can see rt_68720.t in the t directory for an example of the latter. [ENHANCEMENTS] An extra argument has been added to the sub associated with odbc_err_handler. The arguments passed to the odbc_err_handler are now state (string), error (string), native error code (number) and the status returned from the last ODBC API. The status will be SQL_ERROR (-1) for errors or SQL_SUCCESS_WITH_INFO (1) for informational messages. =head2 Changes in DBD::ODBC 1.30_6 June 4, 2011 [BUG FIXES] * When DBD::ODBC calls SQLExecDirect (the do method) it was not reporting informational diagnostics (SQL_SUCCESS_WITH_INFO) and not calling the error handler. Arguably, this is a change in behaviour but one I've struggled to resolve since in all other cases of warnings DBD::ODBC's error handler is called. However, DBI does not call its error handler for warnings so was DBD::ODBC wrong to call it's error in the first place for warnings? I decided it was better to leave this as it is but add checking of SQLExecDirect/do. Apart from anything else if DBD::ODBC does not call its error handler for informational diagnostics there is no way to retrieve print statements etc from procedures. * The odbc_describe_parameter.t test could fail with some versions of MS SQL Server ODBC Driver. It was down to when SQLDescribeParameter is disabled, the column_size passed to SQLBindParameter is 0. * pod example of odbc_err_handler incorrectly used \$err_handler instead of \&err_handler. =head2 Changes in DBD::ODBC 1.30_5 May 24, 2011 [BUG FIXES] * The change in behavior detailed in 1.30_1 for wide character binding was still not working properly (see http://rt.cpan.org/Ticket/Display.html?id=67994). It was working for SQL_CHAR described columns but not SQL_VARCHAR. =head2 Changes in DBD::ODBC 1.30_4 May 18, 2011 [BUG FIXES] * Fix issue described in http://www.nntp.perl.org/group/perl.dbi.dev/2011/05/msg6567.html. If you prepare a statement, disconnect and then try and execute the statement you get an error but it does not tell what is wrong. [ENHANCEMENTS] * Added support for StrictlyTyped and DiscardString to the bind_col method. [OTHER] * Minor changes to META.yml for mailing list, dynamic_config, homepage and keywords. * The pod was missing = before the heads on a couple of sections in "Private DBD::ODBC Functions" * TreatAsLob was incorrectly documented as BindAsLob. =head2 Changes in DBD::ODBC 1.30_3 May 17, 2011 [BUG FIXES] * Made the new odbc_describe_parameters work and added test case. =head2 Changes in DBD::ODBC 1.30_2 May 16, 2011 [ENHANCEMENTS] * Added the new odbc_describe_parameters attribute. =head2 Changes in DBD::ODBC 1.30_1 May 12, 2011 [BUG FIXES] * Fixed some compiler warnings shown with -Wall including some printf formats that had extra/missing arguments. * Fixed t/70execute_array.t which was missing an "order by" in the check_data sub which could cause failures for drivers not returning the rows in the order they were inserted. * Minor fix to Makefile.PL to avoid issuing variable used in void context. [CHANGE IN BEHAVIOR] * DBD::ODBC used to quietly rollback any transactions when disconnect was called and AutoCommit was off. This can mask a problem and leads to different behavior when disconnect is called vs not calling disconnect (where you get a warning). This release issues a warning if you call disconnect and a transaction is in progress then it is rolled back. * DBD::ODBC used to bind char/varchar/longvarchar columns as SQL_CHAR meaning that in the unicode build of DBD::ODBC the bound column data would be returned 8bit in whatever character-set (codepage) the data was in, in the database. This was inconvenient and arguably a mistake. Columns like nchar/nvarchar etc were bound as SQL_WCHAR and returned as Unicode. This release changes the behaviour in a unicode build of DBD::ODBC to bind all char columns as SQL_WCHAR. This may inconvenience a few people who expected 8bit chars back, knew the char set and decoded them (sorry). See odbc_old_unicode to return to old behaviour. [ENHANCEMENTS] * added -w option to Makefile.PL to add "-Wall" to CCFLAGS and -fno-strict-aliasing so I can find warnings. * Cope with broken ODBC drivers that describe a parameter as SQL type 0. [OTHER] * Add "disconnect and transactions" to pod describing what DBD::ODBC does if you call disconnect with an outstanding transaction. * Reorganised FAQ for bound parameter issues and added a lot on bound parameter problems. * Added new FAQ entry for Firebird * Removed some unused variables and added some missing function prototypes Martin http://www.nntp.perl.org/group/perl.dbi.announce/2011/06/msg419.html Fri, 24 Jun 2011 01:14:41 +0000 ANNOUNCE: IBM Informix Database Driver for Perl DBI Version 2011.0612(2011-06-12) released by Jonathan Leffler After 3 years and 1 month bar 1 day, a new version of DBD::Informix hits the streets - well, CPAN, anyway. The primary change - support for Perl 5.14.0. IBM Informix Database Driver for Perl DBI Version 2011.0612 (2011-06-12) has been uploaded to CPAN. IBM Informix Database Driver for Perl (also known as DBD::Informix) is the driver code that enables Perl 5.6.1 or later to access Informix databases via the DBI module (but if you are not already using Perl 5.10.0 - or any later version - you should be planning to upgrade to Perl 5.14.0 or later). You will need the code for DBI version 1.38 or later as well (v1.616 - or any later version - is recommended). The code for DBD::Informix is available for download via: http://www.perl.org/CPAN/modules/by-category/07_Database_Interfaces http://dbi.perl.org/ ** When you successfully build this module, use the ItWorks (Perl) ** script to report your configuration to the maintenance team (meaning ** Jonathan Leffler) at dbd.informix@gmail.com. ** The ItWorks script does not send email to anybody; you have to do ** that yourself. New in release :PRODVER:: * Minor bug fix release. * Main change is related to Perl internals and avoids the need for PERL_POLLUTE. This change is not visible to users except that Perl 5.14.x can use the fixed code. * Fixed problem with string that is not null terminated by ESQL/C library. * Clean up some 64-bit compilation warnings. * Build on AIX. * Evade problem with a DISTINCT type of LVARCHAR with NOT NULL (probably ESQL/C bug). * Fewer versions of Informix products are supported. You may try building DBD::Informix with other versions. If it works, great; if not, please upgrade to a supported Informix version. New in release 2008.0513: * Fix $sth->{TYPE}: return 9 (SQL_DATE) not -1 (SQL_LVARCHAR), fixing an 11-year old bug. * Add support for BIGINT in ESQL/C 3.50, including $h->{ix_bigserial}. * CPAN Testers reporting issues because Makefile.PL not exiting successfully when pre-requisites not met. * ESQL/C 3.50 (for IDS 11.50) typedefs ifx_loc_t - update dumpesql.h to cope (Joe R Plugge <jrplugge@west.com>). * ESQL/C test fails during configuration when $Config{ccflags} has leading spaces. Records show this problem also affected Dr Guenther Seifert <guenther-h.seifert@t-systems.com> in June 2007. Apologies for not getting it fixed sooner. Support email address: * This release is supported by Jonathan Leffler <dbd.informix@gmail.com>. * You may also report your bugs via the CPAN resolution tracking system: http://rt.cpan.org/ * Such bug reports can be sent by email to bug-DBD-Informix@rt.cpan.org; they also get sent to dbd.informix@gmail.com, etc. As always, see the ChangeLog file for details about what has changed. Jonathan Leffler (jleffler@us.ibm.com, jleffler@earthlink.net) @(#)$Id: Announce,v 2011.1 2011/06/12 22:14:47 jleffler Exp $ -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." http://www.nntp.perl.org/group/perl.dbi.announce/2011/06/msg418.html Mon, 13 Jun 2011 01:19:54 +0000 New 1.30_1 development release of DBD::ODBC by Martin J. Evans I've just uploaded DBD::ODBC 1.30_1 to CPAN. If you use Windows or a Unicode build of DBD::ODBC on non-Windows platforms you should really test this release as it contains a change in behaviour for Unicode. This release also contains a small but perhaps significant change to the silent rolling back of a transaction when disconnect was called when AutoCommit was disabled. The complete changes since 1.29 are below. Again, many thanks to all the people RTing issues and providing feedback/testing. =head2 Changes in DBD::ODBC 1.30_1 May 12, 2011 [BUG FIXES] * Fixed some compiler warnings shown with -Wall including some printf formats that had extra/missing arguments. * Fixed t/70execute_array.t which was missing an "order by" in the check_data sub which could cause failures for drivers not returning the rows in the order they were inserted. * Minor fix to Makefile.PL to avoid issuing variable used in void context. [CHANGE IN BEHAVIOR] * DBD::ODBC used to quietly rollback any transactions when disconnect was called and AutoCommit was off. This can mask a problem and leads to different behavior when disconnect is called vs not calling disconnect (where you get a warning). This release issues a warning if you call disconnect and a transaction is in progress then it is rolled back. * DBD::ODBC used to bind char/varchar/longvarchar columns as SQL_CHAR meaning that in the unicode build of DBD::ODBC the bound column data would be returned 8bit in whatever character-set (codepage) the data was in, in the database. This was inconvenient and arguably a mistake. Columns like nchar/nvarchar etc were bound as SQL_WCHAR and returned as Unicode. This release changes the behaviour in a unicode build of DBD::ODBC to bind all char columns as SQL_WCHAR. This may inconvenience a few people who expected 8bit chars back, knew the char set and decoded them (sorry). See odbc_old_unicode to return to old behaviour. [ENHANCEMENTS] * added -w option to Makefile.PL to add "-Wall" to CCFLAGS and -fno-strict-aliasing so I can find warnings. * Cope with broken ODBC drivers that describe a parameter as SQL type 0. [OTHER] * Add "disconnect and transactions" to pod describing what DBD::ODBC does if you call disconnect with an outstanding transaction. * Reorganised FAQ for bound parameter issues and added a lot on bound parameter problems. * Added new FAQ entry for Firebird * Removed some unused variables and added some missing function prototypes Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com http://www.nntp.perl.org/group/perl.dbi.announce/2011/05/msg417.html Fri, 13 May 2011 04:03:56 +0000 DBD::Pg version 2.18.0 released by Greg Sabino Mullane Version 2.18.0 of DBD::Pg, the Perl interface to Postgres, has just been released. This fixes some important memory leaks, adds a true cancel() method (per DBI spec), and fixes some other minor bugs. The new version is available from CPAN, of course. The complete list of changes: Version 2.18.0 Released March 28, 2011 (subversion r14081) ('GSM' is Greg Sabino Mullane) - Thanks to 123people.com for sponsoring work on this release [GSM] - New cancel() method per DBI spec. [Eric Simon] (CPAN bug #63516) - Fix memory leak when binding arrays [GSM] (CPAN bug #65734) - Fix memory leak with ParamValues. [Martin J. Evans] (CPAN bug #60863) - Fix memory leak in handle_old_async (missing PQclear) [Rainer Weikusat] (CPAN bug #63408) - Fix memory leak in pg_db_cancel (missing PQclear) [Rainer Weikusat] (CPAN bug #63441) - Mark pg_getcopydata strings as UTF8 as needed (CPAN bug #66006) - Function dequote_bytea returning void should not try to return something [Dagobert Michelsen] (CPAN bug #63497) - Fix the number of tests to skip in t/01connect.t when the $DBI_DSN environment variable lacks a database specification. [David E. Wheeler] - Fix algorithm for skipping tests in t/06bytea.t when running on a version of PostgreSQL lower than 9.0. [David E. Wheeler] - Small tweaks to get tests working when compiled against Postgres 7.4 (CPAN bug #61713) [GSM] - Fix failing test when run as non-superuser [GSM] (CPAN bug #61534) -- Greg Sabino Mullane greg@endpoint.com End Point Corporation PGP Key: 0x14964AC8 http://www.nntp.perl.org/group/perl.dbi.announce/2011/03/msg416.html Wed, 30 Mar 2011 12:39:52 +0000 ANNOUNCE: DBD::ADO 2.99 by Steffen Goeldner file: $CPAN/authors/id/S/SG/SGOELDNER/DBD-ADO-2.99.tar.gz size: 47582 bytes md5: 05ebf07e4476d3e34468819ab6f6fa08 Changes: Patch to remove annoying warnings during global destruction, with tests, from Rafael Kitover. Implemented more_results(). Added tests (t/26more.t). Small change to table_info(): no need for client-side cursors. Steffen http://www.nntp.perl.org/group/perl.dbi.announce/2011/03/msg415.html Tue, 22 Mar 2011 06:35:55 +0000 New 1.29 release of DBD::ODBC by Martin J. Evans I've just uploaded DBD::ODBC 1.29 to CPAN. This is the official release of the 5 development 1.28 releases and contains a large number of changes. Many thanks to everyone who has reported issues, tested and helped with this release. If you report an issue in DBD::ODBC 1.29 (or later when it happens) please now include a DBD::ODBC trace by setting DBI_TRACE=DBD=x.log and exporting it. This will include all DBD::ODBC tracing but omit DBI tracing. Here are the changes since 1.27: =head2 Changes in DBD::ODBC 1.29 March 8, 2011 * An official release of the 1.28 development releases. [NOTE] * The 1.28 development releases made a change which causes a generic error to be reported when an ODBC call fails but an error message is not retrieved from the ODBC Driver. It appears this has caught out a few ODBC drivers - notably freeTDS and Firebird. You now may see errors that were missed before e.g., DBIx::Class's tests for Firebird now errors test 21 "outer txn rolled back" (and others) because SQLRowCount returns an error after "ROLLBACK TO SAVEPOINT savepoint_0"; before this error was missed. =head2 Changes in DBD::ODBC 1.28_5 March 6, 2011 [BUG FIXES] * rt_59621.t had wrong skip count * Fixed missing SQL_MAX_TABLE_NAME_LEN definition from test. * Fixed problem with some drivers which batch "insert;select" where SQLMoreResults is not required and an extra describe is done. * Fixed "select 1" in 02simple.t for Firebird ODBC Driver. * disconnect call added to 70execute_array.t was in the wrong place. * In non-unicode mode we bind strings as SQL_CHAR but the driver may have described them as SQL_WCHAR and we were not doing ChopBlanks processing in that case. [REQUIREMENTS] * Now needs Test::Simple 0.90. [OTHER] * Added dml_counts.pl example * worked around a problem in freeTDS in the 20SqlServer.t test provided by Ralph Doncaster. * Changed test rt_62033.t to try and make it work with freeTDS - I failed. It now skips attempts to fetch when the insert fails. * Worked around problem in Firebird ODBC driver which reports timestamps have a display size of 24 characters but then can return 29 which could lead to data truncation errors. See http://tracker.firebirdsql.org/browse/ODBC-112 * Worked around problem in Firebird ODBC driver which reports VARCHARs have a maximum length of 32765 but in fact it is 4000. See http://tracker.firebirdsql.org/browse/ODBC-111 * Improvements in tracing to take account of DBI's neatsvpv lops 5 characters off maxsize on a string. =head2 Changes in DBD::ODBC 1.28_4 February 24, 2011 [BUG FIXES] * Fixed compilation problems with DBIf_TRACE_TXN * Added missing disconnect call to 70execute_array.t =head2 Changes in DBD::ODBC 1.28_3 February 22, 2011 [BUG FIXES] * Fixed MANIFEST in 1.28_2 which named 2 files incorrectly. * Fixed use of PREREQ_PRINT in versions of ExtUtils::MakeMaker which don't support it. * Fixed a check on LD_LIBRARY_PATH for unixODBC which could report you've not set LD_LIBRARY_PATH correctly. [ENHANCEMENTS] * Added Perl and ExtUtils::MakeMaker version output to build process. * Added support for DBI's new trace flags ENC, CON, TXN and DBD. From DBI 1.617 you should be able to use: DBI_TRACE=DBD to ONLY get DBD::ODBC tracing without DBI tracing ENC and CON DBI flags are synonymous with DBD::ODBC's odbcconnection and odbcunicode trace flags which you can still use for now. [OTHER] * From now on I'm changing the way the Changes file is written as per article at http://blog.urth.org/2011/01/changes-file-how-and-how-not-to.html * Some broken drivers (freeTDS in this case) can return SQL_ERROR from an ODBC API function and then SQLError does not return error details. In this case set a generic error saying an error occurred but we could not retrieve it. * Added FAQ entry on MS Access and text columns limited to 255 chrs. * Added 70execute_array.t test. =head2 Changes in DBD::ODBC 1.28_2 January 24, 2011 Added -x argument to Makefile.PL saying you prefer unixODBC over iODBC driver managers as a) we need to look for iODBC first on some platforms to detect iODBC and b) some platforms (Debian/Ubuntu) people have both binary packages installed but only unixODBC dev package. Patch from Rafael Kitover (Caelum) for better Cygwin handling. Minor change to data sources test to cope with someone having no data sources and using a DSN-less connection for testing. Fixed MARS test when a DSN-less connection used for testing - thanks to Rafael Kitover (Caelum) for spotting this. pod patch for "CPAN Testers Reporting" to point at cpan testers wiki from Rafael Kitover (Caelum). Fixed some broken links in the FAQ. Add a multiple active statement document link to random links and the FAQ entry. A call to SQLNumResultCols was not checked to test it succeeded. Not seen anyone run into this as yet. =head2 Changes in DBD::ODBC 1.28_1 December 29, 2010 Rewrote documentation on odbc_SQL_ROWSET_SIZE and added loads of notes so I don't have to go through a huge irc conversation with ribasushi again. Workaround bug in DBI (prior to 1.616) which mistakenly issues a FETCH on any attribute passed to the connect method and sometimes driver managers error on SQL_ROWSET_SIZE in SQLGetConnectAttr. ChopBlanks was not working on UCS-2 encoded data written into bound columns and was also sometimes reading off the end of the bound array. Minor FAQ changes: Added an additional way to read MS Access dbs from Unix Clarified versions for MARS_Connection updates to cancel_big_fetch.pl Updated TO_DO with more stuff to do Improved tracing output Tidied up some of the examples Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com http://www.nntp.perl.org/group/perl.dbi.announce/2011/03/msg414.html Tue, 08 Mar 2011 08:28:58 +0000 ANNOUNCE: DBD::ADO 2.98 by Steffen Goeldner file: $CPAN/authors/id/S/SG/SGOELDNER/DBD-ADO-2.98.tar.gz size: 46572 bytes md5: 92e83467a8b7fe2a831af507893eb728 Changes: Fixed a 'Missing argument in sprintf' at DBD/ADO/GetInfo.pm line 13. Patch for supporting cygwin in Makefile.PL from Rafael Kitover. Added a workaround for ADO Providers that don't accept a parameter size 0, spotted by Jeff Picklyk. Added test (12bind.t). Added the CLONE special subroutine, spotted by Jeff Picklyk. Steffen http://www.nntp.perl.org/group/perl.dbi.announce/2011/02/msg413.html Fri, 04 Feb 2011 12:19:51 +0000 Announce DBI 1.616 by Tim Bunce file: $CPAN/authors/id/T/TI/TIMB/DBI-1.616.tar.gz size: 576803 bytes md5: 799313e54a693beb635b47918458f7c4 Many thanks to those who have contributed to this release. =head2 Changes in DBI 1.616 (svn r14616) 30th December 2010 Fixed spurious dbi_profile lines written to the log when profiling is enabled and a trace flag, like SQL, is used. Fixed to recognize SQL::Statement errors even if instantiated with RaiseError=0 (Jens Rehsack) Fixed RT#61513 by catching attribute assignment to tied table access interface (Jens Rehsack) Fixing some misbehavior of DBD::File when running within the Gofer server. Fixed compiler warnings RT#62640 Optimized connect() to remove redundant FETCH of \%attrib values. Improved initialization phases in DBI::DBD::SqlEngine (Jens Rehsack) Added DBD::Gofer::Transport::corostream. An experimental proof-of-concept transport that enables asynchronous database calls with few code changes. It enables asynchronous use of DBI frameworks like DBIx::Class. Added additional notes on DBDs which avoid creating a statement in the do() method and the effects on error handlers (Martin J. Evans) Adding new attribute "sql_dialect" to DBI::DBD::SqlEngine to allow users control used SQL dialect (ANSI, CSV or AnyData), defaults to CSV (Jens Rehsack) Add documentation for DBI::DBD::SqlEngine attributes (Jens Rehsack) Documented dbd_st_execute return (Martin J. Evans) Fixed typo in InactiveDestroy thanks to Emmanuel Rodriguez. =cut Wishing everyone a New Year of full of joy and peace. Enjoy! Tim. http://www.nntp.perl.org/group/perl.dbi.announce/2010/12/msg412.html Thu, 30 Dec 2010 10:30:04 +0000 New official DBD::ODBC 1.27 release by Martin J. Evans DBD::ODBC 1.27 is winging its way to CPAN now. Version 1.27 combines all the 1.26 development releases and is a significant release as DBD::ODBC is now entirely ODBC 3.0 and requires an ODBC Driver Manager for any ODBC 2.0 drivers. Many thanks to everyone who has contributed. The changes are listed below. Martin =head2 Changes in DBD::ODBC 1.26_4 December 14, 2010 Fixed bug highlighted by investigation into rt 62033 where the active flag was sometimes not set on the statement after SQLMoreResults indicates a result-set exists. Fix rt63550 reported by John Corcoran where if a do method call fails the SQL C<Statement> is not available in an error handler as we never created a DBI statement in the first place. Added a note to "do" deviations pod. Minor fix to head at wrong level in the pod. Fix a possible snprintf buffer overflow in GetTypeInfo when the type is specified and it is negative. =head2 Changes in DBD::ODBC 1.26_3 November 18, 2010 Fixed rt 63108. The change to column binding in 1.24_2 was not complete and causes bound columns to be rebound on each execute wasting time and leaking memory. Found, diagnosed and proposed fix by Steve Bentley. =head2 Changes in DBD::ODBC 1.26_2 November 9, 2010 Fixed bug found by frew where an snprintf can overflow when binding a lot of parameters. =head2 Changes in DBD::ODBC 1.26_1 October 24, 2010 There are over 200 block changes in the source code for this release from the previous one (see below). If you are using DBD::ODBC in production you should not upgrade without testing this release first as it introduces a lot of internal changes. DBD::ODBC has now gone entirely ODBC 3 and relies on an ODBC Driver Manager to map calls to ODBC 2.0 drivers (why are you still using ODBC 2.0 drivers?). From now on DBD::ODBC needs to be linked with an ODBC Driver Manager and I recommend unixODBC on UNIX and the MS ODBC Driver Manager on Windows. There are really good reasons for this but mainly it is because an ODBC Driver Manager will map ODBC 2.0 calls to an ODBC 3.0 driver and vice versa and handle UNICODE transparently. Bumped Test::Simple requirement up to 0.90 so we can use done_testing and note. Bump Perl requirement to 5.8 as per DBI. Workaround a bug in mdbtools which fails to set the out connection string in a SQLDriverConnect call. This can lead to: Fixed panic: sv_setpvn called with negative strlen at blib/lib/DBD/ODBC.pm line 107. Added rt_61370.t for rt 61370. Removed last remaining sprintf calls and replaced with snprintf. Changed the point at which DBD::ODBC switches from VARCHAR to LONGVARCHAR or WVARCHAR to WLONGVARCHAR when SQLDesribeParam fails. It was 4000 and is now 2000 for unicode builds. Works around a daft issue in the MS SQL Server driver which will not allow 'x' x 2001 converted to wide characters to be inserted into a varchar(8000). Minor change to Makefile.PL to print out found libs for iODBC and unixODBC. Added some FAQs for problems with iODBC and a recent bug in DBI. Added FAQ on my_snprintf problem. Fixed some pod errors in FAQ document. Fixed warning on 64 bit Strawberry Perl when compiling dbdimp.c for cast from ptr to UDWORD. Moved to_do items from Changes to TO_DO. Reformatted this file to save Jens work. Changed calls to SQLTransact (ODBC 2.0) to SQLEndTran (ODBC 3.0). There really shouldn't be any ODBC 2.0 drivers still around but even if there are, the ODBC driver manager should do the mapping for us. Changed calls to SQLGetConnectOption/SQLSetConnectOption to to SQLGetConnectAttr/SQLSetConnectAttr for ODBC 3.0. Changed calls to SQLColAttributes (ODBC 2.0) to SQLColAttribute (ODBC 3.0). Bumped requirement on DBI to 1.609 because that is the first version to contain a dbipport.h which defined my_snprintf - see https://rt.cpan.org/Public/Bug/Display.html?id=62346 and http://www.nntp.perl.org/group/perl.dbi.dev/2010/10/msg6335.html Various small changes to dbdimp.c which should have no effect other than to make it leaner: Removed all dTHR occurrences from dbdimp.c as it is a NOOP since 5.8 and we need 5.8 at least. Removed dbd_param_err as it was not used Removed odbc_get_query_timeout as it was never compiled Removed eod field from statement as it was never used Removed a load of commented out code Replaced some SvPV calls with SvPV_nolen when we didn't used the length Removed some silly code from dbd_db_execdirect which attempted to return -3 - don't think it could ever get run. Minor tracing output tidy up Removed dbd_caution as it was no used Localised more variable declarations http://www.nntp.perl.org/group/perl.dbi.announce/2010/12/msg411.html Wed, 29 Dec 2010 05:36:38 +0000 Do you use PostgreSQL PL/Perl? by Tim Bunce I'm at PGDay Europe 2010 (http://2010.pgday.eu/) On Tuesday morning (that's tomorrow as I write this) I'm giving a talk called "PL/Perl - New features in 9.0". It would be a great help to me if I could get a better idea of how other people use PostgreSQL PL/Perl. What kinds of things do you use PL/Perl in the server for? How much PL/Perl code do you have (approximate number of functions and lines)? What kinds of CPAN modules would you like to use in PL/Perl? Thanks! Tim. http://www.nntp.perl.org/group/perl.dbi.announce/2010/12/msg410.html Mon, 06 Dec 2010 04:03:29 +0000 DBD::drizzle .301 released by Patrick Galbraith Hi all, I have just uploaded to CPAN DBD::drizzle .301. This includes a fix from Eric Day to fix to NULL handling as well as some rewriting of column_info, which used to use DESCRIBE and SHOW commands, but since the direction of Drizzle encourages use of both information_schema and data_dictionary, I've utilized these instead for catalogue information. Once the mirrors update, you should be able to use CPAN for obtaining DBD::drizzle, or you can obtain it from Launchpad: lp:dbd-drizzle Thanks for reminding me to get this out, dear Perl and Drizzle enthusiasts! Your friend, Patrick "CaptTofu" Galbraith http://www.nntp.perl.org/group/perl.dbi.announce/2010/10/msg409.html Thu, 21 Oct 2010 14:04:11 +0000 test DBD::SQLite 1.30_04 - write-ahead logging by Darren Duncan All, I am pleased to announce that DBD::SQLite (Self Contained RDBMS in a Perl DBI Driver) version 1.30_04 has been released on CPAN (by Adam Kennedy). http://search.cpan.org/~adamk/DBD-SQLite-1.30_04/ This developer release bundles the brand-new SQLite version 3.7.2, which (since 3.7.0) adds support for write-ahead logging (WAL). See http://sqlite.org/wal.html for the details of the WAL support that SQLite now has. WAL is an alternative method to how SQLite implements atomic commit and rollback than to its rollback journal method. It offers much improved concurrency and performance in many circumstances, such as because database readers and writers don't block each other. There are also trade-offs. By default, SQLite and DBD::SQLite will continue to use the older rollback journal method, and you can use the new WAL method with the SQL command: PRAGMA journal_mode=WAL; There are also numerous other additions, changes, or fixes in either DBD::SQLite or SQLite itself since the last production DBD::SQLite release 1.29 of 2010 January, which bundles SQLite 3.6.22. For the change details since then, see http://sqlite.org/changes.html or http://search.cpan.org/src/ADAMK/DBD-SQLite-1.30_04/Changes as appropriate. TESTING NEEDED! Please bash the hell out of the latest DBD::SQLite and report any outstanding bugs on RT. Test your dependent or compatible projects with it, which includes any DBMS-wrapping or object persistence modules, and applications. This 1.30_04 release will probably be released as a production 1.31 within a week if no show-stopper problems are found. Please note the compatibility caveats of using pre-3.7.x versions of SQLite on databases that had been used with WAL mode on. In order to use an older SQLite on the database, the database must have last been used by a 3.7.x in journal mode. See http://sqlite.org/wal.html for details. Please note that, if you receive nondescript "disk I/O error" errors from your code after the update, see if the failing code involves a process fork followed by unlinking of the database, such as if it was temporary for testing. The DBD::SQLite test suite had needed an update to act more correctly, which the update to 3.7.x from 3.6.x exposed; 3.6.x didn't complain about this. If you want in to DBD::SQLite development, then join the following email/IRC forums which MST created (the mailing list, I am administrating): http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbd-sqlite #dbd-sqlite on irc.perl.org And the canonical version control is at: http://svn.ali.as/cpan/trunk/DBD-SQLite/ Patches welcome. Ideas welcome. Testing welcome. If you feel that a bug you find is in SQLite itself rather than the Perl DBI driver for it, the main users email forum for SQLite in general is at: http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ... where you can report it as an appropriate list post (the SQLite issue tracking system is no longer updateable by the public; posting in the list can cause an update there by a registered SQLite developer). Please do not reply to me directly with your responses. Instead send them to the forums or file with RT as is appropriate. Thank you. -- Darren Duncan http://www.nntp.perl.org/group/perl.dbi.announce/2010/08/msg408.html Wed, 25 Aug 2010 14:15:22 +0000 ANNOUNCE: DBI 1.613 by Tim Bunce file: $CPAN/authors/id/T/TI/TIMB/DBI-1.613.tar.gz size: 566542 bytes md5: 1fb75474c3ff75fcbc16a98656e8f89d =head2 Changes in DBI 1.613 (svn r14271) 22nd July 2010 Fixed Win32 prerequisite module from PathTools to File::Spec. Changed attribute headings and fixed references in DBI pod (Martin J. Evans) Corrected typos in DBI::FAQ and DBI::ProxyServer (Ansgar Burchardt) =head2 Changes in DBI 1.612 (svn r14254) 16th July 2010 NOTE: This is a minor release for the DBI core but a major release for DBD::File and drivers that depend on it, like DBD::DBM and DBD::CSV. This is also the first release where the bulk of the development work has been done by other people. I'd like to thank (in no particular order) Jens Rehsack, Martin J. Evans, and H.Merijn Brand for all their contributions. Fixed DBD::File's {ChopBlank} handling (it stripped \s instead of space only as documented in DBI) (H.Merijn Brand) Fixed DBD::DBM breakage with SQL::Statement (Jens Rehsack, fixes RT#56561) Fixed DBD::File file handle leak (Jens Rehsack) Fixed problems in 50dbm.t when running tests with multiple dbms (Martin J. Evans) Fixed DBD::DBM bugs found during tests (Jens Rehsack) Fixed DBD::File doesn't find files without extensions under some circumstances (Jens Rehsack, H.Merijn Brand, fixes RT#59038) Changed Makefile.PL to modernize with CONFLICTS, recommended dependencies and resources (Jens Rehsack) Changed DBI::ProfileDumper to rename any existing profile file by appending .prev, instead of overwriting it. Changed DBI::ProfileDumper::Apache to work in more configurations including vhosts using PerlOptions +Parent. Add driver_prefix method to DBI (Jens Rehsack) Added more tests to 50dbm_simple.t to prove optimizations in DBI::SQL::Nano and SQL::Statement (Jens Rehsack) Updated tests to cover optional installed SQL::Statement (Jens Rehsack) Synchronize API between SQL::Statement and DBI::SQL::Nano (Jens Rehsack) Merged some optimizations from SQL::Statement into DBI::SQL::Nano (Jens Rehsack) Added basic test for DBD::File (H.Merijn Brand, Jens Rehsack) Extract dealing with Perl SQL engines from DBD::File into DBI::DBD::SqlEngine for better subclassing of 3rd party non-db DBDs (Jens Rehsack) Updated and clarified documentation for finish method (Tim Bunce). Changes to DBD::File for better English and hopefully better explanation (Martin J. Evans) Update documentation of DBD::DBM to cover current implementation, tried to explain some things better and changes most examples to preferred style of Merijn and myself (Jens Rehsack) Added developer documentation (including a roadmap of future plans) for DBD::File =cut Enjoy! Tim. http://www.nntp.perl.org/group/perl.dbi.announce/2010/07/msg407.html Mon, 26 Jul 2010 14:06:23 +0000 [ANNOUNCE] DBD-Sys-0.100 and DBD-Sys-0.101 by Jens Rehsack Hi, I'm glad to announce new versions of DBD::Sys: - the release with heavy plug-in structure reworking (0.100) and - the release with a test fix (0.101). I would be happy to read about feedback and successful uses. Best regards, Jens -- Changes since initial 0.01 release: 0.101 2010-07-25 - fix tests to run only when all dependencies are satisfied 0.100 2010-07-21 - rename columns which were reserved sql words for table procs - rework plugin-management and table-management: * allow multiple implementors for one table * merge the data from multiple implementors on primary key - rely on DBI::DBD::SqlEngine - add support for Win32::Process::Info - fix DBD::Sys::Plugin::Unix::Users and DBD::Sys::Plugin::Unix::Groups using setpwent/setgrent as recommended by Ashish SHUKLA <ashish@freebsd.org> (and by Richard W. Stevens) - add logins table to get a list of logged in users - add openfiles table - fix hwadress column in netint table to hwaddress - add a second implementation for the netint table using Net::Ifconfig::Wrapper and (for calculating broadcase address) NetAddr::IP - fixing duplicate group entries on FreeBSD (and maybe others) http://www.nntp.perl.org/group/perl.dbi.announce/2010/07/msg406.html Mon, 26 Jul 2010 00:56:52 +0000 ANNOUNCE: DBI 1.612 by Tim Bunce file: $CPAN/authors/id/T/TI/TIMB/DBI-1.612.tar.gz size: 566429 bytes md5: a045d41b8056e549354ab2346fdfac86 =head2 Changes in DBI 1.612 (svn r14254) 16th July 2010 NOTE: This is a minor release for the DBI core but a major release for DBD::File and drivers that depend on it, like DBD::DBM and DBD::CSV. This is also the first release where the bulk of the development work has been done by other people. I'd like to thank (in no particular order) Jens Rehsack, Martin J. Evans, and H.Merijn Brand for all their contributions. Fixed DBD::File's {ChopBlank} handling (it stripped \s instead of space only as documented in DBI) (H.Merijn Brand) Fixed DBD::DBM breakage with SQL::Statement (Jens Rehsack, fixes RT#56561) Fixed DBD::File file handle leak (Jens Rehsack) Fixed problems in 50dbm.t when running tests with multiple dbms (Martin J. Evans) Fixed DBD::DBM bugs found during tests (Jens Rehsack) Fixed DBD::File doesn't find files without extensions under some circumstances (Jens Rehsack, H.Merijn Brand, fixes RT#59038) Changed Makefile.PL to modernize with CONFLICTS, recommended dependencies and resources (Jens Rehsack) Changed DBI::ProfileDumper to rename any existing profile file by appending .prev, instead of overwriting it. Changed DBI::ProfileDumper::Apache to work in more configurations including vhosts using PerlOptions +Parent. Add driver_prefix method to DBI (Jens Rehsack) Added more tests to 50dbm_simple.t to prove optimizations in DBI::SQL::Nano and SQL::Statement (Jens Rehsack) Updated tests to cover optional installed SQL::Statement (Jens Rehsack) Synchronize API between SQL::Statement and DBI::SQL::Nano (Jens Rehsack) Merged some optimizations from SQL::Statement into DBI::SQL::Nano (Jens Rehsack) Added basic test for DBD::File (H.Merijn Brand, Jens Rehsack) Extract dealing with Perl SQL engines from DBD::File into DBI::DBD::SqlEngine for better subclassing of 3rd party non-db DBDs (Jens Rehsack) Updated and clarified documentation for finish method (Tim Bunce). Changes to DBD::File for better English and hopefully better explanation (Martin J. Evans) Update documentation of DBD::DBM to cover current implementation, tried to explain some things better and changes most examples to preferred style of Merijn and myself (Jens Rehsack) Added developer documentation (including a roadmap of future plans) for DBD::File =cut I'd like to highlight again the great work done by Jens Rehsack, Martin J. Evans, and H.Merijn Brand to enhance the functionality of file based DBI drivers in this release. The release today is an extra birthday present for Jens! :) Enjoy! Tim. http://www.nntp.perl.org/group/perl.dbi.announce/2010/07/msg405.html Sat, 17 Jul 2010 01:32:16 +0000