Loading ...
Sorry, an error occurred while loading the content.
 

[ANNOUNCE] DBIx::Recordset 0.25 now on CPAN

Expand Messages
  • Terrence Brannon
    NEW FUNCTIONALITY (Cameron Prince, Terrence Brannon) * Full SQL Query input via the !Query option to Search() * added the $makesql flag to Search() so that
    Message 1 of 1 , Dec 30, 2003
      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
    Your message has been successfully submitted and would be delivered to recipients shortly.