* Full SQL Query input via the !Query option to Search()
* added the '$makesql' flag to Search() so that generated SQL can
be returned instead of executed. It will remain undocumented until
it is supported for Update(), Delete(), and Insert(). It was added
in order that the SQL generated for the test "Order, Group,
Append" would pass on Postgres which finds the generated SQL
invalid.
BUGFIXES (Angus Lees, Terrence Brannon, Gerald Richter)
* when building the FROM clause for LEFT JOINs Recordset placed parentheses around it, like this:
SELECT dbixrs1.id,dbixrs1.name,dbixrs1.value1,dbixrs1.addon,dbixrs2.value2 FROM (dbixrs1 left join dbixrs2 on dbixrs1.id = dbixrs2.id) WHERE dbixrs1.id IN (2, 5, 10);
but this caused a syntax error in sqlite, so a new leftjoin type
of 4 was introduced to support LEFT JOIN with no parentheses
around the join
* Fixed a bug that cause TableAttr with value zero not to work
correctly. Patch from Rene Seindal
* Made sure that filters given by name override filters given by type.
* Fixed PreFetchIfExpires() so that it works for a specified time period as well as for a CODE ref
* Added support to DBIx::Compat so that the pseudo-type "counter" was converted
to SERIAL when DBD::Pg is in use
* DBD::mysql versions > 2.9002 quote the table name. While is good and valid practice, the other drivers tested (SQLite and Pg) do not do this, making it difficult to create a consistent test suite. For the time being, a custom ListTablesMySQL was added to DBIx::Compat which strips the backquotes.
-- Reporting bugs: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html
