| 1 |
Revision history for Perl extension DBIx::SearchBuilder. |
| 2 |
|
| 3 |
1.85 2026-04-14 |
| 4 |
- Use state hashref to support Perl < 5.28. Pointed out by @erempel. Thanks! |
| 5 |
|
| 6 |
1.84 2026-03-24 |
| 7 |
- Disable lazy load feature by default |
| 8 |
- Update t/00.load.t to handle "blib" too |
| 9 |
|
| 10 |
1.83 2026-03-18 |
| 11 |
- Document use of BuildSelectQuery for debugging. Inspired by @maettu |
| 12 |
in PR 4 on github. Thanks! |
| 13 |
- Add repository link to META. Pointed out by @szabgab. Thanks! |
| 14 |
- Do not fetch columns marked as lazy_load by default |
| 15 |
- Refactor _ExtractBindValues for better performance and less memory usage |
| 16 |
- Fix _ClassAccessibleFromSchema to dereference _PrimaryKeys arrayref |
| 17 |
|
| 18 |
1.82 2024-04-29 |
| 19 |
|
| 20 |
- Format reference to other docs as links |
| 21 |
- Document the possibly different encoding of returned values |
| 22 |
- Make wide character tests pass for Oracle |
| 23 |
- Test if empty strings are saved as NULL on Oracle CLOB fields |
| 24 |
- Prefer NULL instead of empty CLOBs for Oracle |
| 25 |
|
| 26 |
1.81 2024-01-18 |
| 27 |
- Add explicit support for MariaDB in addition to MySQL |
| 28 |
|
| 29 |
1.80 2023-12-13 |
| 30 |
- Add CastAsDecimal helper method |
| 31 |
|
| 32 |
1.79 2023-11-27 |
| 33 |
- Produce correct query hints |
| 34 |
|
| 35 |
1.78 2023-07-05 |
| 36 |
- Query the Count data if current page does not have any records |
| 37 |
- Require DBD::SQLite 1.60+ for combine searches |
| 38 |
|
| 39 |
1.77 2023-06-30 |
| 40 |
- Change how DistinctQueryAndCount builds query to fix sorting |
| 41 |
|
| 42 |
1.76 2023-04-20 |
| 43 |
- Call DatabaseVersion instead to make sure we already retrieved the version |
| 44 |
(this is to fix a possible uninitialized warning on disconnect) |
| 45 |
|
| 46 |
1.75 2023-04-19 |
| 47 |
- Log unsupported CombineSearchAndCount warning only once |
| 48 |
- Fix version comparison for MariaDB 10.10+ |
| 49 |
|
| 50 |
1.74 2022-12-12 |
| 51 |
- Explicitly require version to make cpantesters happy |
| 52 |
- Require perl 5.10.1+ to not support derelict versions |
| 53 |
|
| 54 |
1.73 2022-12-08 |
| 55 |
- Remove very old CVS headers from files |
| 56 |
- Standardize whitespace |
| 57 |
- Remove an unused cache parameter remaining from a previous refactor |
| 58 |
- Update a test to work around a change in numeric values returned on |
| 59 |
Postgres starting in version 14 |
| 60 |
- Fix a doc typo |
| 61 |
- Fix a bind value issue with Limit on Postgres |
| 62 |
- Disable finding count in searches for older versions of MySQL and |
| 63 |
MariaDB that don't support window functions (OVER) |
| 64 |
- Truncate values before checking for changes to fix a bug where |
| 65 |
values bigger than a column would be inserted even when they were |
| 66 |
not changed |
| 67 |
|
| 68 |
1.72_01 2022-09-20 |
| 69 |
- Simplify count's internal logic to always use the "count_all" key |
| 70 |
- Fix Count method to always returns count in selected page |
| 71 |
- Support search and count in same query |
| 72 |
- Redo search only if ORDER/GROUP BY is really updated |
| 73 |
- Add bind values support for LIMIT clauses |
| 74 |
|
| 75 |
1.71 2021-09-24 |
| 76 |
- Add dot to load utils in tests for perl 5.26+ |
| 77 |
|
| 78 |
1.70 2021-09-24 |
| 79 |
- Enable queries processed with BuildSelectQuery and BuildSelectCountQuery |
| 80 |
to use bind variables |
| 81 |
|
| 82 |
1.69 2021-01-20 |
| 83 |
|
| 84 |
- New option to quote tablenames in queries, enabled automatically for MySQL 8 |
| 85 |
- Updated tests for new MySQL 8 reserved words and tablename quoting |
| 86 |
|
| 87 |
1.68 2020-07-06 |
| 88 |
- Avoid segmentation faults on disconnect on MariaDB 10.2+ |
| 89 |
|
| 90 |
1.67 |
| 91 |
- Add ->QueryHint and ->QueryHintFormatted to collection API for Oracle |
| 92 |
|
| 93 |
1.66 |
| 94 |
- No changes since 1.65_02 |
| 95 |
|
| 96 |
1.65_02 |
| 97 |
- Stop unilaterally disabling the "UTF8" flag before executing queries |
| 98 |
- Make ->Fields case-sensitive in the column names it returns, as well |
| 99 |
as in the table name it takes. |
| 100 |
|
| 101 |
1.65_01 |
| 102 |
- Make ->Fields only lookup information on the table requested, not all |
| 103 |
fields, for performance. It also is now case-sensitive in table name. |
| 104 |
- Omit calls to ->Fields entirely for PostgreSQL 9.1 and above |
| 105 |
|
| 106 |
1.65 2013-07-03 |
| 107 |
- Bug fix for DateTimeInterval extraction on Pg |
| 108 |
|
| 109 |
1.64 2013-07-01 |
| 110 |
- No changes since 1.63_03. Simply a non-dev release of everything since |
| 111 |
1.63. |
| 112 |
|
| 113 |
1.63_03 2013-06-14 |
| 114 |
- warn when rollback and commit are mixed |
| 115 |
- Handle->NullsOrder |
| 116 |
- skip timezone tests on SQLite when tzinfo is not there |
| 117 |
- skip tests if mysql can not do timezones |
| 118 |
- DISTINCT argument in Join method |
| 119 |
- DISTINCT argument in Join and NewAlias |
| 120 |
- Reset the iterator position whenever a search is run |
| 121 |
- Return the correct record from ->Last instead of the first record |
| 122 |
- Document the caveat of using GotoItem with a non-zero N |
| 123 |
|
| 124 |
1.63_02 2013-04-17 |
| 125 |
- _Set now can take undef as argument to mean default or NULL. Still may |
| 126 |
result in error if default is not defined and no_nulls is true for the |
| 127 |
column. If old behaviour is required set $record->{'no_undefs_in_set'} |
| 128 |
to true value. |
| 129 |
- FUNCTION argument is now allowed in Limit. Code to combine FUNCTION, |
| 130 |
ALIAS and FIELD was refactored and unified in one place - |
| 131 |
CombineFunctionWithField method. Used in Column, GroupBy and Limit. This |
| 132 |
change should be backwards compatible. |
| 133 |
- Handle->DateTimeIntervalFunction |
| 134 |
|
| 135 |
1.63_01 2013-03-27 |
| 136 |
- IN and NOT IN operators in ->Limit method |
| 137 |
- Add an AdditionalColumn method to collections |
| 138 |
- Add an AS parameter to Column method in collections |
| 139 |
- Consistent query generation by sorting hash keys/values |
| 140 |
|
| 141 |
1.63 2012-09-14 |
| 142 |
- joins_are_distinct hint to indicate that distinct is not required for |
| 143 |
the current set of joins. |
| 144 |
|
| 145 |
1.62 2012-03-26 |
| 146 |
- Bind values were ignored in SimpleUpdateFromSelect |
| 147 |
|
| 148 |
1.61 2011-09-16 |
| 149 |
- New methods in Handle for mass changes from select statements: |
| 150 |
InsertFromSelect, DeleteFromSelect and SimpleUpdateFromSelect |
| 151 |
- New methods in Handle for generation of date time related SQL |
| 152 |
|
| 153 |
1.60 2011-09-15 |
| 154 |
- custom BuildDSN for Oracle |
| 155 |
- Database is treated as SID if SID is not provided |
| 156 |
- Build 'dbi:Oracle:<SID>' instead of 'dbi:Oracle:sid=<SID>' |
| 157 |
- changes in DBIx::SearchBuilder->Column method |
| 158 |
- complete documentation |
| 159 |
- support for empty FIELD argument |
| 160 |
- column naming fix when explicit ALIAS => 'main' passed |
| 161 |
|
| 162 |
1.59 2010-11-19 |
| 163 |
- DBIx::SearchBuilder->DistinctFieldValues method |
| 164 |
|
| 165 |
1.58 2010-10-20 |
| 166 |
- SIGNATURE fix |
| 167 |
- delete obsolete cvs metadata from a module |
| 168 |
|
| 169 |
1.57 2010-09-04 |
| 170 |
- INCOMPATIBLE CHANGE: NextPage and PrevPage were adding rows from the |
| 171 |
previous page. Jesse claims that when he wrote this code, he was 20 |
| 172 |
years old and it seemed like a good idea at the time. |
| 173 |
- When logging queries, include full stack trace |
| 174 |
- support $sb->NewAlias( 'table' => 'LEFT' ); |
| 175 |
- allow join to depend on nothing |
| 176 |
- catch cases when there are more closing parens then should be |
| 177 |
- Oracle: Use ROW_NUMBER() to propagate row ordering from inside the |
| 178 |
DISTINCT |
| 179 |
- Various performance improvements through small internal refactorings |
| 180 |
- Implemented 'sub Fields' on Oracle |
| 181 |
- unify case insensitive characters to avoid using LOWER() in some cases |
| 182 |
- We now RedoSearch when RowsPerPage is changed |
| 183 |
- No longer RedoSearch if FirstRow is called, but is not actually changed |
| 184 |
- Document all paging functions and test them |
| 185 |
- handle LOWER() in redundant LEFT joins optimizer, for Oracle and may be |
| 186 |
Pg |
| 187 |
- Make debugging problems easier by passing errors back |
| 188 |
https://rt.cpan.org/Ticket/Display.html?id=55203 |
| 189 |
- fix Record->PrimaryKeys, field names in values hash are lc'ed |
| 190 |
https://rt.cpan.org/Ticket/Display.html?id=18280 |
| 191 |
- doc updates and cleanups |
| 192 |
|
| 193 |
1.56 2009-07-17 |
| 194 |
- Don't use LOWER/ILIKE with dates, heuristic is used, but shouldn't harm |
| 195 |
other things |
| 196 |
- Don't apply DISTINCT on queries with group by, COUNT(DISTINCT x) is |
| 197 |
different and covered in Column method |
| 198 |
|
| 199 |
1.55 2009-05-07 |
| 200 |
- Put test suite SQLite databases inside of tempdirs so they get garbage |
| 201 |
collected properly. Thanks to Andreas Koenig [rt.cpan.org #41322] |
| 202 |
- Allow ->Join to pre-existing collection object |
| 203 |
- Imlement and test SB::Handle::Fields |
| 204 |
- Pg can not guaranty order in the following queries: SELECT ... FROM |
| 205 |
(SELECT... ORDER BY ...) we use them to build distinct sets with |
| 206 |
ordering by columns in joined tables. Switched to group by instead of |
| 207 |
sub-selects. |
| 208 |
|
| 209 |
1.54 2008-07-09 |
| 210 |
- When aborting transactions, we need to flush our cache, because SQLite |
| 211 |
is reusing the primary id for later inserts and the cache can otherwise |
| 212 |
become inconsistent. |
| 213 |
|
| 214 |
1.53 2008-04-02 |
| 215 |
- Fix mysql version check in DistinctQuery function |
| 216 |
- Fix order by outer column on Oracle |
| 217 |
- Improve tests |
| 218 |
|
| 219 |
1.52 2008-04-01 |
| 220 |
- Fix order by outer column on SQLite, mysql, adjust Pg. Add test that |
| 221 |
cover this. |
| 222 |
|
| 223 |
1.51 2008-01-15 |
| 224 |
- Fix CountAll method when paging is enabled and data is in memory already |
| 225 |
|
| 226 |
1.50 2007-11-23 |
| 227 |
- Oracle: Don't DISTINCT query when there is a group by clause |
| 228 |
- Fix a problem when we have more then two collections in a union and some |
| 229 |
of them are empty |
| 230 |
|
| 231 |
1.49 2007-07-07 |
| 232 |
- Fix a CPAN signature issue |
| 233 |
|
| 234 |
1.48 2007-03-11 |
| 235 |
- Fix a problem when left joins optimizer fails to calculate a boolean |
| 236 |
expression because of lower case aggregators. |
| 237 |
|
| 238 |
1.47 2007-03-04 |
| 239 |
- Do the search in unions only when we must do them, not on every call to |
| 240 |
the Next method |
| 241 |
- Don't index ex/ dir to avoid complains by the indexer of PAUSE/CPAN |
| 242 |
|
| 243 |
1.46 2007-02-25 |
| 244 |
- when doing a union, we need to actually search, rather than just doing a |
| 245 |
count |
| 246 |
- add support for testing with Oracle backend |
| 247 |
- Use CROSS JOIN instead of ',' as SQL parsers in Pg and some mysql are |
| 248 |
buggy and cannot parse "FROM X, Y JOIN Z ON Z.f = X.f" |
| 249 |
- deprecate DEBUG method, it's still there but produce warning |
| 250 |
- fix CleanSlate method that was missing several keys |
| 251 |
- fix a long standing bug we had, we didn't write depends_on data about a |
| 252 |
join, so we could build queries with incorrect parens around join |
| 253 |
conditions |
| 254 |
- fix default values for ALIAS1 argument in the Join method, istead of |
| 255 |
defaulting FIELD1 to 'main' value |
| 256 |
- fix a TODO test |
| 257 |
- internal refactoring of a storage for query's conditions, instead of |
| 258 |
building query strings right after the limit or join, we now build a |
| 259 |
perl structure |
| 260 |
- don't clone attributes that don't exists in the Clone method |
| 261 |
- we use Encode module without perl version check for a long time, so we |
| 262 |
can get rid of all checks for the version and load the module at compile |
| 263 |
time everywhere we need it |
| 264 |
- implement MayBeNull method in the handler that checks if applied |
| 265 |
conditions allow NULLs in the result set |
| 266 |
- implement cascaded LEFT JOINs optimization |
| 267 |
- additional tests for CleanSlate and Clone methods, ENTRY_AGGREGATOR |
| 268 |
argument, different types of joins and LEFT JOIN optimizer |
| 269 |
|
| 270 |
1.45 2006-09-26 |
| 271 |
- Postgres: fix "$rec->Create();" |
| 272 |
- Postgres: fix "$rec->Create( IntegerColumn => '' );" |
| 273 |
- Postgres: fix "$rec->SetIntegerColumn( '' );" |
| 274 |
- Postgres: add test |
| 275 |
- cleanup ::Record::Cachable |
| 276 |
- use cache in: $a->LoadByCols(...); $b->LoadById( $a->id ); |
| 277 |
- add cache tests |
| 278 |
|
| 279 |
1.44 2006-05-27 |
| 280 |
- DBIx::SearchBuilder::Handle::DatabaseVersion enhancements |
| 281 |
|
| 282 |
1.43 2006-04-12 |
| 283 |
- Fix to the sequence compatibility fixes. For backwards compatibility. |
| 284 |
|
| 285 |
1.42 2006-04-10 |
| 286 |
- Signatures fixed |
| 287 |
|
| 288 |
1.41 2006-04-10 |
| 289 |
- PG 8.1 sequence compatibility fixes from Daniel Tabuenca |
| 290 |
|
| 291 |
1.40 2006-03-10 |
| 292 |
- 'NOT STARTSWITH' and 'NOT ENDSWITH' |
| 293 |
|
| 294 |
1.39 2006-02-16 |
| 295 |
- Allow ORs on left joins |
| 296 |
|
| 297 |
1.38 2005-12-29 |
| 298 |
- Released 1.37 dev series |
| 299 |
|
| 300 |
1.37_01 2005-12-08 |
| 301 |
- Switched Postgres sequence lookups to use CURRVAL, rather than OIDs |
| 302 |
|
| 303 |
1.36 2005-12-02 |
| 304 |
- Change to how we resolve virtual columns to deal with a "no such |
| 305 |
attribute" bug in RT |
| 306 |
|
| 307 |
1.35 2005-11-02 |
| 308 |
- Doc fixes and OrderBy cleanup from ruslan |
| 309 |
|
| 310 |
1.34 2005-11-02 |
| 311 |
- Clone support from Ruslan |
| 312 |
|
| 313 |
1.33 2005-09-22 |
| 314 |
- Better SQL statement logging from alex |
| 315 |
|
| 316 |
1.32 2005-09-01 |
| 317 |
- DBD::SQLite is necessary for the test suite to run correctl |
| 318 |
|
| 319 |
1.31 2005-07-29 |
| 320 |
- Updated MANIFEST to fix a build issue - Thanks to Andy Lester and David |
| 321 |
Glasser |
| 322 |
|
| 323 |
1.30_03 2005-06-09 |
| 324 |
- Significant new tests from Ruslan Zakirov and Dave Glasser |
| 325 |
- You no longer need to explicitly bless a DBIx::SearchBuilder::Handle |
| 326 |
subclass |
| 327 |
- Start of a major overhaul of the subclass API for |
| 328 |
DBIx::SearchBuilder::Record objects. A new "schema" method will define |
| 329 |
the data in _ClassAccessible and also generate database schema using |
| 330 |
DBIx::DBSchema. |
| 331 |
- for numeric types, make the empty check be "null or 0", not "null or ''" |
| 332 |
- New search tests from ruslan |
| 333 |
- added an init_data method to t/utils.pl |
| 334 |
- CleanSlate doesnt init show_rows |
| 335 |
- CleanSlate doesnt clean _{open|close}_parens |
| 336 |
- get rid of stupid ifs in CleanSlate |
| 337 |
- get rid of evals in _DoSearch and _DoCount, use Handle methods to |
| 338 |
control DBI error handling |
| 339 |
- rewrite LoadByPrimaryKeys args handling to consistent with other Load* |
| 340 |
methods |
| 341 |
- report error when PK filed is missing in LoadByPrimaryKeys |
| 342 |
- fix warning in __Set methods when newvalue is undef |
| 343 |
- small code cleanups |
| 344 |
- test coverage grows from 75.2% to 84.7% for Record.pm |
| 345 |
|
| 346 |
1.30_02 2005-05-22 |
| 347 |
- Lots of patches from Ruslan: First and main change is using of `goto |
| 348 |
&$AUTOLOAD` syntax, that helps avoid code duplication and hides AUTOLOAD |
| 349 |
sub from stack trace. I think this also would help implement |
| 350 |
CompileAllAutoSubs method easier. |
| 351 |
- It's also one of the steps to better tests coverage. |
| 352 |
- Test coverage for Record.pm grows from 66% to 75.2%. |
| 353 |
- _LoadFromSQL never reported error when PK fields are missed. Fixed. |
| 354 |
- fetchrow_hashref dies only when RaiseErrors is true, because we can |
| 355 |
control this from Handle obj so we should die according to |
| 356 |
$Handle->RaiseErrors property. Fixed. |
| 357 |
- When RaiseErrors is "false" then fetchrow_hashref returns undef and we |
| 358 |
should check $sth->err(see `perldoc DBI`). Fixed. |
| 359 |
- After call to fetchrow we should clean "fetched" internal hash and fill |
| 360 |
it only when we return successful result. Fixed. |
| 361 |
- If SimpleQuery fails, _LoadFromSQL method doesn't return any error |
| 362 |
message. Fixed. |
| 363 |
|
| 364 |
1.30_01 2005-05-16 |
| 365 |
- Patches from Ruslan to switch to using 'capitalization.pm' for our |
| 366 |
regular_case subroutine aliases |
| 367 |
|
| 368 |
1.30 2005-07-28 |
| 369 |
- Removed {{{ and }}} fold markers. Patch from Ruslan |
| 370 |
|
| 371 |
1.27 2005-05-08 |
| 372 |
- Added supoprt for functions containing "?" to represent the parameter in |
| 373 |
->Column() |
| 374 |
- Added better support for functional columns in search listings and group |
| 375 |
by clauses |
| 376 |
|
| 377 |
1.26 2005-04-17 |
| 378 |
- Added support for expression based left joins |
| 379 |
|
| 380 |
1.25 2005-04-09 |
| 381 |
- Backed out a change introduced in 1.23 that caused table and column |
| 382 |
names to be quoted, causing Postgres to flip out. |
| 383 |
|
| 384 |
1.24 2005-04-06 |
| 385 |
- Added a new "SearchBuilder::Unique" module for uniquifying search |
| 386 |
results |
| 387 |
|
| 388 |
1.23 |
| 389 |
- Now use DBI->quote_identifier to quote column and table names (Ruslan) |
| 390 |
- Test suite updates (Ruslan) |
| 391 |
|
| 392 |
1.22 2005-01-24 |
| 393 |
- Require encode since we require encode. |
| 394 |
|
| 395 |
1.21 2005-01-22 |
| 396 |
- Oracle LOB handling caused us to corrupt item values on update. |
| 397 |
- Just before inserting things into the database, turn off their utf8 |
| 398 |
flag. The flag didn't have any positve impact _and_ it can take down |
| 399 |
recent DBD::Oracle releases. (This is a new failure in DBD::Oracle 1.16) |
| 400 |
|
| 401 |
1.20 2005-01-18 |
| 402 |
- Minor test suite fixes from Ruslan. |
| 403 |
|
| 404 |
1.19 2005-01-08 |
| 405 |
- Performing a search multiple times could result in multiple copies of |
| 406 |
records in a collection. Uncovered thanks to Kevin Chen and Alex |
| 407 |
Vandiver. |
| 408 |
|
| 409 |
1.18 |
| 410 |
- Release the changes from 1.17 |
| 411 |
|
| 412 |
1.17_03 |
| 413 |
- Properly mark BLOB columns in UPDATE calls. (DBD::Oracle 1.16 broke |
| 414 |
without this) |
| 415 |
|
| 416 |
1.17_02 |
| 417 |
- Better handling of empty values for SB::Record::_Accessible. ( --Ruslan) |
| 418 |
|
| 419 |
1.17_01 |
| 420 |
- More record tests from Ruz |
| 421 |
|
| 422 |
1.16 2004-12-09 |
| 423 |
- Fixed a bug in D::SB::R::Cachable that could cause it to load the wrong |
| 424 |
row from the cache if you were loading by alternate keys and had since |
| 425 |
changed one of the attributes of a previous row. This was unmasked by a |
| 426 |
bug that Ruslan Zakirov found in RT 3.3's custom field handling |
| 427 |
|
| 428 |
1.15 2004-11-27 |
| 429 |
- Fix a testsuite bug when DBD::SQLite isn't there |
| 430 |
|
| 431 |
1.14 |
| 432 |
- Silenced warnings about uninitialized warnings when inserting null cols |
| 433 |
into the database. |
| 434 |
- Started adding lowercase method name aliases |
| 435 |
- Minor refactoring of 'id' method for a stupid, tiny perf improvement |
| 436 |
- Refactoring of DBIx::SearchBuilder::Record::Cachable for performance |
| 437 |
improvement |
| 438 |
- Added a FlushCache method to DBIx::SearchBuilder::Record::Cachable. |
| 439 |
- Started to flesh out a...test suite |
| 440 |
- SearchBuilder now truncates strings before inserting them into character |
| 441 |
types in the database as mysql generally does. Additionally, it |
| 442 |
truncates things at utf8 character boundaries...as mysql does not. |
| 443 |
- Fix for an undefined record cache warning on load from Autrijus Tang |
| 444 |
- Major documentation cleanups --Simon Cavalletto |
| 445 |
- A few tweaks to the ::Record class to eliminate the hard-coding of the |
| 446 |
name of the id column --Simon Cavalletto |
| 447 |
|
| 448 |
1.12 |
| 449 |
- Better error handling for some query build failure cases |
| 450 |
- Corrected query builder for SQLite |
| 451 |
- More refactoring. |
| 452 |
|
| 453 |
1.11 |
| 454 |
- When loading an object whose "id" has been altered, as in the case of |
| 455 |
RT's "Merge" functionality, the wrong object was returned by the caching |
| 456 |
layer. Special casing for the "id" method was removed. |
| 457 |
|
| 458 |
1.10_05 |
| 459 |
- Reworked the _Accessible mechanism in DBIx::SearchBuilder::Record to |
| 460 |
remove a horribly crufty old caching mechanism that created a copy of |
| 461 |
the accessible hash for each and every object instantiated, sometimes |
| 462 |
quite slowly. |
| 463 |
|
| 464 |
1.10_04 2004-08-30 |
| 465 |
- A query builder fix for an issue that bit RT2: Unsatisfied dependency |
| 466 |
chain in Joins Users_2 at |
| 467 |
/usr/local/share/perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 965, line |
| 468 |
69. |
| 469 |
|
| 470 |
1.10_03 2004-08-30 |
| 471 |
- Cache Sanity fixes from Autrijus Tang <[email protected]> |
| 472 |
|
| 473 |
1.10_02 2004-08-26 |
| 474 |
|
| 475 |
1.10_01 2004-08-26 |
| 476 |
- Reimplemented DBIx::SearchBuilder:::Record::Cachable to use |
| 477 |
Cache::Simple::TimedExpiry. This should make it faster and more memory |
| 478 |
efficient. |
| 479 |
|
| 480 |
1.10 |
| 481 |
- Identical to 1.10_05 |
| 482 |
|
| 483 |
1.02_03 2004-07-22 |
| 484 |
- Additional bullet proofing for joins. Now we default to ALIAS1 being |
| 485 |
"main" ([email protected]) |
| 486 |
|
| 487 |
1.02_02 2004-07-20 |
| 488 |
- Fixed a join bug that mostly manifests as a 'Dependency chain' error on |
| 489 |
RT2. |
| 490 |
|
| 491 |
1.02_01 2004-07-07 |
| 492 |
- magic _Object instantiation from [email protected] |
| 493 |
- make SB::_Handle settable directly ([email protected]) |
| 494 |
- document the above |
| 495 |
|
| 496 |
1.01 2004-06-27 |
| 497 |
- Releasing 1.00_06 as stable |
| 498 |
|
| 499 |
1.00_06 |
| 500 |
- Pg/Oracle: Don't attempt to do case insensitive comparisons on integer |
| 501 |
values. |
| 502 |
|
| 503 |
1.00_05 |
| 504 |
- Force utf8 flag on when doing searches for utf8 data; this is a |
| 505 |
workaround for DBDs that don't do it themselves. |
| 506 |
|
| 507 |
1.00_04 |
| 508 |
- Move Postgres specific join behaviour to the superclass so everyone gets |
| 509 |
the benefit. |
| 510 |
|
| 511 |
1.00_03 |
| 512 |
- Remove "AS" from table name aliases on joins, since Oracle doesn't like |
| 513 |
em. |
| 514 |
|
| 515 |
1.00_02 |
| 516 |
- Slightly cleaner code in SearchBuilder->GotoPage |
| 517 |
|
| 518 |
1.00_01 |
| 519 |
- Better handling of case insensitive comparisons on Postgres |
| 520 |
- Proper support for query paging on SQLite |
| 521 |
|
| 522 |
0.99 |
| 523 |
- Bundled changes from 0.98* and released production version |
| 524 |
- Removed duplicate code in cache expiry routines Experimental |
| 525 |
SearchBuilder::Union collection object. |
| 526 |
- Released at the YAPC::Taipei::22004 Release Party |
| 527 |
|
| 528 |
0.98_04 |
| 529 |
- New mysql/oracle "Join" code that allows more complex bundling of joins |
| 530 |
from Linda and Robert |
| 531 |
|
| 532 |
0.98_03 |
| 533 |
- New test infrastructure from Andy Lester |
| 534 |
|
| 535 |
0.98_02 |
| 536 |
- Better handling of != clauses on Postgres |
| 537 |
|
| 538 |
0.97_02 |
| 539 |
- Support for "Group By" clauses. |
| 540 |
- Support for delayed load of certain columns from Autrijus Tang. |
| 541 |
|
| 542 |
0.97_01 |
| 543 |
- Oracle doesn't support binary-safe clobs in a reasonable manner. |
| 544 |
|
| 545 |
0.96_01 |
| 546 |
- Fix a couple of spurious warnings in Record::Cachable |
| 547 |
- Records loaded from multiple-record searches were never cached |
| 548 |
- correctly |
| 549 |
|
| 550 |
0.96 |
| 551 |
- Releasing 0.96_01 as usable |
| 552 |
|
| 553 |
0.95_03 |
| 554 |
- Allow case-insensitive loading by columns in SearchBuilder::Record |
| 555 |
- Record::LoadByCols now lets you specify operator and values |
| 556 |
|
| 557 |
0.95_01 |
| 558 |
- Removed historical escaping for non-ascii searche queries |
| 559 |
|
| 560 |
0.94 |
| 561 |
- Fix for multiple handles in one app from Autrijus Tang |
| 562 |
|
| 563 |
0.93 |
| 564 |
- Added ODBC database driver from Autrijus Tang |
| 565 |
- Added the ability to sort on functions of columns from Autrijus Tang |
| 566 |
- Improved case-insensitve searching behavior for PostgreSQL |
| 567 |
- Added support for multiple handles in one app from Autrijus Tang (#4167) |
| 568 |
- Added initial Informix database driver from Oliver Tappe |
| 569 |
|
| 570 |
0.92 2003-09-04 |
| 571 |
- Fixed a bug that caused certain types of pre-canned table aliases to |
| 572 |
fail to work on join |
| 573 |
|
| 574 |
0.90 2003-08-08 |
| 575 |
- Disable Class::ReturnValue's stack trace feature as it interacted poorly |
| 576 |
with a stack containing lots of data |
| 577 |
|
| 578 |
0.89_02 2003-07-19 |
| 579 |
- Patch from Grant DeGraw to allow ordering by multiple columns. |
| 580 |
|
| 581 |
0.89_01 2003-07-18 |
| 582 |
- Patch from Brook for: |
| 583 |
- better oracle support |
| 584 |
- remove "SELECT DISTINCT" when it's not necessary |
| 585 |
|
| 586 |
0.88 2003-06-23 |
| 587 |
- More correct generation of "Distinct" keyword on counts for queries with |
| 588 |
left joins |
| 589 |
|
| 590 |
0.87 2003-06-16 |
| 591 |
- Changed DBIx::SB::Record::Cachable to expire cached object when a |
| 592 |
"deeper" method call changes their values |
| 593 |
|
| 594 |
0.86 2003-06-07 |
| 595 |
- Doing conditional connections was failing on postgres, because the |
| 596 |
handle was defined, but not connected |
| 597 |
|
| 598 |
0.85 2003-06-07 |
| 599 |
- Stan's destroy fix was actually badly breaking RT |
| 600 |
- It's now an optional parameter. |
| 601 |
|
| 602 |
0.84 2003-06-04 |
| 603 |
- Bumped the version for release |
| 604 |
|
| 605 |
0.83_05 2003-06-02 |
| 606 |
- Provide support for blowing away nested transactions that aren't yet |
| 607 |
committed. |
| 608 |
|
| 609 |
0.83_04 2003-06-02 |
| 610 |
- Fixed how values of returned hashes are downcased. |
| 611 |
- Should be a minor perf improvement |
| 612 |
|
| 613 |
0.83_03 2003-05-30 |
| 614 |
- Moved Stan's destryo fix to the right file |
| 615 |
|
| 616 |
0.83_02 2003-05-27 |
| 617 |
- Better oracle support for unique ids on indexes from Brook |
| 618 |
|
| 619 |
0.83_01 2003-05-27 |
| 620 |
- Stan's DESTROY fix |
| 621 |
- Mathieu Arnold's patch to make function naming for autoloaded functions |
| 622 |
a bit more flexible |
| 623 |
|
| 624 |
0.82 2003-05-19 |
| 625 |
- Query builder changes to improve some join performance |
| 626 |
- Fixes to a tight loop for cache expiry |
| 627 |
|
| 628 |
0.81_04 2003-04-14 |
| 629 |
- Fixed a bug in "Distinct" logic introduced in 0.81_01 |
| 630 |
|
| 631 |
0.81_03 2003-04-13 |
| 632 |
- Patches for Oracle BLOB support from Brook Schofield |
| 633 |
|
| 634 |
0.81_02 2003-04-13 |
| 635 |
- Rebuilt Postgres query generator. |
| 636 |
|
| 637 |
0.81_01 2003-03-27 |
| 638 |
- Select Distinct altered to support oracle |
| 639 |
|
| 640 |
0.80 2003-03-08 |
| 641 |
- Count method enhanced to ignore "LIMIT"s |
| 642 |
- LIMIT behaviour changed to be handle specific |
| 643 |
|
| 644 |
0.79 2003-01-19 |
| 645 |
- ReadableAttributes and WritableAttributes added as methods to Record.pm |
| 646 |
|
| 647 |
0.78 2003-01-16 |
| 648 |
- SB->Count should return no results unless the search is limited |
| 649 |
- Eliminate a warning on empty searches |
| 650 |
|
| 651 |
0.77 2003-01-15 |
| 652 |
- No longer attempt to cache (and fail) objects that haven't been |
| 653 |
database-loaded |
| 654 |
|
| 655 |
0.76 2002-12-30 |
| 656 |
- Extra checking for cache misses in DBIx::SearchBuilder::Record::Cachable |
| 657 |
- The start of support for checking database version, so that we can do |
| 658 |
version-specific SQL |
| 659 |
- A patch from Autrijus Tang that allows utf-8 safe searching |
| 660 |
|
| 661 |
0.75 2002-12-06 |
| 662 |
- Applying a patch from Rob Spier <[email protected]> which enables |
| 663 |
arbitrarily complex grouping clauses. It's a hack, but we love it |
| 664 |
anyway....at least until SB gets redone with proper arbitrarily complex |
| 665 |
query generation. |
| 666 |
|
| 667 |
0.74 2002-10-11 |
| 668 |
- Adding support for mysqlPP |
| 669 |
|
| 670 |
0.73 2002-09-10 |
| 671 |
- More class-returnvalue ification |
| 672 |
- Fixed a caching bug that caused multiple copies of an object in memory |
| 673 |
to not be kept in sync |
| 674 |
|
| 675 |
0.72 2002-08-28 |
| 676 |
- Fixed bug in setting a column to the value of an SQL statement. |
| 677 |
|
| 678 |
0.70 2002-08-27 |
| 679 |
- Better support for Postgres 7.2 and transactions. |
| 680 |
|
| 681 |
0.62 2002-07-05 |
| 682 |
- Support for Class::ReturnValue to channel errors up when expected |
| 683 |
- Dependency on Class::ReturnValue |
| 684 |
- Minor cleanups and refactorings to allow percolation of errors on create |
| 685 |
|
| 686 |
0.34 2001-05-23 |
| 687 |
- SearchBuilder.pm - refactored to allow LEFT joins. |
| 688 |
|
| 689 |
0.31 2001-05-12 |
| 690 |
- SearchBuilder::Record::Cachable now constructs cache keys in a way that |
| 691 |
doesn't lose when records in different tables have the same keys. |
| 692 |
|
| 693 |
0.30 2001-05-11 |
| 694 |
- Added DBIx::SearchBuilder::Record::Cachable from <[email protected]> |
| 695 |
- Changed SearchBuilder->Count to do the right thing if no query has been |
| 696 |
performed |
| 697 |
- No longer specify a sort order if no sort order was specified ;) |
| 698 |
|
| 699 |
0.01 2000-08-29 |
| 700 |
- original version; created by h2xs 1.19 |
| 701 |
|