Changes for version 1.57 - 2010-09-04
- 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
Modules
Encapsulate SQL queries and rows in simple perl objects
Perl extension which is a generic DBI handle
An Informix specific Handle object
An ODBC specific Handle object
An oracle specific Handle object
A Postgres specific Handle object
A SQLite specific Handle object
a Sybase specific Handle object
A mysql specific Handle object
A mysql specific Handle object
Superclass for records loaded by SearchBuilder
Records with caching behavior
Generate table schemas from DBIx::SearchBuilder records
Deal with multiple SearchBuilder result sets as one
Ensure uniqueness of records in a collection