X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=Changes;h=9562a9c9f37ffbbecaf7d642d20aa5364e03341e;hb=79346e56a9ebf94b504a2ee19e96ff3547a77321;hp=ae17bab663b3f15f8d8b396945fa5faf4a0307b6;hpb=3214abc7114c66f6c342ef3c8180ae0fc5d68a8d;p=dbsrgits%2FDBIx-Class.git diff --git a/Changes b/Changes index ae17bab..9562a9c 100644 --- a/Changes +++ b/Changes @@ -1,66 +1,170 @@ Revision history for DBIx::Class - * New Features / Changes - - Prefetch with limit on right-side ordered resultsets now works - correctly (via aggregated grouping) - - Changing the result_class of a ResultSet in progress is now - explicitly forbidden. The behavior was undefined before, and - would result in wildly differing outcomes depending on $rs - attributes. - - Scale back validation of the 'as' attribute - in the field - there are legitimate-ish uses of a inflating into an apparently - invalid relationship graph - - Warn in case of iterative collapse being upgraded to an eager - cursor slurp - - No longer order the insides of a complex prefetch subquery, - unless required to satisfy a limit - +0.082810 2014-10-25 13:58 (UTC) * Fixes - - Properly consider unselected order_by criteria during complex - subqueried prefetch - - Properly support "MySQL-style" left-side group_by with prefetch - - Fix $grouped_rs->get_column($col)->func($func) producing incorrect - SQL (RT#81127) + - Fix incorrect collapsing-parser source being generated in the + presence of unicode data among the collapse-points + - Fix endless loop on BareSourcelessResultClass->throw_exception(...) -0.08209 2013-03-01 12:56 (UTC) - * New Features / Changes - - Debugging aid - warn on invalid result objects created by what - seems like an invalid inheritance hierarchy + * Misc + - Depend on newer SQL::Abstract (fixing overly-aggressive parenthesis + opener: RT#99503) + - Depend on newer Moo, fixing some interoperability issues: + http://lists.scsys.co.uk/pipermail/dbix-class/2014-October/011787.html + +0.082801 2014-10-05 23:55 (UTC) + * Known Issues + - Passing large amounts of objects with stringification overload + directly to DBIx::Class may result in strange action at a distance + exceptions. More info (and a workaround description) can be found + under "Note" at https://metacpan.org/pod/SQL::Abstract#is_plain_value + - The relationship condition resolution fixes come with the side effect + of returning more complete data, tripping up *some* users of an + undocumented but widely used internal function. In particular + https://rt.cpan.org/Ticket/Display.html?id=91375#txn-1407239 + + * Notable Changes and Deprecations + - DBIC::FilterColumn now properly bypasses \'' and \[] literals, just + like the rest of DBIC + - DBIC::FilterColumn "from_storage" handler is now invoked on NULLs + returned from storage + - find() now throws an exception if some of the supplied values are + managed by DBIC::FilterColumn (RT#95054) + - Custom condition relationships are now invoked with a slightly + different signature (existing coderefs will continue to work) + - Add extra custom condition coderef attribute 'foreign_values' + to allow for proper reverse-relationship-like behavior + (i.e. $result->set_from_related($custom_rel, $foreign_result_object) + - When in a transaction, DBIC::Ordered now seamlesly handles result + objects that went out of sync with the storage (RT#96499) + - CDBICompat::columns() now supports adding columns through supplied + Class::DBI::Column instances (GH#52) + - Deprecate { col1 => col2 } expressions in manual {from} structures + (at some point of time manual {from} will be deprecated entirely) * Fixes - - Fix another embarrassing regression preventing correct refining of - the search criteria on a prefetched relation (broken in 0.08205) - - Fix incorrect callsite reporting by DBIC::Carp + - Fix Resultset delete/update affecting *THE ENTIRE TABLE* in cases + of empty (due to conditions) resultsets with multi-column keys + - Fix on_connect_* not always firing in some cases - a race condition + existed between storage accessor setters and the determine_driver + routines, triggering a connection before the set-cycle is finished + - Fix collapse being ignored on single-origin selection (RT#95658) + - Fix incorrect behavior on custom result_class inflators altering + the amount of returned results + - Fix failure to detect stable order criteria when in iterator + mode of a has_many prefetch off a search_related chain + - Prevent erroneous database hit when accessing prefetched related + resultsets with no rows + - Proper exceptions on malformed relationship conditions (RT#92234) + - Fix incorrect handling of custom relationship conditions returning + SQLA literal expressions + - Fix long standing bug with populate() missing data from hashrefs with + different keysets: http://is.gd/2011_dbic_populate_gotcha (RT#92723) + - Fix multi-value literal populate not working with simplified bind + specifications + - Massively improve the implied resultset condition parsing - now all + applicable conditions within a resultset should be properly picked + up by create() and populate() + - Ensure definitive condition extractor handles bizarre corner cases + without bombing out (RT#93244) + - Fix set_column on non-native (+columns) selections (RT#86685) + - Fix set_inflated_column incorrectly handling \[] literals (GH#44) + - Ensure that setting a column to a literal invariably marks it dirty + - Fix copy() not working correctly with extra selections present + - Work around exception objects with broken string overloading in one + additional codepath (missed in 0.08260) + - Fix more inconsistencies of the quote_names attribute propagating + to SQL::Translator (partially RT#87731) + - Fix SQLT constraint naming when DBIC table names are fully qualified + (PR#48) + - Ensure ::Schema::Versioned connects only once by reusing the main + connection (GH#57) + - Fix inability to handle multiple consecutive transactions with + savepoints on DBD::SQLite < 1.39 + - Fix CDBICompat to match Class::DBI behavior handling non-result + blessed has_a (implicit deflate via stringification and inflate via + blind new) (GH#51) -0.08208 2013-02-20 09:56 (UTC) - * New Features / Changes - - A bunch of nonsensically named arguments to the SQL::Translator - parser have been marked as deprecated (while still fully - supported) + * Misc + - Ensure source metadata calls always take place on the result source + instance registered with the caller + - IFF DBIC_TRACE output defaults to STDERR we now silence the possible + wide-char warnings if the trace happens to contain unicode +0.08270 2014-01-30 21:54 (PST) * Fixes - - Fix duplicated selected columns when calling 'count' when a same - aggregate function is used more than once in a 'having' clause - (RT#83305) - - Prevent SQL::Translator::Producer::YAML from seeing the $dbh - in a potentially connected $schema instance (RT#75394) + - Fix 0.08260 regression in DBD::SQLite bound int handling. Inserted + data was not affected, but any function <=> integer comparison would + have failed (originally fixed way back in 0e773352) + - Fix failure to load DateTime formatter when connecting to Firebird + over ODBC * Misc - - Fixup our distbuilding process to stop creating world-writable - tarball contents (implicitly fixes RT#83084) - - Added strict and warnings tests for all lib and test files + - All drivers based on ::Storage::DBI::Firebird::Common now return the + same sqlt_type value (affects ::DBI::Interbase, ::DBI::Firebird and + ::DBI::ODBC::Firebird) -0.08241-TRIAL (EXPERIMENTAL BETA RELEASE) 2013-02-20 11:97 (UTC) - * New Features / Changes - - Revert to passing the original (pre-0.08240) arguments to - inflate_result() and remove the warning about ResultClass - inheritance. - - Optimize the generated rowparsers even more - no user-visible - changes. - - Emit a warning on incorrect use of nullable columns within a - primary key +0.08260 2014-01-28 18:52 (UTC) + * New Features + - A new zero-to-DBIC style manual: DBIx::Class::Manual::QuickStart + + * Notable Changes and Deprecations + - Explicitly deprecate combination of distinct and selecting a + non-column via $rs->get_column() + + * Fixes + - More robust handling of circular relationship declarations by loading + foreign classes less frequently (should resolve issues like + http://lists.scsys.co.uk/pipermail/dbix-class/2013-June/011374.html) + Note that none of this is a manifestations of a DBIC bug, but rather + unexpected (but correct) behavior of load-order-dependent (hence + logically broken) Resultclass hierarchies. In order to deal with this + DBIC is scaling back a large number of sanity checks, which are to be + reintroduce pending a better framework for source registration + - Fix multiple edge cases of complex prefetch combining incorrectly + with correlated subquery selections + - Fix multiple edge cases stemming from interaction of a non-selecting + order_by specification and distinct and/or complex prefetch + - Fix unbound growth of a resultset during repeated execute/exhaust + cycles (GH#29) + - Work around (and be very vocal about the fact) when DBIC encounters + an exception object with broken string overloading + - Clarify ambiguous behavior of distinct when used with ResultSetColumn + i.e. $rs->search({}, { distinct => 1 })->get_column (...) + - Setting quote_names propagates to SQL::Translator when producing + SQLite DDL (it is one of the few producers *NOT* quoting by default) + - Fix incorrect binding of large integers on old versions of + DBD::SQLite (now DBIC simply always binds SQLite ints as BIGINT) + - Silence (harmless) warnings on recent DBD::SQLite versions, when + inserting/updating large integers on 32bit ivsize systems (RT#76395) + - Back out self-cleaning from DBIx::Class::Carp for the time being + (as a side effect fixes RT#86267) + - Fix incorrect internal use of implicit list context in copy() + - Fix 0.08250 regression in driver determination when DBI_DSN is used + - Tests no longer fail if $ENV{DBI_DSN} is set + - Throw clearer exception on ->new_related() with a non-existent + relationship + - Fix incorrect parethesis unroll with multicolumn in, (never noticed + before fixing false positive in SQLA::Test 1.77) + - Fix t/storage/replicated.t class loading problem + - Stop using the deprecated Class::MOP::load_class() + - Fix warning in t/54taint.t with explicitly unset PERL5LIB (RT#91972) + - Fix t/54taint.t failing under a local::lib with installed earlier + DBIC version (RT#92486) -0.08240-TRIAL (EXPERIMENTAL BETA RELEASE) 2013-02-14 05:56 (UTC) + * Misc + - Massive incompatible change of ::BlockRunner internals (was never + documented as usable externally, this last set of changes settles + the design for proper documentation and opening up) + - Adjust exceptions in tests to accommodate changes in the upcoming + DBD::SQLite based on libsqlite 3.8.2 + - More robust lock file naming scheme - allow tests to work on exotic + MSWin32 filesystems (habitual offender being http://is.gd/iy5XVP) + - Better diagnostics when File::Spec->tmpdir gives us crap in testing + - Replace $row with $result in all docs to be consistent and to + clarify various return values + +0.08250 2013-04-29 22:00 (UTC) * New Features / Changes - Rewrite from scratch the result constructor codepath - many bugfixes and performance improvements (the current codebase is now capable of @@ -74,15 +178,90 @@ Revision history for DBIx::Class (RT#54949, RT#74024, RT#74584) - Prefetch no longer inserts right-side table order_by clauses (massively helps the deficient MySQL optimizer) + - Prefetch with limit on right-side ordered resultsets now works + correctly (via aggregated grouping) + - No longer order the insides of a complex prefetch subquery, + unless required to satisfy a limit + - Stop erroneously considering order_by criteria from a join under + distinct => 1 (the distinct should apply to the main source only) - Massively optimize codepath around ->cursor(), over 10x speedup on some iterating workloads. + - Support standalone \[ $sql, $value ] in literal SQL with bind + specifications: \[ '? + ?', 42, 69 ] is now equivalent to + \[ '? + ?', [ {} => 42 ], [ {} => 69 ] ] + - Changing the result_class of a ResultSet in progress is now + explicitly forbidden. The behavior was undefined before, and + would result in wildly differing outcomes depending on $rs + attributes. + - Deprecate returning of prefetched 'filter' rels as part of + get_columns() and get_inflated_columns() data + - Invoking get_inflated_columns() no longer fires get_columns() but + instead retrieves data from individual non-inflatable columns via + get_column() + - Emit a warning on incorrect use of nullable columns within a + primary key + - Limited checks are performed on whether columns without declared + is_nullable => 1 metadata do in fact sometimes fetch NULLs from + the database (the check is currently very limited and is performed + only on resultset collapse when the alternative is rather worse) * Fixes + - Fix _dbi_attrs_for_bind() being called befor DBI has been loaded + (regression in 0.08210) + - Fix update/delete operations on resultsets *joining* the updated + table failing on MySQL. Resolves oversights in the fixes for + RT#81378 and RT#81897 - Fix open cursors silently resetting when inherited across a fork or a thread + - Properly support "MySQL-style" left-side group_by with prefetch + - Fix $grouped_rs->get_column($col)->func($func) producing incorrect + SQL (RT#81127) + - Stop Sybase ASE storage from generating invalid SQL in subselects + when a limit without offset is encountered + - Even more robust behavior of GenericSubQuery limit dialect + - Make sure deployment_statements() and cursor_class() are called on + a resolved storage subclass + + * Misc + - Fix tests failing due to unspecified resultset retrieval order + (test suite now will pass with newest SQLite libs) + +0.08210 2013-04-04 15:30 (UTC) + * New Features / Changes + - Officially deprecate the 'cols' and 'include_columns' resultset + attributes + - Remove ::Storage::DBI::sth() deprecated in 0.08191 + + * Fixes + - Work around a *critical* bug with potential for data loss in + DBD::SQLite - RT#79576 + - Audit and correct potential bugs associated with braindead reuse + of $1 on unsuccessful matches + - Fix incorrect warning/exception originator reported by carp*() and + throw_exception() + +0.08209 2013-03-01 12:56 (UTC) + * New Features / Changes + - Debugging aid - warn on invalid result objects created by what + seems like an invalid inheritance hierarchy + + * Fixes + - Fix another embarrassing regression preventing correct refining of + the search criteria on a prefetched relation (broken in 0.08205) + - Fix incorrect callsite reporting by DBIC::Carp + +0.08208 2013-02-20 09:56 (UTC) + * New Features / Changes + - A bunch of nonsensically named arguments to the SQL::Translator + parser have been marked as deprecated (while still fully + supported) + + * Fixes - Fix duplicated selected columns when calling 'count' when a same aggregate function is used more than once in a 'having' clause (RT#83305) + - Prevent SQL::Translator::Producer::YAML from seeing the $dbh + in a potentially connected $schema instance (RT#75394) * Misc - Fixup our distbuilding process to stop creating world-writable