view release on metacpan or  search on metacpan

corpus/dists/SQL-Statement.changes  view on Meta::CPAN

[Bug fixes]
* add some getters as documented in SQL::Statement::Structure
  (fixes RT#59834, thanks John Wiersba)
* add missing import of function croak to SQL::Statement::Term::ColumnValue
* fix assignment of parser result (doesn't run with perl-5.13.3)

Version 1.28, released July 15th, 2010
----------------------------------------------

[Improvements]
* Introduce new "capability" method for SQL::Statement and SQL::Eval::Table
  + Add capability for "insert_new_row" to allow DBD::DBM to fix PK
    constrain on INSERT statements.
* Performance of IMPORT feature improved (thanks to Sven Probst, RT#57322)

[Bug fixes]
* expect every table object being derived from SQL::Eval::Table
* rewrite DELETE and UPDATE command based on table capabilities
* add abstract methods for all methods derived classes must override
  (this means, open_table for SQL::Statement deriveds must be overridden
   and all data access methods of tables - see SQL::Eval::Table for details)
* Tests are fixed to use TEMP TABLES explicitely when required
* check for invalid column names fixed
* Don't let depreciated parser structures stay alive in SQL::Statement when
  reusing the Parser

[Documentation]
* Method documentation of SQL::Statement and SQL::Eval::Table are improved
* Add a Roadmap describing future plans for SQL::Statement (in addition to
  DBD::File::Roadmap).
* POD spelling fixes provided by H.Merijn Brand and Pod::Spell::CommonMistakes
  (thanks Tux)
* POD grammar fixes and reasonable sentences created by Martin Evans 

[Things that may break your code]
* SQL::Statement 1.28 is expected not to work proper in combination with
  DBI 1.611 and below
* SQL::Statement::ColumnValue expects now every table being derived from
  SQL::Eval::Table

Version 1.27, release May 06th, 2010
----------------------------------------------

[Bug fixes]
* use originally given table name for open_table() on SELECT, too
  (all other command still use the originally given name)
* warn/die -> carp/croak
* fix delete_one_row & update_one_row ability using

[Documentation]
* Apply spelling fix patch from Ansgar Burchardt (RT#56475)

Version 1.26, release April 09th, 2010
----------------------------------------------

[Bug fixes]
* Handle NULL columns in concatenation as empty strings

[Improvements]
* Change regex's in parser to use \p{Word} instead of \w to allow unicode
  support

[Documentation]
* Make clear, that identifiers are handled case insensetive and there is
  a real good solution provided by DBI which allows to live great with
  that behaviour.

Version 1.25, release March 15th, 2010
----------------------------------------------

[Bug fixes]
* Keep org_table_names with schema information to allow derived
  table classes to handle as it seems reasonable there
* Separate columns with "\0" in multi-column aggregation to be able to
  difference between ('1','1foo') and ('11','foo')

[Misc]
* More resources added to META.yml

Version 1.24, release March 15th, 2010
----------------------------------------------

[Misc]
* Ignore *.rej in MANIFEST.SKIP (fixes RT #52081 reported by
  Lars Thegler)

[Bug fixes]
* Add missing import of _INSTANCE in SQL::Statement::Function::NumericEval
  fixes RT #52356 - reported by Detlef Pilzecker)
* Fix wrongly discarded DISTINCT clause (RT#53186)

[Improvements]
* Fix parsing errors of plain numbers (RT#16931)
* Fix parsing errors of nested calculation / functions (RT#16931, RT#52356)
* Rewrite result calculation of aggregation functions (simplify code, speed up)
* Upgrade Makefile.PL (patch from Alexandr Ciornii) to handle different
  EU::MM versions and abilities properly
* Update documentation to show how 'column_defs' and SQL::Statement::Term
  instances shall be used
* Introduce SQL::Dialect::Role providing ini-style data access to SQL::Dialects
  (patch from Michael Schwern)

[Things that may break your code]
* SQL::Parser now didn't deliver a struct containing 'column_names',
  'computed_columns' and 'set_functions' - it's combined into one member
  'column_defs'.
* Minimum required perl version is now 5.8 - upcoming next version of DBI
  requires perl 5.8, too - and I could simplify some code that's why

Version 1.23, release November 20th, 2009
----------------------------------------------

[Misc]
* Applied patch from Marc Espie which fixes several orthographic
  errors in SQL::Statement::Syntax documentation.
* Added a fixed version of test reported via RT #34121

[Bug fixes]
* Fix an issue in UPDATE command which 'shift's the values from
  the list of parameters which causes there're no more parameters