Revision history for Perl extension DBIx::SQLCrosstab.

1.17 11-Jan-2004

New features

• 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.

Deprecations

• usage of {col_op} and {add_op} (and {op} as a scalar) are now DEPRECATED.

Bugs fixed

• 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)
  • Changed example table names to "xtab_*", so that users allowed to a single database can easily add these tables without affecting existing ones.
  • Added drop_crosstab.sql to remove the example tables easily. (Thanks to Mark Stosberg for all these ideas on the SQL examples)
  • New documentation available: an article at OnLamp http://www.onlamp.com/pub/a/onlamp/2003/12/04/crosstabs.html and one at PerlMonks http://www.perlmonks.org/index.pl?node_id=313934

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

• Added new methods:

  set_param() to add or modify parameters after creation get_params() to get the current parameters into a string save_params() to save the parameters to a file load_params() to load the parameters from a file

• Added new examples and database diagram
• Added new sample schemas
• Fixed some documentation issues

1.14 08-Oct-2003

First distributed version

1.00-1.13

Building features and fixing bugs

1.00 12-Sep-2003

• original version