Terrence, thanks very much for getting the new version on CPAN and all your work you put into DBIx::Recordset
Gerald Terrence Brannon wrote: > NEW FUNCTIONALITY (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 > > * 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. -------------------------------------------------------------- Gerald Richter ecos electronic communication services gmbh IT-Securityl�sungen * dynamische Webapplikationen * Consulting Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz E-Mail: [EMAIL PROTECTED] Voice: +49 6133 939-122 WWW: http://www.ecos.de/ Fax: +49 6133 939-333 -------------------------------------------------------------- | | ECOS BB-5000 Firewall- und IT-Security Appliance: www.bb-5000.info | +------------------------------------------------------------- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
