- updated to 1.74
see /usr/share/doc/packages/perl-DBIx-SearchBuilder/Changes
1.74 2022-12-12
- Explicitly require version to make cpantesters happy
- Require perl 5.10.1+ to not support derelict versions
1.73 2022-12-08
- Remove very old CVS headers from files
- Standardize whitespace
- Remove an unused cache parameter remaining from a previous refactor
- Update a test to work around a change in numeric values returned on
Postgres starting in version 14
- Fix a doc typo
- Fix a bind value issue with Limit on Postgres
- Disable finding count in searches for older versions of MySQL and
MariaDB that don't support window functions (OVER)
- Truncate values before checking for changes to fix a bug where
values bigger than a column would be inserted even when they were
not changed
1.72_01 2022-09-20
- Simplify count's internal logic to always use the "count_all" key
- Fix Count method to always returns count in selected page
- Support search and count in same query
- Redo search only if ORDER/GROUP BY is really updated
- Add bind values support for LIMIT clauses
OBS-URL: https://build.opensuse.org/request/show/1042457
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-DBIx-SearchBuilder?expand=0&rev=18
- Stop unilaterally disabling the "UTF8" flag before executing queries
- Make ->Fields case-sensitive in the column names it returns, as well
as in the table name it takes.
- Make ->Fields only lookup information on the table requested, not all
fields, for performance. It also is now case-sensitive in table name.
- Omit calls to ->Fields entirely for PostgreSQL 9.1 and above
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-DBIx-SearchBuilder?expand=0&rev=11
* DBIx::SearchBuilder->DistinctFieldValues method
* SIGNATURE fix
* delete obsolete cvs metadata from a module
* INCOMPATIBLE CHANGE: NextPage and PrevPage were adding rows from
the previous page. Jesse claims that when he wrote this code, he
was 20 years old and it seemed like a good idea at the time.
* When logging queries, include full stack trace
* support $sb->NewAlias( 'table' => 'LEFT' );
* allow join to depend on nothing
* catch cases when there are more closing parens then should be
* Oracle: Use ROW_NUMBER() to propagate row ordering from inside the DISTINCT
* Various performance improvements through small internal refactorings
* Implemented 'sub Fields' on Oracle
* unify case insensitive characters to avoid using LOWER() in some
cases
* We now RedoSearch when RowsPerPage is changed
* No longer RedoSearch if FirstRow is called, but is not actually changed
* Document all paging functions and test them
* handle LOWER() in redundant LEFT joins optimizer,
for Oracle and may be Pg
* Make debugging problems easier by passing errors back
https://rt.cpan.org/Ticket/Display.html?id=55203
* fix Record->PrimaryKeys, field names in values hash are lc'ed
https://rt.cpan.org/Ticket/Display.html?id=18280
* doc updates and cleanups
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-DBIx-SearchBuilder?expand=0&rev=5
