The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
 / 
SQL-Interp-1.10
River stage one • 1 direct dependent • 1 total dependent
8 ++

Changes for version 1.10 - 2009-06-28

  • FEATURES
    • Add support for MySQL's "REPLACE INTO". (TBONE, Mark Stosberg, RT#43477)
  • PERFORMANCE
    • When SQL snippets are provided as hashrefs, we now always sort them to insure consistent results for the benefit of possible statement caching. This shouldn't change your application behavior, as hashs are not to be considered an ordered data structure. If you want to force an element to be first in the where clause, that's better done with the pre-existing functionality: sql_interp("... WHERE a = 1 AND ",\%rest_of_where_hash);
      • Thanks to Andrew Kirkpatrick for the patch (RT#33310).
  • BUG FIXES
    • The documentation said that we supported a reference to an arrayref in the "IN ()" context, but there didn't appear to be code or tests for this. Both have been added now. (Mark Stosberg, RT#39336).
  • INTERNALS
    • Update formatting and language about the historical fork with SQL::Interpolate.
    • Fix documentation typos (TBONE, RT#42726, RT#42733, RT#42336)

Modules

DBIx::Interp
Interpolate Perl variables into SQL with DBI
SQL::Interp
Interpolate Perl variables into SQL statements

Provides

DBIx::Interp::STX
in lib/DBIx/Interp.pm
DBIx::Interp::db
in lib/DBIx/Interp.pm
SQL::Interp::SQL
in lib/SQL/Interp.pm
SQL::Interp::Variable
in lib/SQL/Interp.pm

Examples

Other files