if there are no complaints about it.
We can integrate Kee Hinckley's stuff into 0.26 when he gets back from his plane trips.
Please test this before I upload it to CPAN:
http://www.urth.org/~metaperl/DBIx-Recordset-0.25.tar.gz
It was tested on MySQL, Postgres and SQLite only.
I am taking a 4-day train trip tonight so I will not be able to respond to email
until 5 or so days from now.
It is checked into svn, so patches can be applied.
NEW FUNCTIONALITY (Kee Hinckley, Cameron Prince, Terrence Brannon)
* 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
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
