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

[fREW Schmidt]

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_array
        - 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 subquery
        - 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 DBI
          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' option
        - 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20120529/fec=
26ffe/attachment.htm