Release v0.08271
[dbsrgits/DBIx-Class.git] / Changes
CommitLineData
3b44ccc6 1Revision history for DBIx::Class
64ea0f49 2
0d2cde0d 30.08271 2016-06-17 10:11 (UTC)
4
5 xx Maintenance no-changes-in-lib release fixing failing tests xx
6 xx due to advances in currently available CPAN dependencies xx
7 xx ( for folks stuck due to minor 0.0828xx regressions ) xx
8
b409dead 9 * Fixes
75d25fea 10 - Fix t/105view_deps.t failing with libsqlite >= 3.009, where view
11 definitions are lazily-checked for correctness only at DML-time as
12 opposed to DDL-time (RT#1546088)
b409dead 13 - Fix hang in t/72pg.t when run against DBD::Pg 3.5.0. The ping()
14 implementation changes due to RT#100648 made an alarm() based
15 timeout lock-prone.
f5423b14 16 - Adjust Oracle SQLMaker to accommodate fixed API in SQL::Abstract
d5369db2 17 - Disable test failing on newer SQLite (workaround for RT#96499)
b409dead 18
0d862c5c 19 * Misc
20 - Remove warning about potential side effects of RT#79576 (scheduled)
8428e0b6 21 - Fix intermittent failures in the LeakTracer on 5.18+
0d862c5c 22
75cbf825 230.08270 2014-01-30 21:54 (PST)
215102b9 24 * Fixes
25 - Fix 0.08260 regression in DBD::SQLite bound int handling. Inserted
26 data was not affected, but any function <=> integer comparison would
27 have failed (originally fixed way back in 0e773352)
e5a62c46 28 - Fix failure to load DateTime formatter when connecting to Firebird
29 over ODBC
215102b9 30
f7370154 31 * Misc
32 - All drivers based on ::Storage::DBI::Firebird::Common now return the
33 same sqlt_type value (affects ::DBI::Interbase, ::DBI::Firebird and
34 ::DBI::ODBC::Firebird)
35
653361f3 360.08260 2014-01-28 18:52 (UTC)
37 * New Features
16e77134 38 - A new zero-to-DBIC style manual: DBIx::Class::Manual::QuickStart
39
653361f3 40 * Notable Changes and Deprecations
41 - Explicitly deprecate combination of distinct and selecting a
42 non-column via $rs->get_column()
43
f9b5239a 44 * Fixes
9e7525a2 45 - More robust handling of circular relationship declarations by loading
46 foreign classes less frequently (should resolve issues like
47 http://lists.scsys.co.uk/pipermail/dbix-class/2013-June/011374.html)
a37e6150 48 Note that none of this is a manifestations of a DBIC bug, but rather
49 unexpected (but correct) behavior of load-order-dependent (hence
50 logically broken) Resultclass hierarchies. In order to deal with this
51 DBIC is scaling back a large number of sanity checks, which are to be
52 reintroduce pending a better framework for source registration
0dadd60d 53 - Fix multiple edge cases of complex prefetch combining incorrectly
54 with correlated subquery selections
b33613cf 55 - Fix multiple edge cases stemming from interaction of a non-selecting
eb58c082 56 order_by specification and distinct and/or complex prefetch
6ae62c5c 57 - Fix unbound growth of a resultset during repeated execute/exhaust
653361f3 58 cycles (GH#29)
841efcb3 59 - Work around (and be very vocal about the fact) when DBIC encounters
60 an exception object with broken string overloading
aca094b4 61 - Clarify ambiguous behavior of distinct when used with ResultSetColumn
62 i.e. $rs->search({}, { distinct => 1 })->get_column (...)
f9b5239a 63 - Setting quote_names propagates to SQL::Translator when producing
64 SQLite DDL (it is one of the few producers *NOT* quoting by default)
04ab4eb1 65 - Fix incorrect binding of large integers on old versions of
66 DBD::SQLite (now DBIC simply always binds SQLite ints as BIGINT)
67 - Silence (harmless) warnings on recent DBD::SQLite versions, when
68 inserting/updating large integers on 32bit ivsize systems (RT#76395)
16e77134 69 - Back out self-cleaning from DBIx::Class::Carp for the time being
70 (as a side effect fixes RT#86267)
a9da9b6a 71 - Fix incorrect internal use of implicit list context in copy()
37b5ab51 72 - Fix 0.08250 regression in driver determination when DBI_DSN is used
444f799b 73 - Tests no longer fail if $ENV{DBI_DSN} is set
3f8affda 74 - Throw clearer exception on ->new_related() with a non-existent
1d1ccc94 75 relationship
76 - Fix incorrect parethesis unroll with multicolumn in, (never noticed
77 before fixing false positive in SQLA::Test 1.77)
617474ab 78 - Fix t/storage/replicated.t class loading problem
d401ab6b 79 - Stop using the deprecated Class::MOP::load_class()
f9139687 80 - Fix warning in t/54taint.t with explicitly unset PERL5LIB (RT#91972)
6fc6d60c 81 - Fix t/54taint.t failing under a local::lib with installed earlier
82 DBIC version (RT#92486)
f9b5239a 83
47d7b769 84 * Misc
7d534e68 85 - Massive incompatible change of ::BlockRunner internals (was never
86 documented as usable externally, this last set of changes settles
87 the design for proper documentation and opening up)
ed5550d3 88 - Adjust exceptions in tests to accommodate changes in the upcoming
89 DBD::SQLite based on libsqlite 3.8.2
0a03f539 90 - More robust lock file naming scheme - allow tests to work on exotic
91 MSWin32 filesystems (habitual offender being http://is.gd/iy5XVP)
fa19e5d6 92 - Better diagnostics when File::Spec->tmpdir gives us crap in testing
47d7b769 93 - Replace $row with $result in all docs to be consistent and to
94 clarify various return values
95
c36f8d8d 960.08250 2013-04-29 22:00 (UTC)
6dd43920 97 * New Features / Changes
f3c8fa02 98 - Rewrite from scratch the result constructor codepath - many bugfixes
99 and performance improvements (the current codebase is now capable of
100 outperforming both DBIx::DataModel and Rose::DB::Object on some
101 workloads). Some notable benefits:
102 - Multiple has_many prefetch
103 - Partial prefetch - you now can select only columns you are
104 interested in, while preserving the collapse functionality
105 (collapse is now exposed as a first-class API attribute)
106 - Prefetch of resultsets with arbitrary order
107 (RT#54949, RT#74024, RT#74584)
108 - Prefetch no longer inserts right-side table order_by clauses
109 (massively helps the deficient MySQL optimizer)
110 - Prefetch with limit on right-side ordered resultsets now works
111 correctly (via aggregated grouping)
112 - No longer order the insides of a complex prefetch subquery,
113 unless required to satisfy a limit
114 - Stop erroneously considering order_by criteria from a join under
115 distinct => 1 (the distinct should apply to the main source only)
116 - Massively optimize codepath around ->cursor(), over 10x speedup
117 on some iterating workloads.
1b5ddf23 118 - Support standalone \[ $sql, $value ] in literal SQL with bind
119 specifications: \[ '? + ?', 42, 69 ] is now equivalent to
120 \[ '? + ?', [ {} => 42 ], [ {} => 69 ] ]
f3c8fa02 121 - Changing the result_class of a ResultSet in progress is now
122 explicitly forbidden. The behavior was undefined before, and
123 would result in wildly differing outcomes depending on $rs
124 attributes.
6dd43920 125 - Deprecate returning of prefetched 'filter' rels as part of
126 get_columns() and get_inflated_columns() data
127 - Invoking get_inflated_columns() no longer fires get_columns() but
128 instead retrieves data from individual non-inflatable columns via
129 get_column()
f3c8fa02 130 - Emit a warning on incorrect use of nullable columns within a
131 primary key
02a73c96 132 - Limited checks are performed on whether columns without declared
133 is_nullable => 1 metadata do in fact sometimes fetch NULLs from
134 the database (the check is currently very limited and is performed
135 only on resultset collapse when the alternative is rather worse)
6dd43920 136
f4fdfd69 137 * Fixes
723f25e0 138 - Fix _dbi_attrs_for_bind() being called befor DBI has been loaded
139 (regression in 0.08210)
f4fdfd69 140 - Fix update/delete operations on resultsets *joining* the updated
141 table failing on MySQL. Resolves oversights in the fixes for
142 RT#81378 and RT#81897
f3c8fa02 143 - Fix open cursors silently resetting when inherited across a fork
144 or a thread
145 - Properly support "MySQL-style" left-side group_by with prefetch
146 - Fix $grouped_rs->get_column($col)->func($func) producing incorrect
147 SQL (RT#81127)
048c2440 148 - Stop Sybase ASE storage from generating invalid SQL in subselects
149 when a limit without offset is encountered
f3c8fa02 150 - Even more robust behavior of GenericSubQuery limit dialect
1759f82f 151 - Make sure deployment_statements() and cursor_class() are called on
152 a resolved storage subclass
f4fdfd69 153
fb88ca2c 154 * Misc
155 - Fix tests failing due to unspecified resultset retrieval order
156 (test suite now will pass with newest SQLite libs)
157
5a1dea85 1580.08210 2013-04-04 15:30 (UTC)
11343b34 159 * New Features / Changes
160 - Officially deprecate the 'cols' and 'include_columns' resultset
161 attributes
9930caaf 162 - Remove ::Storage::DBI::sth() deprecated in 0.08191
11343b34 163
d77ee505 164 * Fixes
75a1d824 165 - Work around a *critical* bug with potential for data loss in
166 DBD::SQLite - RT#79576
d77ee505 167 - Audit and correct potential bugs associated with braindead reuse
168 of $1 on unsuccessful matches
5e0e5426 169 - Fix incorrect warning/exception originator reported by carp*() and
170 throw_exception()
d77ee505 171
4f364257 1720.08209 2013-03-01 12:56 (UTC)
e0de554e 173 * New Features / Changes
174 - Debugging aid - warn on invalid result objects created by what
175 seems like an invalid inheritance hierarchy
176
9ae300a4 177 * Fixes
178 - Fix another embarrassing regression preventing correct refining of
179 the search criteria on a prefetched relation (broken in 0.08205)
569b96bb 180 - Fix incorrect callsite reporting by DBIC::Carp
9ae300a4 181
cc3654a1 1820.08208 2013-02-20 09:56 (UTC)
a07ae2aa 183 * New Features / Changes
184 - A bunch of nonsensically named arguments to the SQL::Translator
185 parser have been marked as deprecated (while still fully
186 supported)
187
913b4bae 188 * Fixes
189 - Fix duplicated selected columns when calling 'count' when a same
190 aggregate function is used more than once in a 'having' clause
191 (RT#83305)
31399b48 192 - Prevent SQL::Translator::Producer::YAML from seeing the $dbh
193 in a potentially connected $schema instance (RT#75394)
913b4bae 194
ad944588 195 * Misc
196 - Fixup our distbuilding process to stop creating world-writable
197 tarball contents (implicitly fixes RT#83084)
4a233f30 198 - Added strict and warnings tests for all lib and test files
ad944588 199
08d7807b 2000.08206 2013-02-08
8c21eef7 201 * Fixes
8f6986ac 202 - Fix dbh_do() failing to properly reconnect (regression in 0.08205)
8c21eef7 203 - Extra sanity check of a fresh DBI handle ($dbh). Fixes
204 connection coderefs returning garbage (seen in the wild)
205
60fd7c30 206 * Misc
207 - Only allow known globals in SQL::Translator leak allowance
a5ef1371 208 - General cleanup of error message texts - quote names/identifiers
209 for easier reading
210 - Stop t/52leaks.t from failing when AUTOMATED_TESTING=1
60fd7c30 211
f4fe67e2 2120.08205 2013-01-22
67341081 213 * New Features / Changes
214 - The emulate_limit() arbitrary limit dialect emulation mechanism is
215 now deprecated, and will be removed when DBIx::Class migrates to
216 Data::Query
97202028 217 - Support for the source_bind_attributes() storage method has been
218 removed after a lengthy deprecation cycle
218b7c12 219 * Fixes
fd8076c8 220 - When performing resultset update/delete only strip condition
221 qualifiers - leave the source name alone (RT#80015, RT#78844)
31073ac7 222 - Fix incorrect behavior on resultset update/delete invoked on
223 composite resultsets (e.g. as_subselect_rs)
45150bc4 224 - Fix update/delete operations referencing the updated table failing
225 on MySQL, due to its refusal to modify a table being directly
226 queried. As a workaround induce in-memory temp-table creation
227 (RT#81378, RT#81897)
218b7c12 228 - More robust behavior under heavily threaded environments - make
229 sure we do not have refaddr reuse in the global storage registry
dfd722ef 230 - Fix failing test on 5.8 under Win32 (RT#81114)
b563960f 231 - Fix hash-randomization test issues (RT#81638)
1fccee7b 232 - Disallow erroneous calling of connect_info on a replicated storage
233 (RT#78436)
44e95db4 234 * Misc
235 - Improve the populate docs in ::Schema and ::ResultSet
97202028 236 - ::Storage::DBI::source_bind_attributes() removed as announced
237 on Jan 2011 in 0e773352a
218b7c12 238
8b4fa23f 2390.08204 2012-11-08
8249c09b 240 * New Features / Changes
241 - SQLMaker now accepts \'literal' with the 'for' rs attribute as an
242 override to the builtin FOR options
897f4ac8 243 * Fixes
375c84bb 244 - Fix unique constraint violations in Ordered.pm blanket movement
245 (RT#79773, rolls back short-sighted 5e6fde33e)
81e4dc3d 246 - Fix API mismatch between new_result() and new_related() (originally
247 broken by fea3d045)
897f4ac8 248 - Fix test failure on perl 5.8
75d3bdb2 249 * Misc
250 - Much more extensive diagnostics when a new RDBMS/DSN combination is
251 encountered (RT#80431)
897f4ac8 252
80e1ff14 2530.08203 2012-10-18
2aeb3c7f 254 * Fixes
255 - Really fix inadequate $dbh->ping SQLite implementation (what shipped
256 in 0.08201 tickled other deficiencies in DBD::SQLite itself)
257
524fc24c 2580.08202 2012-10-06
8d1fb3e2 259 * Fixes
260 - Replace inadequate $dbh->ping SQLite implementation with our own,
261 fixes RT#78420
262
058a18cc 2630.08200 2012-08-24 (UTC)
277b225f 264 * Fixes
265 - Change one of the new tests for the previous release to not require
266 SQL::Translator
267
6adcb211 2680.08199 2012-08-22 (UTC)
5007739d 269 * Fixes
270 - Roll back incomplete (and broken) internal changes - restore prefetch functionality
271
0a7eddc0 2720.08198 2012-07-11 03:43 (UTC)
273 * Fixes
274 - Fix a number of Win32 Test issues
275 - Fix silent Oracle connection failures
276
5e2a9177 2770.08197 2012-07-10 10:32 (UTC)
07d6018a 278 * New Features / Changes
279 - Issue a warning when DateTime objects are passed to ->search
52cef7e3 280 - Fast populate() in void context is now even more efficient by
281 going directly through execute_for_fetch bypassing execute_array
be64931c 282 - Fix update()/delete() on complex resultsets to no longer fall back
283 to silly row-by-row deletion, construct a massive OR statement
284 instead
81bf295c 285 - Allow complex update/delete operations on sources without a
286 primary key, as long as they have at least one non-nullable
287 unique constraint
7b71391b 288 - dbicadmin now better supports catalyst-style config files, by
289 unrolling 'config_info' hashkeys
2edf3352 290 - Multiple Improvements MSSQL over DBD::ADO
291 - Transaction support
292 - Support for VARCHAR(MAX)/VARBINARY(MAX)/NVARCHAR(MAX) datatypes
293 - Nomalization of retrieved GUID values
81bf295c 294
295 * Fixes
27e0370d 296 - Fix complex has_many prefetch with resultsets not selecting identity
297 columns from the root result source
8b31f62e 298 - Fix SkipFirst and FirstSkip limit dialects (Informix and Firebird)
86bb5a27 299 - Fix "Skimming limit" dialects (Top, FetchFirst) to properly check
300 the order_by criteria for stability
301 - Fix "Skimming limit" dialects (Top, FetchFirst) to propagate
302 non-selected order criteria when part of a larger subquery
27a7c422 303 - Fix RowNumberOver and all "skimming limits" to correctly assemble
304 bind values when supplied for both select and order_by
305 - Fix all subquery-based dialects to not lose a subquery fragment
306 when we both select and order by the result of the same subquery
307 - Fix the Sybase hubrid limit dialect (RowCountOrGenericSubQ) losing
308 Group/Having/Order clauses when called without an offset (RT#73244)
038b8126 309 - No longer generate incorrect SQL on ->as_query called on resultsets
310 with software_limit enabled
a9bac98f 311 - A number of corner case fixes of void context populate() with \[]
66441708 312 - Fix corner case of forked children disconnecting the parents DBI
313 handle
fabbd5cc 314 - Improve identity/autoinc retrieval code in MSSQL and Sybase -
315 should reduce weird side-effects especially with populate()
25d3127d 316 - Explicitly disable DBD::ODBC batch operations (as of DBD::ODBC 1.35)
3edfebff 317 for the following drivers too buggy to handle the optimized path:
318 - FreeTDS ODBC driver (when used with MSSQL)
319 - The Firebird ODBC driver
1d8a370f 320 - The MSAccess ODBC driver
25d3127d 321 - Explicitly disable DBD::ODBC dynamic_cursors when using freetds 0.83
0d6c550e 322 or later - they made enough ODBC incompatible changes making it
323 impossible to support sanely
324 - Explicitly disable SCOPE_IDENTITY queries and statement caching for
bfec318f 325 MSSQL on DBD::Sybase compiled against freetds 0.83 or later - way too
326 buggy
327 - Disable statement caching when using Sybase ASE and DBD::Sybase
328 compiled against freetds 0.83 or later
0a03206a 329 - Fix leakage of $schema on in-memory new_related() calls
48775dd1 330 - Fix more cases of $schema leakage in SQLT::Parser::DBIC
a6ae092b 331 - Fix leakage of $storage in ::Storage::DBI::Oracle
cccd1876 332 - Fix pessimization of Oracle RowNum limit dialect query when no
333 offset has been specified
aea59b74 334 - Remove useless vestigial pessimization in Ordered.pm for cases
5e6fde33 335 when the position column is part of a unique constraint
7b71391b 336 - Fix dbicadmin to no longer ignore the documented 'config' option
a4367b26 337 - The schema-resultsource entanglement is now much more robust
338 under threads
aea59b74 339 - Fix ::Schema::ddl_filename() failing miserably on paths containing
340 certain numeric sequences
6fec58ca 341 - t/53lean_startup.t adjusted for new 5.15.x base.pm behavior
8b31f62e 342
8273e845 343 * Misc
65d35121 344 - Centralized leak-checks for all instances of DBICTest::Schema
345 from within any test
7be5717e 346 - Now passes all tests with Test::Builder 1.005
8273e845 347 - Codebase is now trailing-whitespace-free
be64931c 348 - Cleanup of complex resultset update/delete oprations - storage
349 specific code moved back to ResultSet and replaced by checks
350 of storage capabilities
8fda97d5 351 - Fixed carp_once only emitting one single warning per package
352 regardless of warning content
8d6b1478 353 - Test suite now can be safely executed in parallel (prove -jN
354 or HARNESS_OPTIONS=jN)
8273e845 355
30cfb462 3560.08196 2011-11-29 05:35 (UTC)
bc57c92c 357 * Fixes
358 - Fix tests for DBD::SQLite >= 1.34.
6ddb4ac0 359 - Fix test failures with DBICTEST_SQLITE_USE_FILE set
b0408e26 360 - Fix the find() condition heuristics being invoked even when the
361 call defaults to 'primary' (i.e. when invoked with bare values)
ce9f555e 362 - Throw much clearer error on incorrect inflation spec
2324c42c 363 - Fix incorrect storage behavior when first call on a fresh schema
364 is with_deferred_fk_checks
c7bc500e 365 - Fix incorrect dependency on Test::Simple/Builder (RT#72282)
aadfe180 366 - Fix uninitialized warning in ::Storage::Sybase::ASE
8892d8e5 367 - Improve/cache DBD-specific datatype bind checks (also solves a
368 nasty memleak with version.pm on multiple ->VERSION invocations)
386c61f6 369 - The internal carp module now correctly skips CAG frames when
370 reporting a callsite
45638aed 371 - Fix test failures on perl < 5.8.7 and new Package::Stash::XS
f62c5724 372 - Fix TxnScopeGuard not behaving correctly when $@ is set at the
373 time of $guard instantiation
8bc47467 374 - Fix the join/prefetch resolver when dealing with ''/undef/()
375 relation specifications
bc57c92c 376
cd122820 377 * Misc
378 - No longer depend on Variable::Magic now that a pure-perl
379 namespace::clean is available
26022fb5 380 - Drop Oracle's Math::BigInt req down to 1.80 - no fixes concerning
381 us were made since
cd122820 382
58a4b69c 3830.08195 2011-07-27 16:20 (UTC)
e12571af 384 * Fixes
385 - Fix horrible oversight in the Oracle sqlmaker when dealing with
386 queries updating blobs (RT#69829)
387
43d10c98 3880.08194 2011-07-20 16:10 (UTC)
8c49ff1a 389 * Fixes
ce855fff 390 - Fix $rs->populate([]) to be a no-op rather than an exception
17877ef0 391 - Overhaul t/53lean_startup.t to better dodge false positives
392 - Stop Data::Compare from loading random plugins
00819de0 393 - Oracle: Recalculate LOB bind indices for UPDATE with LOBs in WHERE
394 (RT#69548)
8c49ff1a 395
cfd773c2 3960.08193 2011-07-14 17:00 (UTC)
71829446 397 * New Features / Changes
c6b7885f 398 - Allow schema cloning to mutate attributes
3170049a 399 - DBIC now attempts more aggressive de-duplication of where
400 conditions on resultset chaining
5ef76b8b 401 - The Ordered component is now smarter wrt reordering of dirty
402 objects, and does its job with less storage queries
64b3598f 403 - Logging via DBIC_TRACE=1=<filename> no longer overwrites the
404 logfile on every program startup, appending loglines instead
71829446 405
406 * Fixes
f74d22e2 407 - Fix issue where the query was becoming overly mangled when trying
408 to use pagination with a query that has a sub-select in the WHERE
c6b7885f 409 clause
6a6394f1 410 - Fix possible incorrect pagination on Oracle, when a resultset
411 is not ordered by a unique column
7f3fd262 412 - Revert "Fix incorrect signature of the default sqlt_deploy_hook"
413 from 0.08191 - documentation was in fact incorrect, not the code
c6b7885f 414 - Fix Sybase ASE IC::DateTime support (::Storage going out of sync
415 with new default format expected by DateTime::Format::Sybase)
8d2da21a 416 - Fix a bug in update_all() resulting in the first row receiving a
417 different dataset than the subsequent ones
696ba760 418 - Accomodate MSAccess supporting only 'INNER JOIN' (not plain 'JOIN')
24f5cbcb 419 - InflateColumn::DateTime option datetime_undef_if_invalid no longer
420 masks missing dependency exceptions (RT#66823)
701c9693 421 - Fix bug in Schema::Versioned failing to insert a schema version row
422 during upgrades at the turn of the second
67b35a45 423 - Fix incorrect bind of integers >= 2^^32 (bigint columns) to
424 SQL_INTEGER, resulting in silent conversion to '-1'
88b1530a 425 - Fix pre 5.10 failures of t/55namespaces_cleaned.t due to buggy
426 require() (RT#68814)
e6f3272b 427 - Oracle autoinc inserts no longer leave open cursors behind
f74d22e2 428
4cc6b752 4290.08192 2011-05-10 04:20 (UTC)
632d1e0f 430 * Fixes
431 - Fix serious regression on SQLite, corrupting data when an alphanum
432 value does not correspond to a stale numeric datatype in colinfo
867a7241 433
632d1e0f 4340.08191 2011-05-02 00:45 (UTC) (deleted from CPAN)
2b8cc2f2 435 * New Features / Changes
436 - Add quote_names connection option. When set to true automatically
437 sets quote_char and name_sep appropriate for your RDBMS
8b9473f5 438 - Add retrieve_on_insert column info flag, allowing to retrieve any
439 column value instead of just autoinc primary keys
f7f53a89 440 - Bring back strict ordering of selectors in complex search chains
441 (an ill-fated attempt was made in 0.08127 to order intelligently)
fcb7fcbb 442 - All limit dialects (except for the older Top and FetchFirst) are
443 now using bind parameters for the limits/offsets, making DBI's
444 prepare_cached useful across paged resutsets
86a51471 445 - Support for savepoints for SQLite
726c8f65 446 - Support for MS Access databases via DBD::ODBC and DBD::ADO (only
447 Win32 support currently tested)
f7e5fd18 448 - Support for the Firebird RDBMS over the new DBD::Firebird driver
56dca25f 449 - IC::DateTime support for MSSQL over DBD::ADO
ab17c175 450 - Both the ::ODBC and ::ADO dispatchers now warn if a rdbms-specific
451 driver is not found for this connection before falling back to
452 plain ::Storage::DBI
402ac1c9 453 - ::Storage::DBI::sth was mistakenly marked/documented as public,
454 privatize and warn on deprecated use
0e773352 455 - Massive overhaul of bind values/attributes handling - slightly
456 changes the output of as_query (should not cause compat issues)
96eacdb7 457 - Support ancient DB2 versions (5.4 and older), with proper limit
458 dialect
a870aa85 459 - Support sub-second precision for TIMESTAMPs for Firebird over ODBC
00a28188 460 - Support BLOBs and CLOBs in WHERE clauses for Oracle, including LIKE
461 queries for CLOBs.
2b8cc2f2 462
f98120e4 463 * Fixes
87bf71d5 464 - Fix ::Storage::DBI::* MRO problems on 5.8.x perls
f98120e4 465 - Disable mysql_auto_reconnect for MySQL - depending on the ENV
466 it sometimes defaults to on and causes major borkage on older
467 DBD::mysql versions
55d02972 468 - Fix dropped bind values in select/group_by on Oracle (omission
469 from 0542ec57 and 4c2b30d6)
19c4cc62 470 - Fix remaining errors with Oracle and identifiers longer than the
471 Oracle-imposed maximum of 30 characters (RT#66390)
f116ff4e 472 - Fix older oracle-specific "WhereJoins" to work properly with
473 name quoting
66917da3 474 - Fix problems with M.A.D. under CGI::SpeedyCGI (RT#65131)
74719352 475 - Reenable paging of cached resultsets - breakage erroneously added
476 in 0.08127
e1a97e24 477 - Better error handling when prepare() fails silently
91d0c99f 478 - Fixes skipped lines when a comment is followed by a statement
479 when deploying a schema via sql file
1e0daa97 480 - Fix reverse_relationship_info on prototypical result sources
481 (sources not yet registered with a schema)
51c9ead2 482 - Warn and skip relationships missing from a partial schema during
483 dbic cascade_delete
db29433c 484 - Automatically require the requested cursor class before use
485 (RT#64795)
e02b39b4 486 - Work around a Firebird ODBC driver bug exposed by DBD::ODBC 1.29
c1e5a9ac 487 - Fix (to the extent allowed by the driver) transaction support in
488 DBD::Sybase compiled against FreeTDS
51c9ead2 489 - Fix exiting via next warnings in ResultSource::sequence()
61f031bf 490 - Fix stripping of table qualifiers in update/delete in arrayref
491 condition elements
2ea6032a 492 - Change SQLMaker carp-monkeypatch to be compatible with versions
493 of SQL::Abstract >= 1.73
1bffc6b8 494 - Fix using \[] literals in the from resultset attribute
f6faeab8 495 - Fix populate() with \[], arrays (datatype) and other exotic values
90d7422f 496 - Fix handling of rollbacks in nested transactions
69d3c270 497 - Fix complex limits (RNO/RowNum/FetchFirst/Top/GenSubq) with
498 sub-selects in the selectors list (correlated subqueries)
fd4b0742 499 - Fix inconsistency between $rs->next with and without HRI when all
500 the "root" columns are in fact injected from the right rs side
a4812caa 501 - Fix the join optimizer to correctly preserve the non-multi path to
502 a multi relationship ( x -> might_have y -> has_many z )
93508f48 503 - Fix object-derived custom-relationship resultsets to resultsources
504 with multilevel monikers (e.g. $schema->source('Foo::Bar') )
fed15b91 505 - Fix incorrect signature of the default sqlt_deploy_hook - it now
506 matches the documentation of passing in the result source object
5b4f3fd0 507 - Fix inadequate handling of internal storage methods within
508 ::Storage::Replicated (RT#66295)
f98120e4 509
87bf71d5 510 * Misc
70c28808 511 - Rewire all warnings to a new Carp-like implementation internal
512 to DBIx::Class, and remove the Carp::Clan dependency
87bf71d5 513 - Only load Class::C3 and friends if necessary ($] < 5.010)
3b80fa31 514 - Greatly reduced loading of non-essential modules to aid startup
515 time (mainly benefiting CGI users)
9c1700e3 516 - Make sure all namespaces are clean of rogue imports
997a3638 517 - Dropped DBI req 2 years back - everything works with 1.57, no
518 point requiring something newer
87bf71d5 519
86b9a583 5200.08190-TRIAL 2011-01-24 15:35 (UTC)
521
522 * New Features / Changes
523 - Support for completely arbitrary SQL::Abstract-based conditions
524 in all types of relationships
525
f4591846 5260.08127 2011-01-19 16:40 (UTC)
6c925c72 527 * New Features / Changes
628c2218 528 - Schema/resultsource instances are now crossreferenced via a new
529 system guaranteeing leak-free mutually assured destruction
6c925c72 530 - DBIx::Class now warns when the user erroneously supplies
531 AutoCommit => 0 to connect()
532 - A warning is also issued before forcing the RaiseError
533 setting of externally supplied DBI handles
65c1217d 534 - Switch to a warning when find() is invoked with both a 'key'
535 argument and a NULL-containing condition to satisfy the named
536 constraint. Previously (starting with 0.08124) an exception was
f107730c 537 thrown
538 - Switch to a warning when a commit is attempted with an out-of-sync
539 transaction_depth (someone issued a begin externally to DBIC).
540 Previously (starting with 0.08124) an exception was thrown
50261284 541
0542ec57 542 * Fixes
384b8bce 543 - A number of improvements/diagnostics of multiple active resultset
544 handling on MSSQL over DBD::ODBC
eb37b376 545 - Revert default selection to being lazy again (eagerness introduced
dc81dba3 546 in 0.08125) - fixes DBIx::Class::Helper::ResultSet::RemoveColumns
547 - Fix losing order of columns provided in select/as (regression from
548 0.08125)
36fd7f07 549 - Unaliased "dark" selectors no longer throw off prefetch
0542ec57 550 - Fix proper composition of bind values across all possible
551 SQL areas ( group_by => \[ ... ] now works properly )
d6170b26 552 - Allow populate to skip empty has_many relationships which makes
553 it easier to pass HashRefInflator data directly to ->populate
4376a157 554 - Improve freeze/thaw semantics and error messages (RT#62546)
a9e8284f 555 - Fix inconsistency in Manual::Features (RT#64500)
4e0a89e4 556 - Fix incorrect SQL when using for => 'shared' with MySQL (RT#64590)
628c2218 557 - Throw comprehensible exception on erroneous $schema->source()
558 invocation
559 - Fix sloppy refactor of ResultSource::sequence back from 89170201
560 (RT#64839)
561 - Fix incorrect error detection during populate() on Oracle
562 - Better handling of result_source-less row objects by
563 auto-calling result_source_instance when necessary
564 - Fix reverse_relationship_info and sqlt deploy on partially
565 loaded schemas (relationships point to non-existent sources)
0542ec57 566
1239d14e 567 * Misc
568 - Fix test warning on win32 - at this point the test suite is
569 warning-free on all known OSes
4549ba49 570 - Require newest namespace::clean which in turn depends on new
571 installable Package::Stash
1239d14e 572
40b2218d 5730.08126 2010-12-28 18:10 (UTC)
b8d22f13 574 * Fixes
575 - Bump forgotten Class::Accessor::Grouped core dependency
576 - Promote forgotten Hash::Merge optdep to a hard requirement
cc1924ac 577 - Skip t/storage/error.t on smokers with leaking perls
02050e77 578 - Fix t/storage/txn.t deadlocks on slower machines
4557be61 579 - Do not run on smokers if a trial Package::Stash is found
b8d22f13 580
e139bd60 5810.08125 2010-12-27 04:30 (UTC)
6cad253b 582 * New Features / Changes
52416317 583 - New method ResultSource columns_info method, returning multiple
584 pairs of column name/info at once
0e7a447e 585 - $rs->search now throws when called in void context, as it makes
586 no sense (and is nearly always a sign of a bug/misdesign)
00336453 587 - Restore long-lost ability to supply unbalanced select/as pairs
588 e.g. +select => \'DISTINCT(foo, bar)', +as => ['foo', 'bar']
589 - +columns now behaves just like columns by not stripping a
590 fully-qualified 'as' spec (i.e. foo.bar results in $obj->foo->bar)
43da768f 591 - Deprecate legacy $rs->search( %condition ) syntax (warn once per
592 callsite)
6cad253b 593 - NULL is now supplied unquoted to all debug-objects, in order to
594 differentiate between a real NULL and the string 'NULL'
41519379 595 - New search() condition operator -value used to pass complex bind
596 values to DBI: search({ array_col => { -value => [1,2,3] }})
bf51641f 597 - Add full INSERT...RETURNING support for Oracle
b1d821de 598 - Deprecate use of -nest in search conditions (warn once per
599 callsite)
1b6fe47d 600 - Deprecate the completely useless DBIx::Class::Serialize::Storable
601 result component
6cad253b 602
64ae1667 603 * Fixes
604 - Fixed read-only attribute set attempt in ::Storage::Replicated
605 (RT#62642)
6f5f880d 606 - Fix incomplete logic while detecting correct Oracle sequence
607 on insert
a6646e1b 608 - Fix detection of Oracle sequences for tables without an explicitly
609 specified schema (RT#63493)
07cda1c5 610 - Major overhaul of Storage::Oracle to handle enabled quoting
37aafa2e 611 - Fixed incorrect composition of select/as/columns attributes during
612 chaining (RT#61235)
052b8ce2 613 - Proper serialization of resultsets with open cursors
a85b7ebe 614 - Refactor handling of RDBMS-side values during insert() - fix
615 regression of inserts into a Postgres / ::Replicated combination
cb566613 616 - Missing dependency check in t/60core.t (RT#62635)
49bceca3 617 - Fix regressions in IC::DT registration logic
4c2b30d6 618 - Fix regression in select-associated bind value handling (RT#61025)
887a0aef 619 - Simplify SQL generated by some LIMITed prefetching queries
14e26c5f 620 - Throw an exception when a required group_by on a complex prefetch
621 can not be auto-constructed, instead of continuing to eventually
622 produce invalid SQL
052b8ce2 623 - Fix infinite loops on old perls with a recent Try::Tiny
ec6415a9 624 - Improve "fork()" on Win32 by reimplementing a more robust DBIC
625 thread support (still problematic, pending a DBI fix)
20595c02 626 - Properly quote table name on INSERT with no values
8e9b9ce5 627 - Work around possible Storage destruction warnings
e493ecb2 628 - Fix count of grouped resultsets using HAVING with aliases
35f5c265 629 - Setting belongs_to columns/relationships no longer leaves the
630 FK value and related object out of sync
d7632687 631 - Stop stripping newlines from SQL statements in the limit emulators
632 as it is possible that custom sql with comments was provided
f3386204 633 - Add forgotten attributes to Admin.pm
47a435d2 634 - Fix incorrect 'having' attribute documentation (RT#64129)
8592e2d1 635 - Improve fallback-to-master/return-to-slave reporting in
636 ::Replicated::Balancer
e69b5335 637 - Adjust txn_scope_guard code/tests to changes in $@ handling on
638 recent blead (RT#64251)
052b8ce2 639
640 * Misc
be68095d 641 - Add extra option groups to DBIC::Optional::Depencencies, to aid
642 users in requesting the prerequisites for a particular RDBMS
26148d36 643 - Switch all serialization to use Storable::nfreeze for portable
644 architecture independent ice
2f5a6e87 645 - Fix the bogus META.yml dependency injection issue for good
c6fa3170 646 - Refactor DBIx::Class::Storage::Statistics::debugfh() to be lazy
64ae1667 647
ca734bc9 6480.08124 2010-10-28 14:23 (UTC)
eec182b6 649 * New Features / Changes
e6600283 650 - Add new -ident "function" indicating rhs is a column name
651 { col => { -ident => 'othercol' } } vs { col => \'othercol' }
97c96475 652 - Extend 'proxy' relationship attribute
d9672fb9 653 - Use DBIx::Class::Storage::Debug::PrettyPrint when the
654 environment variable DBIC_TRACE_PROFILE is set, see
655 DBIx::Class::Storage for more information
d9da98ab 656 - Implemented add_unique_constraints() which delegates to
657 add_unique_constraint() as appropriate
658 - add_unique_constraint() now poparly throws if called with
659 multiple constraint definitions
660 - No longer depend on SQL::Abstract::Limit - DBIC has been doing
661 most of the heavy lifting for a while anyway
eec182b6 662 - FilterColumn now passes data through when transformations
663 are not specified rather than throwing an exception.
d9672fb9 664 - Optimized RowNum based Oracle limit-dialect (RT#61277)
65245220 665 - Requesting a pager on a resultset with cached entries now
666 throws an exception, instead of returning a 1-page object
667 since the amount of rows is always equal to the "pagesize"
668 - $rs->pager now uses a lazy count to determine the amount of
669 total entries only when really needed, instead of doing it
670 at instantiation time
9ba33dac 671 - New documentation map organized by features
672 (DBIx::Class::Manual::Features)
b7743dab 673 - find( { ... }, { key => $constraint } ) now throws an exception
674 when the supplied data does not fully specify $constraint
49ca473e 675 - find( col1 => $val1, col2 => $val2, ... ) is no longer supported
676 (it has been in deprecated state for more than 4 years)
f5ef5fa1 677 - Make sure exception_action does not allow exception-hiding
678 due to badly-written handlers (the mechanism was never meant
679 to be able to suppress exceptions)
d9da98ab 680
f8583f8f 681 * Fixes
574d9b69 682 - Fix memory leak during populate() on 5.8.x perls
1f870d5a 683 - Temporarily fixed 5.13.x failures (RT#58225)
684 (perl-core fix still pending)
a8c2c746 685 - Fix result_soutrce_instance leaks on compose_namespace
f5ef5fa1 686 - Fix $_ volatility on load_namespaces (a class changing $_
687 at compile time no longer causes a massive fail)
b7743dab 688 - Fix find() without a key attr. choosing constraints even if
689 some of the supplied values are NULL (RT#59219)
f8583f8f 690 - Fixed rels ending with me breaking subqueried limit realiasing
59ac6523 691 - Fixed $rs->update/delete on resutsets constrained by an
692 -or condition
53c29913 693 - Remove rogue GROUP BY on non-multiplying prefetch-induced
694 subqueries
0a3441ee 695 - Fix incorrect order_by handling with prefetch on
696 $ordered_rs->search_related ('has_many_rel') resultsets
72044892 697 - Oracle sequence detection now *really* works across schemas
698 (fixed some ommissions from 0.08123)
f54428ab 699 - dbicadmin now uses a /usr/bin/env shebang to work better with
700 perlbrew and other local perl builds
6c3e6bf6 701 - bulk-inserts via $dbh->bind_array (void $rs->populate) now
702 display properly in DBIC_TRACE
7f505c17 703 - Incomplete exception thrown on relationship auto-fk-inference
704 failures
d955e938 705 - Fixed distinct with order_by to not double-specify the same
706 column in the GROUP BY clause
7653fdac 707 - Properly support column names with symbols (e.g. single quote)
708 via custom accessors
c271eec3 709 - Fixed ::Schema::Versioned to work properly with quoting on
710 (RT#59619)
9f72d93a 711 - Fixed t/54taint fails under local-lib
e5372da4 712 - Fixed SELECT ... FOR UPDATE with LIMIT regression (RT#58554)
b818efd7 713 - Fixed CDBICompat to preserve order of column-group additions,
714 so that test relying on the order of %{} will no longer fail
4cb6dfa2 715 - Fixed mysterious ::Storage::DBI goto-shim failures on older
716 perl versions
c6d30d5e 717 - Non-blessed reference exceptions are now correctly preserved
718 when thrown from udner DBIC (e.g. from txn_do)
a458e9e3 719 - No longer disconnecting database handles supplied to connect
720 via a coderef
ab35aeab 721 - Fixed t/inflate/datetime_pg.t failures due to a low dependency
722 on DateTime::Format::Pg (RT#61503)
d52d4d6e 723 - Fix dirtyness detection on source-less objects
f3e9f010 724 - Fix incorrect limit_dialect assignment on Replicated pool members
d2fcb9b3 725 - Fix invalid sql on relationship attr order_by with prefetch
ab4f4e4c 726 - Fix primary key sequence detection for Oracle
727 (first trigger instead of trigger for column)
ca734bc9 728 - Add various missing things to Optional::Dependencies
729 - Skip a test that breaks due to serious bugs in current DBD::SQLite
730 - Fix tests related to leaks and leaky perls (5.13.5, 5.13.6)
f8583f8f 731
347275d1 732 * Misc
0007aedf 733 - Entire test suite now passes under DBIC_TRACE=1
6c3e6bf6 734 - Makefile.PL no longer imports GetOptions() to interoperate
735 better with Catalyst installers
47a4aa51 736 - Bumped minimum Module::Install for developers
b9df8e39 737 - Bumped DBD::SQLite dependency and removed some TODO markers
d9da98ab 738 from tests (RT#59565)
d096e13f 739 - Do not execute t/zzzzzzz_sqlite_deadlock.t for regular module
740 installs - test is prone to spontaneous blow up
68de9438 741 - DT-related tests now require a DateTime >= 0.55 (RT#60324)
ccebe1f1 742 - Makefile.PL now provides a pre-parsed DBIC version to the
743 Opt::Dep pod generator
a8c2c746 744 - t/52leaks.t now performs very aggressive leak detection in
745 author/smoker mode
347275d1 746
9aa2ba09 7470.08123 2010-06-12 14:46 (UTC)
449c7034 748 * Fixes
749 - Make sure Oracle identifier shortener applies to auto-generated
f1577a8d 750 column names, so we stay within the 30-char limit (RT#58271)
df6e3f5c 751 - Oracle sequence detection now works across schemas
9aa2ba09 752 - Fix a Storage/$dbh leak introduced by the migration to
ddfd085d 753 Try::Tiny (this is *not* a Try::Tiny bug)
9f775126 754 - Fix corner case of count with group-by over a 1:1 join column
755 where the selector ends up with column name clashes
aa9bcbfb 756 - POD fixes (RT#58247)
ddfd085d 757
a258bfc7 758 * Misc
759 - Test suite default on-disk database now checks for Win32
760 fail-conditions even when running on other OSes
449c7034 761
9aa2ba09 7620.08122 2010-06-03 17:41 (UTC)
a31e24c0 763 * New Features
764 - Add DBIx::Class::FilterColumn for non-ref filtering
aa0163d4 765 - ::Storage::DBI now correctly preserves a parent $dbh from
860e7b5a 766 terminating children, even during interpreter-global
aa0163d4 767 out-of-order destruction
6ada2587 768 - dbicadmin supports an -I option with the same semantics as
769 perl itself
fb95dc4d 770 - InflateColumn::DateTime support for MSSQL via DBD::Sybase
a07bb26c 771 - Millisecond precision support for MSSQL datetimes for
fb95dc4d 772 InflateColumn::DateTime
49afd714 773 - Oracle-specific hierarchical query syntax support:
868a7b26 774 CONNECT BY (NOCYCLE) / START WITH / ORDER SIBLINGS BY
a07bb26c 775 - Support connecting using $ENV{DBI_DSN} and $ENV{DBI_DRIVER}
453781a1 776 - current_source_alias method on ResultSet objects to
777 determine the alias to use in programatically assembled
778 search()es (originally added in 0.08100 but unmentioned)
860e7b5a 779 - Rewrite/unification of all subselecting limit emulations
780 (RNO, Top, RowNum) to be much more robust wrt complex joined
781 resultsets
782 - MSSQL limits now don't require nearly as many applications of
783 the unsafe_subselect_ok attribute, due to optimized queries
75f025cf 784 - Support for Generic Subquery limit "emulation" - awfully slow
785 and inefficient but works on almost any db, and is preferred
5106b8a9 786 to software limit emulation
787 - Sybase ASE driver now uses SET ROWCOUNT where possible, and
788 Generic Subquery otherwise for limit support instead of always
789 using software limit emulation
076be7c4 790 - create_ddl_dir (and derivatives) now attempt to create the given
791 $ddl_dir if it does not already exist
96736321 792 - deployment_statements now automatically supplies the current RDBMS
793 version to SQLT producer_args for MySQL, Pg, SQLite and Oracle
a31e24c0 794
795 * Fixes
fef47a8e 796 - Fix nasty potentially data-eating bug when deleting/updating
797 a limited resultset
a31e24c0 798 - Fix find() to use result_class set on object
799 - Fix result_class setter behaviour to not mistakenly stuff attrs.
800 - Don't try and ensure_class_loaded an object. This doesn't work.
801 - Fix as_subselect_rs to not inject resultset class-wide where
802 conditions outside of the resulting subquery
acc01554 803 - Fix count() failing with {for} resultset attribute (RT#56257)
804 - Fixed incorrect detection of Limit dialect on unconnected $schema
fef47a8e 805 - update() on row not in_storage no longer throws an exception
806 if there are no dirty columns to update (fixes cascaded update
807 annoyances)
887d8da0 808 - update()/delete() on prefetching resultsets no longer results
809 in malformed SQL (some $rs attributes were erroneously left in)
6ada2587 810 - Fix dbicadmin to allow deploy() on non-versioned schema
811 - Fix dbicadmin to respect sql_dir on upgrade() (RT#57732)
65ee2b31 812 - Update Schema::Versioned to respect hashref style of
813 connection_info
814 - Do not recreate the same related object twice during MultiCreate
815 (solves the problem of orphaned IC::FS files)
4282b6f8 816 - Fully qualify xp_msver selector when using DBD::Sybase with
817 MSSQL (RT#57467)
f76f761c 818 - Fix ::DBI::Storage to always be able to present a full set of
819 connect() attributes to e.g. Schema::Versioned
acc01554 820 - Fix Oracle auto-inc trigger detection of "INSERT OR UPDATE"-type
821 triggers
453781a1 822
a31e24c0 823 * Misc
0424d17a 824 - Reformatted Changelog \o/
e21297d3 825 - DBIC goes git://git.shadowcat.co.uk/dbsrgits/DBIx-Class.git
0424d17a 826 - Allow developers to skip optional dependency forcing when working
827 from a checkout
828 - Add a warning to load_namespaces if a class in ResultSet/ is not
829 a subclass of DBIx::Class::ResultSet
a31e24c0 830 - All DBIC exception-handling switched to Try::Tiny
acc01554 831 - All DBIC modules are now free of imports via namespace::clean
a31e24c0 832 - Depend on optimized SQL::Abstract (faster SQL generation)
acc01554 833 - Depend on new Class::Accessor::Grouped reintroducing optional use
834 of Class::XSAccessor (just install C::XSA and get lightning fast
835 column accessors)
a31e24c0 836
c77ab576 8370.08121 2010-04-11 18:43:00 (UTC)
28d28903 838 - Support for Firebird RDBMS with DBD::InterBase and ODBC
734868da 839 - Add core support for INSERT RETURNING (for storages that
840 supports this syntax, currently PostgreSQL and Firebird)
3c2a505c 841 - Fix spurious warnings on multiple UTF8Columns component loads
842 - DBIx::Class::UTF8Columns entered deprecated state
c2ecf953 843 - DBIx::Class::InflateColumn::File entered deprecated state
e3fc11e1 844 - DBIx::Class::Optional::Dependencies left experimental state
845 - Add req_group_list to Opt::Deps (RT#55211)
b8391c87 846 - Add support for mysql-specific STRAIGHT_JOIN (RT#55579)
fb61e30c 847 - Cascading delete/update are now wrapped in a transaction
848 for atomicity
c4e5e95d 849 - Fix accidental autovivification of ENV vars
850 - Fix update_all and delete_all to be wrapped in a transaction
68888c09 851 - Fix multiple deficiencies when using MultiCreate with
852 data-encoder components (e.g. ::EncodedColumn)
b703fec7 853 - Fix regression where SQL files with comments were not
854 handled properly by ::Schema::Versioned.
263d5dcc 855 - Fix regression on not properly throwing when $obj->relationship
856 is unresolvable
1a736efb 857 - Fix the join-optimiser to consider unqualified column names
858 whenever possible
faeb2407 859 - Fix an issue with multiple same-table joins confusing the join
860 optimizier
0818c9a7 861 - Add has_relationship method to row objects
cf856357 862 - Fix regression in set_column on PK-less objects
455a33cb 863 - Better error text on malformed/missing relationships
c2ecf953 864 - Add POD about the significance of PK columns
865 - Fix for SQLite to ignore the (unsupported) { for => ... }
866 attribute
867 - Fix ambiguity in default directory handling of create_ddl_dir
868 (RT#54063)
157ce0cf 869 - Support add_columns('+colname' => { ... }) to augment column
870 definitions.
263d5dcc 871
033955f9 8720.08120 2010-02-24 08:58:00 (UTC)
2b3c0853 873 - Make sure possibly overwritten deployment_statements methods in
4fff7913 874 schemas get called on $schema->deploy
875 - Fix count() with group_by aliased-function resultsets
dea1b49e 876 - with_deferred_fk_checks() Oracle support
7ccf4805 877 - Massive refactor and cleanup of primary key handling
efc8ae6e 878 - Fixed regression losing custom result_class (really this time)
02730621 879 (RT#54697)
880 - Fixed regression in DBIC SQLT::Parser failing with a classname
881 (as opposed to a schema object)
270edb2b 882 - Changes to Storage::DBI::Oracle to accomodate changes in latest
883 SQL::Translator (quote handling)
dea1b49e 884 - Make sure deployment_statements is per-storage overridable
033955f9 885 - Fix dbicadmin's (lack of) POD
2b3c0853 886
f181e8fe 8870.08119 2010-02-15 09:36:00 (UTC)
d1f542db 888 - Add $rs->is_ordered to test for existing order_by on a resultset
af7fbf9f 889 - Add as_subselect_rs to DBIC::ResultSet from
890 DBIC::Helper::ResultSet::VirtualView::as_virtual_view
4752726d 891 - Refactor dbicadmin adding DDL manipulation capabilities
aa8b2277 892 - New optional dependency manager to aid extension writers
84d9d68d 893 - Depend on newest bugfixed Moose
642299a7 894 - Make resultset chaining consistent wrt selection specification
84d9d68d 895 - Storage::DBI::Replicated cleanup
896 - Fix autoinc PKs without an autoinc flag on Sybase ASA
af7fbf9f 897
a12793fd 8980.08118 2010-02-08 11:53:00 (UTC)
13d06949 899 - Fix a bug causing UTF8 columns not to be decoded (RT#54395)
900 - Fix bug in One->Many->One prefetch-collapse handling (RT#54039)
b82c8a28 901 - Cleanup handling of relationship accessor types
9738897e 902
6d5dca4e 9030.08117 2010-02-05 17:10:00 (UTC)
55087b99 904 - Perl 5.8.1 is now the minimum supported version
d64a2734 905 - Massive optimization of the join resolution code - now joins
906 will be removed from the resulting SQL if DBIC can prove they
907 are not referenced by anything
6dfbe2f8 908 - Subqueries no longer marked experimental
3197bdf8 909 - Support for Informix RDBMS (limit/offset and auto-inc columns)
60511375 910 - Support for Sybase SQLAnywhere, both native and via ODBC
dc571b76 911 - might_have/has_one now warn if applied calling class's column
912 has is_nullable set to true.
a7f4b74c 913 - Fixed regression in deploy() with a {sources} table limit applied
914 (RT#52812)
3ad8d9f1 915 - Views without a view_definition will throw an exception when
916 parsed by SQL::Translator::Parser::DBIx::Class
7ac1f782 917 - Stop the SQLT parser from auto-adding indexes identical to the
918 Primary Key
60511375 919 - InflateColumn::DateTime refactoring to allow fine grained method
920 overloads
66e33361 921 - Fix ResultSetColumn improperly selecting more than the requested
922 column when +columns/+select is present
037e8dca 923 - Fix failure when update/delete of resultsets with complex WHERE
924 SQLA structures
30ae562b 925 - Fix regression in context sensitiveness of deployment_statements
400c6f34 926 - Fix regression resulting in overcomplicated query on
927 search_related from prefetching resultsets
8baabfd8 928 - Fix regression on all-null returning searches (properly switch
929 LEFT JOIN to JOIN in order to distinguish between both cases)
0ce4ab92 930 - Fix regression in groupedresultset count() used on strict-mode
931 MySQL connections
010f82a0 932 - Better isolation of RNO-limited queries from the rest of a
933 prefetching resultset
934 - New MSSQL specific resultset attribute to allow hacky ordered
416e0bc0 935 subquery support
2ad89bf5 936 - Fix nasty schema/dbhandle leak due to SQL::Translator
78aef8c4 937 - Initial implementation of a mechanism for Schema::Version to
938 apply multiple step upgrades
3eee36aa 939 - Fix regression on externally supplied $dbh with AutoCommit=0
940 - FAQ "Custom methods in Result classes"
941 - Cookbook POD fix for add_drop_table instead of add_drop_tables
942 - Schema POD improvement for dclone
400c6f34 943
3b5769af 9440.08115 2009-12-10 09:02:00 (CST)
9010bab8 945 - Real limit/offset support for MSSQL server (via Row_Number)
886d0b49 946 - Fix distinct => 1 with non-selecting order_by (the columns
947 in order_by also need to be aded to the resulting group_by)
e3d5a547 948 - Do not attempt to deploy FK constraints pointing to a View
285dd1d6 949 - Fix count/objects from search_related on limited resultset
d992eae8 950 - Stop propagating distinct => 1 over search_related chains
36b59369 951 - Make sure populate() inherits the resultset conditions just
952 like create() does
547b4396 953 - Make get_inflated_columns behave identically to get_columns
954 wrt +select/+as (RT#46953)
4d46dbcf 955 - Fix problems with scalarrefs under InflateColumn (RT#51559)
285dd1d6 956 - Throw exception on delete/update of PK-less resultsets
957 - Refactored Sybase storage driver into a central ::DBI::Sybase
958 dispatcher, and a sybase-specific ::DBI::Sybase::ASE
959 - Fixed an atrocious DBD::ADO bind-value bug
960 - Cookbook/Intro POD improvements
e3d5a547 961
57cf1a59 9620.08114 2009-11-14 17:45:00 (UTC)
a1e695ad 963 - Preliminary support for MSSQL via DBD::ADO
57cf1a59 964 - Fix botched 0.08113 release (invalid tarball)
a1e695ad 965
4e8ffded 9660.08113 2009-11-13 23:13:00 (UTC)
18d80024 967 - Fix populate with has_many bug
968 (RT #50828)
e6dd7b42 969 - Fix Oracle autoincrement broken for Resultsets with scalar refs
970 (RT #50874)
d867eeda 971 - Complete Sybase RDBMS support including:
972 - Support for TEXT/IMAGE columns
973 - Support for the 'money' datatype
6a9765c1 974 - Transaction savepoints support
975 - DateTime inflation support
976 - Support for bind variables when connecting to a newer Sybase with
977 OpenClient libraries
978 - Support for connections via FreeTDS with CASTs for bind variables
979 when needed
980 - Support for interpolated variables with proper quoting when
981 connecting to an older Sybase and/or via FreeTDS
982 - bulk API support for populate()
3ed85561 983 - Transaction support for MSSQL via DBD::Sybase
7ae6270b 984 - Add is_paged method to DBIx::Class::ResultSet so that we can
dbf5b601 985 check that if we want a pager
986 - Skip versioning test on really old perls lacking Time::HiRes
987 (RT #50209)
988 - Fixed on_connect_do/call regression when used with a coderef
989 connector (RT #50003)
69cd8a7f 990 - A couple of fixes to Ordered to remedy subclassing issues
57eb47b0 991 - Fixed another lingering problem with PostgreSQL
992 auto-increment support and its interaction with multiple
993 schemas
3ed85561 994 - Remove some IN workarounds, and require a recent version of
995 SQLA instead
996 - Improvements to populate's handling of mixed scalarref values
0fcfe456 997 - Fixed regression losing result_class after $rs->find (introduced
998 in 0.08108)
63bb9738 999 - Fix in_storage() to return 1|0 as per existing documentation
c9c9297b 1000 - Centralize handling of _determine_driver calls prior to certain
1001 ::Storage::DBI methods
af668ad6 1002 - Fix update/delete arbitrary condition handling (RT#51409)
3ed85561 1003 - POD improvements
763026c1 1004
51845f96 10050.08112 2009-09-21 10:57:00 (UTC)
be97d16b 1006 - Remove the recommends from Makefile.PL, DBIx::Class is not
93c50889 1007 supposed to have optional dependencies. ever.
be97d16b 1008 - Mangle the DBIx/Class.pm POD to be more clear about
93c50889 1009 copyright and license
be97d16b 1010 - Put back PG's multiple autoinc per table support, accidentally
51845f96 1011 dropped during the serial-autodetection rewrite
be97d16b 1012 - Make sure ResultSetColumn does not depend on the (undefined)
1013 return value of ->cursor->reset()
4e55c3ae 1014 - Add single() to ResultSetColumn (same semantics as ResultSet)
be97d16b 1015 - Make sure to turn off IDENTITY_INSERT after insert() on MSSQL
1016 tables that needed it
1017 - More informative exception on failing _resolve_relationship
8c60e1a7 1018 - Allow undef/NULL as the sole grouping value in Ordered
4e55c3ae 1019 - Fix unreported rollback exceptions in TxnScopeGuard
8a3fa4ae 1020 - Fix overly-eager left-join chain enforcing code
3c44586e 1021 - Warn about using distinct with an existing group_by
1022 - Warn about attempting to $rs->get_column a non-unique column
1023 when has_many joins are added to resultset
51845f96 1024 - Refactor of the exception handling system (now everything is a
1bedffac 1025 DBIx::Class::Exception object)
01dc6781 1026
59f27fc3 10270.08111 2009-09-06 21:58:00 (UTC)
7755a91d 1028 - The hashref to connection_info now accepts a 'dbh_maker'
1029 coderef, allowing better intergration with Catalyst
d8ce00f5 1030 - Fixed a complex prefetch + regular join regression introduced
1031 in 0.08108
48617009 1032 - Fixed insert_bulk rebless handling
7cfda9a6 1033 - Fixed Storable roundtrip regression, and general serialization
1034 cleanup
ce35224f 1035 - SQLT related fixes:
1036 - sqlt_type is now called on the correct storage object
006fb68c 1037 - hooks can now see the correct producer_type (RT#47891)
7cfda9a6 1038 - optional SQLT requirements for e.g. deploy() bumped to 0.11002
decb86c0 1039 - Really fixed (and greatly cleaned up) postgresql autoinc sequence
1040 autodetection
7cfda9a6 1041 - Automatically detect MySQL v3 and use INNER JOIN instead of JOIN
006fb68c 1042 - POD improvements (including RT#48769)
1043 - Test suite tweaks (including fixes for recent CPANTS fails)
59f27fc3 1044 - Better support for MSSQL IDENTITY_INSERT ON
d8ce00f5 1045
dc5460a7 10460.08109 2009-08-18 08:35:00 (UTC)
294a5282 1047 - Replication updates:
1048 - Improved the replication tests so that they are more reliable
1049 and accurate, and hopefully solve some cross platform issues.
1050 - Bugfixes related to naming particular replicants in a
1051 'force_pool' attribute.
1052 - Lots of documentation updates, including a new Introduction.pod
1053 file.
1054 - Fixed the way we detect transaction to make this more reliable
1055 and forward looking.
1056 - Fixed some trouble with the way Moose Types are used.
1910c7af 1057 - Made discard_chages/get_from_storage replication aware (they
1058 now read from the master storage by default)
294a5282 1059 - Refactor of MSSQL storage drivers, with some new features:
1060 - Support for placeholders for MSSQL via DBD::Sybase with proper
1061 autodetection
1062 - 'uniqueidentifier' support with auto newid()
1063 - Dynamic cursor support and other MARS options for ODBC
2b0abe0e 1064 - savepoints with auto_savepoint => 1
294a5282 1065 - Support for MSSQL 'money' type
1066 - Support for 'smalldatetime' type used in MSSQL and Sybase for
4c46fa18 1067 InflateColumn::DateTime
1f4263eb 1068 - Support for Postgres 'timestamp without timezone' type in
294a5282 1069 InflateColumn::DateTime (RT#48389)
97a0a148 1070 - Added new MySQL specific on_connect_call macro 'set_strict_mode'
1071 (also known as make_mysql_not_suck_as_much)
294a5282 1072 - Multiple prefetch-related fixes:
1073 - Adjust overly agressive subquery join-chain pruning
1074 - Always preserve the outer join-chain - fixes numerous
1075 problems with search_related chaining
1076 - Deal with the distinct => 1 attribute properly when using
1077 prefetch
f077b8f5 1078 - An extension of the select-hashref syntax, allowing labeling
1079 SQL-side aliasing: select => [ { max => 'foo', -as => 'bar' } ]
13a3e374 1080 - Massive optimization of the DBI storage layer - reduce the
f077b8f5 1081 amount of connected() ping-calls
58e39c86 1082 - Some fixes of multi-create corner cases
294a5282 1083 - Multiple POD improvements
73d47f9f 1084 - Added exception when resultset is called without an argument
c0f4f8bb 1085 - Improved support for non-schema-qualified tables under
67e894d2 1086 Postgres (fixed last_insert_id sequence name auto-detection)
97a0a148 1087
2ec1a5c1 10880.08108 2009-07-05 23:15:00 (UTC)
04492bc7 1089 - Fixed the has_many prefetch with limit/group deficiency -
1090 it is now possible to select "top 5 commenters" while
1091 prefetching all their comments
1092 - New resultsed method count_rs, returns a ::ResultSetColumn
1093 which in turn returns a single count value
1094 - Even better support of count with limit
6a999241 1095 - New on_connect_call/on_disconnect_call functionality (check
1096 POD of Storage::DBI)
1097 - Automatic datetime handling environment/session setup for
1098 Oracle via connect_call_datetime_setup()
f685632d 1099 - count/all on related left-joined empty resultsets now correctly
1100 returns 0/()
e8b32a6d 1101 - Fixed regression when both page and offset are specified on
1102 a resultset
1103 - Fixed HRI returning too many empty results on multilevel
1104 nonexisting prefetch
497d874a 1105 - make_column_dirty() now overwrites the deflated value with an
1106 inflated one if such exists
7ae6270b 1107 - Fixed set_$rel with where restriction deleting rows outside
d2d82857 1108 the restriction
04492bc7 1109 - populate() returns the created objects or an arrayref of the
115a7c3b 1110 created objects depending on scalar vs. list context
04492bc7 1111 - Fixed find_related on 'single' relationships - the former
1112 implementation would overspecify the WHERE condition, reporting
1113 no related objects when there in fact is one
1114 - SQL::Translator::Parser::DBIx::Class now attaches tables to the
1115 central schema object in relationship dependency order
1116 - Fixed regression in set_column() preventing sourceless object
1117 manipulations
1118 - Fixed a bug in search_related doubling a join if the original
1119 $rs already joins/prefetches the same relation
1120 - Storage::DBI::connected() improvements for Oracle and Sybase
b4fd6882 1121 - Fixed prefetch+incomplete select regression introduced in
1122 0.08100
9ab7fe6a 1123 - MSSQL limit (TOP emulation) fixes and improvements
51a296b4 1124
6d82e103 11250.08107 2009-06-14 08:21:00 (UTC)
1126 - Fix serialization regression introduced in 0.08103 (affects
1127 Cursor::Cached)
1128 - POD fixes
1129 - Fixed incomplete ::Replicated debug output
1130
ea60f9a9 11310.08106 2009-06-11 21:42:00 (UTC)
1132 - Switched SQLite storage driver to DateTime::Format::SQLite
1133 (proper timezone handling)
1134 - Fix more test problems
1135
fb022fcf 11360.08105 2009-06-11 19:04:00 (UTC)
90499ee4 1137 - Update of numeric columns now properly uses != to determine
1138 dirtyness instead of the usual eq
1139 - Fixes to IC::DT tests
04492bc7 1140 - Fixed exception when undef_if_invalid and timezone are both set
1141 on an invalid datetime column
90499ee4 1142
536bf52b 11430.08104 2009-06-10 13:38:00 (UTC)
1ca68535 1144 - order_by now can take \[$sql, @bind] as in
1145 order_by => { -desc => \['colA LIKE ?', 'somestring'] }
1146 - SQL::Abstract errors are now properly croak()ed with the
1147 correct trace
4242d79d 1148 - populate() now properly reports the dataset slice in case of
1149 an exception
9c094643 1150 - Fixed corner case when populate() erroneously falls back to
4242d79d 1151 create()
9c094643 1152 - Work around braindead mysql when doing subquery counts on
b5963465 1153 resultsets containing identically named columns from several
1154 tables
536bf52b 1155 - Fixed m2m add_to_$rel to invoke find_or_create on the far
9c094643 1156 side of the relation, to avoid duplicates
1157 - DBIC now properly handles empty inserts (invoking all default
1158 values from the DB, normally via INSERT INTO tbl DEFAULT VALUES
7ae6270b 1159 - Fix find_or_new/create to stop returning random rows when
9c094643 1160 default value insert is requested (RT#28875)
1161 - Make IC::DT extra warning state the column name too
1162 - It is now possible to transparrently search() on columns
536bf52b 1163 requiring DBI bind (i.e. PostgreSQL BLOB)
9c094643 1164 - as_query is now a Storage::DBI method, so custom cursors can
1165 be seamlessly used
1166 - Fix search_related regression introduced in 0.08103
4242d79d 1167
e911e7ff 11680.08103 2009-05-26 19:50:00 (UTC)
1ace31c2 1169 - Multiple $resultset -> count/update/delete fixes. Now any
1170 of these operations will succeed, regardless of the complexity
1171 of $resultset. distinct, group_by, join, prefetch are all
1172 supported with expected results
19431116 1173 - Return value of $rs->delete is now the storage return value
1174 and not 1 as it used to be
a4d8bea5 1175 - don't pass SQL functions into GROUP BY
c8a8b777 1176 - Remove MultiDistinctEmulation.pm, effectively deprecating
1177 { select => { distinct => [ qw/col1 col2/ ] } }
1178 - Change ->count code to work correctly with DISTINCT (distinct => 1)
1179 via GROUP BY
1ace31c2 1180 - Removed interpolation of bind vars for as_query - placeholders
7ae6270b 1181 are preserved and nested query bind variables are properly
1ace31c2 1182 merged in the correct order
7ae6270b 1183 - Refactor DBIx::Class::Storage::DBI::Sybase to automatically
d4483998 1184 load a subclass, namely Microsoft_SQL_Server.pm
568bde84 1185 (similar to DBIx::Class::Storage::DBI::ODBC)
44a8dcf3 1186 - Refactor InflateColumn::DateTime to allow components to
1187 circumvent DateTime parsing
9073e906 1188 - Support inflation of timestamp datatype
1189 - Support BLOB and CLOB datatypes on Oracle
46ad3c86 1190 - Storage::DBI::Replicated::Balancer::Random:
1191 added master_read_weight
1192 - Storage::DBI::Replicated: storage opts from connect_info,
1193 connect_info merging to replicants, hashref connect_info support,
1194 improved trace output, other bug fixes/cleanups
1ace31c2 1195 - distinct => 1 with prefetch now groups by all columns
1196 - on_connect_do accepts a single string equivalent to a one
1197 element arrayref (RT#45159)
1198 - DB2 limit + offset now works correctly
1199 - Sybase now supports autoinc PKs (RT#40265)
1200 - Prefetch on joins over duplicate relations now works
1201 correctly (RT#28451)
6c99a3ee 1202 - "timestamp with time zone" columns (for Pg) now get inflated with a
1203 time zone information preserved
19431116 1204 - MSSQL Top limit-emulation improvements (GROUP BY and subquery support)
bed3a173 1205 - ResultSetColumn will not lose the joins infered from a parent
1206 resultset prefetch
d4483998 1207
90b41762 12080.08102 2009-04-30 08:29:00 (UTC)
9beb2b51 1209 - Fixed two subtle bugs when using columns or select/as
1210 paired with a join (limited prefetch)
1211 - Fixed breakage of cdbi tests (RT#45551)
1212 - Some POD improvements
1213
a0f289c8 12140.08101 2009-04-27 09:45:00 (UTC)
1215 - Fix +select, +as, +columns and include_columns being stripped
1216 by $rs->get_column
1217 - move load_optional_class from DBIx::Class::Componentised to
1218 Class::C3::Componentised, bump dependency
1219 - register_extra_source() now *really* fixed wrt subclassing
1220 - Added missing POD descriptions (RT#45195)
1221 - Fix insert() to not store_column() every present object column
1222 - Multiple Makefile.PL fixes
121068ec 1223
a0f289c8 12240.08100 2009-04-19 11:39:35 (UTC)
6882de2b 1225 - Todo out the register_extra_source test until after shipping
1226
6c0e3b46 12270.08099_08 2009-03-30 00:00:00 (UTC)
1228 - Fixed taint mode with load_namespaces
1229 - Putting IC::DateTime locale, timezone or floating_tz_ok attributes into
92ed0695 1230 extra => {} has been deprecated. The new way is to put these things
1231 directly into the columns definition
6c0e3b46 1232 - Switched MI code to MRO::Compat
1233 - Document db-side default_value caveats
cfcaa8ed 1234 - Search_like() now warns to indicate deprecation in 0.09.
6c0e3b46 1235 - TxnScopeGuard left experimental state
1236
12370.08099_07 2009-02-27 02:00:00 (UTC)
de404241 1238 - multi-create using find_or_create rather than _related for post-insert
1239 - fix get_inflated_columns to check has_column_loaded
6ffb5be5 1240 - Add DBIC_MULTICREATE_DEBUG env var (undocumented, quasi-internal)
1241 - Fix up multi-create to:
1242 - correctly propagate columns loaded during multi-insert of rels
1243 - not try and insert things tagged on via new_related unless required
8d689133 1244 - Possible to set locale in IC::DateTime extra => {} config
6ffb5be5 1245 - Calling the accessor of a belongs_to when the foreign_key
7ae6270b 1246 was NULL and the row was not stored would unexpectedly fail
6ffb5be5 1247 - Split sql statements for deploy only if SQLT::Producer returned a scalar
1248 containing all statements to be executed
1249 - Add as_query() for ResultSet and ResultSetColumn. This makes subqueries
6882de2b 1250 possible. See the Cookbook for details.
bd7ca9e8 1251 - Massive rewrite of Ordered to properly handle position constraints and
1252 to make it more matpath-friendly
0233fc64 1253 - deploy_statements called ddl_filename with the $version and $dir arguments
6c0e3b46 1254 in the wrong order.
00c937a2 1255 - columns/+columns attributes now support { as => select } hahsrefs
64ea0f49 1256 - support for views both in DBIC and via deploy() in SQLT
eaab653f 1257
12580.08099_06 2009-01-23 07:30:00 (UTC)
0eb27426 1259 - Allow a scalarref to be supplied to the 'from' resultset attribute
1260 - Classes submitted as result_class for a resultsource are now
1261 automatically loaded via ensure_loaded()
1262 - 'result_class' resultset attribute, identical to result_class()
0da3fea1 1263 - add 'undef_on_null_fk' option for relationship accessors of type 'single'.
cef1bdda 1264 This will prevent DBIC from querying the database if one or more of
0e40881e 1265 the key columns IS NULL
1266 - for 'belongs_to' rels, 'undef_on_null_fk' defaults to true.
1267 - fixed scope unaware last_insert_id fetching for MSSQL
1268 (http://msdn.microsoft.com/en-us/library/ms190315.aspx)
0da3fea1 1269 - an sqlt_deploy_hook can now be shared between result sources using
1270 a configurable callback trigger
20ea616f 1271 - new order_by => { -desc => 'colname' } syntax supported
1272 - PG array datatype supported
0e80c4ca 1273 - insert should use store_column, not set_column to avoid marking
7ae6270b 1274 clean just-stored values as dirty. New test for this
1275 - regression test for source_name
28e6c8b6 1276
12770.08099_05 2008-10-30 21:30:00 (UTC)
cfcaa8ed 1278 - Rewrite of Storage::DBI::connect_info(), extended with an
28e6c8b6 1279 additional argument format type
2177f7d2 1280 - InflateColumn::DateTime: add warning about floating timezone
1281 - InflateColumn::DateTime: possible to enforce/skip inflation
cfcaa8ed 1282 - delete throws exception if passed arguments to prevent drunken mishaps.
68f3b0dd 1283 - Fix storage to copy scalar conds before regexping to avoid
1284 trying to modify a constant in odd edge cases
1285 - Related resultsets on uninserted objects are now empty
370f2ba2 1286 - Fixed up related resultsets and multi-create
2eebd801 1287 - Fixed superfluous connection in ODBC::_rebless
1288 - Fixed undef PK for first insert in ODBC::Microsoft_SQL_Server
7ae6270b 1289 - Added virtual method to Versioned so a user can create upgrade
a354b842 1290 path across multiple versions (jgoulah)
d76e282a 1291 - Better (and marginally faster) implementation of the HashRefInflator
1292 hash construction algorithm
d76e282a 1293 - Allow explicit specification of ON DELETE/ON UPDATE constraints
1294 when using the SQLT parser
af8b962f 1295
8c764dc7 12960.08099_04 2008-07-24 01:00:00
e96a93df 1297 - Functionality to storage to enable a sub to be run without FK checks
7ae6270b 1298 - Fixed $schema->clone bug which caused clone and source to share
73529292 1299 internal hash refs
2a4d9487 1300 - Added register_extra_source methods for additional sources
33a126ef 1301 - Added datetime_undef_if_invalid for InflateColumn::DateTime to
1302 return undef on invalid date/time values
262da53c 1303 - Added search_related_rs method to ResultSet
6dbea98e 1304 - add a make_column_dirty method to Row to force updates
cb136e67 1305 - throw a clear exception when user tries multi-has_many prefetch
1306 - SQLT parser prefixes index names with ${table}_idx_ to avoid clashes
748ab0dc 1307 - mark ResultSetManager as deprecated and undocument it
debccec3 1308 - pod fix (RT #32988)
f947585b 1309 - add Test::Exception to test requirements (RT #34256)
fe650234 1310 - make ash's build_requires/META.yml fixes work better
13de943d 1311 - is_deferable support on relations used by the SQL::Translator
ad6c4e20 1312 parser
d63be6d0 1313 - Refactored DBIx::Class::Schema::Versioned
a63219bc 1314 - Syntax errors from resultset components are now reported correctly
45f1a484 1315 - sqltargs respected correctly in deploy et al.
5dee2dcf 1316 - Added support for savepoints, and using them automatically in
1317 nested transactions if auto_savepoint is set in connect_info.
0da8b7da 1318 - Changed naming scheme for constraints and keys in the sqlt parser;
1319 names should now be consistent and collision-free.
ad6c4e20 1320 - Improve handling of explicit key attr in ResultSet::find
1321 - Add warnings for non-unique ResultSet::find queries
e515254d 1322 - Changed Storage::DBI::Replication to Storage::DBI::Replicated and
1323 refactored support.
7ae6270b 1324 - By default now deploy/diff et al. will ignore constraint and index
d4d46d19 1325 names
e758ffe6 1326 - Add ResultSet::_is_deterministic_value, make new_result filter the
1327 values passed to new to drop values that would generate invalid SQL.
7ae6270b 1328 - Use Sub::Name to name closures before installing them. Fixes
ddc0a6c8 1329 incompatibility with Moose method modifiers on generated methods.
13de943d 1330
dd018f09 13310.08010 2008-03-01 10:30
1332 - Fix t/94versioning.t so it passes with latest SQL::Translator
1333
95e34604 13340.08009 2008-01-20 13:30
0ed8d3b6 1335 - Made search_rs smarter about when to preserve the cache to fix
1336 mm prefetch usage
7ae6270b 1337 - Added Storage::DBI subclass for MSSQL over ODBC.
4146e3da 1338 - Added freeze, thaw and dclone methods to Schema so that thawed
1339 objects will get re-attached to the schema.
8cfef6f5 1340 - Moved dbicadmin to JSON::Any wrapped JSON.pm for a sane API
67109394 1341 (also fixes RT #32393)
a0826322 1342 - introduced DBIx::Class::set_inflated_columns
1343 - DBIx::Class::Row::copy uses set_inflated_columns
4146e3da 1344
af8b962f 13450.08008 2007-11-16 14:30:00
7e9b2a24 1346 - Fixed join merging bug (test from Zby)
eba322a7 1347 - When adding relationships, it will throw an exception if you get the
1348 foreign and self parts the wrong way round in the condition
5d62876f 1349 - ResultSetColumn::func() now returns all results if called in list
1350 context; this makes things like func('DISTINCT') work as expected
7ae6270b 1351 - Many-to-many relationships now warn if the utility methods would
35210a5d 1352 clash
dda9af55 1353 - InflateColumn::DateTime now accepts an extra parameter of timezone
1354 to set timezone on the DT object (thanks Sergio Salvi)
7ae6270b 1355 - Added sqlt_deploy_hook to result classes so that indexes can be
aaf2403d 1356 added.
7ae6270b 1357 - Added startup checks to warn loudly if we appear to be running on
11736b4c 1358 RedHat systems from perl-5.8.8-10 and up that have the bless/overload
1359 patch applied (badly) which causes 2x -> 100x performance penalty.
1360 (Jon Schutz)
7ae6270b 1361 - ResultSource::reverse_relationship_info can distinguish between
86636368 1362 sources using the same table
1363 - Row::insert will now not fall over if passed duplicate related objects
7ae6270b 1364 - Row::copy will not fall over if you have two relationships to the
35688220 1365 same source with a unique constraint on it
eba322a7 1366
c94f64f9 13670.08007 2007-09-04 19:36:00
8f7e044c 1368 - patch for Oracle datetime inflation (abram@arin.net)
6f442eb7 1369 - added on_disconnect_do
1370 - on_connect_do and on_disconnect_do take coderefs and arrayrefs
1371
5c642b15 13720.08006 2007-08-12 15:12:00
1373 - Move to using Class::C3::Componentised
1374 - Remove warn statement from DBIx::Class::Row
1375
7ae6270b 13760.08005 2007-08-06
f011970e 1377 - add timestamp fix re rt.cpan 26978 - no test yet but change
1378 clearly should cause no regressions
01d59a6a 1379 - provide alias for related_resultset via local() so it's set
1380 correctly at resultset construction time (fixes RestrictWithObject)
e5d9ee92 1381 - fixes bind params in debug statements
1382 (original test from abraxxa)
649bfb8c 1383 - fixed storage->connected fork bug
1384 (test and fix from Radu Greab)
fe0e9f67 1385 - add 1; to AccessorGroup.pm for stuff that still uses it
70f39278 1386 - refactor Statistics to create debugging filehandle to fix bug with
1387 closed STDERR, update docs and modify Versioned to use Statistics
1388 (original fix from diz)
1389
e7827df0 13900.08004 2007-08-06 19:00:00
7ae6270b 1391 - fix storage connect code to not trigger bug via auto-viv
e7827df0 1392 (test from aherzog)
e4eb8ee1 1393 - fixup cursor_class to be an 'inherited' attr for per-package defaults
e6c747fd 1394 - add default_resultset_attributes entry to Schema
6296f45b 1395 - optimisation in DBI::Cursor to check software_limit before falling
1396 back to base Cursor->all
2bc3c81e 1397 - fix bug with create_multi not inserting non-storage objects
1398 (test and fix from davinchi)
73281318 1399 - DBIx::Class::AccessorGroup made empty subclass of
1400 Class::Accessor::Grouped
ec8c7e7f 1401 - fixed an ugly bug regarding $dbh->{AutoCommit} and transactions
73281318 1402 - ensure_class_loaded handles non-classnames better.
9a0891be 1403 - non-destructive hashref handling for connect_info options
2bd9c7c0 1404 - count no longer returns negative values after slice
1405 (report and test from JOHANL)
114780ee 1406 - rebless before building datetime_parser
1407 (patch from mattlaw / Matt Lawrence)
1408
ab2cf1fb 14090.08003 2007-07-14 18:01:00
1410 - improved populate bulk_insert mode
a8c98174 1411 - fixed up multi_create to be more intelligent about PK<->PK rels
6cc5b382 1412 - fix many-many rels to not use set_columns
dfccde48 1413 - Unmarked deploy as experimental since it isn't anymore
1414 - Removed Cwd dep since it's not required and causes problems
1415 with debian packaging
b4474f31 1416 - Patch to fix ? in data for NoBindVars (from Tom Hukins)
77d518d1 1417 - Restored mk_classaccessor method for compatibility
3f6cc7e4 1418 - Fixed group_by problem with oracle limit syntax
1419 - Fixed attr merging problem
1420 - Fixed $rs->get_column w/prefetch problem
77d518d1 1421
6fa7228e 14220.08002 2007-06-20 06:10:00
9c6d6d93 1423 - add scope guard to Row::insert to ensure rollback gets called
1424 - more heuristics in Row::insert to try and get insert order right
1425 - eliminate vestigial code in PK::Auto
2ab60eb9 1426 - more expressive DBI errors
1427 - soften errors during deploy
291bf95f 1428 - ensure_connected before txn_begin to catch stomping on transaction
1429 depth
b2f408f3 1430 - new method "rethrow" for our exception objects
1431
a2800991 14320.08001 2007-06-17 21:21:02
1433 - Cleaned up on_connect handling for versioned
1434 - removed DateTime use line from multi_create test
1435 - hid DBIx::ContextualFetch::st override in CDBICompat
1436
737416a4 14370.08000 2007-06-17 18:06:12
942cd0c1 1438 - Fixed DBIC_TRACE debug filehandles to set ->autoflush(1)
1439 - Fixed circular dbh<->storage in HandleError with weakref
1440
a0bd8a8c 14410.07999_06 2007-06-13 04:45:00
3fda409f 1442 - tweaked Row.pm to make last_insert_id take multiple column names
a0bd8a8c 1443 - Fixed DBIC::Storage::DBI::Cursor::DESTROY bug that was
1444 messing up exception handling
1445 - added exception objects to eliminate stacktrace/Carp::Clan
1446 output redundancy
1447 - setting $ENV{DBIC_TRACE} defaults stacktrace on.
4d4c7bbe 1448 - added stacktrace option to Schema, makes throw_exception
1449 use "confess"
1450 - make database handles use throw_exception by default
1451 - make database handles supplied by a coderef use our
1452 standard HandleError/RaiseError/PrintError
1453 - add "unsafe" connect_info option to suppress our setting
1454 of HandleError/RaiseError/PrintError
1455 - removed several redundant evals whose sole purpose was to
1456 provide extra debugging info
4d993a62 1457 - fixed page-within-page bug (reported by nilsonsfj)
4d4c7bbe 1458 - fixed rare bug when database is disconnected inbetween
1459 "$dbh->prepare_cached" and "$sth->execute"
4d993a62 1460
ff132c6f 14610.07999_05 2007-06-07 23:00:00
2c2a01a5 1462 - Made source_name rw in ResultSource
40dce2a5 1463 - Fixed up SQL::Translator test/runtime dependencies
e3d0ecce 1464 - Fixed t/60core.t in the absence of DateTime::Format::MySQL
8b621a87 1465 - Test cleanup and doc note (ribasushi)
e3d0ecce 1466
1c1896e8 14670.07999_04 2007-06-01 14:04:00
f5d3a5de 1468 - pulled in Replication storage from branch and marked EXPERIMENTAL
24010dd8 1469 - fixup to ensure join always LEFT after first LEFT join depthwise
f217eaab 1470 - converted the vendor tests to use schema objects intead of schema
1471 classes, made cleaned more reliable with END blocks
42416a0b 1472 - versioning support via DBIx::Class::Schema::Versioned
f217eaab 1473 - find/next now return undef rather than () on fail from Bernhard Graf
f80f8e2f 1474 - rewritten collapse_result to fix prefetch
1475 - moved populate to resultset
1476 - added support for creation of related rows via insert and populate
f217eaab 1477 - transaction support more robust now in the face of varying AutoCommit
1478 and manual txn_begin usage
1479 - unbreak back-compat for Row/ResultSet->new_result
03cc17a5 1480 - Added Oracle/WhereJoins.pm for Oracle >= 8 to support
1481 Oracle <= 9i, and provide Oracle with a better join method for
1482 later versions. (I use the term better loosely.)
3d618782 1483 - The SQL::T parser class now respects a relationship attribute of
03cc17a5 1484 is_foreign_key_constrain to allow explicit control over wether or
1485 not a foreign constraint is needed
fac560c2 1486 - resultset_class/result_class now (again) auto loads the specified
1d4e109a 1487 class; requires Class::Accessor::Grouped 0.05002+
ba4a6453 1488 - added get_inflated_columns to Row
43556c5d 1489 - %colinfo accessor and inflate_column now work together
42d96e77 1490 - More documentation updates
1491 - Error messages from ->deploy made more informative
1492 - connect_info will now always return the arguments it was
1493 originally given
1494 - A few small efficiency improvements for load_classes
1495 and compose_namespace
1496
13f897a0 14970.07006 2007-04-17 23:18:00
b740ac42 1498 - Lots of documentation updates
1499 - deploy now takes an optional 'source_names' parameter (dec)
1500 - Quoting for for columns_info_for
1501 - RT#25683 fixed (multiple open sths on DBD::Sybase)
1502 - CDBI compat infers has_many from has_a (Schwern)
e73fced0 1503 - Fix ddl_filename transformation (Carl Vincent)
8b50216e 1504
e9188247 15050.07999_02 2007-01-25 20:11:00
1506 - add support for binding BYTEA and similar parameters (w/Pg impl)
1507 - add support to Ordered for multiple ordering columns
1508 - mark DB.pm and compose_connection as deprecated
1509 - switch tests to compose_namespace
737416a4 1510 - ResultClass::HashRefInflator added
e9188247 1511 - Changed row and rs objects to not have direct handle to a source,
1512 instead a (schema,source_name) tuple of type ResultSourceHandle
c216324a 1513
f00482a5 15140.07005 2007-01-10 18:36:00
1515 - fixup changes file
1516 - remove erroneous .orig files - oops
1517
d5efeb56 15180.07004 2007-01-09 21:52:00
d180c0f3 1519 - fix find_related-based queries to correctly grep the unique key
97c76264 1520 - fix InflateColumn to inflate/deflate all refs but scalar refs
d180c0f3 1521
e1f1616e 15220.07003 2006-11-16 11:52:00
8de06d81 1523 - fix for rt.cpan.org #22740 (use $^X instead of hardcoded "perl")
25dbe178 1524 - Tweaks to resultset to allow inflate_result to return an array
382b1d53 1525 - Fix UTF8Columns to work under Perl <= 5.8.0
c6a0dde1 1526 - Fix up new_result in ResultSet to avoid alias-related bugs
a4c8f60d 1527 - Made new/update/find handle 'single' rel accessor correctly
1528 - Fix NoBindVars to be safer and handle non-true bind values
e1f1616e 1529 - Don't blow up if columns_info_for returns useless results
1530 - Documentation updates
382b1d53 1531
e9188247 15320.07999_01 2006-10-05 21:00:00
1533 - add connect_info option "disable_statement_caching"
1534 - create insert_bulk using execute_array, populate uses it
1535 - added DBIx::Class::Schema::load_namespaces, alternative to
1536 load_classes
1537 - added source_info method for source-level metadata (kinda like
1538 column_info)
1539 - Some of ::Storage::DBI's code/docs moved to ::Storage
1540 - DBIx::Class::Schema::txn_do code moved to ::Storage
1541 - Storage::DBI now uses exceptions instead of ->ping/->{Active} checks
1542 - Storage exceptions are thrown via the schema class's throw_exception
1543 - DBIx::Class::Schema::throw_exception's behavior can be modified via
1544 ->exception_action
1545 - columns_info_for is deprecated, and no longer runs automatically.
1546 You can make it work like before via
1547 __PACKAGE__->column_info_from_storage(1) for now
1548 - Replaced DBIx::Class::AccessorGroup and Class::Data::Accessor with
5d583aba 1549 Class::Accessor::Grouped. Only user noticible change is to
1550 table_class on ResultSourceProxy::Table (i.e. table objects in
1551 schemas) and, resultset_class and result_class in ResultSource.
e9188247 1552 These accessors no longer automatically require the classes when
1553 set.
1554
2292193a 15550.07002 2006-09-14 21:17:32
1556 - fix quote tests for recent versions of SQLite
1557 - added reference implementation of Manual::Example
1558 - backported column_info_from_storage accessor from -current, but
6d2d6160 1559 - fixed inflate_datetime.t tests/stringify under older Test::More
2292193a 1560 - minor fixes for many-to-many relationship helpers
36f79eed 1561 - cleared up Relationship docs, and fixed some typos
e4cc8257 1562 - use ref instead of eval to check limit syntax (to avoid issues with
1563 Devel::StackTrace)
2292193a 1564 - update ResultSet::_cond_for_update_delete to handle more complicated
1565 queries
1566 - bugfix to Oracle columns_info_for
a918d901 1567 - remove_columns now deletes columns from _columns
1568
f096a498 15690.07001 2006-08-18 19:55:00
9dba3059 1570 - add directory argument to deploy()
1571 - support default aliases in many_to_many accessors.
1572 - support for relationship attributes in many_to_many accessors.
1573 - stop search_rs being destructive to attrs
1574 - better error reporting when loading components
1575 - UTF8Columns changed to use "utf8" instead of "Encode"
ab8481f5 1576 - restore automatic aliasing in ResultSet::find() on nonunique queries
1577 - allow aliases in ResultSet::find() queries (in cases of relationships
1578 with prefetch)
89034887 1579 - pass $attrs to find from update_or_create so a specific key can be
1580 provided
04786a4c 1581 - remove anonymous blesses to avoid major speed hit on Fedora Core 5's
1582 Perl and possibly others; for more information see:
1583 https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=196836
282cccff 1584 - fix a pathological prefetch case
1585 - table case fix for Oracle in columns_info_for
cb3e35d2 1586 - stopped search_rs deleting attributes from passed hash
282cccff 1587
cebfddb3 15880.07000 2006-07-23 02:30:00
28d25740 1589 - supress warnings for possibly non-unique queries, since
1590 _is_unique_query doesn't infer properly in all cases
b489f68a 1591 - skip empty queries to eliminate spurious warnings on ->deploy
d09c569a 1592 - fixups to ORDER BY, tweaks to deepen some copies in ResultSet
eac29141 1593 - fixup for RowNum limit syntax with functions
d09c569a 1594
99eff28a 15950.06999_07 2006-07-12 20:58:05
1596 - fix issue with from attr copying introduced in last release
1597
26cfd055 15980.06999_06 2006-07-12 17:16:55
1599 - documentation for new storage options, fix S::A::L hanging on to $dbh
1600 - substantial refactor of search_related code to fix alias numbering
dcfb635f 1601 - don't generate partial unique keys in ResultSet::find() when a table
1602 has more than one unique constraint which share a column and only one
1603 is satisfied
404939a4 1604 - cleanup UTF8Columns and make more efficient
26cfd055 1605 - rename DBIX_CLASS_STORAGE_DBI_DEBUG to DBIC_TRACE (with compat)
f9fbd9bb 1606 - rename _parent_rs to _parent_source in ResultSet
0793f927 1607 - new FAQ.pod!
f9fbd9bb 1608
2b19c829 16090.06999_05 2006-07-04 14:40:01
88de38fa 1610 - fix issue with incorrect $rs->{attrs}{alias}
c1466191 1611 - fix subclassing issue with source_name
296ef183 1612 - tweak quotes test to output text on failure
f32eb113 1613 - fix Schema->txn_do to not fail as a classmethod
1614
39b590c1 16150.06999_04 2006-06-29 20:18:47
d651c864 1616 - disable cdbi-t/02-Film.t warning tests under AS perl
ca306ecb 1617 - fixups to MySQL tests (aka "work round mysql being retarded")
1618 - compat tweaks for Storage debug logging
1619
ef26a392 16200.06999_03 2006-06-26 21:04:44
1621 - various documentation improvements
1622 - fixes to pass test suite on Windows
1623 - rewrote and cleaned up SQL::Translator tests
1624 - changed relationship helpers to only call ensure_class_loaded when the
5d583aba 1625 join condition is inferred
ef26a392 1626 - rewrote many_to_many implementation, now provides helpers for adding
1627 and deleting objects without dealing with the link table
6ccc50ab 1628 - reworked InflateColumn implementation to lazily deflate where
ef26a392 1629 possible; now handles passing an inflated object to new()
1630 - changed join merging to not create a rel_2 alias when adding a join
42312aa5 1631 that already exists in a parent resultset
ef26a392 1632 - Storage::DBI::deployment_statements now calls ensure_connected
5d583aba 1633 if it isn't passed a type
ef26a392 1634 - fixed Componentized::ensure_class_loaded
5d0a2955 1635 - InflateColumn::DateTime supports date as well as datetime
ef26a392 1636 - split Storage::DBI::MSSQL into MSSQL and Sybase::MSSQL
5d583aba 1637 - fixed wrong debugging hook call in Storage::DBI
1638 - set connect_info properly before setting any ->sql_maker things
42312aa5 1639
713ca2e2 16400.06999_02 2006-06-09 23:58:33
9b83fccd 1641 - Fixed up POD::Coverage tests, filled in some POD holes
175cff3e 1642 - Added a warning for incorrect component order in load_components
bd93520f 1643 - Fixed resultset bugs to do with related searches
1644 - added code and tests for Componentized::ensure_class_found and
1645 load_optional_class
1646 - NoBindVars + Sybase + MSSQL stuff
1647 - only rebless S::DBI if it is still S::DBI and not a subclass
1648 - Added `use' statement for DBD::Pg in Storage::DBI::Pg
1649 - stopped test relying on order of unordered search
1650 - bugfix for join-types in nested joins using the from attribute
1651 - obscure prefetch problem fixed
1652 - tightened up deep search_related
1653 - Fixed 'DBIx/Class/DB.pm did not return a true value' error
1654 - Revert change to test for deprecated find usage and swallow warnings
1655 - Slight wording change to new_related() POD
1656 - new specific test for connect_info coderefs
1657 - POD clarification and content bugfixing + a few code formatting fixes
1658 - POD::Coverage additions
1659 - fixed debugfh
1660 - Fix column_info stomping
9b83fccd 1661
0de39991 16620.06999_01 2006-05-28 17:19:30
368a5228 1663 - add automatic naming of unique constraints
1c81f831 1664 - marked DB.pm as deprecated and noted it will be removed by 1.0
a8db04ca 1665 - add ResultSetColumn
ef26a392 1666 - refactor ResultSet code to resolve attrs as late as possible
a8db04ca 1667 - merge prefetch attrs into join attrs
cec13963 1668 - add +select and +as attributes to ResultSet
e7cafd06 1669 - added InflateColumn::DateTime component
4c248161 1670 - refactor debugging to allow for profiling using Storage::Statistics
6aaa8ea2 1671 - removed Data::UUID from deps, made other optionals required
38e48163 1672 - modified SQLT parser to skip dupe table names
002a359a 1673 - added remove_column(s) to ResultSource/ResultSourceProxy
1674 - added add_column alias to ResultSourceProxy
bab77431 1675 - added source_name to ResultSource
1bc0b925 1676 - load_classes now uses source_name and sets it if necessary
1677 - add update_or_create_related to Relationship::Base
1678 - add find_or_new to ResultSet/ResultSetProxy and find_or_new_related
1679 to Relationship::Base
1680 - add accessors for unique constraint names and coulums to
1681 ResultSource/ResultSourceProxy
1682 - rework ResultSet::find() to search unique constraints
9387c904 1683 - CDBICompat: modify retrieve to fix column casing when ColumnCase is
1684 loaded
1685 - CDBICompat: override find_or_create to fix column casing when
1686 ColumnCase is loaded
62eb8fe8 1687 - reorganized and simplified tests
1688 - added Ordered
8046a6d1 1689 - added the ability to set on_connect_do and the various sql_maker
1690 options as part of Storage::DBI's connect_info.
002a359a 1691
0de39991 16920.06003 2006-05-19 15:37:30
9c2c91ea 1693 - make find_or_create_related check defined() instead of truth
8417f5ee 1694 - don't unnecessarily fetch rels for cascade_update
d3c946a0 1695 - don't set_columns explicitly in update_or_create; instead use
1696 update($hashref) so InflateColumn works
0823196c 1697 - fix for has_many prefetch with 0 related rows
1698 - make limit error if rows => 0
a917fb06 1699 - added memory cycle tests and a long-needed weaken call
1700
a2f6c15f 17010.06002 2006-04-20 00:42:41
2c037e6b 1702 - fix set_from_related to accept undef
bd054cb4 1703 - fix to Dumper-induced hash iteration bug
83419ec6 1704 - fix to copy() with non-composed resultsource
765f5b7b 1705 - fix to ->search without args to clone rs but maintain cache
a32e8402 1706 - grab $self->dbh once per function in Storage::DBI
428c2b82 1707 - nuke ResultSource caching of ->resultset for consistency reasons
16b4fd26 1708 - fix for -and conditions when updating or deleting on a ResultSet
1709
d56d8619 17100.06001
6346a152 1711 - Added fix for quoting with single table
182fee36 1712 - Substantial fixes and improvements to deploy
1713 - slice now uses search directly
1714 - fixes for update() on resultset
1715 - bugfix to Cursor to avoid error during DESTROY
986e4fca 1716 - transaction DBI operations now in debug trace output
6346a152 1717
41741748 17180.06000 2006-03-25 18:03:46
eaefb953 1719 - Lots of documentation improvements
1720 - Minor tweak to related_resultset to prevent it storing a searched rs
8fcf21b3 1721 - Fixup to columns_info_for when database returns type(size)
eeb34228 1722 - Made do_txn respect void context (on the off-chance somebody cares)
5bd6785c 1723 - Fix exception text for nonexistent key in ResultSet::find()
8fcf21b3 1724
41741748 17250.05999_04 2006-03-18 19:20:49
7ed3d6dc 1726 - Fix for delete on full-table resultsets
936332ea 1727 - Removed caching on count() and added _count for pager()
3ec067db 1728 - ->connection does nothing if ->storage defined and no args
1729 (and hence ->connect acts like ->clone under the same conditions)
1730 - Storage::DBI throws better exception if no connect info
1731 - columns_info_for made more robust / informative
1346e22d 1732 - ithreads compat added, fork compat improved
bcd26419 1733 - weaken result_source in all resultsets
bd93520f 1734 - Make pg seq extractor less sensitive.
3b44ccc6 1735
c42d8358 17360.05999_03 2006-03-14 01:58:10
1737 - has_many prefetch fixes
85dea9a9 1738 - deploy now adds drop statements before creates
f109ee4a 1739 - deploy outputs debugging statements if DBIX_CLASS_STORAGE_DBI_DEBUG
1740 is set
85dea9a9 1741
f109ee4a 17420.05999_02 2006-03-10 13:31:37
e9100ff7 1743 - remove test dep on YAML
1744 - additional speed tweaks for C3
e535069e 1745 - allow scalarefs passed to order_by to go straight through to SQL
9b465d00 1746 - renamed insert_or_update to update_or_insert (with compat alias)
f43b2744 1747 - hidden lots of packages from the PAUSE Indexer
561bd5f6 1748
17490.05999_01 2006-03-09 18:31:44
5e8b1b2a 1750 - renamed cols attribute to columns (cols still supported)
1751 - added has_column_loaded to Row
90ec6cad 1752 - Storage::DBI connect_info supports coderef returning dbh as 1st arg
aa972396 1753 - load_components() doesn't prepend base when comp. prefixed with +
074a366d 1754 - $schema->deploy
1755 - HAVING support
1756 - prefetch for has_many
eaefb953 1757 - cache attr for resultsets
074a366d 1758 - PK::Auto::* no longer required since Storage::DBI::* handle auto-inc
0e35aa05 1759 - minor tweak to tests for join edge case
1760 - added cascade_copy relationship attribute
1761 (sponsored by Airspace Software, http://www.airspace.co.uk/)
1762 - clean up set_from_related
1763 - made copy() automatically null out auto-inc columns
62cb84ec 1764 - added txn_do() method to Schema, which allows a coderef to be
1765 executed atomically
70ecd5a1 1766
975c65b5 17670.05007 2006-02-24 00:59:00
971c0085 1768 - tweak to Componentised for Class::C3 0.11
1769 - fixes for auto-inc under MSSQL
1770
f8d97a01 17710.05006 2006-02-17 15:32:40
1772 - storage fix for fork() and workaround for Apache::DBI
fc27a867 1773 - made update(\%hash) work on row as well as rs
d3231653 1774 - another fix for count with scalar group_by
1775 - remove dependency on Module::Find in 40resultsetmanager.t (RT #17598)
4834d8ac 1776
d0bb3812 17770.05005 2006-02-13 21:24:51
1778 - remove build dependency on version.pm
1779
dec2517f 17800.05004 2006-02-13 20:59:00
002a359a 1781 - allow specification of related columns via cols attr when primary
f3b05bad 1782 keys of the related table are not fetched
1783 - fix count for group_by as scalar
f66596f9 1784 - add horrific fix to make Oracle's retarded limit syntax work
3b24f6ea 1785 - remove Carp require
60283c2e 1786 - changed UUIDColumns to use new UUIDMaker classes for uuid creation
1787 using whatever module may be available
f66596f9 1788
85b4a1c5 17890.05003 2006-02-08 17:50:20
1790 - add component_class accessors and use them for *_class
1791 - small fixes to Serialize and ResultSetManager
85b4a1c5 1792 - rollback on disconnect, and disconnect on DESTROY
85b4a1c5 1793
cc6504dc 17940.05002 2006-02-06 12:12:03
1795 - Added recommends for Class::Inspector
fac560c2 1796 - Added skip_all to t/40resultsetmanager.t if no Class::Inspector
1797 available
cc6504dc 1798
17990.05001 2006-02-05 15:28:10
6ee299bf 1800 - debug output now prints NULL for undef params
887ce227 1801 - multi-step prefetch along the same rel (e.g. for trees) now works
489709af 1802 - added multi-join (join => [ 'foo', 'foo' ]), aliases second to foo_2
5ec6bc2e 1803 - hack PK::Auto::Pg for "table" names referencing a schema
1804 - find() with attributes works
5ac6a044 1805 - added experimental Serialize and ResultSetManager components
19345968 1806 - added code attribute recording to DBIx::Class
5ac6a044 1807 - fix to find() for complex resultsets
1808 - added of $storage->debugcb(sub { ... })
1809 - added $source->resultset_attributes accessor
1810 - added include_columns rs attr
1811
fc69fea6 18120.05000 2006-02-01 16:48:30
1813 - assorted doc fixes
602afcfa 1814 - remove ObjectCache, not yet working in 0.05
1815 - let many_to_many rels have attrs
1816 - fix ID method in PK.pm to be saner for new internals
132f3b89 1817 - fix t/30dbicplain.t to use ::Schema instead of
1818 Catalyst::Model::DBIC::Plain
cd67f809 1819
7a1fe534 18200.04999_06 2006-01-28 21:20:32
de5e2fe9 1821 - fix Storage/DBI (tried to load deprecated ::Exception component)
1822
18230.04999_05 2006-01-28 20:13:52
00018e9d 1824 - count will now work for grouped resultsets
1825 - added accessor => option to column_info to specify accessor name
a37a4697 1826 - added $schema->populate to load test data (similar to AR fixtures)
5e8b1b2a 1827 - removed cdbi-t dependencies, only run tests if installed
1828 - Removed DBIx::Class::Exception
1829 - unified throw_exception stuff, using Carp::Clan
1830 - report query when sth generation fails.
a14d1055 1831 - multi-step prefetch!
1832 - inheritance fixes
1833 - test tweaks
1834
09aeebca 18350.04999_04 2006-01-24 21:48:21
1836 - more documentation improvements
fac560c2 1837 - add columns_info_for for vendor-specific column info (Zbigniew
1838 Lukasiak)
1839 - add SQL::Translator::Producer for DBIx::Class table classes (Jess
1840 Robinson)
09aeebca 1841 - add unique constraint declaration (Daniel Westermann-Clark)
1842 - add new update_or_create method (Daniel Westermann-Clark)
e46a66f2 1843 - rename ResultSetInstance class to ResultSetProxy, ResultSourceInstance
1844 to ResultSourceProxy, and TableInstance to ResultSourceProxy::Table
09aeebca 1845 - minor fixes to UUIDColumns
6565b410 1846 - add debugfh method and ENV magic for tracing SQL (Nigel Metheringham)
09aeebca 1847
151fc9ad 18480.04999_03 2006-01-20 06:05:27
09aeebca 1849 - imported Jess Robinson's SQL::Translator::Parser::DBIx::Class
fac560c2 1850 - lots of internals cleanup to eliminate result_source_instance
1851 requirement
8bfc3d48 1852 - added register_column and register_relationship class APIs
1853 - made Storage::DBI use prepare_cached safely (thanks to Tim Bunce)
1854 - many documentation improvements (thanks guys!)
fac560c2 1855 - added ->connection, ->connect, ->register_source and ->clone schema
1856 methods
5e8b1b2a 1857 - Use croak instead of die for user errors.
8bfc3d48 1858
9ce9ec10 18590.04999_02 2006-01-14 07:17:35
1860 - Schema is now self-contained; no requirement for co-operation
1861 - add_relationship, relationships, relationship_info, has_relationship
1862 - relationship handling on ResultSource
1863 - all table handling now in Table.pm / ResultSource.pm
475978db 1864 - added GROUP BY and DISTINCT support
1865 - hacked around SQL::Abstract::Limit some more in DBIC::SQL::Abstract
1866 (this may have fixed complex quoting)
1867 - moved inflation to inflate_result in Row.pm
1868 - added $rs->search_related
1869 - split compose_namespace out of compose_connection in Schema
fea3d045 1870 - ResultSet now handles find
1871 - various *_related methods are now ->search_related->*
1872 - added new_result to ResultSet
475978db 1873
82b1cd1f 18740.04999_01 2005-12-27 03:33:42
1875 - search and related methods moved to ResultSet
1876 - select and as added to ResultSet attrs
1877 - added DBIx::Class::Table and TableInstance for table-per-class
1878 - added DBIx::Class::ResultSetInstance which handles proxying
1879 search etc. as a superclass of DBIx::Class::DB
1880 - assorted test and code cleanup work
1881
de5d1955 18820.04001 2005-12-13 22:00:00
47bd0267 1883 - Fix so set_inflated_column calls set_column
de5d1955 1884 - Syntax errors in relationship classes are now reported
c2074366 1885 - Better error detection in set_primary_key and columns methods
1886 - Documentation improvements
1887 - Better transaction support with txn_* methods
1888 - belongs_to now works when $cond is a string
1889 - PK::Auto::Pg updated, only tries primary keys instead of all cols
47bd0267 1890
18910.04 2005-11-26
484c9dda 1892 - Moved get_simple and set_simple into AccessorGroup
1893 - Made 'new' die if given invalid columns
103647d5 1894 - Added has_column and column_info to Table.pm
1895 - Refactored away from direct use of _columns and _primaries
47bd0267 1896 - Switched from NEXT to Class::C3
484c9dda 1897
2441e56f 18980.03004
1899 - Added an || '' to the CDBICompat stringify to avoid null warnings
5e8b1b2a 1900 - Updated name section for manual pods
3b44ccc6 19010.03003 2005-11-03 17:00:00
1902 - POD fixes.
1903 - Changed use to require in Relationship/Base to avoid import.
1904
19050.03002 2005-10-20 22:35:00
1906 - Minor bugfix to new (Row.pm)
1907 - Schema doesn't die if it can't load a class (Schema.pm)
1908 - New UUID columns plugin (UUIDColumns.pm)
1909 - Documentation improvements.
1910
19110.03001 2005-09-23 14:00:00
1912 - Fixes to relationship helpers
1913 - IMPORTANT: prefetch/schema combination bug fix
1914
19150.03 2005-09-19 19:35:00
1916 - Paging support
1917 - Join support on search
1918 - Prefetch support on search
1919
19200.02 2005-08-12 18:00:00
1921 - Test fixes.
1922 - Performance improvements.
1923 - Oracle primary key support.
1924 - MS-SQL primary key support.
1925 - SQL::Abstract::Limit integration for database-agnostic limiting.
1926
19270.01 2005-08-08 17:10:00
1928 - initial release
fac560c2 1929