Revision history for Perl extension DBIx::SQLCrosstab.
1.17 11-Jan-2004
- Now the {op} parameter is an array
reference, containing pairs of operator/column, so that
now it is possible to perform
[ ['COUNT', 'id'], ['SUM', 'salary'], ['AVG', 'expenses'] ]
in one query.
- usage of {col_op} and {add_op} (and {op} as a scalar) are now
DEPRECATED.
- operator names may cause a syntax error when they become
column headers. Fixed.
Changed functionality
- changed operator names (when they become column headers)
to "x"operator (xcount, xsum, xavg, etc.) to avoid a name
conflict with some DBMS engines. Thanks to Cyril Dréno for
reporting this bug.
- changed crosstab column names from "fldXXX" to "xfldXXX"
to avoid possible clashes with some other SQL generators.
- the main example (sqlcrosstab_example.pl) now
creates multi-operation tables to test and demonstrate
the above change.
Examples and Documentation
- Changed example create_crosstab.sqlite to create_crosstab.sql92
(it should work on any ANSI-SQL92 compliant DBMS)
1.16 12-Dec-2003 (Experimental - Not released)
- Raised pre-requisite. DBIx::SQLCrosstab::Format won't
work with Perl versions earlier than 5.6.1.
Notice that due to this limitation the installation test will
fail under Perl 5.6.0.
Actually, the minimum requirement was like that from the
beginning, but I failed to notice it. Thanks
to Cyril Dréno for reporting this bug.
1.15 12-Oct-2003
1.14 08-Oct-2003
First distributed version
1.00-1.13
Building features and fixing bugs
1.00 12-Sep-2003