DBIx-SearchBuilder

 view release on metacpan or  search on metacpan

Changes  view on Meta::CPAN

   ordering by columns in joined tables. Switched to group by instead of
   sub-selects.

1.54 2008-07-09
 - When aborting transactions, we need to flush our cache, because SQLite
   is reusing the primary id for later inserts and the cache can otherwise
   become inconsistent.

1.53 2008-04-02
 - Fix mysql version check in DistinctQuery function
 - Fix order by outer column on Oracle
 - Improve tests

1.52 2008-04-01
 - Fix order by outer column on SQLite, mysql, adjust Pg. Add test that
   cover this.

1.51 2008-01-15
 - Fix CountAll method when paging is enabled and data is in memory already

1.50 2007-11-23
 - Oracle: Don't DISTINCT query when there is a group by clause
 - Fix a problem when we have more then two collections in a union and some
   of them are empty

1.49 2007-07-07
 - Fix a CPAN signature issue

1.48 2007-03-11
 - Fix a problem when left joins optimizer fails to calculate a boolean
   expression because of lower case aggregators.

1.47 2007-03-04
 - Do the search in unions only when we must do them, not on every call to
   the Next method
 - Don't index ex/ dir to avoid complains by the indexer of PAUSE/CPAN

1.46 2007-02-25
 - when doing a union, we need to actually search, rather than just doing a
   count
 - add support for testing with Oracle backend
 - Use CROSS JOIN instead of ',' as SQL parsers in Pg and some mysql are
   buggy and cannot parse "FROM X, Y JOIN Z ON Z.f = X.f"
 - deprecate DEBUG method, it's still there but produce warning
 - fix CleanSlate method that was missing several keys
 - fix a long standing bug we had, we didn't write depends_on data about a
   join, so we could build queries with incorrect parens around join
   conditions
 - fix default values for ALIAS1 argument in the Join method, istead of
   defaulting FIELD1 to 'main' value
 - fix a TODO test
 - internal refactoring of a storage for query's conditions, instead of
   building query strings right after the limit or join, we now build a
   perl structure
 - don't clone attributes that don't exists in the Clone method
 - we use Encode module without perl version check for a long time, so we
   can get rid of all checks for the version and load the module at compile
   time everywhere we need it
 - implement MayBeNull method in the handler that checks if applied
   conditions allow NULLs in the result set
 - implement cascaded LEFT JOINs optimization
 - additional tests for CleanSlate and Clone methods, ENTRY_AGGREGATOR
   argument, different types of joins and LEFT JOIN optimizer

1.45 2006-09-26
 - Postgres: fix "$rec->Create();"
 - Postgres: fix "$rec->Create( IntegerColumn => '' );"
 - Postgres: fix "$rec->SetIntegerColumn( '' );"
 - Postgres: add test
 - cleanup ::Record::Cachable
 - use cache in: $a->LoadByCols(...); $b->LoadById( $a->id );
 - add cache tests

1.44 2006-05-27
 - DBIx::SearchBuilder::Handle::DatabaseVersion enhancements

1.43 2006-04-12
 - Fix to the sequence compatibility fixes. For backwards compatibility.

1.42 2006-04-10
 - Signatures fixed

1.41 2006-04-10
 - PG 8.1 sequence compatibility fixes from Daniel Tabuenca

1.40 2006-03-10
 - 'NOT STARTSWITH' and 'NOT ENDSWITH'

1.39 2006-02-16
 - Allow ORs on left joins

1.38 2005-12-29
 - Released 1.37 dev series

1.37_01 2005-12-08
 - Switched Postgres sequence lookups to use CURRVAL, rather than OIDs

1.36 2005-12-02
 - Change to how we resolve virtual columns to deal with a   "no such
   attribute" bug in RT

1.35 2005-11-02
 - Doc fixes and OrderBy cleanup from ruslan

1.34 2005-11-02
 - Clone support from Ruslan

1.33 2005-09-22
 - Better SQL statement logging from alex

1.32 2005-09-01
 - DBD::SQLite is necessary for the test suite to run correctl

1.31 2005-07-29
 - Updated MANIFEST to fix a build issue -  Thanks to Andy Lester and David
   Glasser

1.30_03 2005-06-09
 - Significant new tests from Ruslan Zakirov and Dave Glasser
 - You no longer need to explicitly bless a DBIx::SearchBuilder::Handle
   subclass



( run in 0.912 second using v1.01-cache-2.11-cpan-bbe5e583499 )