forked from Perl5/DBIx-Class
/
Changes
1268 lines (1174 loc) · 63.4 KB
/
Changes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
Revision history for DBIx::Class
* New Features / Changes
- Extend 'proxy' relationship attribute
- Use DBIx::Class::Storage::Debug::PrettyPrint when the
environment variable DBIC_TRACE_PROFILE is set, see
DBIx::Class::Storage for more information
- Implemented add_unique_constraints() which delegates to
add_unique_constraint() as appropriate
- add_unique_constraint() now poparly throws if called with
multiple constraint definitions
- No longer depend on SQL::Abstract::Limit - DBIC has been doing
most of the heavy lifting for a while anyway
- FilterColumn now passes data through when transformations
are not specified rather than throwing an exception.
- Optimized RowNum based Oracle limit-dialect (RT#61277)
- Requesting a pager on a resultset with cached entries now
throws an exception, instead of returning a 1-page object
since the amount of rows is always equal to the "pagesize"
- $rs->pager now uses a lazy count to determine the amount of
total entries only when really needed, instead of doing it
at instantiation time
- New documentation map organized by features
(DBIx::Class::Manual::Features)
* Fixes
- Fix memory leak during populate() on 5.8.x perls
- Fix result_soutrce_instance leaks on compose_namespace
- Make sure exception_action does not allow exception-hiding
due to badly-written handlers (the mechanism was never meant
to be able to suppress exceptions)
- Fixed rels ending with me breaking subqueried limit realiasing
- Fixed $rs->update/delete on resutsets constrained by an
-or condition
- Remove rogue GROUP BY on non-multiplying prefetch-induced
subqueries
- Oracle sequence detection now *really* works across schemas
(fixed some ommissions from 0.08123)
- dbicadmin now uses a /usr/bin/env shebang to work better with
perlbrew and other local perl builds
- bulk-inserts via $dbh->bind_array (void $rs->populate) now
display properly in DBIC_TRACE
- Incomplete exception thrown on relationship auto-fk-inference
failures
- Fixed distinct with order_by to not double-specify the same
column in the GROUP BY clause
- Properly support column names with symbols (e.g. single quote)
via custom accessors
- Fixed ::Schema::Versioned to work properly with quoting on
(RT#59619)
- Fixed t/54taint fails under local-lib
- Fixed SELECT ... FOR UPDATE with LIMIT regression (RT#58554)
- Fixed CDBICompat to preserve order of column-group additions,
so that test relying on the order of %{} will no longer fail
- Fixed mysterious ::Storage::DBI goto-shim failures on older
perl versions
- Non-blessed reference exceptions are now correctly preserved
when thrown from udner DBIC (e.g. from txn_do)
- No longer disconnecting database handles supplied to connect
via a coderef
- Fixed t/inflate/datetime_pg.t failures due to a low dependency
on DateTime::Format::Pg (RT#61503)
- Fix dirtyness detection on source-less objects
- Fix incorrect limit_dialect assignment on Replicated pool members
- Fix invalid sql on relationship attr order_by with prefetch
- Fix primary key sequence detection for Oracle
(first trigger instead of trigger for column)
* Misc
- Refactored capability handling in Storage::DBI, allows for
standardized capability handling wrt query/enable/disable
- Entire test suite now passes under DBIC_TRACE=1
- Makefile.PL no longer imports GetOptions() to interoperate
better with Catalyst installers
- Bumped minimum Module::Install for developers
- Bumped DBD::SQLite dependency and removed some TODO markers
from tests (RT#59565)
- Do not execute t/zzzzzzz_sqlite_deadlock.t for regular module
installs - test is prone to spontaneous blow up
- DT-related tests now require a DateTime >= 0.55 (RT#60324)
- Makefile.PL now provides a pre-parsed DBIC version to the
Opt::Dep pod generator
- t/52leaks.t now performs very aggressive leak detection in
author/smoker mode
0.08123 2010-06-12 14:46 (UTC)
* Fixes
- Make sure Oracle identifier shortener applies to auto-generated
column names, so we stay within the 30-char limit (RT#58271)
- Oracle sequence detection now works across schemas
- Fix a Storage/$dbh leak introduced by the migration to
Try::Tiny (this is *not* a Try::Tiny bug)
- Fix corner case of count with group-by over a 1:1 join column
where the selector ends up with column name clashes
- POD fixes (RT#58247)
* Misc
- Test suite default on-disk database now checks for Win32
fail-conditions even when running on other OSes
0.08122 2010-06-03 17:41 (UTC)
* New Features
- Add DBIx::Class::FilterColumn for non-ref filtering
- ::Storage::DBI now correctly preserves a parent $dbh from
terminating children, even during interpreter-global
out-of-order destruction
- dbicadmin supports an -I option with the same semantics as
perl itself
- InflateColumn::DateTime support for MSSQL via DBD::Sybase
- Millisecond precision support for MSSQL datetimes for
InflateColumn::DateTime
- Oracle-specific hierarchical query syntax support:
CONNECT BY (NOCYCLE) / START WITH / ORDER SIBLINGS BY
- Support connecting using $ENV{DBI_DSN} and $ENV{DBI_DRIVER}
- current_source_alias method on ResultSet objects to
determine the alias to use in programatically assembled
search()es (originally added in 0.08100 but unmentioned)
- Rewrite/unification of all subselecting limit emulations
(RNO, Top, RowNum) to be much more robust wrt complex joined
resultsets
- MSSQL limits now don't require nearly as many applications of
the unsafe_subselect_ok attribute, due to optimized queries
- Support for Generic Subquery limit "emulation" - awfully slow
and inefficient but works on almost any db, and is preferred
to software limit emulation
- Sybase ASE driver now uses SET ROWCOUNT where possible, and
Generic Subquery otherwise for limit support instead of always
using software limit emulation
- create_ddl_dir (and derivatives) now attempt to create the given
$ddl_dir if it does not already exist
- deployment_statements now automatically supplies the current RDBMS
version to SQLT producer_args for MySQL, Pg, SQLite and Oracle
* Fixes
- Fix nasty potentially data-eating bug when deleting/updating
a limited resultset
- Fix find() to use result_class set on object
- Fix result_class setter behaviour to not mistakenly stuff attrs.
- Don't try and ensure_class_loaded an object. This doesn't work.
- Fix as_subselect_rs to not inject resultset class-wide where
conditions outside of the resulting subquery
- Fix count() failing with {for} resultset attribute (RT#56257)
- Fixed incorrect detection of Limit dialect on unconnected $schema
- update() on row not in_storage no longer throws an exception
if there are no dirty columns to update (fixes cascaded update
annoyances)
- update()/delete() on prefetching resultsets no longer results
in malformed SQL (some $rs attributes were erroneously left in)
- Fix dbicadmin to allow deploy() on non-versioned schema
- Fix dbicadmin to respect sql_dir on upgrade() (RT#57732)
- Update Schema::Versioned to respect hashref style of
connection_info
- Do not recreate the same related object twice during MultiCreate
(solves the problem of orphaned IC::FS files)
- Fully qualify xp_msver selector when using DBD::Sybase with
MSSQL (RT#57467)
- Fix ::DBI::Storage to always be able to present a full set of
connect() attributes to e.g. Schema::Versioned
- Fix Oracle auto-inc trigger detection of "INSERT OR UPDATE"-type
triggers
* Misc
- Reformatted Changelog \o/
- DBIC goes git://git.shadowcat.co.uk/dbsrgits/DBIx-Class.git
- Allow developers to skip optional dependency forcing when working
from a checkout
- Add a warning to load_namespaces if a class in ResultSet/ is not
a subclass of DBIx::Class::ResultSet
- All DBIC exception-handling switched to Try::Tiny
- All DBIC modules are now free of imports via namespace::clean
- Depend on optimized SQL::Abstract (faster SQL generation)
- Depend on new Class::Accessor::Grouped reintroducing optional use
of Class::XSAccessor (just install C::XSA and get lightning fast
column accessors)
0.08121 2010-04-11 18:43:00 (UTC)
- Support for Firebird RDBMS with DBD::InterBase and ODBC
- Add core support for INSERT RETURNING (for storages that
supports this syntax, currently PostgreSQL and Firebird)
- Fix spurious warnings on multiple UTF8Columns component loads
- DBIx::Class::UTF8Columns entered deprecated state
- DBIx::Class::InflateColumn::File entered deprecated state
- DBIx::Class::Optional::Dependencies left experimental state
- Add req_group_list to Opt::Deps (RT#55211)
- Add support for mysql-specific STRAIGHT_JOIN (RT#55579)
- Cascading delete/update are now wrapped in a transaction
for atomicity
- Fix accidental autovivification of ENV vars
- Fix update_all and delete_all to be wrapped in a transaction
- Fix multiple deficiencies when using MultiCreate with
data-encoder components (e.g. ::EncodedColumn)
- Fix regression where SQL files with comments were not
handled properly by ::Schema::Versioned.
- Fix regression on not properly throwing when $obj->relationship
is unresolvable
- Fix the join-optimiser to consider unqualified column names
whenever possible
- Fix an issue with multiple same-table joins confusing the join
optimizier
- Add has_relationship method to row objects
- Fix regression in set_column on PK-less objects
- Better error text on malformed/missing relationships
- Add POD about the significance of PK columns
- Fix for SQLite to ignore the (unsupported) { for => ... }
attribute
- Fix ambiguity in default directory handling of create_ddl_dir
(RT#54063)
- Support add_columns('+colname' => { ... }) to augment column
definitions.
0.08120 2010-02-24 08:58:00 (UTC)
- Make sure possibly overwritten deployment_statements methods in
schemas get called on $schema->deploy
- Fix count() with group_by aliased-function resultsets
- with_deferred_fk_checks() Oracle support
- Massive refactor and cleanup of primary key handling
- Fixed regression losing custom result_class (really this time)
(RT#54697)
- Fixed regression in DBIC SQLT::Parser failing with a classname
(as opposed to a schema object)
- Changes to Storage::DBI::Oracle to accomodate changes in latest
SQL::Translator (quote handling)
- Make sure deployment_statements is per-storage overridable
- Fix dbicadmin's (lack of) POD
0.08119 2010-02-15 09:36:00 (UTC)
- Add $rs->is_ordered to test for existing order_by on a resultset
- Add as_subselect_rs to DBIC::ResultSet from
DBIC::Helper::ResultSet::VirtualView::as_virtual_view
- Refactor dbicadmin adding DDL manipulation capabilities
- New optional dependency manager to aid extension writers
- Depend on newest bugfixed Moose
- Make resultset chaining consistent wrt selection specification
- Storage::DBI::Replicated cleanup
- Fix autoinc PKs without an autoinc flag on Sybase ASA
0.08118 2010-02-08 11:53:00 (UTC)
- Fix a bug causing UTF8 columns not to be decoded (RT#54395)
- Fix bug in One->Many->One prefetch-collapse handling (RT#54039)
- Cleanup handling of relationship accessor types
0.08117 2010-02-05 17:10:00 (UTC)
- Perl 5.8.1 is now the minimum supported version
- Massive optimization of the join resolution code - now joins
will be removed from the resulting SQL if DBIC can prove they
are not referenced by anything
- Subqueries no longer marked experimental
- Support for Informix RDBMS (limit/offset and auto-inc columns)
- Support for Sybase SQLAnywhere, both native and via ODBC
- might_have/has_one now warn if applied calling class's column
has is_nullable set to true.
- Fixed regression in deploy() with a {sources} table limit applied
(RT#52812)
- Views without a view_definition will throw an exception when
parsed by SQL::Translator::Parser::DBIx::Class
- Stop the SQLT parser from auto-adding indexes identical to the
Primary Key
- InflateColumn::DateTime refactoring to allow fine grained method
overloads
- Fix ResultSetColumn improperly selecting more than the requested
column when +columns/+select is present
- Fix failure when update/delete of resultsets with complex WHERE
SQLA structures
- Fix regression in context sensitiveness of deployment_statements
- Fix regression resulting in overcomplicated query on
search_related from prefetching resultsets
- Fix regression on all-null returning searches (properly switch
LEFT JOIN to JOIN in order to distinguish between both cases)
- Fix regression in groupedresultset count() used on strict-mode
MySQL connections
- Better isolation of RNO-limited queries from the rest of a
prefetching resultset
- New MSSQL specific resultset attribute to allow hacky ordered
subquery support
- Fix nasty schema/dbhandle leak due to SQL::Translator
- Initial implementation of a mechanism for Schema::Version to
apply multiple step upgrades
- Fix regression on externally supplied $dbh with AutoCommit=0
- FAQ "Custom methods in Result classes"
- Cookbook POD fix for add_drop_table instead of add_drop_tables
- Schema POD improvement for dclone
0.08115 2009-12-10 09:02:00 (CST)
- Real limit/offset support for MSSQL server (via Row_Number)
- Fix distinct => 1 with non-selecting order_by (the columns
in order_by also need to be aded to the resulting group_by)
- Do not attempt to deploy FK constraints pointing to a View
- Fix count/objects from search_related on limited resultset
- Stop propagating distinct => 1 over search_related chains
- Make sure populate() inherits the resultset conditions just
like create() does
- Make get_inflated_columns behave identically to get_columns
wrt +select/+as (RT#46953)
- Fix problems with scalarrefs under InflateColumn (RT#51559)
- Throw exception on delete/update of PK-less resultsets
- Refactored Sybase storage driver into a central ::DBI::Sybase
dispatcher, and a sybase-specific ::DBI::Sybase::ASE
- Fixed an atrocious DBD::ADO bind-value bug
- Cookbook/Intro POD improvements
0.08114 2009-11-14 17:45:00 (UTC)
- Preliminary support for MSSQL via DBD::ADO
- Fix botched 0.08113 release (invalid tarball)
0.08113 2009-11-13 23:13:00 (UTC)
- Fix populate with has_many bug
(RT #50828)
- Fix Oracle autoincrement broken for Resultsets with scalar refs
(RT #50874)
- Complete Sybase RDBMS support including:
- Support for TEXT/IMAGE columns
- Support for the 'money' datatype
- Transaction savepoints support
- DateTime inflation support
- Support for bind variables when connecting to a newer Sybase with
OpenClient libraries
- Support for connections via FreeTDS with CASTs for bind variables
when needed
- Support for interpolated variables with proper quoting when
connecting to an older Sybase and/or via FreeTDS
- bulk API support for populate()
- Transaction support for MSSQL via DBD::Sybase
- Add is_paged method to DBIx::Class::ResultSet so that we can
check that if we want a pager
- Skip versioning test on really old perls lacking Time::HiRes
(RT #50209)
- Fixed on_connect_do/call regression when used with a coderef
connector (RT #50003)
- A couple of fixes to Ordered to remedy subclassing issues
- Fixed another lingering problem with PostgreSQL
auto-increment support and its interaction with multiple
schemas
- Remove some IN workarounds, and require a recent version of
SQLA instead
- Improvements to populate's handling of mixed scalarref values
- Fixed regression losing result_class after $rs->find (introduced
in 0.08108)
- Fix in_storage() to return 1|0 as per existing documentation
- Centralize handling of _determine_driver calls prior to certain
::Storage::DBI methods
- Fix update/delete arbitrary condition handling (RT#51409)
- POD improvements
0.08112 2009-09-21 10:57:00 (UTC)
- Remove the recommends from Makefile.PL, DBIx::Class is not
supposed to have optional dependencies. ever.
- Mangle the DBIx/Class.pm POD to be more clear about
copyright and license
- Put back PG's multiple autoinc per table support, accidentally
dropped during the serial-autodetection rewrite
- Make sure ResultSetColumn does not depend on the (undefined)
return value of ->cursor->reset()
- Add single() to ResultSetColumn (same semantics as ResultSet)
- Make sure to turn off IDENTITY_INSERT after insert() on MSSQL
tables that needed it
- More informative exception on failing _resolve_relationship
- Allow undef/NULL as the sole grouping value in Ordered
- Fix unreported rollback exceptions in TxnScopeGuard
- Fix overly-eager left-join chain enforcing code
- Warn about using distinct with an existing group_by
- Warn about attempting to $rs->get_column a non-unique column
when has_many joins are added to resultset
- Refactor of the exception handling system (now everything is a
DBIx::Class::Exception object)
0.08111 2009-09-06 21:58:00 (UTC)
- The hashref to connection_info now accepts a 'dbh_maker'
coderef, allowing better intergration with Catalyst
- Fixed a complex prefetch + regular join regression introduced
in 0.08108
- Fixed insert_bulk rebless handling
- Fixed Storable roundtrip regression, and general serialization
cleanup
- SQLT related fixes:
- sqlt_type is now called on the correct storage object
- hooks can now see the correct producer_type (RT#47891)
- optional SQLT requirements for e.g. deploy() bumped to 0.11002
- Really fixed (and greatly cleaned up) postgresql autoinc sequence
autodetection
- Automatically detect MySQL v3 and use INNER JOIN instead of JOIN
- POD improvements (including RT#48769)
- Test suite tweaks (including fixes for recent CPANTS fails)
- Better support for MSSQL IDENTITY_INSERT ON
0.08109 2009-08-18 08:35:00 (UTC)
- Replication updates:
- Improved the replication tests so that they are more reliable
and accurate, and hopefully solve some cross platform issues.
- Bugfixes related to naming particular replicants in a
'force_pool' attribute.
- Lots of documentation updates, including a new Introduction.pod
file.
- Fixed the way we detect transaction to make this more reliable
and forward looking.
- Fixed some trouble with the way Moose Types are used.
- Made discard_chages/get_from_storage replication aware (they
now read from the master storage by default)
- Refactor of MSSQL storage drivers, with some new features:
- Support for placeholders for MSSQL via DBD::Sybase with proper
autodetection
- 'uniqueidentifier' support with auto newid()
- Dynamic cursor support and other MARS options for ODBC
- savepoints with auto_savepoint => 1
- Support for MSSQL 'money' type
- Support for 'smalldatetime' type used in MSSQL and Sybase for
InflateColumn::DateTime
- Support for Postgres 'timestamp without timezone' type in
InflateColumn::DateTime (RT#48389)
- Added new MySQL specific on_connect_call macro 'set_strict_mode'
(also known as make_mysql_not_suck_as_much)
- Multiple prefetch-related fixes:
- Adjust overly agressive subquery join-chain pruning
- Always preserve the outer join-chain - fixes numerous
problems with search_related chaining
- Deal with the distinct => 1 attribute properly when using
prefetch
- An extension of the select-hashref syntax, allowing labeling
SQL-side aliasing: select => [ { max => 'foo', -as => 'bar' } ]
- Massive optimization of the DBI storage layer - reduce the
amount of connected() ping-calls
- Some fixes of multi-create corner cases
- Multiple POD improvements
- Added exception when resultset is called without an argument
- Improved support for non-schema-qualified tables under
Postgres (fixed last_insert_id sequence name auto-detection)
0.08108 2009-07-05 23:15:00 (UTC)
- Fixed the has_many prefetch with limit/group deficiency -
it is now possible to select "top 5 commenters" while
prefetching all their comments
- New resultsed method count_rs, returns a ::ResultSetColumn
which in turn returns a single count value
- Even better support of count with limit
- New on_connect_call/on_disconnect_call functionality (check
POD of Storage::DBI)
- Automatic datetime handling environment/session setup for
Oracle via connect_call_datetime_setup()
- count/all on related left-joined empty resultsets now correctly
returns 0/()
- Fixed regression when both page and offset are specified on
a resultset
- Fixed HRI returning too many empty results on multilevel
nonexisting prefetch
- make_column_dirty() now overwrites the deflated value with an
inflated one if such exists
- Fixed set_$rel with where restriction deleting rows outside
the restriction
- populate() returns the created objects or an arrayref of the
created objects depending on scalar vs. list context
- Fixed find_related on 'single' relationships - the former
implementation would overspecify the WHERE condition, reporting
no related objects when there in fact is one
- SQL::Translator::Parser::DBIx::Class now attaches tables to the
central schema object in relationship dependency order
- Fixed regression in set_column() preventing sourceless object
manipulations
- Fixed a bug in search_related doubling a join if the original
$rs already joins/prefetches the same relation
- Storage::DBI::connected() improvements for Oracle and Sybase
- Fixed prefetch+incomplete select regression introduced in
0.08100
- MSSQL limit (TOP emulation) fixes and improvements
0.08107 2009-06-14 08:21:00 (UTC)
- Fix serialization regression introduced in 0.08103 (affects
Cursor::Cached)
- POD fixes
- Fixed incomplete ::Replicated debug output
0.08106 2009-06-11 21:42:00 (UTC)
- Switched SQLite storage driver to DateTime::Format::SQLite
(proper timezone handling)
- Fix more test problems
0.08105 2009-06-11 19:04:00 (UTC)
- Update of numeric columns now properly uses != to determine
dirtyness instead of the usual eq
- Fixes to IC::DT tests
- Fixed exception when undef_if_invalid and timezone are both set
on an invalid datetime column
0.08104 2009-06-10 13:38:00 (UTC)
- order_by now can take \[$sql, @bind] as in
order_by => { -desc => \['colA LIKE ?', 'somestring'] }
- SQL::Abstract errors are now properly croak()ed with the
correct trace
- populate() now properly reports the dataset slice in case of
an exception
- Fixed corner case when populate() erroneously falls back to
create()
- Work around braindead mysql when doing subquery counts on
resultsets containing identically named columns from several
tables
- Fixed m2m add_to_$rel to invoke find_or_create on the far
side of the relation, to avoid duplicates
- DBIC now properly handles empty inserts (invoking all default
values from the DB, normally via INSERT INTO tbl DEFAULT VALUES
- Fix find_or_new/create to stop returning random rows when
default value insert is requested (RT#28875)
- Make IC::DT extra warning state the column name too
- It is now possible to transparrently search() on columns
requiring DBI bind (i.e. PostgreSQL BLOB)
- as_query is now a Storage::DBI method, so custom cursors can
be seamlessly used
- Fix search_related regression introduced in 0.08103
0.08103 2009-05-26 19:50:00 (UTC)
- Multiple $resultset -> count/update/delete fixes. Now any
of these operations will succeed, regardless of the complexity
of $resultset. distinct, group_by, join, prefetch are all
supported with expected results
- Return value of $rs->delete is now the storage return value
and not 1 as it used to be
- don't pass SQL functions into GROUP BY
- Remove MultiDistinctEmulation.pm, effectively deprecating
{ select => { distinct => [ qw/col1 col2/ ] } }
- Change ->count code to work correctly with DISTINCT (distinct => 1)
via GROUP BY
- Removed interpolation of bind vars for as_query - placeholders
are preserved and nested query bind variables are properly
merged in the correct order
- Refactor DBIx::Class::Storage::DBI::Sybase to automatically
load a subclass, namely Microsoft_SQL_Server.pm
(similar to DBIx::Class::Storage::DBI::ODBC)
- Refactor InflateColumn::DateTime to allow components to
circumvent DateTime parsing
- Support inflation of timestamp datatype
- Support BLOB and CLOB datatypes on Oracle
- Storage::DBI::Replicated::Balancer::Random:
added master_read_weight
- Storage::DBI::Replicated: storage opts from connect_info,
connect_info merging to replicants, hashref connect_info support,
improved trace output, other bug fixes/cleanups
- distinct => 1 with prefetch now groups by all columns
- on_connect_do accepts a single string equivalent to a one
element arrayref (RT#45159)
- DB2 limit + offset now works correctly
- Sybase now supports autoinc PKs (RT#40265)
- Prefetch on joins over duplicate relations now works
correctly (RT#28451)
- "timestamp with time zone" columns (for Pg) now get inflated with a
time zone information preserved
- MSSQL Top limit-emulation improvements (GROUP BY and subquery support)
- ResultSetColumn will not lose the joins infered from a parent
resultset prefetch
0.08102 2009-04-30 08:29:00 (UTC)
- Fixed two subtle bugs when using columns or select/as
paired with a join (limited prefetch)
- Fixed breakage of cdbi tests (RT#45551)
- Some POD improvements
0.08101 2009-04-27 09:45:00 (UTC)
- Fix +select, +as, +columns and include_columns being stripped
by $rs->get_column
- move load_optional_class from DBIx::Class::Componentised to
Class::C3::Componentised, bump dependency
- register_extra_source() now *really* fixed wrt subclassing
- Added missing POD descriptions (RT#45195)
- Fix insert() to not store_column() every present object column
- Multiple Makefile.PL fixes
0.08100 2009-04-19 11:39:35 (UTC)
- Todo out the register_extra_source test until after shipping
0.08099_08 2009-03-30 00:00:00 (UTC)
- Fixed taint mode with load_namespaces
- Putting IC::DateTime locale, timezone or floating_tz_ok attributes into
extra => {} has been deprecated. The new way is to put these things
directly into the columns definition
- Switched MI code to MRO::Compat
- Document db-side default_value caveats
- Search_like() now warns to indicate deprecation in 0.09.
- TxnScopeGuard left experimental state
0.08099_07 2009-02-27 02:00:00 (UTC)
- multi-create using find_or_create rather than _related for post-insert
- fix get_inflated_columns to check has_column_loaded
- Add DBIC_MULTICREATE_DEBUG env var (undocumented, quasi-internal)
- Fix up multi-create to:
- correctly propagate columns loaded during multi-insert of rels
- not try and insert things tagged on via new_related unless required
- Possible to set locale in IC::DateTime extra => {} config
- Calling the accessor of a belongs_to when the foreign_key
was NULL and the row was not stored would unexpectedly fail
- Split sql statements for deploy only if SQLT::Producer returned a scalar
containing all statements to be executed
- Add as_query() for ResultSet and ResultSetColumn. This makes subqueries
possible. See the Cookbook for details.
- Massive rewrite of Ordered to properly handle position constraints and
to make it more matpath-friendly
- deploy_statements called ddl_filename with the $version and $dir arguments
in the wrong order.
- columns/+columns attributes now support { as => select } hahsrefs
- support for views both in DBIC and via deploy() in SQLT
0.08099_06 2009-01-23 07:30:00 (UTC)
- Allow a scalarref to be supplied to the 'from' resultset attribute
- Classes submitted as result_class for a resultsource are now
automatically loaded via ensure_loaded()
- 'result_class' resultset attribute, identical to result_class()
- add 'undef_on_null_fk' option for relationship accessors of type 'single'.
This will prevent DBIC from querying the database if one or more of
the key columns IS NULL
- for 'belongs_to' rels, 'undef_on_null_fk' defaults to true.
- fixed scope unaware last_insert_id fetching for MSSQL
(http://msdn.microsoft.com/en-us/library/ms190315.aspx)
- an sqlt_deploy_hook can now be shared between result sources using
a configurable callback trigger
- new order_by => { -desc => 'colname' } syntax supported
- PG array datatype supported
- insert should use store_column, not set_column to avoid marking
clean just-stored values as dirty. New test for this
- regression test for source_name
0.08099_05 2008-10-30 21:30:00 (UTC)
- Rewrite of Storage::DBI::connect_info(), extended with an
additional argument format type
- InflateColumn::DateTime: add warning about floating timezone
- InflateColumn::DateTime: possible to enforce/skip inflation
- delete throws exception if passed arguments to prevent drunken mishaps.
- Fix storage to copy scalar conds before regexping to avoid
trying to modify a constant in odd edge cases
- Related resultsets on uninserted objects are now empty
- Fixed up related resultsets and multi-create
- Fixed superfluous connection in ODBC::_rebless
- Fixed undef PK for first insert in ODBC::Microsoft_SQL_Server
- Added virtual method to Versioned so a user can create upgrade
path across multiple versions (jgoulah)
- Better (and marginally faster) implementation of the HashRefInflator
hash construction algorithm
- Allow explicit specification of ON DELETE/ON UPDATE constraints
when using the SQLT parser
0.08099_04 2008-07-24 01:00:00
- Functionality to storage to enable a sub to be run without FK checks
- Fixed $schema->clone bug which caused clone and source to share
internal hash refs
- Added register_extra_source methods for additional sources
- Added datetime_undef_if_invalid for InflateColumn::DateTime to
return undef on invalid date/time values
- Added search_related_rs method to ResultSet
- add a make_column_dirty method to Row to force updates
- throw a clear exception when user tries multi-has_many prefetch
- SQLT parser prefixes index names with ${table}_idx_ to avoid clashes
- mark ResultSetManager as deprecated and undocument it
- pod fix (RT #32988)
- add Test::Exception to test requirements (RT #34256)
- make ash's build_requires/META.yml fixes work better
- is_deferable support on relations used by the SQL::Translator
parser
- Refactored DBIx::Class::Schema::Versioned
- Syntax errors from resultset components are now reported correctly
- sqltargs respected correctly in deploy et al.
- Added support for savepoints, and using them automatically in
nested transactions if auto_savepoint is set in connect_info.
- Changed naming scheme for constraints and keys in the sqlt parser;
names should now be consistent and collision-free.
- Improve handling of explicit key attr in ResultSet::find
- Add warnings for non-unique ResultSet::find queries
- Changed Storage::DBI::Replication to Storage::DBI::Replicated and
refactored support.
- By default now deploy/diff et al. will ignore constraint and index
names
- Add ResultSet::_is_deterministic_value, make new_result filter the
values passed to new to drop values that would generate invalid SQL.
- Use Sub::Name to name closures before installing them. Fixes
incompatibility with Moose method modifiers on generated methods.
0.08010 2008-03-01 10:30
- Fix t/94versioning.t so it passes with latest SQL::Translator
0.08009 2008-01-20 13:30
- Made search_rs smarter about when to preserve the cache to fix
mm prefetch usage
- Added Storage::DBI subclass for MSSQL over ODBC.
- Added freeze, thaw and dclone methods to Schema so that thawed
objects will get re-attached to the schema.
- Moved dbicadmin to JSON::Any wrapped JSON.pm for a sane API
(also fixes RT #32393)
- introduced DBIx::Class::set_inflated_columns
- DBIx::Class::Row::copy uses set_inflated_columns
0.08008 2007-11-16 14:30:00
- Fixed join merging bug (test from Zby)
- When adding relationships, it will throw an exception if you get the
foreign and self parts the wrong way round in the condition
- ResultSetColumn::func() now returns all results if called in list
context; this makes things like func('DISTINCT') work as expected
- Many-to-many relationships now warn if the utility methods would
clash
- InflateColumn::DateTime now accepts an extra parameter of timezone
to set timezone on the DT object (thanks Sergio Salvi)
- Added sqlt_deploy_hook to result classes so that indexes can be
added.
- Added startup checks to warn loudly if we appear to be running on
RedHat systems from perl-5.8.8-10 and up that have the bless/overload
patch applied (badly) which causes 2x -> 100x performance penalty.
(Jon Schutz)
- ResultSource::reverse_relationship_info can distinguish between
sources using the same table
- Row::insert will now not fall over if passed duplicate related objects
- Row::copy will not fall over if you have two relationships to the
same source with a unique constraint on it
0.08007 2007-09-04 19:36:00
- patch for Oracle datetime inflation (abram@arin.net)
- added on_disconnect_do
- on_connect_do and on_disconnect_do take coderefs and arrayrefs
0.08006 2007-08-12 15:12:00
- Move to using Class::C3::Componentised
- Remove warn statement from DBIx::Class::Row
0.08005 2007-08-06
- add timestamp fix re rt.cpan 26978 - no test yet but change
clearly should cause no regressions
- provide alias for related_resultset via local() so it's set
correctly at resultset construction time (fixes RestrictWithObject)
- fixes bind params in debug statements
(original test from abraxxa)
- fixed storage->connected fork bug
(test and fix from Radu Greab)
- add 1; to AccessorGroup.pm for stuff that still uses it
- refactor Statistics to create debugging filehandle to fix bug with
closed STDERR, update docs and modify Versioned to use Statistics
(original fix from diz)
0.08004 2007-08-06 19:00:00
- fix storage connect code to not trigger bug via auto-viv
(test from aherzog)
- fixup cursor_class to be an 'inherited' attr for per-package defaults
- add default_resultset_attributes entry to Schema
- optimisation in DBI::Cursor to check software_limit before falling
back to base Cursor->all
- fix bug with create_multi not inserting non-storage objects
(test and fix from davinchi)
- DBIx::Class::AccessorGroup made empty subclass of
Class::Accessor::Grouped
- fixed an ugly bug regarding $dbh->{AutoCommit} and transactions
- ensure_class_loaded handles non-classnames better.
- non-destructive hashref handling for connect_info options
- count no longer returns negative values after slice
(report and test from JOHANL)
- rebless before building datetime_parser
(patch from mattlaw / Matt Lawrence)
0.08003 2007-07-14 18:01:00
- improved populate bulk_insert mode
- fixed up multi_create to be more intelligent about PK<->PK rels
- fix many-many rels to not use set_columns
- Unmarked deploy as experimental since it isn't anymore
- Removed Cwd dep since it's not required and causes problems
with debian packaging
- Patch to fix ? in data for NoBindVars (from Tom Hukins)
- Restored mk_classaccessor method for compatibility
- Fixed group_by problem with oracle limit syntax
- Fixed attr merging problem
- Fixed $rs->get_column w/prefetch problem
0.08002 2007-06-20 06:10:00
- add scope guard to Row::insert to ensure rollback gets called
- more heuristics in Row::insert to try and get insert order right
- eliminate vestigial code in PK::Auto
- more expressive DBI errors
- soften errors during deploy
- ensure_connected before txn_begin to catch stomping on transaction
depth
- new method "rethrow" for our exception objects
0.08001 2007-06-17 21:21:02
- Cleaned up on_connect handling for versioned
- removed DateTime use line from multi_create test
- hid DBIx::ContextualFetch::st override in CDBICompat
0.08000 2007-06-17 18:06:12
- Fixed DBIC_TRACE debug filehandles to set ->autoflush(1)
- Fixed circular dbh<->storage in HandleError with weakref
0.07999_06 2007-06-13 04:45:00
- tweaked Row.pm to make last_insert_id take multiple column names
- Fixed DBIC::Storage::DBI::Cursor::DESTROY bug that was
messing up exception handling
- added exception objects to eliminate stacktrace/Carp::Clan
output redundancy
- setting $ENV{DBIC_TRACE} defaults stacktrace on.
- added stacktrace option to Schema, makes throw_exception
use "confess"
- make database handles use throw_exception by default
- make database handles supplied by a coderef use our
standard HandleError/RaiseError/PrintError
- add "unsafe" connect_info option to suppress our setting
of HandleError/RaiseError/PrintError
- removed several redundant evals whose sole purpose was to
provide extra debugging info
- fixed page-within-page bug (reported by nilsonsfj)
- fixed rare bug when database is disconnected inbetween
"$dbh->prepare_cached" and "$sth->execute"
0.07999_05 2007-06-07 23:00:00
- Made source_name rw in ResultSource
- Fixed up SQL::Translator test/runtime dependencies
- Fixed t/60core.t in the absence of DateTime::Format::MySQL
- Test cleanup and doc note (ribasushi)
0.07999_04 2007-06-01 14:04:00
- pulled in Replication storage from branch and marked EXPERIMENTAL
- fixup to ensure join always LEFT after first LEFT join depthwise
- converted the vendor tests to use schema objects intead of schema
classes, made cleaned more reliable with END blocks
- versioning support via DBIx::Class::Schema::Versioned
- find/next now return undef rather than () on fail from Bernhard Graf
- rewritten collapse_result to fix prefetch
- moved populate to resultset
- added support for creation of related rows via insert and populate
- transaction support more robust now in the face of varying AutoCommit
and manual txn_begin usage
- unbreak back-compat for Row/ResultSet->new_result
- Added Oracle/WhereJoins.pm for Oracle >= 8 to support
Oracle <= 9i, and provide Oracle with a better join method for
later versions. (I use the term better loosely.)
- The SQL::T parser class now respects a relationship attribute of
is_foreign_key_constrain to allow explicit control over wether or
not a foreign constraint is needed
- resultset_class/result_class now (again) auto loads the specified
class; requires Class::Accessor::Grouped 0.05002+
- added get_inflated_columns to Row
- %colinfo accessor and inflate_column now work together
- More documentation updates
- Error messages from ->deploy made more informative
- connect_info will now always return the arguments it was
originally given
- A few small efficiency improvements for load_classes
and compose_namespace
0.07006 2007-04-17 23:18:00
- Lots of documentation updates
- deploy now takes an optional 'source_names' parameter (dec)
- Quoting for for columns_info_for
- RT#25683 fixed (multiple open sths on DBD::Sybase)
- CDBI compat infers has_many from has_a (Schwern)
- Fix ddl_filename transformation (Carl Vincent)
0.07999_02 2007-01-25 20:11:00
- add support for binding BYTEA and similar parameters (w/Pg impl)
- add support to Ordered for multiple ordering columns
- mark DB.pm and compose_connection as deprecated
- switch tests to compose_namespace
- ResultClass::HashRefInflator added
- Changed row and rs objects to not have direct handle to a source,
instead a (schema,source_name) tuple of type ResultSourceHandle
0.07005 2007-01-10 18:36:00
- fixup changes file
- remove erroneous .orig files - oops
0.07004 2007-01-09 21:52:00
- fix find_related-based queries to correctly grep the unique key
- fix InflateColumn to inflate/deflate all refs but scalar refs
0.07003 2006-11-16 11:52:00
- fix for rt.cpan.org #22740 (use $^X instead of hardcoded "perl")
- Tweaks to resultset to allow inflate_result to return an array
- Fix UTF8Columns to work under Perl <= 5.8.0
- Fix up new_result in ResultSet to avoid alias-related bugs
- Made new/update/find handle 'single' rel accessor correctly
- Fix NoBindVars to be safer and handle non-true bind values
- Don't blow up if columns_info_for returns useless results
- Documentation updates
0.07999_01 2006-10-05 21:00:00
- add connect_info option "disable_statement_caching"
- create insert_bulk using execute_array, populate uses it
- added DBIx::Class::Schema::load_namespaces, alternative to
load_classes
- added source_info method for source-level metadata (kinda like
column_info)
- Some of ::Storage::DBI's code/docs moved to ::Storage
- DBIx::Class::Schema::txn_do code moved to ::Storage
- Storage::DBI now uses exceptions instead of ->ping/->{Active} checks
- Storage exceptions are thrown via the schema class's throw_exception
- DBIx::Class::Schema::throw_exception's behavior can be modified via
->exception_action
- columns_info_for is deprecated, and no longer runs automatically.
You can make it work like before via
__PACKAGE__->column_info_from_storage(1) for now
- Replaced DBIx::Class::AccessorGroup and Class::Data::Accessor with
Class::Accessor::Grouped. Only user noticible change is to
table_class on ResultSourceProxy::Table (i.e. table objects in
schemas) and, resultset_class and result_class in ResultSource.
These accessors no longer automatically require the classes when
set.
0.07002 2006-09-14 21:17:32
- fix quote tests for recent versions of SQLite
- added reference implementation of Manual::Example
- backported column_info_from_storage accessor from -current, but
- fixed inflate_datetime.t tests/stringify under older Test::More
- minor fixes for many-to-many relationship helpers
- cleared up Relationship docs, and fixed some typos
- use ref instead of eval to check limit syntax (to avoid issues with
Devel::StackTrace)
- update ResultSet::_cond_for_update_delete to handle more complicated
queries
- bugfix to Oracle columns_info_for
- remove_columns now deletes columns from _columns
0.07001 2006-08-18 19:55:00
- add directory argument to deploy()
- support default aliases in many_to_many accessors.
- support for relationship attributes in many_to_many accessors.
- stop search_rs being destructive to attrs
- better error reporting when loading components
- UTF8Columns changed to use "utf8" instead of "Encode"
- restore automatic aliasing in ResultSet::find() on nonunique queries
- allow aliases in ResultSet::find() queries (in cases of relationships
with prefetch)
- pass $attrs to find from update_or_create so a specific key can be
provided
- remove anonymous blesses to avoid major speed hit on Fedora Core 5's
Perl and possibly others; for more information see:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=196836
- fix a pathological prefetch case
- table case fix for Oracle in columns_info_for
- stopped search_rs deleting attributes from passed hash
0.07000 2006-07-23 02:30:00
- supress warnings for possibly non-unique queries, since
_is_unique_query doesn't infer properly in all cases
- skip empty queries to eliminate spurious warnings on ->deploy
- fixups to ORDER BY, tweaks to deepen some copies in ResultSet
- fixup for RowNum limit syntax with functions
0.06999_07 2006-07-12 20:58:05
- fix issue with from attr copying introduced in last release
0.06999_06 2006-07-12 17:16:55
- documentation for new storage options, fix S::A::L hanging on to $dbh
- substantial refactor of search_related code to fix alias numbering
- don't generate partial unique keys in ResultSet::find() when a table
has more than one unique constraint which share a column and only one
is satisfied
- cleanup UTF8Columns and make more efficient
- rename DBIX_CLASS_STORAGE_DBI_DEBUG to DBIC_TRACE (with compat)
- rename _parent_rs to _parent_source in ResultSet
- new FAQ.pod!
0.06999_05 2006-07-04 14:40:01
- fix issue with incorrect $rs->{attrs}{alias}
- fix subclassing issue with source_name
- tweak quotes test to output text on failure
- fix Schema->txn_do to not fail as a classmethod
0.06999_04 2006-06-29 20:18:47
- disable cdbi-t/02-Film.t warning tests under AS perl
- fixups to MySQL tests (aka "work round mysql being retarded")
- compat tweaks for Storage debug logging
0.06999_03 2006-06-26 21:04:44
- various documentation improvements
- fixes to pass test suite on Windows
- rewrote and cleaned up SQL::Translator tests
- changed relationship helpers to only call ensure_class_loaded when the
join condition is inferred
- rewrote many_to_many implementation, now provides helpers for adding
and deleting objects without dealing with the link table
- reworked InflateColumn implementation to lazily deflate where
possible; now handles passing an inflated object to new()
- changed join merging to not create a rel_2 alias when adding a join
that already exists in a parent resultset
- Storage::DBI::deployment_statements now calls ensure_connected
if it isn't passed a type
- fixed Componentized::ensure_class_loaded
- InflateColumn::DateTime supports date as well as datetime
- split Storage::DBI::MSSQL into MSSQL and Sybase::MSSQL
- fixed wrong debugging hook call in Storage::DBI
- set connect_info properly before setting any ->sql_maker things
0.06999_02 2006-06-09 23:58:33
- Fixed up POD::Coverage tests, filled in some POD holes
- Added a warning for incorrect component order in load_components
- Fixed resultset bugs to do with related searches
- added code and tests for Componentized::ensure_class_found and
load_optional_class
- NoBindVars + Sybase + MSSQL stuff
- only rebless S::DBI if it is still S::DBI and not a subclass
- Added `use' statement for DBD::Pg in Storage::DBI::Pg
- stopped test relying on order of unordered search
- bugfix for join-types in nested joins using the from attribute
- obscure prefetch problem fixed
- tightened up deep search_related
- Fixed 'DBIx/Class/DB.pm did not return a true value' error
- Revert change to test for deprecated find usage and swallow warnings
- Slight wording change to new_related() POD
- new specific test for connect_info coderefs
- POD clarification and content bugfixing + a few code formatting fixes
- POD::Coverage additions
- fixed debugfh
- Fix column_info stomping