[prev in list] [next in list] [prev in thread] [next in thread] 

List:       apache-modperl
Subject:    [ANNOUNCE] DBIx::Recordset 0.25 now on CPAN
From:       Terrence Brannon <metaperl () urth ! org>
Date:       2003-12-31 3:17:22
Message-ID: 3FF23FC2.9020208 () urth ! org
[Download RAW message or body]

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.


-- 
Reporting bugs: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html

[prev in list] [next in list] [prev in thread] [next in thread]