DBIx-SearchBuilder
view release on metacpan or search on metacpan
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 )