The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.
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