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

[fREW Schmidt]

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_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) datatyp=
es
>           - 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 che=
ck
>           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 assemb=
le
>           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 pat=
h:
>           - 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
>



-- =

fREW Schmidt
http://blog.afoolishmanifesto.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20120531/d46=
72bf9/attachment.htm