perl.dbi.announce http://www.nntp.perl.org/group/perl.dbi.announce/ ... Copyright 1998-2014 perl.org Wed, 26 Nov 2014 14:30:27 +0000 ask@perl.org DBD::Pg 3.4.0 released by Greg Sabino Mullane <br/>-----BEGIN PGP SIGNED MESSAGE-----<br/>Hash: RIPEMD160<br/><br/>Version 3.4.0 of DBD::Pg, the Perl interface to Postgres, <br/>was released on August 16, 2014. The primary changes in this <br/>version are improvements in the table_info() and column_info() <br/>methods: see below for details. As always, you can download <br/>a tarball from CPAN:<br/><br/>http://search.cpan.org/dist/DBD-Pg/<br/><br/>Checksums for version 3.4.0 of DBD::Pg<br/><br/>e1fbe2ac4bd4951f1726a36b315c263c DBD-Pg-3.4.0.tar.gz<br/>611cda7b4eefcc437991eebb4a1561a112554c18 DBD-Pg-3.4.0.tar.gz<br/><br/>The mailing list welcomes any and all questions:<br/><br/>http://www.nntp.perl.org/group/perl.dbd.pg/<br/><br/>Development can be tracked via git:<br/><br/>git://bucardo.org/dbdpg.git<br/><br/>Complete list of changes in 3.4.0:<br/><br/>(git commit 7a5da12d84b4c2e9879f90fb6168f56c095071fa)<br/><br/> - Cleanup and improve table_info()<br/> [Mike Pomraning &lt;mjp@pilcrow.madison.wi.us&gt;] (github issue #7)<br/><br/> table_info() type searching now supports TABLE, VIEW, SYSTEM TABLE,<br/> SYSTEM VIEW, and LOCAL TEMPORARY<br/><br/> table_info() object searching fully supports the above types.<br/><br/> table_info() object searching no longer ignores invalid types - a filter <br/> of &#39;NOSUCH&#39; will return no rows, and &#39;NOSUCH,LOCAL TEMPORARY&#39; will<br/> return only temp objects.<br/><br/> tableinfo() type filters are strictly matched now ... previously a <br/> search for SYSTEM TABLE would have fetched plain TABLE objects.<br/><br/> table_info() now treats temporary tables and temporary views as LOCAL TEMPORARY<br/><br/> - Make sure column_info() and table_info() can handle materialized views.<br/> [Greg Sabino Mullane] (CPAN bug #97032)<br/><br/><br/>- -- <br/>Greg Sabino Mullane greg@turnstep.com<br/>PGP Key: 0x14964AC8 201408181051<br/>http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8<br/>-----BEGIN PGP SIGNATURE-----<br/><br/>iEYEAREDAAYFAlPyEwYACgkQvJuQZxSWSsgBBQCgrYkYnb9Sgv4G5yQJYNQqIOfj<br/>VhkAn2bxny/zVJBOFvOJ/w/AtajXgO52<br/>=70S2<br/>-----END PGP SIGNATURE-----<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/08/msg472.html Mon, 18 Aug 2014 15:39:45 +0000 Re: DBD::mysql 4.028 released by Patrick Galbraith <br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/08/msg471.html Mon, 04 Aug 2014 08:30:33 +0000 New 1.50 release of DBD::ODBC by Martin J. Evans I&#39;ve just uploaded DBD::ODBC 1.50 to the CPAN. This is the culmination of a series of 4 development releases in the 1.49 series. There are a number of bug fixes, enhancements, deprecated features and most importantly some changes in behaviour. See below for a list of changes.<br/><br/>1.50 2014-07-25<br/><br/> [BUG FIXES]<br/><br/> The 80_odbc_diags.t test could fail if a driver fails a table does<br/> not exist test in the prepare instead of the execute.<br/><br/>1.49_4 2014-07-08<br/><br/> [BUG FIXES]<br/><br/> Fixed sql_type_cast.t test which assumed column aliases which stay<br/> lowercase.<br/><br/> Fixed 87_odbc_lob_read.t test which did not bow out of the test<br/> properly if the database was not MS SQL Server.<br/><br/> [DOCUMENTATION]<br/><br/> Revised the query notification example and documentation.<br/><br/> Added a link to a better Query Notification article.<br/><br/>1.49_3 2014-05-01<br/><br/> [CHANGE IN BEHAVIOUR]<br/><br/> As warned years ago, this release removes the odbc_old_unicode attribute.<br/> If you have a good reason to use it speak up now before the next non-development<br/> release.<br/><br/> [BUG FIXES]<br/><br/> Fix rt89255: Fails to create test table for tests using PostgreSQL odbc driver.<br/> Change test suite to fallback on PRECISION if COLUMN_SIZE is not found.<br/><br/> [ENHANCEMENTS]<br/><br/> Added support for MS SQL Server Query Notification. See the new<br/> section in the pod.<br/><br/> Added a currently undocumented (and experimental)<br/> odbc_describe_param method on a statement handle which takes a<br/> parameter number as the only argument and returns an array of the<br/> data type, parameter size, decimal digits and nullable (as per<br/> SQLDescribeParam).<br/><br/> [DOCUMENTATION]<br/><br/> Added FAQ on truncated column names with freeTDS.<br/><br/> [MISCELLANEOUS]<br/><br/> I have removed the &quot;experimental&quot; tag for odbc_getdiagfield and odbc_getdiagrec<br/> methods.<br/><br/>1.49_2 2014-04-26<br/><br/> [BUG FIXES]<br/><br/> Change to data_sources in 1.49_1 could lead to a compile error since<br/> data_sources was not returning a value if an error occurred.<br/><br/>1.49_1 2014-04-25<br/><br/> [BUG FIXES]<br/><br/> If you had a lot of DSNs on Windows (more than 280 but it depends on<br/> the length of their names) and called the data_sources method it<br/> could crash your script. Code internally changed to stop putting the DSNs<br/> returned on the stack.<br/><br/> [CHANGE IN BEHAVIOUR]<br/><br/> As warned years ago, the private data_sources method has been<br/> removed - use DBI one instead.<br/><br/> [MISCELLANEOUS]<br/><br/> Added FAQ entry of maximum number of allowed parameters.<br/><br/>Martin<br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/07/msg470.html Sun, 27 Jul 2014 21:20:17 +0000 DBD::Pg 3.3.0 released (driver for Postgres) by Greg Sabino Mullane Version 3.3.0 of DBD::Pg, DBI driver for PostgreSQL, is<br/>now available. This release enhances UTF-8 support a<br/>great deal, thanks to the work of Dagfinn Ilmari Manns&aring;ker<br/>and Nicholas Clark. As always, you can find it on CPAN at:<br/><br/>http://search.cpan.org/dist/DBD-Pg/<br/><br/>Checksums:<br/><br/>547de1382a47d66872912fe64282ff55 DBD-Pg-3.3.0.tar.gz<br/>9ec52d0d75463e6a448760e2d2fcbc41ca6201e1 DBD-Pg-3.3.0.tar.gz<br/><br/>Complete list of changes:<br/><br/>Version 3.3.0 Released May 31, 2014 (git commit 055f788cf96b380b9fe0e80b6cedb88f8d1799b8)<br/><br/> - Major cleanup of UTF-8 support:<br/> Fix quoting of UTF-8 values<br/> Add support for UTF-8 statement strings<br/> Fix UTF-8 support in placeholders and return values<br/> [Dagfinn Ilmari Manns&aring;ker] (CPAN bug #95214 and #91655)<br/> Test that the Pg server agrees with us about the lengths of input strings.<br/> Refactor Unicode test to use anon hashes to describe the tests to run.<br/> Test pg_enable_utf8 of -1, in addition to 0 and 1.<br/> Extend the Unicode round-trip tests to verify ASCII, BMP and non-BMP code points.<br/> Test that characters created in the server reach the client correctly.<br/><br/> - Rewrite foreign_key_info to be just one query<br/> [Dagfinn Ilmari Manns&aring;ker]<br/><br/> - Remove ODBC support from foreign_key_info<br/> [Dagfinn Ilmari Manns&aring;ker]<br/><br/> - Remove use of dTHX in functions in quote.c and types.c<br/> [Nicholas Clark]<br/><br/><br/>--<br/>Greg Sabino Mullane greg@turnstep.com<br/>End Point Corporation http://www.endpoint.com/<br/>PGP Key: 0x14964AC8 201406021319<br/>http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8<br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/06/msg469.html Mon, 02 Jun 2014 21:26:14 +0000 DBD::Pg version 3.2.1 released (Perl Postgres driver) by Greg Sabino Mullane <br/>-----BEGIN PGP SIGNED MESSAGE-----<br/>Hash: RIPEMD160<br/><br/><br/>Version 3.2.1 of DBD::Pg, the Perl interface to Postgres,<br/>has just been released. In addition to some bug fixes, <br/>there is a new handle attribute called pg_placeholder_nocolons. <br/>When set, it will prevent the colon character from being picked <br/>up as a placeholder. More information can be found at:<br/><br/>http://blog.endpoint.com/2014/05/dbdpg-array-slices-and.html<br/><br/>The new version is available from CPAN:<br/><br/>http://search.cpan.org/dist/DBD-Pg/<br/><br/>hecksums:<br/><br/>6f2196ddd75d613e37a57e1ed7f0bcfc DBD-Pg-3.2.1.tar.gz<br/>ddcef35e7431742258a415069c9f1c2d303c0446 DBD-Pg-3.2.1.tar.gz<br/><br/>- -- <br/>Greg Sabino Mullane greg@turnstep.com<br/>End Point Corporation http://www.endpoint.com/<br/>PGP Key: 0x14964AC8 201405251417<br/>http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8<br/>-----BEGIN PGP SIGNATURE-----<br/><br/>iEYEAREDAAYFAlOCNXgACgkQvJuQZxSWSsgmjgCg2cqODzZF5ZJuZsUUJ2F6IeF6<br/>LD8AnjtVS2AOhnEOZPHZg1wWLBMKNmDQ<br/>=yw6M<br/>-----END PGP SIGNATURE-----<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/05/msg468.html Mon, 26 May 2014 10:34:40 +0000 DBD::Pg 3.1.0 released (driver for Postgres) by Greg Sabino Mullane <br/>-----BEGIN PGP SIGNED MESSAGE-----<br/>Hash: RIPEMD160<br/><br/><br/>Version 3.1.0 of DBD::Pg, DBI driver for PostgreSQL, has <br/>been uploaded to CPAN.<br/><br/>Changes:<br/><br/>Version 3.1.0 Released April 4, 2014 (git commit 26517a3531f93de79375a02da45a79789cd3caae)<br/><br/> - Make sure UTF-8 enabled notifications are handled correctly<br/> [Greg Sabino Mullane]<br/><br/> - Allow &quot;WITH&quot; and &quot;VALUES&quot; as valid words starting a DML statement<br/> [Greg Sabino Mullane] (CPAN bug #92724)<br/><br/><br/>Checksums:<br/><br/>dc350b9eeb5316e2ae0f574a64ff333c DBD-Pg-3.1.0.tar.gz<br/>322b201281949afb55cbdfdf78e89618053f16f5 DBD-Pg-3.1.0.tar.gz<br/><br/>- -- <br/>Greg Sabino Mullane greg@turnstep.com<br/>End Point Corporation http://www.endpoint.com/<br/>PGP Key: 0x14964AC8 201404050758<br/>http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8<br/>-----BEGIN PGP SIGNATURE-----<br/><br/>iEYEAREDAAYFAlM/7/AACgkQvJuQZxSWSshA5gCgll06SlSIodlQx4tUX/gMJX4Y<br/>OmQAni2ZZbEjS6D7F/KRqhJtIENmpK+s<br/>=LjS5<br/>-----END PGP SIGNATURE-----<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/04/msg467.html Sun, 06 Apr 2014 11:22:10 +0000 New trial version of DBD::ORale on its way to CPAN by Yanick Champoux Hi all,<br/><br/>A new trial version of DBD::Oracle is on its way to CPAN (changelog is <br/>below).<br/><br/>As usual, a big &quot;thank you&quot; to the reporters, patchers and general <br/>helpers who made this release possible (this time around, those would be <br/>Witold, Andy, Martin, Heinrich and Mike).<br/><br/>Enjoy!<br/><br/>1.71_00 2014-03-31<br/> - Recognizes __CYGWIN64__. (RT88709, reported by Witold Petriczek)<br/> - CHOOSE hint is deprecated. (RT91217, reported by Andy Bucksch,<br/> fix by Martin J Evans)<br/> - Set UTF8 flag per-connection. (RT88185, reported by Heinrich <br/>Mislik, patch by Martin J. Evans)<br/> - Add a CONTRIBUTING.mkd file. (GH#2)<br/> - Add SELinux trick. (RT#87003, patch submitted by Mike Doherty)<br/><br/><br/>`/anick<br/><br/>-- <br/><br/><br/>--<br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/03/msg466.html Mon, 31 Mar 2014 16:16:28 +0000 DBD::mysql 4.027 released by Patrick Galbraith Dear Perl community,<br/><br/>I&rsquo;m pleased to announce the release of DBD::mysql 4.027. This release isn&rsquo;t a huge release but has some nice fixes nonetheless. Particularly, some fixes that improve building and installing on OS X.<br/><br/>Per the change log:<br/><br/>2014-13-15 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.027)<br/>* Added more OS X notes and fixed compiler warnings<br/>* Skip tests if test database is not present-RT92330 (zefram &lt;zefram at fysh dot org&gt;<br/>* metacpan.org and search.cpan.org didn&#39;t display module POD, caused by fix for RT90101. Reported by Oleg, RT92350.<br/><br/>As before, thank you to Michael Beijen and the community for your help!<br/><br/>You can find the latest in github:<br/><br/>https://github.com/perl5-dbi/DBD-mysql<br/><br/>As well as CPAN:<br/><br/>http://search.cpan.org/~capttofu/DBD-mysql-4.027/lib/DBD/mysql.pm<br/><br/>Thank you for using DBD::mysql!<br/><br/>Patrick Galbraith<br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/03/msg465.html Tue, 25 Mar 2014 17:30:47 +0000 New DBD::ODBC 1.47 release by Martin J. Evans I have just uploaded DBD::ODBC 1.47 to the CPAN.<br/><br/>This release does contain significant changes in behaviour for unicode builds of DBD::ODBC so I hope when I warned you months ago you tested it.<br/><br/>Thanks to everyone on the dbi-dev list and irc that helped me work my way through the unicode issue.<br/><br/>I&#39;m now going to sit back and wait for the usual rush of reports from everyone who didn&#39;t test it.<br/><br/>See below for changes since last full release.<br/><br/>Martin<br/><br/>1.47 2014-02-19<br/><br/> Full release of the 1.46 development releases.<br/><br/> [MISCELLANEOUS]<br/><br/> Just some tidying up of dbdimp.c - shouldn&#39;t make a difference to anyone.<br/><br/> Further changes to this change file to make it CPAN::Changes spec.<br/> NOTE the changes.cpanhq.com site does not yet support &quot;unknown&quot; for<br/> dates.<br/><br/>1.46_2 2013-12-17<br/><br/> [BUG FIXES]<br/><br/> When built with unicode support and odbc_old_unicode is not enabled<br/> columns reported as SQL_LONGVARCHAR were not by default bound as<br/> SQL_WCHAR and hence were not returned correctly unless the bind was<br/> overridden.<br/><br/> [MISCELLANEOUS]<br/><br/> Added test 90_trace_flag.t<br/><br/>1.46_1 2013-11-16<br/><br/> [CHANGE IN BEHAVIOUR]<br/><br/> As warned in release 1.45, the binding of unicode parameters to<br/> char/varchar columns has changed significantly. If you don&#39;t attempt<br/> to insert unicode into char/varchar columns or if you only inserted<br/> unicode into nchar/nvarchar columns you should see no difference.<br/> From this release, unicode data inserted into<br/> char/varchar/longvarchar columns is bound as SQL_WCHAR and not<br/> whatever the driver reports the parameter as (which is mostly<br/> SQL_CHAR).<br/><br/> Previously if DBD::ODBC received an error or (SQL_SUCCESS_WITH_INFO)<br/> from an ODBC API call and then the driver refused to return the<br/> error state/text DBD::ODBC would issue its own error saying &quot;Unable<br/> to fetch information about the error&quot; and state IM008. That state<br/> was wrong and has been changed to HY000.<br/><br/> [BUG FIXES]<br/><br/> Some drivers cannot support catalogs and/or schema names in<br/> SQLTables. Recent changes set the schema/catalog name to the empty<br/> string (good reasons below) which causes &quot;optional feature not<br/> implemented&quot; from MS Access (which does not support schemas - even<br/> for a simply ping (which uses SQLTables)). Now we call<br/> SQLCATALOG_NAME and SQLSCHEMA_USAGE on connect to ascertain support<br/> which modifies SQLTables call.<br/><br/> [MISCELLANEOUS]<br/><br/> Added test 45_unicode_varchar.t for MS SQL Server only so far.<br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/02/msg464.html Wed, 19 Feb 2014 17:05:49 +0000 DBD::Oracle v1.70 is on its way to CPAN by Yanick Champoux Hi all,<br/><br/>Release v1.69_02 has been promoted to v1.70. Again, thanks to all <br/>contributors who made this release possible!<br/><br/>1.70 2014-02-12<br/>- promote 1.69_02 to stable.<br/><br/>1.69_02 2014-01-19<br/><br/>[IMPROVEMENTS]<br/><br/>- The DSN &#39;dbi:Oracle:sid=foo&#39; is now an alias for &#39;dbi:Oracle:foo&#39;.<br/>(RT#91775, Yanick Champoux, requested by David Wheeler)<br/><br/>- Support for ORA_SYSBACKUP, ORA_SYSDG and ORA_SYSKM. (RT#91473,<br/>Kris Lemaire)<br/><br/>[BUG FIXES]<br/><br/>- OCI_THREADED setting had been accidentally removed, causing potential<br/>crashes when using threads. (RT#92229, Martin J. Evans, reported<br/>by Detlef L&#xFFFD;tticke)<br/><br/>- When using fetch*_hashref the values are decoded but<br/>not the keys so if you have unicode column names they were not<br/>returned correctly. (RT#92134, Martin J. Evans, reported by<br/>Marcel Montes)<br/><br/><br/>1.69_01 2014-01-14<br/><br/>[BUG FIXES]<br/><br/>- Fix RT91698. If you bound an output parameter to a scalar and<br/>repeatedly called execute the memory allocated in your bound<br/>scalar could increase each time. (Martin J. Evans)<br/><br/><br/><br/><br/>Joy,<br/>`/anick<br/><br/><br/><br/>-- <br/><br/><br/>--<br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/02/msg463.html Thu, 13 Feb 2014 09:33:38 +0000 PostgreSQL driver DBD::Pg releases version 3.0.0 by Greg Sabino Mullane <br/>-----BEGIN PGP SIGNED MESSAGE-----<br/>Hash: RIPEMD160<br/><br/>Version 3.0.0 of DBD::Pg, the Perl interface to Postgres,<br/>has just been released. As you can see from the version <br/>number, this is a major release. In addition to many <br/>bugfixes and enhancements, the behavior of pg_enable_utf8 <br/>has been changed. The minimum versions of Perl (5.8.1) <br/>and DBI (1.614) have been increased.<br/><br/>The new version is available from CPAN. Checksums:<br/><br/>58c2613bcb241279aca4c111ba16db48 DBD-Pg-3.0.0.tar.gz<br/>03ded628d453718cbceaea906da3412df5a7137a DBD-Pg-3.0.0.tar.gz<br/><br/>The complete list of changes:<br/><br/>Version 3.0.0<br/><br/> - Major change in UTF-8 handling. If client_encoding is set to UTF-8, <br/> always mark returned Perl strings as utf8. See the pg_enable_utf8 docs<br/> for more information.<br/> [Greg Sabino Mullane, David E. Wheeler, David Christensen]<br/><br/> - Bump DBI requirement to 1.614<br/><br/> - Bump Perl requirement to 5.8.1<br/><br/> - Add new handle attribute, switch_prepared, to control when we stop <br/> using PQexecParams and start using PQexecPrepared. The default is 2: <br/> in previous versions, the effective behavior was 1 (i.e. PQexecParams <br/> was never used).<br/> [Greg Sabino Mullane]<br/><br/> - Better handling of items inside of arrays, particularly bytea arrays.<br/> [Greg Sabino Mullane] (CPAN bug #91454)<br/><br/> - Map SQL_CHAR back to bpchar, not char<br/> [Greg Sabino Mullane, reported by H.Merijn Brand]<br/><br/> - Do not force oids to Perl ints<br/> [Greg Sabino Mullane] (CPAN bug #85836)<br/><br/> - Return better sqlstate codes on fatal errors<br/> [Rainer Weikusat]<br/><br/> - Better prepared statement names to avoid bug<br/> [Spencer Sun] (CPAN bug #88827)<br/><br/> - Add pg_expression field to statistics_info output to show <br/> functional index information<br/> [Greg Sabino Mullane] (CPAN bug #76608)<br/><br/> - Adjust lo_import_with_oid check for 8.3<br/> (CPAN bug #83145)<br/><br/> - Better handling of libpq errors to return SQLSTATE 08000<br/> [Stephen Keller]<br/><br/> - Make sure CREATE TABLE .. AS SELECT returns rows in non do() cases<br/><br/> - Add support for AutoInactiveDestroy<br/> [David Dick] (CPAN bug #68893)<br/><br/> - Fix ORDINAL_POSITION in foreign_key_info<br/> [Dagfinn Ilmari Mannsker] (CPAN bug #88794)<br/><br/> - Fix foreign_key_info with unspecified schema<br/> [Dagfinn Ilmari Mannsker] (CPAN bug #88787)<br/><br/> - Allow foreign_key_info to work when pg_expand_array is off<br/> [Greg Sabino Mullane and Tim Bunce] (CPAN bug #51780)<br/><br/> - Remove math.h linking, as we no longer need it<br/> (CPAN bug #79256)<br/><br/> - Spelling fixes<br/> (CPAN bug #78168)<br/><br/> - Better wording for the AutoCommit docs<br/> (CPAN bug #82536)<br/><br/> - Change NOTICE to DEBUG1 in t/02attribs.t test for handle attribute &quot;PrintWarn&quot;:<br/> implicit index creation is now quieter in Postgres.<br/> [Erik Rijkers]<br/><br/> - Use correct SQL_BIGINT constant for int8<br/> [Dagfinn Ilmari Mannsker]<br/><br/> - Fix assertion when binding array columns on debug perls &gt;= 5.16<br/> [Dagfinn Ilmari Mannsker]<br/><br/> - Adjust test to use 3 digit exponential values<br/> [Greg Sabino Mullane] (CPAN bug #59449)<br/><br/> - Avoid reinstalling driver methods in threads<br/> [Dagfinn Ilmari Mannsker] (CPAN bug #83638)<br/><br/> - Make sure App::Info does not prompt for pg_config location <br/> if AUTOMATED_TESTING or PERL_MM_USE_DEFAULT is set<br/> [David E. Wheeler] (CPAN bug #90799)<br/><br/> - Fix typo in docs for pg_placeholder_dollaronly<br/> [Bryan Carpenter] (CPAN bug #91400)<br/><br/> - Cleanup dangling largeobjects in tests<br/> [Fitz Elliott] (CPAN bug #92212)<br/><br/> - Fix skip test counting in t/09arrays.t<br/> [Greg Sabino Mullane] (CPAN bug #79544)<br/><br/> - Explicitly specify en_US for spell checking<br/> [Dagfinn Ilmari Mannsker] (CPAN bug #91804)<br/><br/><br/>- -- <br/>Greg Sabino Mullane greg@turnstep.com<br/>End Point Corporation http://www.endpoint.com/<br/>PGP Key: 0x14964AC8 201402050932<br/>http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8<br/>-----BEGIN PGP SIGNATURE-----<br/><br/>iEYEAREDAAYFAlLyS34ACgkQvJuQZxSWSsjLcgCeM413ALNdM7rj4SfYMnyEmee5<br/>VtAAnj56tNtWoK9dWJKVg1wHgTsXBXok<br/>=6wwX<br/>-----END PGP SIGNATURE-----<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/02/msg462.html Wed, 05 Feb 2014 15:49:58 +0000 Announce: DBI 1.631 by Tim Bunce file: $CPAN/authors/id/T/TI/TIMB/DBI-1.631.tar.gz<br/> size: 589096 bytes<br/> md5: 444d3c305e86597e11092b517794a840<br/><br/>=head2 Changes in DBI 1.631 - 20th Jan 2014<br/><br/>NOTE: This release changes the handle passed to Callbacks from being an &#39;inner&#39;<br/>handle to being an &#39;outer&#39; handle. If you have code that makes use of Callbacks,<br/>ensure that you understand what this change means and review your callback code.<br/><br/> Fixed err_hash handling of integer err RT#92172 [Dagfinn Ilmari]<br/> Fixed use of \Q vs \E in t/70callbacks.t<br/><br/> Changed the handle passed to Callbacks from being an &#39;inner&#39;<br/> handle to being an &#39;outer&#39; handle.<br/><br/> Improved reliability of concurrent testing<br/> PR#8 [Peter Rabbitson]<br/> Changed optional dependencies to &quot;suggest&quot;<br/> PR#9 [Karen Etheridge]<br/> Changed to avoid mg_get in neatsvpv during global destruction<br/> PR#10 [Matt Phillips]<br/><br/>=cut<br/><br/>Many thanks to all the contributors.<br/><br/>Enjoy!<br/><br/>Tim.<br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/01/msg461.html Mon, 20 Jan 2014 15:20:11 +0000 DBD::Oracle trial release v1.69_02 on its way to CPAN by Yanick Champoux Hi all,<br/><br/> A new trial release of DBD::Oracle is on its way to CPAN. A rather <br/>nasty thread bug was found,<br/>and I took the opportunity to push in a few more patches.<br/><br/> As usual, thanks to everybody who contributed (in this instance, <br/>Martin J. Evans, Detlef Luetticke, Marcel Montes and David Wheeler).<br/><br/>Enjoy!<br/>`/anick<br/><br/>1.69_02 2014-01-19<br/><br/> [IMPROVEMENTS]<br/><br/> - The DSN &#39;dbi:Oracle:sid=foo&#39; is now an alias for &#39;dbi:Oracle:foo&#39;.<br/> (RT#91775, Yanick Champoux, requested by David Wheeler)<br/><br/> - Support for ORA_SYSBACKUP, ORA_SYSDG and ORA_SYSKM. (RT#91473,<br/> Kris Lemaire)<br/><br/> [BUG FIXES]<br/><br/> - OCI_THREADED setting had been accidentally removed, causing potential<br/> crashes when using threads. (RT#92229, Martin J. Evans, reported<br/> by Detlef Luetticke)<br/><br/> - When using fetch*_hashref the values are decoded but<br/> not the keys so if you have unicode column names they were not<br/> returned correctly. (RT#92134, Martin J. Evans, reported by<br/> Marcel Montes)<br/><br/><br/>-- <br/><br/><br/>--<br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/01/msg460.html Mon, 20 Jan 2014 11:21:57 +0000 DBD::mysql 4.026 released by Patrick Galbraith Dear Perl and MySQL community,<br/><br/>I&rsquo;m pleased to announce the release of DBD::mysql 4.026<br/><br/>In this release:<br/><br/>2014-01-15 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.026)<br/>* t/29warnings.t fails on MySQL Server 5.1.something - Reported by RT91202, Gisle Aas. Now is handled depending on version.<br/>* README.pod misses proper NAME heading - RT90101 - Damyan Ivanov, Debian Perl Group<br/>* Added fix and test for RT91715 (ability to obtain $dbh-&gt;{mysql_use_result} value)<br/>* Added feature from Jacob Gelbman (cPanel) mysql_skip_secure_auth<br/><br/>Thanks to everyone who contributed!<br/><br/>For more information: http://search.cpan.org/~capttofu/DBD-mysql-4.026<br/><br/>Regards,<br/><br/>Patrick<br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/01/msg459.html Fri, 17 Jan 2014 23:04:46 +0000 DBD::Oracle trial release v1.69_01 on its way to CPAN by Yanick Champoux Hi everybody,<br/><br/>A very small, yet important, release of DBD::Oracle is rushing toward <br/>CPAN as we speak. It addresses a potential memory leak. As always, <br/>respects to Martin J. Evans for his mastery of the DBD inner workings, <br/>and eternal gratitude for his patches. :-)<br/><br/>(and, as usual, release will go general after 2 weeks of uneventful soaking)<br/><br/>1.69_01 2014-01-14<br/><br/> [BUG FIXES]<br/><br/> - Fix RT91698. If you bound an output parameter to a scalar and<br/> repeatedly called execute the memory allocated in your bound<br/> scalar could increase each time. (Martin J. Evans)<br/><br/><br/>Cheers,<br/>`/anick<br/><br/>-- <br/>Yanick Champoux<br/>Solutions Architect<br/>Pythian - Love your data<br/><br/>champoux@pythian.com<br/><br/>Tel: +1 613 565 8696 x 274<br/>www.pythian.com<br/><br/>-- <br/><br/><br/>--<br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2014/01/msg458.html Tue, 14 Jan 2014 18:59:02 +0000 DBD::ODBC 1.46_1 released - You REALLY need to test this release by Martin J. Evans I&#39;ve just uploaded DBD::ODBC 1.46_1 to the CPAN. In the process of <br/>writing <br/>http://www.easysoft.com/developer/languages/perl/sql-server-unicode.html <br/>and https://github.com/mjegh/dbd_odbc_sql_server_unicode I discovered a <br/>serious bug in the way DBD::ODBC can attempt to insert unicode <br/>characters into char/varchar/longvarchar columns. This experimental <br/>release fixes that issue but it does mean this release contains a <br/>significant change in behaviour.<br/><br/>The issue ONLY applied to unicode builds of DBD::ODBC (the default on <br/>Windows) and enabled in Linux/Unix via the -u switch to Makefile.PL.<br/><br/>The problem was that when inserting parameter data into <br/>char/varchar/longvarchar columns DBD::ODBC ignored what your parameter <br/>actually looked like and simply bound the parameter as the type <br/>described by the database (SQL_CHAR). This meant that if you bound data <br/>was unicode, the separate octets of the perl UTF-8 encoded data would be <br/>inserted instead of the unicode characters. A simple example illustrates <br/>this easiest:<br/><br/>Say you had a unicode euro in a perl scalar. This is U+20AC and is <br/>encoded in UTF-8 as 0xe2,0x82,0xc2. If you inserted into a <br/>char/varchar/longvarchar the database would receive it as 3 separate <br/>chrs instead of 1 i.e., select len(mycol) from mytable would return 3 <br/>instead of 1.<br/><br/>There are a few situations when this did not apply 1) if you overrode <br/>the bind type with SQL_WVARCHAR 2) if your ODBC driver did not support <br/>SQLDescribeParam or you told DBD::ODBC not to use it.<br/><br/>A new test (45_unicode_varchar.t which has high verbosity set right now) <br/>has been added to the test suite. Unfortunately, this test only runs to <br/>MS SQL Server right now. If this test does not pass for you please <br/>report it and the output to me as soon as possible.<br/><br/>You are strongly advised to test this release with your development <br/>environment as I&#39;ve not implemented a deprecation policy for this change <br/>as yet. I&#39;m hoping to release a full version as 1.46_1 is, BUT if it is <br/>reported to me that this will cause too many people problems I&#39;ll <br/>reconsider.<br/><br/>I full description of the issues and other problems can be found at <br/>http://www.easysoft.com/developer/languages/perl/sql-server-unicode.html <br/>and https://github.com/mjegh/dbd_odbc_sql_server_unicode.<br/><br/>Here is a full list of the changes since 1.45:<br/><br/> [CHANGE IN BEHAVIOUR]<br/><br/> As warned in release 1.45, the binding of unicode parameters to<br/> char/varchar columns has changed significantly - see warning at<br/> start of DBD::ODBC pod. If you don&#39;t attempt to insert unicode into<br/> char/varchar columns or if you only inserted unicode into<br/> nchar/nvarchar columns you should see no difference.<br/><br/> Previously if DBD::ODBC received an error or (SQL_SUCCESS_WITH_INFO)<br/> from an ODBC API call and then the driver refused to return the<br/> error state/text DBD::ODBC would issue its own error saying &quot;Unable<br/> to fetch information about the error&quot; and state IM008. That state<br/> was wrong and has been changed to HY000.<br/><br/> [BUG FIXES]<br/><br/> Some drivers cannot support catalogs and/or schema names in<br/> SQLTables. Recent changes set the schema/catalog name to the empty<br/> string (good reasons below) which causes &quot;optional feature not<br/> implemented&quot; from MS Access (which does not support schemas - even<br/> for a simply ping (which uses SQLTables)). Now we call<br/> SQLCATALOG_NAME and SQLSCHEMA_USAGE on connect to ascertain support<br/> which modifies SQLTables call.<br/><br/> [MISCELLANEOUS]<br/><br/> Added test 45_unicode_varchar.t for MS SQL Server only so far.<br/><br/>Martin<br/>-- <br/>Martin J. Evans<br/>Wetherby, UK<br/> http://www.nntp.perl.org/group/perl.dbi.announce/2013/11/msg457.html Sun, 17 Nov 2013 14:46:31 +0000 DBD::mysql 4.025 released, by Patrick Galbraith I&#39;m pleased to announce the release of DBD::mysql 4.025. This fix includes the following:<br/><br/>* Set with parentheses and column_info - RT50304 - reported and fixed by Kevin Bosak.<br/>* Fix method redefinition warnings in threads on Perl &gt;= 5.16 - Dagfinn Ilmari Manns&aring;ker<br/>* use strict and warnings everywhere.<br/>* Minimum perl version is now 5.8.1, just as for DBI.<br/>* Improved database version check so tests run correctly on MariaDB 10.<br/>* Fix manifest - RT89106, reported by Joe Grasse.<br/>* set auto_increment_offset explicitly to make tests pass if they are set on server - RT83487, reported by Ian Barton.<br/>* Assume &#39;localhost&#39; when testport is set but no testhost in Makefile.PL - RT83496, reported by Philip Stoev.<br/>* Corrected documentation for mysql_init_command option - Alexey Molchanov &lt;alexey.molchanov@portaone.com&gt;<br/>* Skip stored procedure tests if user is unpriviliged - RT83348 - Chris Weyl &lt;cweyl@alumni.drew.edu&gt;<br/>* Fix example in POD doc for NUM_OF_FIELDS - RT36730, reported by tapoutmma.<br/>* Fix for memory leak (RT86153) when connecting with incorrect password<br/>* Bail if connect fails early on (RT31823)<br/><br/>I would like again to thank Michiel Beijen, Chris Weyl, Alexey Molchanov, tapoutmma, Ian Barton, Philip Stoev, Joe Grasse, Dagfinn Ilmari Manns&aring;ker, Kevin Bosak and several others who made this release possible!<br/><br/>You can download DBD::mysql using CPAN as well as <br/><br/>http://search.cpan.org/~capttofu/DBD-mysql-4.025/<br/><br/>file: $CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.025.tar.gz<br/> size: 135538 bytes<br/> md5: 093ed74c3bd327d4e0d0bc70d1035ac3<br/><br/>Regards,<br/><br/>Patrick<br/> http://www.nntp.perl.org/group/perl.dbi.announce/2013/11/msg456.html Sun, 10 Nov 2013 20:56:45 +0000 Trial DBD::Oracle v1.67_00 on its way to CPAN by Yanick Champoux Hi all,<br/><br/>A new trial version of DBD::Oracle is on its way to CPAN. As usual, if <br/>everything goes well, the release will be promoted to general <br/>availability in 2 weeks.<br/><br/>And just as usual, a big thanks to the contributors -- Steffen Goeldner, <br/>Gregor Herrman and the ever-present Martin Evans -- having provided the <br/>bug reports, patches and support for this iteration. You guys rock.<br/><br/>Cheers,<br/>`/anick<br/><br/><br/>1.67_00 2013-11-05<br/><br/> [BUG FIXES]<br/> - Fix RT88135. Add statistics_info support (patch by Steffen Goeldner)<br/> - Fix RT89491. Add RULE hint (patch by Steffen Goeldner)<br/><br/> [DOCUMENTATION]<br/> - POD typos (RT#88285, RT#88284, Gregor Herrman).<br/><br/><br/>-- <br/>Yanick Champoux<br/>Solutions Architect<br/>Pythian - Love your data<br/><br/>champoux@pythian.com<br/><br/>Tel: +1 613 565 8696 x 274<br/>www.pythian.com<br/><br/>-- <br/><br/><br/>--<br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2013/11/msg455.html Wed, 06 Nov 2013 09:28:08 +0000 DBD::ODBC 1.45 released by Martin J. Evans I&#39;ve just uploaded DBD::ODBC 1.45 to the CPAN. As always I&#39;d draw your attention to a few small changes in behaviour. The changes since 1.43 are listed below but I need to warn you about an upcoming change first.<br/><br/>WARNING - PLEASE READ:<br/>=====<br/>The next development cycle of DBD::ODBC will contain signficant changes to the way unicode strings in your Perl scripts are inserted into CHAR and VARCHAR columns. In an attempt to write up exactly how this all works (see https://github.com/mjegh/dbd_odbc_sql_server_unicode and http://www.mail-archive.com/dbi-dev@perl.org/msg07364.html) I have discovered that unicode strings are not being inserted into CHAR/VARCHAR columns correctly in the unicode build of DBD::ODBC. There may also be changes to how unicode strings are read back from the database but I have not evaluated that yet.<br/><br/>Please make sure you keep an eye out of DBD::ODBC development releases 1.46_N and ensure you test them before the next full release is made. In the mean time if you are using unicode with DBD::ODBC and have any comments, have hit any strange issues or are using any workarounds I strongly urge you to contact me now before I get too far into these changes.<br/>=====<br/><br/>Thanks to everyone who has contributed with code or advice.<br/><br/>Here are the changes since 1.43:<br/><br/>=head2 1.45 2013-10-28<br/><br/> [CHANGE IN BEHAVIOUR]<br/><br/> There is no intentional change in behaviour in this release but I&#39;m<br/> adding a warning that the next development release is highly liking<br/> to contain some significant unicode changes in behaviour to fix some<br/> bugs which have been around for quite a long time now.<br/><br/> [BUG FIXES]<br/><br/> If an SQLExecute ODBC API call returned SQL_NO_DATA DBD::ODBC was<br/> still calling SQLError (which was a waste of time).<br/><br/> Since 1.44_1 odbc_out_connect_string stopped returning anything.<br/><br/> [MISCELLANEOUS]<br/><br/> Added another link to resources for supplementary characters.<br/><br/> Added 1 more test to 20SqlServer.t for update statement.<br/><br/> Small changes to 20SqlServer.t test to skip some tests and note the<br/> problem if SQLExecute returns SQL_NO_DATA on a non searched update.<br/><br/>=head2 1.44_4 2013-10-16<br/><br/> [BUG FIXES]<br/><br/> Fix method redefinition warnings in threads on Perl &gt;= 5.16 thanks<br/> Dagfinn Ilmari Manns&aring;ker<br/><br/> [MISCELLANEOUS]<br/><br/> Changed this Changes file to be closer to the version 0.03 change<br/> file spec.<br/><br/> Added t/version.t test.<br/><br/> Added recommends Test::Version.<br/><br/> Updates to the odbc_more_results pod to help clarify its use after<br/> some confusion was seen in a perlmonks thread.<br/><br/>=head2 1.44_3 2013-10-11<br/><br/> [CHANGE IN BEHAVIOUR]<br/><br/> If you attempt to set the ReadOnly attribute and the underlying<br/> ODBC driver does not support this (SQL_SUCCESS_WITH_INFO and &quot;option<br/> value changed&quot; is returned) a warning is issued. However, until RT<br/> 89015 &quot;You cannot issue a warning in the STORE method&quot; in DBI is<br/> resolved you won&#39;t get this warning. As DBI 1.628 it is not<br/> resolved. I&#39;ve only seen the SQLite ODBC driver do this.<br/><br/> If you set ReadOnly and the underlying ODBC driver does not<br/> support this then any subsequent attempts to fetch the ReadOnly<br/> attribute will return the value you set.<br/><br/> [BUG FIXES]<br/><br/> The 82_table_info test assumed all database and ODBC Drivers<br/> supported catalogs and schemas (some don&#39;t). Use get_info to<br/> find out if catalogs and schemas are supported before<br/> running these tests.<br/><br/> The rt_79190.t could incorrectly fail if your test DSN contained<br/> the DRIVER attribute.<br/><br/> [MISCELLANEOUS]<br/><br/> Added RedHat spec file to examples courtesy of Michiel Beijen.<br/><br/> Added &quot;use strict&quot; to FAQ/Changes etc to quieten kwalitee test.<br/><br/> Added a workaround in the test suite for a probable bug in the<br/> postgres ODBC driver which does not return COLUMN_SIZE from<br/> SQLGetTypeInfo. It also issues a warning. See<br/> http://www.postgresql.org/message-id/524EF455.6050409@ntlworld.com<br/><br/>=head2 1.44_3 2013-10-11<br/><br/> [MISCELLANEOUS]<br/><br/> Skip 70execute_array_native.t test if MS Access - even if behind an<br/> ODBC Bridge.<br/><br/> Fixed some compiler warnings when attempting to print/trace SvCUR.<br/><br/>=head2 1.44_2 2013-09-07<br/><br/> [BUG FIXES]<br/><br/> When table_info was called with a &#39;%&#39; for any one of the catalog,<br/> schema or type arguments with the rest all &#39;&#39; (the empty string),<br/> only a list of catalogs, schemas or types should be returned. It was<br/> not doing that as it was changing empty strings to undef/NULL.<br/><br/> pod for odbc_lob_read had an example only saying lob_read.<br/><br/> TYPE attribute for odbc_lob_read was actually coded as Type. It is<br/> now as documented.<br/><br/> The example lob_read.pl had the TYPE set to 999 from when I was<br/> testing it but it got checked in like this.<br/><br/> MANIFEST contained column_info.pl but the file was coltest.pl<br/><br/> [MISCELLANEOUS]<br/><br/> Fixed RT 86379 - spelling mistakes in ODBC.pm and FAQ - thanks<br/> to David Steinbrunner.<br/><br/> Added 82_table_info.t test.<br/><br/> Added 87_odbc_log_read.t test.<br/><br/>=head2 1.44_1 2013-06-06<br/><br/> Moved from subversion to github as svn.perl.org is closing down.<br/> Changed docs to show new repository.<br/><br/> [BUG FIXES]<br/><br/> Fixed RT 84450 - Database Handle Attribute Fetch broken. Thanks to<br/> Stephen Oberholtzer for finding and supplying patch.<br/><br/> Fixed problem with attributes on bind_col not being sticky. You&#39;ll<br/> probably only see this if you are using fetchall_arrayref with a<br/> slice and setting TYPE or attributes in bind_col first.<br/><br/>Martin<br/> http://www.nntp.perl.org/group/perl.dbi.announce/2013/10/msg454.html Tue, 29 Oct 2013 16:30:05 +0000 Announce: DBI 1.630 by Tim Bunce file: $CPAN/authors/id/T/TI/TIMB/DBI-1.630.tar.gz<br/> size: 588554 bytes<br/> md5: 306020fe7b54a53773f54ad581af8c54<br/><br/>=head2 Changes in DBI 1.630 - 28th Oct 2013<br/><br/>NOTE: This release enables PrintWarn by default regardless of $^W.<br/>Your applications may generate more log messages than before.<br/><br/> Fixed err for new drh to be undef not to 0 [Martin J. Evans]<br/> Fixed RT#83132 - moved DBIstcf* constants to util<br/> export tag [Martin J. Evans]<br/> PrintWarn is now triggered by warnings recorded in methods like STORE<br/> that don&#39;t clear err RT#89015 [Tim Bunce]<br/><br/> Changed tracing to no longer show quote and quote_identifier calls<br/> at trace level 1.<br/> Changed DBD::Gofer ping while disconnected set_err from warn to info.<br/> Clarified wording of log message when err is cleared.<br/> Changed bootstrap to use $XS_VERSION RT#89618 [Andreas Koenig]<br/><br/> Added connect_cached.connected Callback PR#3 [David E. Wheeler]<br/><br/> Clarified effect of refs in connect_cached attributes [David E. Wheeler]<br/> Extended ReadOnly attribute docs for when the driver cannot<br/> ensure read only [Martin J. Evans]<br/> Corrected SQL_BIGINT docs to say ODBC value is used PR#5 [ilmari]<br/><br/>There was no DBI 1.629 release.<br/><br/>=cut<br/><br/>Enjoy!<br/><br/>Tim.<br/> http://www.nntp.perl.org/group/perl.dbi.announce/2013/10/msg453.html Mon, 28 Oct 2013 16:01:19 +0000 DBD::mysql 4.024 Released by Patrick Galbraith Dear community,<br/><br/>I&#39;m quite pleased to announce the release of DBD::mysql 4.024. This release has been made possible by the most-appreciated help of Michiel Beijen and others who helped me out to get some work done and the project moving. Also a great thanks to Rudy Lippan for reminding me that people were interested in helping!<br/><br/>The fixes in this release:<br/><br/>* Fix memory leak if mysql_server_prepare is enabled - RT76462 - Masahiro Chiba<br/>* Small dist improvements: Michiel Beijen &lt;michiel.beijen@otrs.com&gt;<br/>* Undefined $DBI::errstr on execute fail on Windows: Michiel Beijen &lt;michiel.beijen@otrs.com&gt;<br/>* Better diagnostics for 80procs.t Fixes RT#71199: Alexandr Ciornii &lt;alexchorny@gmail.com&gt;<br/>* Fix #64013: INSTALL.pod is shown with &#39;man install&#39;: Juergen Weigert &lt;jw@suse.com&gt;<br/>* Added &#39;testport&#39; to keys in Makefile.PL Fixes RT#83492: Michiel Beijen &lt;michiel.beijen@otrs.com&gt;<br/>* Fixed test 70takeimp warning. Michiel Beijen &lt;michiel.beijen@otrs.com&gt;<br/>* Made test t/87async.t not stop on Win32. Michiel Beijen &lt;michiel.beijen@otrs.com&gt;<br/>* Update github location. Update support information. Michiel Beijen &lt;michiel.beijen@otrs.com&gt;<br/>* POD Fixes Patch from RT77043 by Gunnar Wolf, Debian Perl Group. Michiel Beijen &lt;michiel.beijen@otrs.com&gt;<br/><br/>I hope that I&#39;ve given credit to everyone, and if I&#39;ve missed any one, I want you to know that we greatly appreciated your help!<br/><br/>The distribution can be found at:<br/><br/>http://search.cpan.org/~capttofu/DBD-mysql-4.024/lib/DBD/mysql.pm<br/><br/>Also, important to note is that the DBD::mysql git repo is now at:<br/><br/>https://github.com/perl5-dbi/DBD-mysql<br/><br/>Again, thank you and particularly thank thank you Michiel!<br/><br/>Regards,<br/><br/>Patrick Galbraith<br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2013/09/msg452.html Wed, 18 Sep 2013 08:46:38 +0000 Announcing DBI-Test 0.001 by Jens Rehsack Hi,<br/><br/>hereby I proudly announce DBI::Test-0.001.<br/><br/>It&#39;s ready to be used for converting DBD tests as well as create generic basic DBI test.<br/><br/>Cheers<br/>-- <br/>Jens Rehsack<br/>pkgsrc, Perl5<br/>rehsack@cpan.org<br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2013/08/msg451.html Wed, 07 Aug 2013 09:51:47 +0000 New trial version of DBD::Oracle is out by Yanick Champoux Hi all,<br/><br/>Another trial release of DBD::Oracle is out. As usual, the changelog is <br/>below and, pending any potential problem, the release shall be promoted <br/>to stable in 2 weeks. Also as usual, a big thank to the patchers (this <br/>time around: Martin J. Evans and David Steinbrunner).<br/><br/>Joy,<br/>`/anick<br/><br/><br/>1.65_00 2013-07-29<br/><br/> [BUG FIXES]<br/><br/> - Fix RT85886. The TYPE passed to bind_col is supposed to be sticky<br/> and it wasn&#39;t. Attributes passed to bind_col could be lost later if<br/> bind_col is called again without attributes. Both of these occur<br/> when fetchall_arrayref is called with a slice (Martin J. Evans).<br/><br/> [DOCUMENTATION]<br/><br/> - Fix a bunch of typos. [GH#5, David Steinbrunner]<br/><br/>-- <br/><br/><br/>--<br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2013/07/msg450.html Mon, 29 Jul 2013 17:36:28 +0000 Re: Announce DBI 1.628 => Announce DBD::CSV 0.39 by H.Merijn Brand On Mon, 22 Jul 2013 17:06:47 +0100, Tim Bunce &lt;Tim.Bunce@pobox.com&gt;<br/>wrote:<br/><br/>&gt; file: $CPAN/authors/id/T/TI/TIMB/DBI-1.628.tar.gz<br/>&gt; size: 586733 bytes<br/>&gt; md5: 4273f8cc6ee3979ce448c7eb3f8a6a5a<br/>&gt; <br/>&gt; =head2 Changes in DBI 1.628 - 22nd July 2013<br/>&gt; <br/>&gt; Fixed missing fields on partial insert via DBI::DBD::SqlEngine<br/>&gt; engines (DBD::CSV, DBD::DBM etc.) [H.Merijn Brand, Jens Rehsack]<br/>&gt; Fixed stack corruption on callbacks RT#85562 RT#84974 [Aaron Schweiger]<br/>&gt; Fixed DBI::SQL::Nano_::Statement handling of &quot;0&quot; [Jens Rehsack]<br/>&gt; Fixed exit op precedence in test RT#87029 [Reni Urban]<br/>&gt; <br/>&gt; Added support for finding tables in multiple directories<br/>&gt; via new DBD::File f_dir_search attribute [H.Merijn Brand]<br/>&gt; Enable compiling by C++ RT#84285 [Kurt Jaeger]<br/>&gt; <br/>&gt; Typo fixes in pod and comment [David Steinbrunner]<br/>&gt; Change DBI&#39;s docs to refer to git not svn [H.Merijn Brand]<br/>&gt; Clarify bind_col TYPE attribute is sticky [Martin J. Evans]<br/>&gt; Fixed reference to $sth in selectall_arrayref docs RT#84873<br/>&gt; Spelling fixes [Ville Skytt&auml;]<br/>&gt; Changed $VERSIONs to hardcoded strings [H.Merijn Brand]<br/>&gt; <br/>&gt; =cut<br/>&gt; <br/>&gt; Enjoy!<br/>&gt; <br/>&gt; Tim.<br/><br/>THANK YOU!<br/><br/>0.39 - 2013-06-28, H.Merijn Brand<br/> * Use f_file in docs. file is deprecated<br/> * DBD::CSV&#39;s repository moved to github<br/> * Add test for row-completeness<br/> * Fix UTF-8 tests to better follow Text::CSV_XS auto-encoding<br/> * Require more recent versions of low level modules that fixe<br/> issues reported for DBD::CSV<br/> * Development will also do mosts tests with DBI_SQL_NANO=1<br/> * Added support for f_dir_search from DBD::File (in fact DBI was<br/> changed to feature this for DBD::CSV :)<br/> * Fix test relying on spell-error in DBI&#39;s error message<br/> * Document csv_class (still undertested)<br/><br/>0.38 - 2013-01-09, H.Merijn Brand<br/> * the tar paxheaders hit again (http://www.perlmonks.org/?node_id=1004571)<br/><br/>0.37 - 2013-01-09, H.Merijn Brand<br/> * Fixed RT#80078, resulting in getline calls on undef (Benjamin Booth)<br/> * Require latest DBI and SQL::Statement<br/> * Updated copyright to 2013<br/> * Fixes for DBI-1.623 (Jens Rehsack)<br/><br/><br/>-- <br/>H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/<br/>using perl5.00307 .. 5.19 porting perl5 on HP-UX, AIX, and openSUSE<br/>http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/<br/>http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/<br/> http://www.nntp.perl.org/group/perl.dbi.announce/2013/07/msg449.html Mon, 22 Jul 2013 19:25:15 +0000 Announce DBI 1.628 by Tim Bunce file: $CPAN/authors/id/T/TI/TIMB/DBI-1.628.tar.gz<br/> size: 586733 bytes<br/> md5: 4273f8cc6ee3979ce448c7eb3f8a6a5a<br/><br/>=head2 Changes in DBI 1.628 - 22nd July 2013<br/><br/> Fixed missing fields on partial insert via DBI::DBD::SqlEngine<br/> engines (DBD::CSV, DBD::DBM etc.) [H.Merijn Brand, Jens Rehsack]<br/> Fixed stack corruption on callbacks RT#85562 RT#84974 [Aaron Schweiger]<br/> Fixed DBI::SQL::Nano_::Statement handling of &quot;0&quot; [Jens Rehsack]<br/> Fixed exit op precedence in test RT#87029 [Reni Urban]<br/><br/> Added support for finding tables in multiple directories<br/> via new DBD::File f_dir_search attribute [H.Merijn Brand]<br/> Enable compiling by C++ RT#84285 [Kurt Jaeger]<br/><br/> Typo fixes in pod and comment [David Steinbrunner]<br/> Change DBI&#39;s docs to refer to git not svn [H.Merijn Brand]<br/> Clarify bind_col TYPE attribute is sticky [Martin J. Evans]<br/> Fixed reference to $sth in selectall_arrayref docs RT#84873<br/> Spelling fixes [Ville Skytt&auml;]<br/> Changed $VERSIONs to hardcoded strings [H.Merijn Brand]<br/><br/>=cut<br/><br/>Enjoy!<br/><br/>Tim.<br/> http://www.nntp.perl.org/group/perl.dbi.announce/2013/07/msg448.html Mon, 22 Jul 2013 16:48:54 +0000 [Dbix-class] Perl School: Database Programming with Perl and DBIx::Class by Dave Cross <br/>Hi,<br/><br/>I&#39;m running my Perl School class on DBIC again this coming Saturday <br/>(June 8th). It&#39;s at Google Campus in London. It&#39;s a full-day course and <br/>tickets cost &pound;30.<br/><br/>Full details at http://prls.ch/dbic2list<br/><br/>Do you know anyone who could benefit from a one-day introduction to <br/>DBIC? Please feel free to pass on this email to them.<br/><br/>Cheers,<br/><br/>Dave...<br/><br/>-- <br/>Dave Cross :: dave@dave.org.uk<br/>http://dave.org.uk/<br/>@davorg<br/><br/>_______________________________________________<br/>List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class<br/>IRC: irc.perl.org#dbix-class<br/>SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/<br/>Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk<br/> http://www.nntp.perl.org/group/perl.dbi.announce/2013/06/msg447.html Sun, 02 Jun 2013 22:02:58 +0000 DBI article translations (was: DBI article in Korean) by Tim Bunce On Wed, May 22, 2013 at 08:55:26AM +0300, Gabor Szabo wrote:<br/>&gt; Hi,<br/>&gt; <br/>&gt; recently I published an introduction to DBI article on the Perl Maven site:<br/>&gt; http://perlmaven.com/simple-database-access-using-perl-dbi-and-sql<br/>&gt; <br/>&gt; the really interesting thing is that articles are constantly being<br/>&gt; translated to 13 languages.<br/>&gt; The Korean version has already arrived:<br/>&gt; http://ko.perlmaven.com/simple-database-access-using-perl-dbi-and-sql<br/><br/>That&#39;s great. Thanks Gabor.<br/><br/>Tim.<br/> http://www.nntp.perl.org/group/perl.dbi.announce/2013/05/msg446.html Thu, 23 May 2013 10:30:04 +0000 ANNOUNCE: Informix Database Driver for Perl DBI Version 2013.0521(2013-05-21) released by Jonathan Leffler Informix Database Driver for Perl DBI Version 2013.0521 (2013-05-21) has<br/>been uploaded to CPAN.<br/><br/>IBM Informix Database Driver for Perl (also known as DBD::Informix) is<br/>the driver code that enables Perl 5.6.1 or later to access Informix<br/>databases via the DBI module (but if you are not already using Perl<br/>5.10.0 - or any later version - you should be planning to upgrade to<br/>Perl 5.16.2 or later). You will need the code for DBI version 1.38 or<br/>later as well (v1.623 - or any later version - is recommended). The<br/>code for DBD::Informix is available for download via:<br/><br/>http://www.perl.org/CPAN/modules/by-category/07_Database_Interfaces<br/>http://dbi.perl.org/<br/><br/>** When you successfully build this module, use the ItWorks (Perl)<br/>** script to report your configuration to the maintenance team (meaning<br/>** Jonathan Leffler) at dbd.informix@gmail.com.<br/>** The ItWorks script does not send email to anybody; you have to do<br/>** that yourself.<br/><br/>New in release 2013.0521<br/>* Support CSDK 4.10 for IDS 12.10<br/>* Change work email address to jleffler@google.com<br/><br/>New in release 2013.0206:<br/>* Bug fix release (not generally available).<br/>* Properly handle the new ESQL/C version 4.10.<br/><br/>New in release 2013.0113:<br/>* Bug fix release.<br/>* Workaround for bug in ESQL/C 3.70 and earlier that generates error -1820<br/> when reopening a cursor that previously fetched LVARCHAR data.<br/>* Fix for INFORMIXDIR containing Perl regex metacharacters.<br/>* Other minor improvements as documented in the ChangeLog.<br/>* Formal support for ESQL/C 7.x and 8.x (don&#39;t ask why the<br/> current version numbers are smaller) will be dropped after this<br/> release. The code won&#39;t go away yet, but it is beyond time to<br/> get off those versions. ESQL/C 5.20 is nominally supported for<br/> those still using Informix OnLine 5.20, but there is no<br/> testing on that platform.<br/><br/>New in release 2011.0612:<br/>* Minor bug fix release.<br/>* Main change is related to Perl internals and avoids the need for<br/> PERL_POLLUTE. This change is not visible to users except that Perl<br/> 5.14.x can use the fixed code.<br/>* Fixed problem with string that is not null terminated by ESQL/C library.<br/>* Clean up some 64-bit compilation warnings.<br/>* Build on AIX.<br/>* Evade problem with a DISTINCT type of LVARCHAR with NOT NULL (probably<br/> ESQL/C bug).<br/>* Fewer versions of Informix products are supported. You may try<br/> building DBD::Informix with other versions. If it works, great; if<br/> not, please upgrade to a supported Informix version.<br/><br/>Support email address:<br/>* This release is supported by Jonathan Leffler &lt;dbd.informix@gmail.com&gt;.<br/>* You may also report your bugs via the CPAN resolution tracking system:<br/> http://rt.cpan.org/<br/>* Such bug reports can be sent by email to bug-DBD-Informix@rt.cpan.org;<br/> they also get sent to dbd.informix@gmail.com, etc.<br/><br/>As always, see the ChangeLog file for details about what has changed.<br/><br/>Jonathan Leffler (jleffler@google.com, jonathan.leffler@gmail.com)<br/><br/>@(#)$Id: Announce,v 2013.6 2013/05/22 05:41:29 jleffler Exp $<br/><br/>-- <br/>Jonathan Leffler &lt;jonathan.leffler@gmail.com&gt; #include &lt;disclaimer.h&gt;<br/>Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org<br/>&quot;Blessed are we who can laugh at ourselves, for we shall never cease to be<br/>amused.&quot;<br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2013/05/msg445.html Wed, 22 May 2013 09:51:44 +0000 ANNOUNCE DBI-1.627 by Tim Bunce file: $CPAN/authors/id/T/TI/TIMB/DBI-1.627.tar.gz<br/> size: 585833 bytes<br/> md5: aab49be51b0f4867a1894145b023d2c5<br/><br/><br/>The primary DBI repository is now on github under the<br/>ownership of the &quot;perl5-dbi&quot; team:<br/><br/> https://github.com/perl5-dbi/dbi<br/> https://github.com/perl5-dbi?tab=members<br/><br/><br/>=head2 Changes in DBI 1.627 - 16th May 2013<br/><br/> Fixed VERSION regression in DBI::SQL::Nano [Tim Bunce]<br/><br/>=head2 Changes in DBI 1.626 - 15th May 2013<br/><br/> Fixed pod text/link was reversed in a few cases RT#85168<br/> [H.Merijn Brand]<br/><br/> Handle aliasing of STORE&#39;d attributes in DBI::DBD::SqlEngine<br/> [Jens Rehsack]<br/><br/> Updated repository URI to git [Jens Rehsack]<br/><br/> Fixed skip() count arg in t/48dbi_dbd_sqlengine.t [Tim Bunce]<br/><br/>=head2 Changes in DBI 1.625 (svn r15595) 28th March 2013<br/><br/> Fixed heap-use-after-free during global destruction RT#75614<br/> thanks to Reini Urban.<br/> Fixed ignoring RootClass attribute during connect() by<br/> DBI::DBD::SqlEngine reported in RT#84260 by Michael Schout<br/><br/>=head2 Changes in DBI 1.624 (svn r15576) 22nd March 2013<br/><br/> Fixed Gofer for hash randomization in perl 5.17.10+ RT#84146<br/><br/> Clarify docs for can() re RT#83207<br/><br/>=cut<br/><br/>Enjoy!<br/><br/>Tim.<br/> 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<br/>CPAN.<br/><br/>1.62 2013-04-30<br/> - promote 1.61_00 to official release<br/><br/>Thanks to everyone who contributed to this release!<br/><br/>Michael<br/><br/>-- <br/>*Michael Portnoy *<br/> Software Developer Pythian<br/> love your data<br/> www.pythian.com<br/>office: +1 613 565 8696 x 381<br/>mobile : +1 613 325 3788<br/><br/><br/>On Mon, Apr 15, 2013 at 3:41 PM, Yanick Champoux &lt;champoux@pythian.com&gt;wrote:<br/><br/>&gt;<br/>&gt; This one is a minor release (changelog&#39;s below). As usual, if no issue<br/>&gt; is found with this trial version, it&#39;s going to be promoted to 1.62 and<br/>&gt; stable in two weeks&#39; time.<br/>&gt;<br/>&gt; 1.61_00 2013-04-15<br/>&gt;<br/>&gt; [BUG FIXES]<br/>&gt; - Adjust the privs needed for the DROP/CREATE table test. [GH#35]<br/>&gt; (Joe Crotty)<br/>&gt;<br/>&gt; - Fixed RT84170 - when using scrollable cursors and you&#39;ve done a<br/>&gt; positioned fetch and then keep fetching until the end of the<br/>&gt; result-set calls to fetch never return undef and you keep getting<br/>&gt; the last row forever. Also added test case to the 51scroll.t test<br/>&gt; (Martin J. Evans).<br/>&gt;<br/>&gt;<br/>&gt; Enjoy,<br/>&gt; `/anick<br/>&gt;<br/>&gt; --<br/>&gt; Yanick Champoux<br/>&gt; Senior Perl Developer<br/>&gt; Pythian - Love your data<br/>&gt;<br/>&gt; champoux@pythian.com<br/>&gt;<br/>&gt; Tel: +1 613 565 8696 x 274<br/>&gt; www.pythian.com<br/>&gt;<br/>&gt;<br/>&gt; --<br/>&gt;<br/>&gt;<br/>&gt; --<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/><br/>-- <br/><br/><br/>--<br/><br/><br/><br/><br/> 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 <br/>Hi all,<br/><br/>I&#39;m pleased to announce the release of DBD::mysql 4.023. Many pull requests this time around that I am most grateful for! <br/><br/>Per ChangeLog:<br/><br/>* Fix primary_key_info result ordering - https://github.com/CaptTofu/DBD-mysql/pull/39 - Dagfinn Ilmari Manns&aring;ker<br/>* allow compilation with msvc - https://github.com/CaptTofu/DBD-mysql/pull/37 - Walde Christian<br/>* just to set MYSQL_OPT_WRITE_TIMEOUT and MYSQL_OPT_READ_TIMEOUT by dsn - https://github.com/CaptTofu/DBD-mysql/pull/36 - Naosuke Yokoe <br/>* just remove unnecessary &quot;my&quot; - https://github.com/CaptTofu/DBD-mysql/pull/34 - Shoichi Kaji<br/>* eval $ExtUtils::MakeMaker::VERSION requires for old ExtUtils::MakeMaker - https://github.com/CaptTofu/DBD-mysql/pull/32 - Daisuke Murase<br/>* Updated documentation to reflect that bugs will be reported at rt.cpan.org<br/>* Updated version<br/>* Chased tail finding issue with -1 being converted to max unsigned int in PS mode<br/><br/>The code:<br/><br/>https://github.com/CaptTofu/DBD-mysql<br/><br/>The project:<br/><br/>http://search.cpan.org/~capttofu/DBD-mysql-4.023/<br/><br/>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&#39;s bug system to http://rt.cpan.org. Please do note that this is where all DBD::mysql bugs need to be filed. <br/><br/>Thank you!<br/><br/>Patrick<br/><br/><br/><br/><br/><br/> 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 <br/> This one is a minor release (changelog&#39;s below). As usual, if no <br/>issue is found with this trial version, it&#39;s going to be promoted to <br/>1.62 and stable in two weeks&#39; time.<br/><br/>1.61_00 2013-04-15<br/><br/> [BUG FIXES]<br/> - Adjust the privs needed for the DROP/CREATE table test. [GH#35]<br/> (Joe Crotty)<br/><br/> - Fixed RT84170 - when using scrollable cursors and you&#39;ve done a<br/> positioned fetch and then keep fetching until the end of the<br/> result-set calls to fetch never return undef and you keep getting<br/> the last row forever. Also added test case to the 51scroll.t test<br/> (Martin J. Evans).<br/><br/><br/>Enjoy,<br/>`/anick<br/><br/>-- <br/>Yanick Champoux<br/>Senior Perl Developer<br/> <br/>Pythian - Love your data<br/><br/>champoux@pythian.com<br/><br/>Tel: +1 613 565 8696 x 274<br/>www.pythian.com<br/><br/><br/>-- <br/><br/><br/>--<br/><br/><br/><br/> 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 <br/> DBD::Oracle version 1.57_00 is on its way to CPAN. This release is <br/>small, but should make some Win32 users happy. The changelog is pasted <br/>below.<br/><br/> As usual, the dev release will be promoted to general use in two <br/>weeks, assuming no problem is found.<br/><br/>Enjoy,<br/>`/anick<br/><br/> 1.57_00 2013-02-07<br/> [BUG FIXES]<br/><br/> - fix RT46628 - bind_param_inout ORA_RSET causes MSWin32 access<br/> violation and RT82663 - Errors if a returned SYS_REFCURSOR is not<br/> opened (Martin J. Evans)<br/><br/> If a procedure/function returns a SYS_REFCURSOR which was never opened<br/> DBD::Oracle magics a DBI statement handle into existence and attempts<br/> to describe it (which fails). This change examines a returned<br/> SYS_REFCURSOR and if it it is initialised but not executed does not<br/> create a DBI statement handle and returns undef instead. So now if you<br/> have a procedure/function which returns a SYS_REFCURSOR and never open<br/> it you&#39;ll get undef back instead of a useless statement handle.<br/> Extended 50cursor.t test to check the above fix.<br/><br/> [DOCUMENTATION]<br/> - Update Lion instructions for 64-bit Instant Client. (GH#37, patch by<br/> theory)<br/><br/><br/>-- <br/><br/><br/>--<br/><br/><br/><br/> 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)<br/>has been uploaded to CPAN.<br/><br/>IBM Informix Database Driver for Perl (also known as DBD::Informix) is<br/>the driver code that enables Perl 5.6.1 or later to access Informix<br/>databases via the DBI module (but if you are not already using Perl<br/>5.10.0 - or any later version - you should be planning to upgrade to<br/>Perl 5.16.2 or later). You will need the code for DBI version 1.38 or<br/>later as well (v1.623 - or any later version - is recommended). The<br/>code for DBD::Informix is available for download via:<br/><br/>http://www.perl.org/CPAN/modules/by-category/07_Database_Interfaces<br/>http://dbi.perl.org/<br/><br/>** When you successfully build this module, use the ItWorks (Perl)<br/>** script to report your configuration to the maintenance team (meaning<br/>** Jonathan Leffler) at dbd.informix@gmail.com.<br/>** The ItWorks script does not send email to anybody; you have to do<br/>** that yourself.<br/><br/>New in release 2013.0118:<br/>* Bug fix release.<br/>* Workaround for bug in ESQL/C 3.70 and earlier that generates error -1820<br/> when reopening a cursor that previously fetched LVARCHAR data.<br/>* Fix for INFORMIXDIR containing Perl regex metacharacters.<br/>* Other minor improvements as documented in the ChangeLog.<br/>* Formal support for ESQL/C 7.x and 8.x (don&#39;t ask why the<br/> current version numbers are smaller) will be dropped after this<br/> release. The code won&#39;t go away yet, but it is beyond time to<br/> get off those versions. ESQL/C 5.20 is nominally supported for<br/> those still using Informix OnLine 5.20, but there is no<br/> testing on that platform.<br/><br/>New in release 2011.0612:<br/>* Minor bug fix release.<br/>* Main change is related to Perl internals and avoids the need for<br/> PERL_POLLUTE. This change is not visible to users except that Perl<br/> 5.14.x can use the fixed code.<br/>* Fixed problem with string that is not null terminated by ESQL/C library.<br/>* Clean up some 64-bit compilation warnings.<br/>* Build on AIX.<br/>* Evade problem with a DISTINCT type of LVARCHAR with NOT NULL (probably<br/> ESQL/C bug).<br/>* Fewer versions of Informix products are supported. You may try<br/> building DBD::Informix with other versions. If it works, great; if<br/> not, please upgrade to a supported Informix version.<br/><br/>Support email address:<br/>* This release is supported by Jonathan Leffler &lt;dbd.informix@gmail.com&gt;.<br/>* You may also report your bugs via the CPAN resolution tracking system:<br/> http://rt.cpan.org/<br/>* Such bug reports can be sent by email to bug-DBD-Informix@rt.cpan.org;<br/> they also get sent to dbd.informix@gmail.com, etc.<br/><br/>As always, see the ChangeLog file for details about what has changed.<br/><br/>Jonathan Leffler (jleffler@us.ibm.com, jonathan.leffler@gmail.com)<br/><br/>@(#)$Id: Announce,v 2013.2 2013/01/18 19:55:18 jleffler Exp $<br/><br/><br/>-- <br/>Jonathan Leffler &lt;jonathan.leffler@gmail.com&gt; #include &lt;disclaimer.h&gt;<br/>Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org<br/>&quot;Blessed are we who can laugh at ourselves, for we shall never cease to be<br/>amused.&quot;<br/><br/> 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,<br/><br/> DBD::Oracle v1.54 is on its way to CPAN. In this iteration, no new <br/>feature, but a large amount of bug fixes. (see full changelog below)<br/><br/> As usual, a big thank to the peeps who actually reported the bugs <br/>and did the work: Pierre-Alain Blanc, Alexandr<br/>Ciornii, Joe Crotty, Rob Davies, Dave Mitchell, and John Scoles, with a <br/>special shout-out to Steffen Goeldner and Martin J. Evans, who are <br/>indisputably patching kings.<br/><br/>Joy,<br/>`/anick<br/><br/>1.54 2013-01-03<br/><br/> [BUG FIXES]<br/> - Fix RT69350 - 31lob.t was using $lob after destroying its parent $sth<br/> (Rob Davies)<br/><br/> - Fix memory leak in execute_array (John Scoles, Pierre-Alain Blanc)<br/><br/> - Fix RT80349 - The error message in execute_for_fetch when a row fails<br/> can contain the wrong error count. Thanks to Steffen Goeldner for<br/> RT and patch.<br/><br/> - Fix RT80375 - no exception when execute_for_fetch fails and<br/> ArrayTupleStatus is not specified. Also the tuple count calculation<br/> resulted in an undefined warning. Thanks to Steffen Goeldner for<br/> RT and patch.<br/><br/> - Fix RT80487. Skip XMLType tests if Oracle less than V9. Thanks to<br/> Steffen Goeldner for RT and patch.<br/><br/> - Fix RT80486 for 31lob_extended.t. In old old Oracle8,<br/> SYS_REFCURSOR is not defined. Instead of CREATE/DROP PROCEDURE,<br/> use anonymous block. Thanks to Steffen Goeldner for RT and patch.<br/><br/> - Fix bug in 39attr.t which could fail if using an Oracle Client &gt;<br/> 11 but not &gt;= 11.2 (Martin J. Evans)<br/><br/> - ora_server_version was not documented.<br/><br/> - Fix RT80566. 70meta.t test fails with Oracle 8 because<br/> ALL_TAB_COLUMNS.CHAR_LENGTH is new in Oracle 9. Use DATA_LENGTH<br/> instead on pre-9 versions. Thanks to Steffen Goeldner for RT and<br/> patch.<br/><br/> - Fix RT80704. 51scroll.t test checks scrollable cursors but assumes<br/> all Oracles support them (only 9 and above). Thanks to Steffen<br/> Goeldner for RT and patch.<br/><br/> - Fix RT81067. 58object.t has some subtype tests and subtypes were<br/> introduced in Oracle 9. Skip if &lt; Oracle 9. Thanks to Steffen<br/> Goeldner for RT and patch.<br/><br/> - Fix RT81317. 34pres_lobs.t uses the Data Interface for Persistent<br/> LOBs which is new in Oracle 9. Skip if &lt; Oracle 9. Thanks to<br/> Steffen Goeldner for RT and patch.<br/><br/> [MISCELLANEOUS]<br/><br/> - The original 26exe_array test was replaced some time ago with a<br/> copy of the one from DBD::ODBC. Since then I&#39;ve fixed issues in<br/> the DBD::ODBC one and added more tests (like tests for some RTs<br/> above). To make keeping them in synch easier I&#39;ve modularised the<br/> tests. Hence new ExecuteArray.pm. (Martin J. Evans)<br/><br/> - simple code clean up, replacing 3 uses of safemalloc with Newz<br/> (John Scoles)<br/><br/> - Add DBI as a configure prereq for the META* files (thanks to Joe <br/>Crotty)<br/><br/> - New FAQ entry on Solaris and setting linker library path<br/> (Martin J. Evans)<br/><br/> - Removed ineffective commit in 34pres_lobs.t (Martin J. Evans)<br/><br/> - Remove dead README link in Win32 documentation. (pointed out by <br/>Alexandr<br/> Ciornii, RT#82040)<br/><br/> - Changed any use of if SvUPGRADE to remove the if test as per email<br/> from Dave Mitchell and posting at<br/>http://www.xray.mpe.mpg.de/mailing-lists/perl5-porters/2012-12/msg00424.html<br/> (Martin J. Evans)<br/><br/><br/>-- <br/>Yanick Champoux, Senior Perl Developer<br/>The Pythian Group - love your data<br/>http://www.pythian.com<br/><br/><br/>-- <br/><br/><br/>--<br/><br/><br/><br/> 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<br/> size: 596517 bytes<br/> md5: b45654dca3b495f3d496c359f0029d96<br/><br/>=head2 Changes in DBI 1.623 (svn r15547) 2nd Jan 2012<br/><br/> Fixed RT#64330 - ping wipes out errstr (Martin J. Evans).<br/> Fixed RT#75868 - DBD::Proxy shouldn&#39;t call connected() on the server.<br/> Fixed RT#80474 - segfault in DESTROY with threads.<br/> Fixed RT#81516 - Test failures due to hash randomisation in perl 5.17.6<br/> thanks to Jens Rehsack and H.Merijn Brand and feedback on IRC<br/> Fixed RT#81724 - Handle copy-on-write scalars (sprout)<br/> Fixed unused variable / self-assignment compiler warnings.<br/> Fixed default table_info in DBI::DBD::SqlEngine which passed NAMES<br/> attribute instead of NAME to DBD::Sponge RT72343 (Martin J. Evans)<br/><br/> Corrected a spelling error thanks to Chris Sanders.<br/> Corrected typo in DBI-&gt;installed_versions docs RT#78825<br/> thanks to Jan Dubois.<br/><br/> Refactored table meta information management from DBD::File into<br/> DBI::DBD::SqlEngine (H.Merijn Brand, Jens Rehsack)<br/> Pevent undefined f_dir being used in opendir (H.Merijn Brand)<br/><br/> Added logic to force destruction of children before parents<br/> during global destruction. See RT#75614.<br/> Added DBD::File Plugin-Support for table names and data sources<br/> (Jens Rehsack, #dbi Team)<br/> Added new tests to 08keeperr for RT#64330<br/> thanks to Kenichi Ishigaki.<br/> Added extra internal handle type check, RT#79952<br/> thanks to Reini Urban.<br/> Added cubrid_ registered prefix for DBD::cubrid, RT#78453<br/><br/> Removed internal _not_impl method (Martin J. Evans).<br/><br/> NOTE: The &quot;old-style&quot; DBD::DBM attributes &#39;dbm_ext&#39; and &#39;dbm_lockfile&#39;<br/> have been deprecated for several years and their use will now generate<br/> a warning.<br/><br/>=cut<br/><br/>Enjoy!<br/><br/>Many thanks to all those who have contributed to the DBI and drivers<br/>this year, especially Jens Rehsack, H.Merijn Brand and Martin J. Evans.<br/><br/>Happy New Year. <br/><br/>Tim.<br/> 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,<br/><br/>SQL::Statement 1.402 has been uploaded to PAUSE and should be updated <br/>where ever possible.<br/><br/>Version 1.402, released December 19, 2012<br/>-------------------------------------------------<br/><br/>[Misc]<br/>* add Math::Complex 1.56 as recommendation (RT#81926, Sam Ferencik)<br/>* add Math::BigInt 1.88 as recommendation (RT#81927, Sam Ferencik)<br/>* clarify Test::Simple 1.90 is required for building (RT#81925, Sam <br/>Ferencik)<br/><br/>[Bug fixes]<br/>* fix leaking reference to open tables outside SQL::Statement::execute<br/> (fixes RT#81523)<br/>* looks_like_number identifies &#39;nan&#39; as number sometimes (add regex to<br/> t/06virtual.t)<br/><br/>The bug described in RT#81523 might result in invalid (outdated) data<br/>return from SQL::Statement. Upgrading is strongly recommended.<br/><br/>Cheers<br/>-- <br/>Jens Rehsack<br/> 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,<br/><br/>yesterday I have released the initial version of DBIx::Table::TestDataGenerator,<br/>see http://search.cpan.org/~jds/DBIx-Table-TestDataGenerator-0.001/<br/><br/>Its goal is to support testing database clients by adding test data to tables.<br/>The main features are the automatic handling of table constraints and dealing<br/>with parent child relations in tables. Currently Oracle, PostgreSQL and SQLite <br/>are supported,&Acirc;&nbsp;additional DBMSs are in the works.<br/><br/>It has already been a real pleasure discussing things with the Perl community, I<br/>want to say a big thank you to all people involved, for detailed<br/>acknowledgements (and everything else) please see the README file.<br/><br/>Hopefully the module will be useful to you. I am eagerly awaiting your comments,<br/>critique and feature requests!<br/><br/><br/>To all affected by the hurricane reaching the East Coast right now I hope it&Acirc;&nbsp;<br/>will not be half as bad as feared, good luck!<br/><br/>Best regards<br/>Jos&Atilde;&copy;<br/><br/>&Acirc;&nbsp;<br/>&Acirc;&nbsp;<br/> 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.<br/><br/>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.<br/><br/>=head2 Changes in DBD::ODBC 1.41 October 23 2012<br/><br/> A full release of the 1.40 development release series.<br/><br/>=head2 Changes in DBD::ODBC 1.40_3 October 8 2012<br/><br/> [BUG FIXES]<br/><br/> Oops, changes to some rt tests fail when not run to MS SQL Server<br/> and they should not be run for other drivers - there was a double<br/> done_testing call.<br/><br/> [CHANGE IN BEHAVIOUR]<br/><br/> As I warned literally years ago DBD::ODBC&#39;s private function<br/> DescribeCol has been removed. You can use DBI&#39;s statement attributes<br/> like NAME, PRECISION etc, instead. All test code has been changed to<br/> remove calls to DescribeCol and GetTypeInfo.<br/><br/> [MISCELLANEOUS]<br/><br/> New example sqlserver_supplementary_chrs.pl added which shows that<br/> in MS SQL Server 2012 you can now store unicode characters<br/> over 0xFFFF (ones which are surrogate pairs).<br/><br/> More documentation for odbc_out_connect_string.<br/><br/>=head2 Changes in DBD::ODBC 1.40_2 September 6 2012<br/><br/> [BUG FIXES]<br/><br/> Fixed rt 78838 - bind_param does not correctly stringify blessed<br/> objects when connected to MS SQL Server<br/><br/> Fix issue in dbd_bind_ph where if you passed a sql type and were<br/> also attempting to change from in to out or vice versa or increasing<br/> the size of an output bound param it would not spot this error.<br/><br/> Allowed the test cases to spot DB2 driver as libXXXdb2.<br/><br/> [MISCELLANEOUS]<br/><br/> New test cases added for some rts.<br/><br/> Added Test::NoWarnings to some tests where it was missing.<br/><br/>=head2 Changes in DBD::ODBC 1.40_1 September 4 2012<br/><br/> [BUG FIXES]<br/><br/> Debian/Ubuntu have moved unixODBC into /usr/lib/i386-linux-gnu<br/> so look in this dir for unixODBC as well - thanks to Meastro for finding.<br/><br/> Fixed rt 78838<br/> I had a sequence point error which is only seen with some compilers<br/> as it is sometimes optimized=head2 Changes in DBD::ODBC 1.41 October 23 2012<br/><br/> A full release of the 1.40 development release series.<br/><br/>=head2 Changes in DBD::ODBC 1.40_3 October 8 2012<br/><br/> [BUG FIXES]<br/><br/> Oops, changes to some rt tests fail when not run to MS SQL Server<br/> and they should not be run for other drivers - there was a double<br/> done_testing call.<br/><br/> [CHANGE IN BEHAVIOUR]<br/><br/> As I warned literally years ago DBD::ODBC&#39;s private function<br/> DescribeCol has been removed. You can use DBI&#39;s statement attributes<br/> like NAME, PRECISION etc, instead. All test code has been changed to<br/> remove calls to DescribeCol and GetTypeInfo.<br/><br/> [MISCELLANEOUS]<br/><br/> New example sqlserver_supplementary_chrs.pl added which shows that<br/> in MS SQL Server 2012 you can now store unicode characters<br/> over 0xFFFF (ones which are surrogate pairs).<br/><br/> More documentation for odbc_out_connect_string.<br/><br/>=head2 Changes in DBD::ODBC 1.40_2 September 6 2012<br/><br/> [BUG FIXES]<br/><br/> Fixed rt 78838 - bind_param does not correctly stringify blessed<br/> objects when connected to MS SQL Server<br/><br/> Fix issue in dbd_bind_ph where if you passed a sql type and were<br/> also attempting to change from in to out or vice versa or increasing<br/> the size of an output bound param it would not spot this error.<br/><br/> Allowed the test cases to spot DB2 driver as libXXXdb2.<br/><br/> [MISCELLANEOUS]<br/><br/> New test cases added for some rts.<br/><br/> Added Test::NoWarnings to some tests where it was missing.<br/><br/>=head2 Changes in DBD::ODBC 1.40_1 September 4 2012<br/><br/> [BUG FIXES]<br/><br/> Debian/Ubuntu have moved unixODBC into /usr/lib/i386-linux-gnu<br/> so look in this dir for unixODBC as well - thanks to Meastro for finding.<br/><br/> Fixed rt 78838<br/> I had a sequence point error which is only seen with some compilers<br/> as it is sometimes optimized out. It could cause DBD::ODBC to omit<br/> adding the UID/PWD to the end of the connection string when using DSN=.<br/> Thanks to Zsolt Cserna for spotting it and to ilmari and Leon for<br/> explaining it to me.<br/><br/> Fixed rt 79397<br/> Output bound parameters may be incorrectly bound if changed after<br/> bind_param_inout is called. If you start with an undef bound param<br/> and change it to a defined string/number less than 28 characters<br/> before calling execute the original undef will probably be bound.<br/> Thanks to runrig on perl monks for providing an example.<br/><br/> [CHANGE IN BEHAVIOUR]<br/><br/> If you attempt to bind an rv without amagic DBD::ODBC will now<br/> croak - related to rt 78838. out. It could cause DBD::ODBC to omit<br/> adding the UID/PWD to the end of the connection string when using DSN=.<br/> Thanks to Zsolt Cserna for spotting it and to ilmari and Leon for<br/> explaining it to me.<br/><br/> Fixed rt 79397<br/> Output bound parameters may be incorrectly bound if changed after<br/> bind_param_inout is called. If you start with an undef bound param<br/> and change it to a defined string/number less than 28 characters<br/> before calling execute the original undef will probably be bound.<br/> Thanks to runrig on perl monks for providing an example.<br/><br/> [CHANGE IN BEHAVIOUR]<br/><br/> If you attempt to bind an rv without amagic DBD::ODBC will now<br/> croak - related to rt 78838.<br/><br/>Martin<br/>-- <br/>Martin J. Evans<br/>Easysoft Limited<br/>http://www.easysoft.com<br/> 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 <br/> The announcement was sent to the other mailing lists, but I shamefully forgot this one.<br/>Thanks to Tim Bounce++ for the reminding poke.<br/><br/> So, yes, a new version of DBD::Oracle is out.I&#39;m pasting the changelog<br/>below for convenience, but this release is basically Martin Evans heroically<br/>making TAF work, with some additional awesomeness<br/>sprinkled by Merijn, Douglas and David.<br/> <br/><br/>Enjoy!<br/>`/anick<br/> <br/> 1.52<br/> <br/> [BUG FIXES]<br/> <br/> - fix serious memory corruption in TAF support (Martin J. Evans)<br/> <br/> - fix finding client in situation where client and server both<br/> installed but different architectures (patch by H.Merijn Brand)<br/> <br/> - fix memory leak in TAF handling - the TAF function was leaked<br/> (Martin J. Evans)<br/> <br/> - fix issue with taf_function being set to a scalar which goes<br/> out of scope before the callback is made (Martin J. Evans)<br/> <br/> - fix RT46739 if a connection breaks the environment handle is<br/> not thrown away (Martin J. Evans)<br/> <br/> - ora_driver_name was not defaulted to the correct DBD::Oracle<br/> version (Martin J. Evans)<br/> <br/> - ora_driver_name, ora_client_info, ora_client_identifier,<br/> ora_action and ora_oci_success_warn were set twice (if specified)<br/> on connect as they were not deleted from the connect attributes<br/> once handled. Code now leaves the setting to the later STORE DBI<br/> calls (Martin J. Evans)<br/> <br/> - fixed some compiler warnings for %lf (Martin J. Evans)<br/> <br/> - fixed RT78700 - column_info reports wrong size for char semantic<br/> char type columns (Douglas Wilson).<br/> <br/> [CHANGE IN BEHAVIOUR]<br/> <br/> - ora_taf and ora_taf_sleep were redundant and have been removed.<br/> To enable/disable TAF simply set ora_taf_function and if you<br/> want to sleep do it in your callback (Martin J. Evans)<br/> <br/> - ora_taf_function can now be a code reference as well as a string<br/> (Martin J. Evans)<br/> <br/> [ENHANCEMENTS]<br/> <br/> - the ora_can_taf method was virtually useless since you can only<br/> call it after connecting and to enable TAF you had to do it in the<br/> connect call. Now you can enable and disable TAF at any time by<br/> simply setting or clearing the ora_taf_function (see RT78811)<br/> (Martin J. Evans)<br/> <br/> - the ora_taf_function is now passed a third argument of the<br/> connection handle (Martin J. Evans)<br/> <br/> - RT78987 - removed Oraperl.pm and oraperl.ph; these files will be<br/> available in a separate distribution named &quot;Oraperl&quot; (David Perry)<br/> <br/> [MISCELLANEOUS]<br/> <br/> - hide dr, db and st packages from PAUSE (Martin J. Evans)<br/> <br/> - added a few more simple TAF tests (Martin J. Evans)<br/><br/><br/>-- <br/><br/><br/>--<br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.announce/2012/10/msg433.html Tue, 23 Oct 2012 04:17:34 +0000