In the last few days I've released what hopefully will be the last development release of DBD::ODBC
). If you run Windows especially and Perl 5.13 even more, then please test.
It's been 4 months since the last official release (too long I know) but I'm getting more and more cautious as time goes on for fear of being inundated with reports/rts after a release. As always thanks to smoke testing I at least avoided problems with PERL_POLLUTE disappearing from DBI.
I've listed all the changes since 1.24 below but you can also find them here
. This is mostly a bug fix release but I've also added support for excluding parameter markers in SQL comments, an experimental odbc_lob_read method and support for SQL Server's XML type. I would have also done odbc_lob_read except lob reading in ODBC is a bit of a pain since there is no easy way to obtain the length before retrieving the data and few ODBC drivers support GETDATA Extensions allowing SQLGetData to be called on columns surrounded with bound columns (still thinking about that).
This is your last chance to report any problems before an official release. Once I see some Windows and Perl 5.13 smoke results I will do an official release.
=head2 Changes in DBD::ODBC 1.24_4 September 8, 2010
Left a sv_undef in - thanks smoke testers for finding that.
Change sprintf to snprintf for safety.
=head2 Changes in DBD::ODBC 1.24_3 September 6, 2010
Added note from Robert Freimuth for obtaining the last insert ID in MS Access.
Changed all &sv_yes/&sv_no occurrances in XS to PL_sv_yes/PL_sv_no as the originals have now gone from blead Perl.
Minor change to fix missing newline in trace output.
Added a FAQ entry for how "use regional settings" in MS SQL Server breaks things.
=head2 Changes in DBD::ODBC 1.24_2 July 23, 2010
Fix rt57957 reported by Marc Prewitt. DBD::ODBC was not ignoring named placeholders and ? inside comments. Comments are deemed as text between "/*" and "*/" (if not in a literal) and line comments begin with "--".
Added a FAQ on procedures not completing in MS SQL Server. Thanks to Peter Rabbitson for hitting this problem and reminding me I'd seen it a couple of times before.
Added a FAQ on equality comparisons with ntext columns.
Added pod for last_insert_id which is not currently supported.
Fix bug where if SQLMoreResults was called and failed it was not reported.
Removed some unused fields from the fbh structure which should save a little memory for each column in a result-set.
Started adding support for DBI's DiscardString and StrictlyTyped but not complete yet so don't use them yet.
Added experimental odbc_lob_read method - see pod. Thanks to tye and ikegami on perlmonks for pointing out some problems with my initial implementation.
Moved the binding of columns to the first call to fetch instead of after execute is called as it prevents bind_col overrriding the type used for binding and I needed it to support odbc_lob_read. This may have undesired affects so any testing of this release would be
Added bind_col method so DBD::ODBC can support attributes on a bind_col call.
Removed support for DBI's blob_read - it was totally flawed and did not work at all. May replace in the future.
Added support for MS SQL Server XML type (SQL type -152). See rt 59621.
Added note on do method implementation in DBD::ODBC and how some may consider it to deviate from the DBI specification.
=head2 Changes in DBD::ODBC 1.24_1 May 27, 2010
Corrected pod and private attributes for the odbc_SQL_DRIVER_ODBC_VER attribute which was documented as SQL_DRIVER_ODBC_VER.
Added FAQ on pauses on statement destruction when all the result-set has not been retrieved (mostly freeTDS and MS SQL Server ODBC Driver).
Fixed bug introduced in 1.24 where if you are using MS SQL Server, and you are preparing, binding placeholders and re-executing multiple times you may get a "Invalid character value for cast specification" error. Thanks to anonymous for spotting this and producing a standalone example of the problem that made it so much easier to find.