1Revision history for DBIx::Class 2 30.08120 2010-02-24 08:58:00 (UTC) 4 - Make sure possibly overwritten deployment_statements methods in 5 schemas get called on $schema->deploy 6 - Fix count() with group_by aliased-function resultsets 7 - with_deferred_fk_checks() Oracle support 8 - Massive refactor and cleanup of primary key handling 9 - Fixed regression losing custom result_class (really this time) 10 (RT#54697) 11 - Fixed regression in DBIC SQLT::Parser failing with a classname 12 (as opposed to a schema object) 13 - Changes to Storage::DBI::Oracle to accomodate changes in latest 14 SQL::Translator (quote handling) 15 - Make sure deployment_statements is per-storage overridable 16 - Fix dbicadmin's (lack of) POD 17 180.08119 2010-02-15 09:36:00 (UTC) 19 - Add $rs->is_ordered to test for existing order_by on a resultset 20 - Add as_subselect_rs to DBIC::ResultSet from 21 DBIC::Helper::ResultSet::VirtualView::as_virtual_view 22 - Refactor dbicadmin adding DDL manipulation capabilities 23 - New optional dependency manager to aid extension writers 24 - Depend on newest bugfixed Moose 25 - Make resultset chaining consistent wrt selection specification 26 - Storage::DBI::Replicated cleanup 27 - Fix autoinc PKs without an autoinc flag on Sybase ASA 28 290.08118 2010-02-08 11:53:00 (UTC) 30 - Fix a bug causing UTF8 columns not to be decoded (RT#54395) 31 - Fix bug in One->Many->One prefetch-collapse handling (RT#54039) 32 - Cleanup handling of relationship accessor types 33 340.08117 2010-02-05 17:10:00 (UTC) 35 - Perl 5.8.1 is now the minimum supported version 36 - Massive optimization of the join resolution code - now joins 37 will be removed from the resulting SQL if DBIC can prove they 38 are not referenced by anything 39 - Subqueries no longer marked experimental 40 - Support for Informix RDBMS (limit/offset and auto-inc columns) 41 - Support for Sybase SQLAnywhere, both native and via ODBC 42 - might_have/has_one now warn if applied calling class's column 43 has is_nullable set to true. 44 - Fixed regression in deploy() with a {sources} table limit applied 45 (RT#52812) 46 - Views without a view_definition will throw an exception when 47 parsed by SQL::Translator::Parser::DBIx::Class 48 - Stop the SQLT parser from auto-adding indexes identical to the 49 Primary Key 50 - InflateColumn::DateTime refactoring to allow fine grained method 51 overloads 52 - Fix ResultSetColumn improperly selecting more than the requested 53 column when +columns/+select is present 54 - Fix failure when update/delete of resultsets with complex WHERE 55 SQLA structures 56 - Fix regression in context sensitiveness of deployment_statements 57 - Fix regression resulting in overcomplicated query on 58 search_related from prefetching resultsets 59 - Fix regression on all-null returning searches (properly switch 60 LEFT JOIN to JOIN in order to distinguish between both cases) 61 - Fix regression in groupedresultset count() used on strict-mode 62 MySQL connections 63 - Better isolation of RNO-limited queries from the rest of a 64 prefetching resultset 65 - New MSSQL specific resultset attribute to allow hacky ordered 66 subquery support 67 - Fix nasty schema/dbhandle leak due to SQL::Translator 68 - Initial implementation of a mechanism for Schema::Version to 69 apply multiple step upgrades 70 - Fix regression on externally supplied $dbh with AutoCommit=0 71 - FAQ "Custom methods in Result classes" 72 - Cookbook POD fix for add_drop_table instead of add_drop_tables 73 - Schema POD improvement for dclone 74 750.08115 2009-12-10 09:02:00 (CST) 76 - Real limit/offset support for MSSQL server (via Row_Number) 77 - Fix distinct => 1 with non-selecting order_by (the columns 78 in order_by also need to be aded to the resulting group_by) 79 - Do not attempt to deploy FK constraints pointing to a View 80 - Fix count/objects from search_related on limited resultset 81 - Stop propagating distinct => 1 over search_related chains 82 - Make sure populate() inherits the resultset conditions just 83 like create() does 84 - Make get_inflated_columns behave identically to get_columns 85 wrt +select/+as (RT#46953) 86 - Fix problems with scalarrefs under InflateColumn (RT#51559) 87 - Throw exception on delete/update of PK-less resultsets 88 - Refactored Sybase storage driver into a central ::DBI::Sybase 89 dispatcher, and a sybase-specific ::DBI::Sybase::ASE 90 - Fixed an atrocious DBD::ADO bind-value bug 91 - Cookbook/Intro POD improvements 92 930.08114 2009-11-14 17:45:00 (UTC) 94 - Preliminary support for MSSQL via DBD::ADO 95 - Fix botched 0.08113 release (invalid tarball) 96 970.08113 2009-11-13 23:13:00 (UTC) 98 - Fix populate with has_many bug 99 (RT #50828) 100 - Fix Oracle autoincrement broken for Resultsets with scalar refs 101 (RT #50874) 102 - Complete Sybase RDBMS support including: 103 - Support for TEXT/IMAGE columns 104 - Support for the 'money' datatype 105 - Transaction savepoints support 106 - DateTime inflation support 107 - Support for bind variables when connecting to a newer Sybase with 108 OpenClient libraries 109 - Support for connections via FreeTDS with CASTs for bind variables 110 when needed 111 - Support for interpolated variables with proper quoting when 112 connecting to an older Sybase and/or via FreeTDS 113 - bulk API support for populate() 114 - Transaction support for MSSQL via DBD::Sybase 115 - Add is_paged method to DBIx::Class::ResultSet so that we can 116 check that if we want a pager 117 - Skip versioning test on really old perls lacking Time::HiRes 118 (RT #50209) 119 - Fixed on_connect_do/call regression when used with a coderef 120 connector (RT #50003) 121 - A couple of fixes to Ordered to remedy subclassing issues 122 - Fixed another lingering problem with PostgreSQL 123 auto-increment support and its interaction with multiple 124 schemas 125 - Remove some IN workarounds, and require a recent version of 126 SQLA instead 127 - Improvements to populate's handling of mixed scalarref values 128 - Fixed regression losing result_class after $rs->find (introduced 129 in 0.08108) 130 - Fix in_storage() to return 1|0 as per existing documentation 131 - Centralize handling of _determine_driver calls prior to certain 132 ::Storage::DBI methods 133 - Fix update/delete arbitrary condition handling (RT#51409) 134 - POD improvements 135 1360.08112 2009-09-21 10:57:00 (UTC) 137 - Remove the recommends from Makefile.PL, DBIx::Class is not 138 supposed to have optional dependencies. ever. 139 - Mangle the DBIx/Class.pm POD to be more clear about 140 copyright and license 141 - Put back PG's multiple autoinc per table support, accidentally 142 dropped during the serial-autodetection rewrite 143 - Make sure ResultSetColumn does not depend on the (undefined) 144 return value of ->cursor->reset() 145 - Add single() to ResultSetColumn (same semantics as ResultSet) 146 - Make sure to turn off IDENTITY_INSERT after insert() on MSSQL 147 tables that needed it 148 - More informative exception on failing _resolve_relationship 149 - Allow undef/NULL as the sole grouping value in Ordered 150 - Fix unreported rollback exceptions in TxnScopeGuard 151 - Fix overly-eager left-join chain enforcing code 152 - Warn about using distinct with an existing group_by 153 - Warn about attempting to $rs->get_column a non-unique column 154 when has_many joins are added to resultset 155 - Refactor of the exception handling system (now everything is a 156 DBIx::Class::Exception object) 157 1580.08111 2009-09-06 21:58:00 (UTC) 159 - The hashref to connection_info now accepts a 'dbh_maker' 160 coderef, allowing better intergration with Catalyst 161 - Fixed a complex prefetch + regular join regression introduced 162 in 0.08108 163 - Fixed insert_bulk rebless handling 164 - Fixed Storable roundtrip regression, and general serialization 165 cleanup 166 - SQLT related fixes: 167 - sqlt_type is now called on the correct storage object 168 - hooks can now see the correct producer_type (RT#47891) 169 - optional SQLT requirements for e.g. deploy() bumped to 0.11002 170 - Really fixed (and greatly cleaned up) postgresql autoinc sequence 171 autodetection 172 - Automatically detect MySQL v3 and use INNER JOIN instead of JOIN 173 - POD improvements (including RT#48769) 174 - Test suite tweaks (including fixes for recent CPANTS fails) 175 - Better support for MSSQL IDENTITY_INSERT ON 176 1770.08109 2009-08-18 08:35:00 (UTC) 178 - Replication updates: 179 - Improved the replication tests so that they are more reliable 180 and accurate, and hopefully solve some cross platform issues. 181 - Bugfixes related to naming particular replicants in a 182 'force_pool' attribute. 183 - Lots of documentation updates, including a new Introduction.pod 184 file. 185 - Fixed the way we detect transaction to make this more reliable 186 and forward looking. 187 - Fixed some trouble with the way Moose Types are used. 188 - Made discard_chages/get_from_storage replication aware (they 189 now read from the master storage by default) 190 - Refactor of MSSQL storage drivers, with some new features: 191 - Support for placeholders for MSSQL via DBD::Sybase with proper 192 autodetection 193 - 'uniqueidentifier' support with auto newid() 194 - Dynamic cursor support and other MARS options for ODBC 195 - savepoints with auto_savepoint => 1 196 - Support for MSSQL 'money' type 197 - Support for 'smalldatetime' type used in MSSQL and Sybase for 198 InflateColumn::DateTime 199 - Support for Postgres 'timestamp without timezone' type in 200 InflateColumn::DateTime (RT#48389) 201 - Added new MySQL specific on_connect_call macro 'set_strict_mode' 202 (also known as make_mysql_not_suck_as_much) 203 - Multiple prefetch-related fixes: 204 - Adjust overly agressive subquery join-chain pruning 205 - Always preserve the outer join-chain - fixes numerous 206 problems with search_related chaining 207 - Deal with the distinct => 1 attribute properly when using 208 prefetch 209 - An extension of the select-hashref syntax, allowing labeling 210 SQL-side aliasing: select => [ { max => 'foo', -as => 'bar' } ] 211 - Massive optimization of the DBI storage layer - reduce the 212 amount of connected() ping-calls 213 - Some fixes of multi-create corner cases 214 - Multiple POD improvements 215 - Added exception when resultset is called without an argument 216 - Improved support for non-schema-qualified tables under 217 Postgres (fixed last_insert_id sequence name auto-detection) 218 2190.08108 2009-07-05 23:15:00 (UTC) 220 - Fixed the has_many prefetch with limit/group deficiency - 221 it is now possible to select "top 5 commenters" while 222 prefetching all their comments 223 - New resultsed method count_rs, returns a ::ResultSetColumn 224 which in turn returns a single count value 225 - Even better support of count with limit 226 - New on_connect_call/on_disconnect_call functionality (check 227 POD of Storage::DBI) 228 - Automatic datetime handling environment/session setup for 229 Oracle via connect_call_datetime_setup() 230 - count/all on related left-joined empty resultsets now correctly 231 returns 0/() 232 - Fixed regression when both page and offset are specified on 233 a resultset 234 - Fixed HRI returning too many empty results on multilevel 235 nonexisting prefetch 236 - make_column_dirty() now overwrites the deflated value with an 237 inflated one if such exists 238 - Fixed set_$rel with where restriction deleting rows outside 239 the restriction 240 - populate() returns the created objects or an arrayref of the 241 created objects depending on scalar vs. list context 242 - Fixed find_related on 'single' relationships - the former 243 implementation would overspecify the WHERE condition, reporting 244 no related objects when there in fact is one 245 - SQL::Translator::Parser::DBIx::Class now attaches tables to the 246 central schema object in relationship dependency order 247 - Fixed regression in set_column() preventing sourceless object 248 manipulations 249 - Fixed a bug in search_related doubling a join if the original 250 $rs already joins/prefetches the same relation 251 - Storage::DBI::connected() improvements for Oracle and Sybase 252 - Fixed prefetch+incomplete select regression introduced in 253 0.08100 254 - MSSQL limit (TOP emulation) fixes and improvements 255 2560.08107 2009-06-14 08:21:00 (UTC) 257 - Fix serialization regression introduced in 0.08103 (affects 258 Cursor::Cached) 259 - POD fixes 260 - Fixed incomplete ::Replicated debug output 261 2620.08106 2009-06-11 21:42:00 (UTC) 263 - Switched SQLite storage driver to DateTime::Format::SQLite 264 (proper timezone handling) 265 - Fix more test problems 266 2670.08105 2009-06-11 19:04:00 (UTC) 268 - Update of numeric columns now properly uses != to determine 269 dirtyness instead of the usual eq 270 - Fixes to IC::DT tests 271 - Fixed exception when undef_if_invalid and timezone are both set 272 on an invalid datetime column 273 2740.08104 2009-06-10 13:38:00 (UTC) 275 - order_by now can take \[$sql, @bind] as in 276 order_by => { -desc => \['colA LIKE ?', 'somestring'] } 277 - SQL::Abstract errors are now properly croak()ed with the 278 correct trace 279 - populate() now properly reports the dataset slice in case of 280 an exception 281 - Fixed corner case when populate() erroneously falls back to 282 create() 283 - Work around braindead mysql when doing subquery counts on 284 resultsets containing identically named columns from several 285 tables 286 - Fixed m2m add_to_$rel to invoke find_or_create on the far 287 side of the relation, to avoid duplicates 288 - DBIC now properly handles empty inserts (invoking all default 289 values from the DB, normally via INSERT INTO tbl DEFAULT VALUES 290 - Fix find_or_new/create to stop returning random rows when 291 default value insert is requested (RT#28875) 292 - Make IC::DT extra warning state the column name too 293 - It is now possible to transparrently search() on columns 294 requiring DBI bind (i.e. PostgreSQL BLOB) 295 - as_query is now a Storage::DBI method, so custom cursors can 296 be seamlessly used 297 - Fix search_related regression introduced in 0.08103 298 2990.08103 2009-05-26 19:50:00 (UTC) 300 - Multiple $resultset -> count/update/delete fixes. Now any 301 of these operations will succeed, regardless of the complexity 302 of $resultset. distinct, group_by, join, prefetch are all 303 supported with expected results 304 - Return value of $rs->delete is now the storage return value 305 and not 1 as it used to be 306 - don't pass SQL functions into GROUP BY 307 - Remove MultiDistinctEmulation.pm, effectively deprecating 308 { select => { distinct => [ qw/col1 col2/ ] } } 309 - Change ->count code to work correctly with DISTINCT (distinct => 1) 310 via GROUP BY 311 - Removed interpolation of bind vars for as_query - placeholders 312 are preserved and nested query bind variables are properly 313 merged in the correct order 314 - Refactor DBIx::Class::Storage::DBI::Sybase to automatically 315 load a subclass, namely Microsoft_SQL_Server.pm 316 (similar to DBIx::Class::Storage::DBI::ODBC) 317 - Refactor InflateColumn::DateTime to allow components to 318 circumvent DateTime parsing 319 - Support inflation of timestamp datatype 320 - Support BLOB and CLOB datatypes on Oracle 321 - Storage::DBI::Replicated::Balancer::Random: 322 added master_read_weight 323 - Storage::DBI::Replicated: storage opts from connect_info, 324 connect_info merging to replicants, hashref connect_info support, 325 improved trace output, other bug fixes/cleanups 326 - distinct => 1 with prefetch now groups by all columns 327 - on_connect_do accepts a single string equivalent to a one 328 element arrayref (RT#45159) 329 - DB2 limit + offset now works correctly 330 - Sybase now supports autoinc PKs (RT#40265) 331 - Prefetch on joins over duplicate relations now works 332 correctly (RT#28451) 333 - "timestamp with time zone" columns (for Pg) now get inflated with a 334 time zone information preserved 335 - MSSQL Top limit-emulation improvements (GROUP BY and subquery support) 336 - ResultSetColumn will not lose the joins infered from a parent 337 resultset prefetch 338 3390.08102 2009-04-30 08:29:00 (UTC) 340 - Fixed two subtle bugs when using columns or select/as 341 paired with a join (limited prefetch) 342 - Fixed breakage of cdbi tests (RT#45551) 343 - Some POD improvements 344 3450.08101 2009-04-27 09:45:00 (UTC) 346 - Fix +select, +as, +columns and include_columns being stripped 347 by $rs->get_column 348 - move load_optional_class from DBIx::Class::Componentised to 349 Class::C3::Componentised, bump dependency 350 - register_extra_source() now *really* fixed wrt subclassing 351 - Added missing POD descriptions (RT#45195) 352 - Fix insert() to not store_column() every present object column 353 - Multiple Makefile.PL fixes 354 3550.08100 2009-04-19 11:39:35 (UTC) 356 - Todo out the register_extra_source test until after shipping 357 3580.08099_08 2009-03-30 00:00:00 (UTC) 359 - Fixed taint mode with load_namespaces 360 - Putting IC::DateTime locale, timezone or floating_tz_ok attributes into 361 extra => {} has been deprecated. The new way is to put these things 362 directly into the columns definition 363 - Switched MI code to MRO::Compat 364 - Document db-side default_value caveats 365 - Search_like() now warns to indicate deprecation in 0.09. 366 - TxnScopeGuard left experimental state 367 3680.08099_07 2009-02-27 02:00:00 (UTC) 369 - multi-create using find_or_create rather than _related for post-insert 370 - fix get_inflated_columns to check has_column_loaded 371 - Add DBIC_MULTICREATE_DEBUG env var (undocumented, quasi-internal) 372 - Fix up multi-create to: 373 - correctly propagate columns loaded during multi-insert of rels 374 - not try and insert things tagged on via new_related unless required 375 - Possible to set locale in IC::DateTime extra => {} config 376 - Calling the accessor of a belongs_to when the foreign_key 377 was NULL and the row was not stored would unexpectedly fail 378 - Split sql statements for deploy only if SQLT::Producer returned a scalar 379 containing all statements to be executed 380 - Add as_query() for ResultSet and ResultSetColumn. This makes subqueries 381 possible. See the Cookbook for details. 382 - Massive rewrite of Ordered to properly handle position constraints and 383 to make it more matpath-friendly 384 - deploy_statements called ddl_filename with the $version and $dir arguments 385 in the wrong order. 386 - columns/+columns attributes now support { as => select } hahsrefs 387 - support for views both in DBIC and via deploy() in SQLT 388 3890.08099_06 2009-01-23 07:30:00 (UTC) 390 - Allow a scalarref to be supplied to the 'from' resultset attribute 391 - Classes submitted as result_class for a resultsource are now 392 automatically loaded via ensure_loaded() 393 - 'result_class' resultset attribute, identical to result_class() 394 - add 'undef_on_null_fk' option for relationship accessors of type 'single'. 395 This will prevent DBIC from querying the database if one or more of 396 the key columns IS NULL 397 - for 'belongs_to' rels, 'undef_on_null_fk' defaults to true. 398 - fixed scope unaware last_insert_id fetching for MSSQL 399 (http://msdn.microsoft.com/en-us/library/ms190315.aspx) 400 - an sqlt_deploy_hook can now be shared between result sources using 401 a configurable callback trigger 402 - new order_by => { -desc => 'colname' } syntax supported 403 - PG array datatype supported 404 - insert should use store_column, not set_column to avoid marking 405 clean just-stored values as dirty. New test for this 406 - regression test for source_name 407 4080.08099_05 2008-10-30 21:30:00 (UTC) 409 - Rewrite of Storage::DBI::connect_info(), extended with an 410 additional argument format type 411 - InflateColumn::DateTime: add warning about floating timezone 412 - InflateColumn::DateTime: possible to enforce/skip inflation 413 - delete throws exception if passed arguments to prevent drunken mishaps. 414 - Fix storage to copy scalar conds before regexping to avoid 415 trying to modify a constant in odd edge cases 416 - Related resultsets on uninserted objects are now empty 417 - Fixed up related resultsets and multi-create 418 - Fixed superfluous connection in ODBC::_rebless 419 - Fixed undef PK for first insert in ODBC::Microsoft_SQL_Server 420 - Added virtual method to Versioned so a user can create upgrade 421 path across multiple versions (jgoulah) 422 - Better (and marginally faster) implementation of the HashRefInflator 423 hash construction algorithm 424 - Allow explicit specification of ON DELETE/ON UPDATE constraints 425 when using the SQLT parser 426 4270.08099_04 2008-07-24 01:00:00 428 - Functionality to storage to enable a sub to be run without FK checks 429 - Fixed $schema->clone bug which caused clone and source to share 430 internal hash refs 431 - Added register_extra_source methods for additional sources 432 - Added datetime_undef_if_invalid for InflateColumn::DateTime to 433 return undef on invalid date/time values 434 - Added search_related_rs method to ResultSet 435 - add a make_column_dirty method to Row to force updates 436 - throw a clear exception when user tries multi-has_many prefetch 437 - SQLT parser prefixes index names with ${table}_idx_ to avoid clashes 438 - mark ResultSetManager as deprecated and undocument it 439 - pod fix (RT #32988) 440 - add Test::Exception to test requirements (RT #34256) 441 - make ash's build_requires/META.yml fixes work better 442 - is_deferable support on relations used by the SQL::Translator 443 parser 444 - Refactored DBIx::Class::Schema::Versioned 445 - Syntax errors from resultset components are now reported correctly 446 - sqltargs respected correctly in deploy et al. 447 - Added support for savepoints, and using them automatically in 448 nested transactions if auto_savepoint is set in connect_info. 449 - Changed naming scheme for constraints and keys in the sqlt parser; 450 names should now be consistent and collision-free. 451 - Improve handling of explicit key attr in ResultSet::find 452 - Add warnings for non-unique ResultSet::find queries 453 - Changed Storage::DBI::Replication to Storage::DBI::Replicated and 454 refactored support. 455 - By default now deploy/diff et al. will ignore constraint and index 456 names 457 - Add ResultSet::_is_deterministic_value, make new_result filter the 458 values passed to new to drop values that would generate invalid SQL. 459 - Use Sub::Name to name closures before installing them. Fixes 460 incompatibility with Moose method modifiers on generated methods. 461 4620.08010 2008-03-01 10:30 463 - Fix t/94versioning.t so it passes with latest SQL::Translator 464 4650.08009 2008-01-20 13:30 466 - Made search_rs smarter about when to preserve the cache to fix 467 mm prefetch usage 468 - Added Storage::DBI subclass for MSSQL over ODBC. 469 - Added freeze, thaw and dclone methods to Schema so that thawed 470 objects will get re-attached to the schema. 471 - Moved dbicadmin to JSON::Any wrapped JSON.pm for a sane API 472 (also fixes RT #32393) 473 - introduced DBIx::Class::set_inflated_columns 474 - DBIx::Class::Row::copy uses set_inflated_columns 475 4760.08008 2007-11-16 14:30:00 477 - Fixed join merging bug (test from Zby) 478 - When adding relationships, it will throw an exception if you get the 479 foreign and self parts the wrong way round in the condition 480 - ResultSetColumn::func() now returns all results if called in list 481 context; this makes things like func('DISTINCT') work as expected 482 - Many-to-many relationships now warn if the utility methods would 483 clash 484 - InflateColumn::DateTime now accepts an extra parameter of timezone 485 to set timezone on the DT object (thanks Sergio Salvi) 486 - Added sqlt_deploy_hook to result classes so that indexes can be 487 added. 488 - Added startup checks to warn loudly if we appear to be running on 489 RedHat systems from perl-5.8.8-10 and up that have the bless/overload 490 patch applied (badly) which causes 2x -> 100x performance penalty. 491 (Jon Schutz) 492 - ResultSource::reverse_relationship_info can distinguish between 493 sources using the same table 494 - Row::insert will now not fall over if passed duplicate related objects 495 - Row::copy will not fall over if you have two relationships to the 496 same source with a unique constraint on it 497 4980.08007 2007-09-04 19:36:00 499 - patch for Oracle datetime inflation (abram@arin.net) 500 - added on_disconnect_do 501 - on_connect_do and on_disconnect_do take coderefs and arrayrefs 502 5030.08006 2007-08-12 15:12:00 504 - Move to using Class::C3::Componentised 505 - Remove warn statement from DBIx::Class::Row 506 5070.08005 2007-08-06 508 - add timestamp fix re rt.cpan 26978 - no test yet but change 509 clearly should cause no regressions 510 - provide alias for related_resultset via local() so it's set 511 correctly at resultset construction time (fixes RestrictWithObject) 512 - fixes bind params in debug statements 513 (original test from abraxxa) 514 - fixed storage->connected fork bug 515 (test and fix from Radu Greab) 516 - add 1; to AccessorGroup.pm for stuff that still uses it 517 - refactor Statistics to create debugging filehandle to fix bug with 518 closed STDERR, update docs and modify Versioned to use Statistics 519 (original fix from diz) 520 5210.08004 2007-08-06 19:00:00 522 - fix storage connect code to not trigger bug via auto-viv 523 (test from aherzog) 524 - fixup cursor_class to be an 'inherited' attr for per-package defaults 525 - add default_resultset_attributes entry to Schema 526 - optimisation in DBI::Cursor to check software_limit before falling 527 back to base Cursor->all 528 - fix bug with create_multi not inserting non-storage objects 529 (test and fix from davinchi) 530 - DBIx::Class::AccessorGroup made empty subclass of 531 Class::Accessor::Grouped 532 - fixed an ugly bug regarding $dbh->{AutoCommit} and transactions 533 - ensure_class_loaded handles non-classnames better. 534 - non-destructive hashref handling for connect_info options 535 - count no longer returns negative values after slice 536 (report and test from JOHANL) 537 - rebless before building datetime_parser 538 (patch from mattlaw / Matt Lawrence) 539 5400.08003 2007-07-14 18:01:00 541 - improved populate bulk_insert mode 542 - fixed up multi_create to be more intelligent about PK<->PK rels 543 - fix many-many rels to not use set_columns 544 - Unmarked deploy as experimental since it isn't anymore 545 - Removed Cwd dep since it's not required and causes problems 546 with debian packaging 547 - Patch to fix ? in data for NoBindVars (from Tom Hukins) 548 - Restored mk_classaccessor method for compatibility 549 - Fixed group_by problem with oracle limit syntax 550 - Fixed attr merging problem 551 - Fixed $rs->get_column w/prefetch problem 552 5530.08002 2007-06-20 06:10:00 554 - add scope guard to Row::insert to ensure rollback gets called 555 - more heuristics in Row::insert to try and get insert order right 556 - eliminate vestigial code in PK::Auto 557 - more expressive DBI errors 558 - soften errors during deploy 559 - ensure_connected before txn_begin to catch stomping on transaction 560 depth 561 - new method "rethrow" for our exception objects 562 5630.08001 2007-06-17 21:21:02 564 - Cleaned up on_connect handling for versioned 565 - removed DateTime use line from multi_create test 566 - hid DBIx::ContextualFetch::st override in CDBICompat 567 5680.08000 2007-06-17 18:06:12 569 - Fixed DBIC_TRACE debug filehandles to set ->autoflush(1) 570 - Fixed circular dbh<->storage in HandleError with weakref 571 5720.07999_06 2007-06-13 04:45:00 573 - tweaked Row.pm to make last_insert_id take multiple column names 574 - Fixed DBIC::Storage::DBI::Cursor::DESTROY bug that was 575 messing up exception handling 576 - added exception objects to eliminate stacktrace/Carp::Clan 577 output redundancy 578 - setting $ENV{DBIC_TRACE} defaults stacktrace on. 579 - added stacktrace option to Schema, makes throw_exception 580 use "confess" 581 - make database handles use throw_exception by default 582 - make database handles supplied by a coderef use our 583 standard HandleError/RaiseError/PrintError 584 - add "unsafe" connect_info option to suppress our setting 585 of HandleError/RaiseError/PrintError 586 - removed several redundant evals whose sole purpose was to 587 provide extra debugging info 588 - fixed page-within-page bug (reported by nilsonsfj) 589 - fixed rare bug when database is disconnected inbetween 590 "$dbh->prepare_cached" and "$sth->execute" 591 5920.07999_05 2007-06-07 23:00:00 593 - Made source_name rw in ResultSource 594 - Fixed up SQL::Translator test/runtime dependencies 595 - Fixed t/60core.t in the absence of DateTime::Format::MySQL 596 - Test cleanup and doc note (ribasushi) 597 5980.07999_04 2007-06-01 14:04:00 599 - pulled in Replication storage from branch and marked EXPERIMENTAL 600 - fixup to ensure join always LEFT after first LEFT join depthwise 601 - converted the vendor tests to use schema objects intead of schema 602 classes, made cleaned more reliable with END blocks 603 - versioning support via DBIx::Class::Schema::Versioned 604 - find/next now return undef rather than () on fail from Bernhard Graf 605 - rewritten collapse_result to fix prefetch 606 - moved populate to resultset 607 - added support for creation of related rows via insert and populate 608 - transaction support more robust now in the face of varying AutoCommit 609 and manual txn_begin usage 610 - unbreak back-compat for Row/ResultSet->new_result 611 - Added Oracle/WhereJoins.pm for Oracle >= 8 to support 612 Oracle <= 9i, and provide Oracle with a better join method for 613 later versions. (I use the term better loosely.) 614 - The SQL::T parser class now respects a relationship attribute of 615 is_foreign_key_constrain to allow explicit control over wether or 616 not a foreign constraint is needed 617 - resultset_class/result_class now (again) auto loads the specified 618 class; requires Class::Accessor::Grouped 0.05002+ 619 - added get_inflated_columns to Row 620 - %colinfo accessor and inflate_column now work together 621 - More documentation updates 622 - Error messages from ->deploy made more informative 623 - connect_info will now always return the arguments it was 624 originally given 625 - A few small efficiency improvements for load_classes 626 and compose_namespace 627 6280.07006 2007-04-17 23:18:00 629 - Lots of documentation updates 630 - deploy now takes an optional 'source_names' parameter (dec) 631 - Quoting for for columns_info_for 632 - RT#25683 fixed (multiple open sths on DBD::Sybase) 633 - CDBI compat infers has_many from has_a (Schwern) 634 - Fix ddl_filename transformation (Carl Vincent) 635 6360.07999_02 2007-01-25 20:11:00 637 - add support for binding BYTEA and similar parameters (w/Pg impl) 638 - add support to Ordered for multiple ordering columns 639 - mark DB.pm and compose_connection as deprecated 640 - switch tests to compose_namespace 641 - ResultClass::HashRefInflator added 642 - Changed row and rs objects to not have direct handle to a source, 643 instead a (schema,source_name) tuple of type ResultSourceHandle 644 6450.07005 2007-01-10 18:36:00 646 - fixup changes file 647 - remove erroneous .orig files - oops 648 6490.07004 2007-01-09 21:52:00 650 - fix find_related-based queries to correctly grep the unique key 651 - fix InflateColumn to inflate/deflate all refs but scalar refs 652 6530.07003 2006-11-16 11:52:00 654 - fix for rt.cpan.org #22740 (use $^X instead of hardcoded "perl") 655 - Tweaks to resultset to allow inflate_result to return an array 656 - Fix UTF8Columns to work under Perl <= 5.8.0 657 - Fix up new_result in ResultSet to avoid alias-related bugs 658 - Made new/update/find handle 'single' rel accessor correctly 659 - Fix NoBindVars to be safer and handle non-true bind values 660 - Don't blow up if columns_info_for returns useless results 661 - Documentation updates 662 6630.07999_01 2006-10-05 21:00:00 664 - add connect_info option "disable_statement_caching" 665 - create insert_bulk using execute_array, populate uses it 666 - added DBIx::Class::Schema::load_namespaces, alternative to 667 load_classes 668 - added source_info method for source-level metadata (kinda like 669 column_info) 670 - Some of ::Storage::DBI's code/docs moved to ::Storage 671 - DBIx::Class::Schema::txn_do code moved to ::Storage 672 - Storage::DBI now uses exceptions instead of ->ping/->{Active} checks 673 - Storage exceptions are thrown via the schema class's throw_exception 674 - DBIx::Class::Schema::throw_exception's behavior can be modified via 675 ->exception_action 676 - columns_info_for is deprecated, and no longer runs automatically. 677 You can make it work like before via 678 __PACKAGE__->column_info_from_storage(1) for now 679 - Replaced DBIx::Class::AccessorGroup and Class::Data::Accessor with 680 Class::Accessor::Grouped. Only user noticible change is to 681 table_class on ResultSourceProxy::Table (i.e. table objects in 682 schemas) and, resultset_class and result_class in ResultSource. 683 These accessors no longer automatically require the classes when 684 set. 685 6860.07002 2006-09-14 21:17:32 687 - fix quote tests for recent versions of SQLite 688 - added reference implementation of Manual::Example 689 - backported column_info_from_storage accessor from -current, but 690 - fixed inflate_datetime.t tests/stringify under older Test::More 691 - minor fixes for many-to-many relationship helpers 692 - cleared up Relationship docs, and fixed some typos 693 - use ref instead of eval to check limit syntax (to avoid issues with 694 Devel::StackTrace) 695 - update ResultSet::_cond_for_update_delete to handle more complicated 696 queries 697 - bugfix to Oracle columns_info_for 698 - remove_columns now deletes columns from _columns 699 7000.07001 2006-08-18 19:55:00 701 - add directory argument to deploy() 702 - support default aliases in many_to_many accessors. 703 - support for relationship attributes in many_to_many accessors. 704 - stop search_rs being destructive to attrs 705 - better error reporting when loading components 706 - UTF8Columns changed to use "utf8" instead of "Encode" 707 - restore automatic aliasing in ResultSet::find() on nonunique queries 708 - allow aliases in ResultSet::find() queries (in cases of relationships 709 with prefetch) 710 - pass $attrs to find from update_or_create so a specific key can be 711 provided 712 - remove anonymous blesses to avoid major speed hit on Fedora Core 5's 713 Perl and possibly others; for more information see: 714 https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=196836 715 - fix a pathological prefetch case 716 - table case fix for Oracle in columns_info_for 717 - stopped search_rs deleting attributes from passed hash 718 7190.07000 2006-07-23 02:30:00 720 - supress warnings for possibly non-unique queries, since 721 _is_unique_query doesn't infer properly in all cases 722 - skip empty queries to eliminate spurious warnings on ->deploy 723 - fixups to ORDER BY, tweaks to deepen some copies in ResultSet 724 - fixup for RowNum limit syntax with functions 725 7260.06999_07 2006-07-12 20:58:05 727 - fix issue with from attr copying introduced in last release 728 7290.06999_06 2006-07-12 17:16:55 730 - documentation for new storage options, fix S::A::L hanging on to $dbh 731 - substantial refactor of search_related code to fix alias numbering 732 - don't generate partial unique keys in ResultSet::find() when a table 733 has more than one unique constraint which share a column and only one 734 is satisfied 735 - cleanup UTF8Columns and make more efficient 736 - rename DBIX_CLASS_STORAGE_DBI_DEBUG to DBIC_TRACE (with compat) 737 - rename _parent_rs to _parent_source in ResultSet 738 - new FAQ.pod! 739 7400.06999_05 2006-07-04 14:40:01 741 - fix issue with incorrect $rs->{attrs}{alias} 742 - fix subclassing issue with source_name 743 - tweak quotes test to output text on failure 744 - fix Schema->txn_do to not fail as a classmethod 745 7460.06999_04 2006-06-29 20:18:47 747 - disable cdbi-t/02-Film.t warning tests under AS perl 748 - fixups to MySQL tests (aka "work round mysql being retarded") 749 - compat tweaks for Storage debug logging 750 7510.06999_03 2006-06-26 21:04:44 752 - various documentation improvements 753 - fixes to pass test suite on Windows 754 - rewrote and cleaned up SQL::Translator tests 755 - changed relationship helpers to only call ensure_class_loaded when the 756 join condition is inferred 757 - rewrote many_to_many implementation, now provides helpers for adding 758 and deleting objects without dealing with the link table 759 - reworked InflateColumn implementation to lazily deflate where 760 possible; now handles passing an inflated object to new() 761 - changed join merging to not create a rel_2 alias when adding a join 762 that already exists in a parent resultset 763 - Storage::DBI::deployment_statements now calls ensure_connected 764 if it isn't passed a type 765 - fixed Componentized::ensure_class_loaded 766 - InflateColumn::DateTime supports date as well as datetime 767 - split Storage::DBI::MSSQL into MSSQL and Sybase::MSSQL 768 - fixed wrong debugging hook call in Storage::DBI 769 - set connect_info properly before setting any ->sql_maker things 770 7710.06999_02 2006-06-09 23:58:33 772 - Fixed up POD::Coverage tests, filled in some POD holes 773 - Added a warning for incorrect component order in load_components 774 - Fixed resultset bugs to do with related searches 775 - added code and tests for Componentized::ensure_class_found and 776 load_optional_class 777 - NoBindVars + Sybase + MSSQL stuff 778 - only rebless S::DBI if it is still S::DBI and not a subclass 779 - Added `use' statement for DBD::Pg in Storage::DBI::Pg 780 - stopped test relying on order of unordered search 781 - bugfix for join-types in nested joins using the from attribute 782 - obscure prefetch problem fixed 783 - tightened up deep search_related 784 - Fixed 'DBIx/Class/DB.pm did not return a true value' error 785 - Revert change to test for deprecated find usage and swallow warnings 786 - Slight wording change to new_related() POD 787 - new specific test for connect_info coderefs 788 - POD clarification and content bugfixing + a few code formatting fixes 789 - POD::Coverage additions 790 - fixed debugfh 791 - Fix column_info stomping 792 7930.06999_01 2006-05-28 17:19:30 794 - add automatic naming of unique constraints 795 - marked DB.pm as deprecated and noted it will be removed by 1.0 796 - add ResultSetColumn 797 - refactor ResultSet code to resolve attrs as late as possible 798 - merge prefetch attrs into join attrs 799 - add +select and +as attributes to ResultSet 800 - added InflateColumn::DateTime component 801 - refactor debugging to allow for profiling using Storage::Statistics 802 - removed Data::UUID from deps, made other optionals required 803 - modified SQLT parser to skip dupe table names 804 - added remove_column(s) to ResultSource/ResultSourceProxy 805 - added add_column alias to ResultSourceProxy 806 - added source_name to ResultSource 807 - load_classes now uses source_name and sets it if necessary 808 - add update_or_create_related to Relationship::Base 809 - add find_or_new to ResultSet/ResultSetProxy and find_or_new_related 810 to Relationship::Base 811 - add accessors for unique constraint names and coulums to 812 ResultSource/ResultSourceProxy 813 - rework ResultSet::find() to search unique constraints 814 - CDBICompat: modify retrieve to fix column casing when ColumnCase is 815 loaded 816 - CDBICompat: override find_or_create to fix column casing when 817 ColumnCase is loaded 818 - reorganized and simplified tests 819 - added Ordered 820 - added the ability to set on_connect_do and the various sql_maker 821 options as part of Storage::DBI's connect_info. 822 8230.06003 2006-05-19 15:37:30 824 - make find_or_create_related check defined() instead of truth 825 - don't unnecessarily fetch rels for cascade_update 826 - don't set_columns explicitly in update_or_create; instead use 827 update($hashref) so InflateColumn works 828 - fix for has_many prefetch with 0 related rows 829 - make limit error if rows => 0 830 - added memory cycle tests and a long-needed weaken call 831 8320.06002 2006-04-20 00:42:41 833 - fix set_from_related to accept undef 834 - fix to Dumper-induced hash iteration bug 835 - fix to copy() with non-composed resultsource 836 - fix to ->search without args to clone rs but maintain cache 837 - grab $self->dbh once per function in Storage::DBI 838 - nuke ResultSource caching of ->resultset for consistency reasons 839 - fix for -and conditions when updating or deleting on a ResultSet 840 8410.06001 842 - Added fix for quoting with single table 843 - Substantial fixes and improvements to deploy 844 - slice now uses search directly 845 - fixes for update() on resultset 846 - bugfix to Cursor to avoid error during DESTROY 847 - transaction DBI operations now in debug trace output 848 8490.06000 2006-03-25 18:03:46 850 - Lots of documentation improvements 851 - Minor tweak to related_resultset to prevent it storing a searched rs 852 - Fixup to columns_info_for when database returns type(size) 853 - Made do_txn respect void context (on the off-chance somebody cares) 854 - Fix exception text for nonexistent key in ResultSet::find() 855 8560.05999_04 2006-03-18 19:20:49 857 - Fix for delete on full-table resultsets 858 - Removed caching on count() and added _count for pager() 859 - ->connection does nothing if ->storage defined and no args 860 (and hence ->connect acts like ->clone under the same conditions) 861 - Storage::DBI throws better exception if no connect info 862 - columns_info_for made more robust / informative 863 - ithreads compat added, fork compat improved 864 - weaken result_source in all resultsets 865 - Make pg seq extractor less sensitive. 866 8670.05999_03 2006-03-14 01:58:10 868 - has_many prefetch fixes 869 - deploy now adds drop statements before creates 870 - deploy outputs debugging statements if DBIX_CLASS_STORAGE_DBI_DEBUG 871 is set 872 8730.05999_02 2006-03-10 13:31:37 874 - remove test dep on YAML 875 - additional speed tweaks for C3 876 - allow scalarefs passed to order_by to go straight through to SQL 877 - renamed insert_or_update to update_or_insert (with compat alias) 878 - hidden lots of packages from the PAUSE Indexer 879 8800.05999_01 2006-03-09 18:31:44 881 - renamed cols attribute to columns (cols still supported) 882 - added has_column_loaded to Row 883 - Storage::DBI connect_info supports coderef returning dbh as 1st arg 884 - load_components() doesn't prepend base when comp. prefixed with + 885 - $schema->deploy 886 - HAVING support 887 - prefetch for has_many 888 - cache attr for resultsets 889 - PK::Auto::* no longer required since Storage::DBI::* handle auto-inc 890 - minor tweak to tests for join edge case 891 - added cascade_copy relationship attribute 892 (sponsored by Airspace Software, http://www.airspace.co.uk/) 893 - clean up set_from_related 894 - made copy() automatically null out auto-inc columns 895 - added txn_do() method to Schema, which allows a coderef to be 896 executed atomically 897 8980.05007 2006-02-24 00:59:00 899 - tweak to Componentised for Class::C3 0.11 900 - fixes for auto-inc under MSSQL 901 9020.05006 2006-02-17 15:32:40 903 - storage fix for fork() and workaround for Apache::DBI 904 - made update(\%hash) work on row as well as rs 905 - another fix for count with scalar group_by 906 - remove dependency on Module::Find in 40resultsetmanager.t (RT #17598) 907 9080.05005 2006-02-13 21:24:51 909 - remove build dependency on version.pm 910 9110.05004 2006-02-13 20:59:00 912 - allow specification of related columns via cols attr when primary 913 keys of the related table are not fetched 914 - fix count for group_by as scalar 915 - add horrific fix to make Oracle's retarded limit syntax work 916 - remove Carp require 917 - changed UUIDColumns to use new UUIDMaker classes for uuid creation 918 using whatever module may be available 919 9200.05003 2006-02-08 17:50:20 921 - add component_class accessors and use them for *_class 922 - small fixes to Serialize and ResultSetManager 923 - rollback on disconnect, and disconnect on DESTROY 924 9250.05002 2006-02-06 12:12:03 926 - Added recommends for Class::Inspector 927 - Added skip_all to t/40resultsetmanager.t if no Class::Inspector 928 available 929 9300.05001 2006-02-05 15:28:10 931 - debug output now prints NULL for undef params 932 - multi-step prefetch along the same rel (e.g. for trees) now works 933 - added multi-join (join => [ 'foo', 'foo' ]), aliases second to foo_2 934 - hack PK::Auto::Pg for "table" names referencing a schema 935 - find() with attributes works 936 - added experimental Serialize and ResultSetManager components 937 - added code attribute recording to DBIx::Class 938 - fix to find() for complex resultsets 939 - added of $storage->debugcb(sub { ... }) 940 - added $source->resultset_attributes accessor 941 - added include_columns rs attr 942 9430.05000 2006-02-01 16:48:30 944 - assorted doc fixes 945 - remove ObjectCache, not yet working in 0.05 946 - let many_to_many rels have attrs 947 - fix ID method in PK.pm to be saner for new internals 948 - fix t/30dbicplain.t to use ::Schema instead of 949 Catalyst::Model::DBIC::Plain 950 9510.04999_06 2006-01-28 21:20:32 952 - fix Storage/DBI (tried to load deprecated ::Exception component) 953 9540.04999_05 2006-01-28 20:13:52 955 - count will now work for grouped resultsets 956 - added accessor => option to column_info to specify accessor name 957 - added $schema->populate to load test data (similar to AR fixtures) 958 - removed cdbi-t dependencies, only run tests if installed 959 - Removed DBIx::Class::Exception 960 - unified throw_exception stuff, using Carp::Clan 961 - report query when sth generation fails. 962 - multi-step prefetch! 963 - inheritance fixes 964 - test tweaks 965 9660.04999_04 2006-01-24 21:48:21 967 - more documentation improvements 968 - add columns_info_for for vendor-specific column info (Zbigniew 969 Lukasiak) 970 - add SQL::Translator::Producer for DBIx::Class table classes (Jess 971 Robinson) 972 - add unique constraint declaration (Daniel Westermann-Clark) 973 - add new update_or_create method (Daniel Westermann-Clark) 974 - rename ResultSetInstance class to ResultSetProxy, ResultSourceInstance 975 to ResultSourceProxy, and TableInstance to ResultSourceProxy::Table 976 - minor fixes to UUIDColumns 977 - add debugfh method and ENV magic for tracing SQL (Nigel Metheringham) 978 9790.04999_03 2006-01-20 06:05:27 980 - imported Jess Robinson's SQL::Translator::Parser::DBIx::Class 981 - lots of internals cleanup to eliminate result_source_instance 982 requirement 983 - added register_column and register_relationship class APIs 984 - made Storage::DBI use prepare_cached safely (thanks to Tim Bunce) 985 - many documentation improvements (thanks guys!) 986 - added ->connection, ->connect, ->register_source and ->clone schema 987 methods 988 - Use croak instead of die for user errors. 989 9900.04999_02 2006-01-14 07:17:35 991 - Schema is now self-contained; no requirement for co-operation 992 - add_relationship, relationships, relationship_info, has_relationship 993 - relationship handling on ResultSource 994 - all table handling now in Table.pm / ResultSource.pm 995 - added GROUP BY and DISTINCT support 996 - hacked around SQL::Abstract::Limit some more in DBIC::SQL::Abstract 997 (this may have fixed complex quoting) 998 - moved inflation to inflate_result in Row.pm 999 - added $rs->search_related 1000 - split compose_namespace out of compose_connection in Schema 1001 - ResultSet now handles find 1002 - various *_related methods are now ->search_related->* 1003 - added new_result to ResultSet 1004 10050.04999_01 2005-12-27 03:33:42 1006 - search and related methods moved to ResultSet 1007 - select and as added to ResultSet attrs 1008 - added DBIx::Class::Table and TableInstance for table-per-class 1009 - added DBIx::Class::ResultSetInstance which handles proxying 1010 search etc. as a superclass of DBIx::Class::DB 1011 - assorted test and code cleanup work 1012 10130.04001 2005-12-13 22:00:00 1014 - Fix so set_inflated_column calls set_column 1015 - Syntax errors in relationship classes are now reported 1016 - Better error detection in set_primary_key and columns methods 1017 - Documentation improvements 1018 - Better transaction support with txn_* methods 1019 - belongs_to now works when $cond is a string 1020 - PK::Auto::Pg updated, only tries primary keys instead of all cols 1021 10220.04 2005-11-26 1023 - Moved get_simple and set_simple into AccessorGroup 1024 - Made 'new' die if given invalid columns 1025 - Added has_column and column_info to Table.pm 1026 - Refactored away from direct use of _columns and _primaries 1027 - Switched from NEXT to Class::C3 1028 10290.03004 1030 - Added an || '' to the CDBICompat stringify to avoid null warnings 1031 - Updated name section for manual pods 10320.03003 2005-11-03 17:00:00 1033 - POD fixes. 1034 - Changed use to require in Relationship/Base to avoid import. 1035 10360.03002 2005-10-20 22:35:00 1037 - Minor bugfix to new (Row.pm) 1038 - Schema doesn't die if it can't load a class (Schema.pm) 1039 - New UUID columns plugin (UUIDColumns.pm) 1040 - Documentation improvements. 1041 10420.03001 2005-09-23 14:00:00 1043 - Fixes to relationship helpers 1044 - IMPORTANT: prefetch/schema combination bug fix 1045 10460.03 2005-09-19 19:35:00 1047 - Paging support 1048 - Join support on search 1049 - Prefetch support on search 1050 10510.02 2005-08-12 18:00:00 1052 - Test fixes. 1053 - Performance improvements. 1054 - Oracle primary key support. 1055 - MS-SQL primary key support. 1056 - SQL::Abstract::Limit integration for database-agnostic limiting. 1057 10580.01 2005-08-08 17:10:00 1059 - initial release 1060 1061