[Dbix-class] Re: New (dev) rel of DBIC and SQLA, PLEASE TEST

fREW Schmidt frioux at gmail.com
Mon Jun 4 12:51:40 GMT 2012


_03 was released  (https://metacpan.org/release/FREW/DBIx-Class-0.08197_03/)
correctly a couple days ago and seems to be working on the smokers.  Will
cut it as a real release today or tomorrow.

On Thu, May 31, 2012 at 9:55 PM, fREW Schmidt <frioux at gmail.com> wrote:

> Re-disted as _02 to fix busted dist.
>
> On Tue, May 29, 2012 at 9:28 PM, fREW Schmidt <frioux at gmail.com> wrote:
>
>> I'm releasing a dev rel of DBIC and SQLA, please test them on your setups
>> to see if you hit any regressions.  Here are the changelogs, I'll do a
>> proper release after a few days.
>>
>> SQLA:
>>     - Fix parsing of ORDER BY foo + ?
>>     - Stop filling in placeholders in `format-sql` since it does not
>> support
>>       passing values for them anyway
>>     - Fix parsing of NOT EXISTS
>>     - Fix over-eager parenthesis unrolling
>>     - Fix deep recursion warnings while parsing obnoxiously long sql
>> statements
>>     - Fix incorrect comparison of malformed lists
>>     - Fix incorrect reporting of mismatch-members in SQLA::Test
>>     - Migrate the -ident operator from DBIC into SQLA
>>     - Migrate the -value operator from DBIC into SQLA
>>
>> DBIC:
>>     * New Features / Changes
>>         - Issue a warning when DateTime objects are passed to ->search
>>         - Fast populate() in void context is now even more efficient by
>>           going directly through execute_for_fetch bypassing execute_arr=
ay
>>         - Fix update()/delete() on complex resultsets to no longer fall
>> back
>>           to silly row-by-row deletion, construct a massive OR statement
>>           instead
>>         - Allow complex update/delete operations on sources without a
>>           primary key, as long as they have at least one non-nullable
>>           unique constraint
>>         - dbicadmin now better supports catalyst-style config files, by
>>           unrolling 'config_info' hashkeys
>>         - Multiple Improvements MSSQL over DBD::ADO
>>           - Transaction support
>>           - Support for VARCHAR(MAX)/VARBINARY(MAX)/NVARCHAR(MAX)
>> datatypes
>>           - Nomalization of retrieved GUID values
>>
>>     * Fixes
>>         - Fix complex has_many prefetch with resultsets not selecting
>> identity
>>           columns from the root result source
>>         - Fix SkipFirst and FirstSkip limit dialects (Informix and
>> Firebird)
>>         - Fix "Skimming limit" dialects (Top, FetchFirst) to properly
>> check
>>           the order_by criteria for stability
>>         - Fix "Skimming limit" dialects (Top, FetchFirst) to propagate
>>           non-selected order criteria when part of a larger subquery
>>         - Fix RowNumberOver and all "skimming limits" to correctly
>> assemble
>>           bind values when supplied for both select and order_by
>>         - Fix all subquery-based dialects to not lose a subquery fragment
>>           when we both select and order by the result of the same subque=
ry
>>         - Fix the Sybase hubrid limit dialect (RowCountOrGenericSubQ)
>> losing
>>           Group/Having/Order clauses when called without an offset
>> (RT#73244)
>>         - No longer generate incorrect SQL on ->as_query called on
>> resultsets
>>           with software_limit enabled
>>         - A number of corner case fixes of void context populate() with
>> \[]
>>         - Fix corner case of forked children disconnecting the parents D=
BI
>>           handle
>>         - Improve identity/autoinc retrieval code in MSSQL and Sybase -
>>           should reduce weird side-effects especially with populate()
>>         - Explicitly disable DBD::ODBC batch operations (as of DBD::ODBC
>> 1.35)
>>           for the following drivers too buggy to handle the optimized
>> path:
>>           - FreeTDS ODBC driver (when used with MSSQL)
>>           - The Firebird ODBC driver
>>           - The MSAccess ODBC driver
>>         - Explicitly disable DBD::ODBC dynamic_cursors when using freetds
>> 0.83
>>           or later - they made enough ODBC incompatible changes making it
>>           impossible to support sanely
>>         - Explicitly disable SCOPE_IDENTITY queries and statement caching
>> for
>>           MSSQL on DBD::Sybase compiled against freetds 0.83 or later -
>> way too
>>           buggy
>>         - Disable statement caching when using Sybase ASE and DBD::Sybase
>>           compiled against freetds 0.83 or later
>>         - Fix leakage of $schema on in-memory new_related() calls
>>         - Fix more cases of $schema leakage in SQLT::Parser::DBIC
>>         - Fix leakage of $storage in ::Storage::DBI::Oracle
>>         - Fix pessimization of Oracle RowNum limit dialect query when no
>>           offset has been specified
>>         - Remove useless vestigial pessimization in Ordered.pm for cases
>>           when the position column is part of a unique constraint
>>         - Fix dbicadmin to no longer ignore the documented 'config' opti=
on
>>         - The schema-resultsource entanglement is now much more robust
>>           under threads
>>         - Fix ::Schema::ddl_filename() failing miserably on paths
>> containing
>>           certain numeric sequences
>>         - t/53lean_startup.t adjusted for new 5.15.x base.pm behavior
>>
>>     * Misc
>>         - Centralized leak-checks for all instances of DBICTest::Schema
>>           from within any test
>>         - Now passes all tests with Test::Builder 1.005
>>         - Codebase is now trailing-whitespace-free
>>         - Cleanup of complex resultset update/delete oprations - storage
>>           specific code moved back to ResultSet and replaced by checks
>>           of storage capabilities
>>         - Fixed carp_once only emitting one single warning per package
>>           regardless of warning content
>>         - Test suite now can be safely executed in parallel (prove -jN
>>           or HARNESS_OPTIONS=3DjN)
>>
>> --
>> fREW Schmidt
>> http://blog.afoolishmanifesto.com
>>
>
>
>
> --
> fREW Schmidt
> http://blog.afoolishmanifesto.com
>



-- =

fREW Schmidt
http://blog.afoolishmanifesto.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20120604/73d=
16e54/attachment.htm


More information about the DBIx-Class mailing list