X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=Changes;h=95aaf23820bd34660f726ae5d18a814391029628;hb=beee10ec5947450478a177c43b64e69300650d5d;hp=22dbebabed85a566136c05cb140096de41ea6ffd;hpb=0a2833d8ee24159420d7cb9a5b4184e4d0eb5b1a;p=dbsrgits%2FSQL-Translator.git diff --git a/Changes b/Changes index 22dbeba..95aaf23 100644 --- a/Changes +++ b/Changes @@ -1,22 +1,111 @@ -* All parser grammars are now precompiled for speed +* Apply quotes to fix tables that are reserved words, DBI::SQLServer (Jonathan C. Otsuka) +* Add DECIMAL_DIGITS to field size for scale info, DBI::SQLServer (Jonathan C. Otsuka) +* De-linkify XML namespace in docs (RT#81838) +* Allow both single and double quotes for values in MySQL parser +* Fix diff for altering two things per column - add ; at the end +* Call all diff methods in list context (it can be merged later) +* Fix Pg diff issue with drop constraint on primary keys +* SQLite support for SET NULL, SET DEFAULT and NO ACTION in FK clauses +* Clean up properly after Parser::DBI::PostgreSQL tests +* Fix typos in error messages +* Add SQL_TINYINT and SQL_BIGINT to the type map in + SQL::Translator::Schema::Field + +# ---------------------------------------------------------- +# 0.11016 2012-10-09 +# ---------------------------------------------------------- + +* Allow passing an arrayref to SQLT->filename (lost in Mooification) + +# ---------------------------------------------------------- +# 0.11015 2012-10-05 +# ---------------------------------------------------------- + +* Fix stupid missing version number in SQL::Translator::Schema::Object + +# ---------------------------------------------------------- +# 0.11014 2012-10-05 +# ---------------------------------------------------------- + +* Relicense under Perl 5 terms + +# ---------------------------------------------------------- +# 0.11013_03 2012-09-25 +# ---------------------------------------------------------- + +* Remove SQL::Translator::Schema::Graph as announced in 0.11011 +* Remove a number of no longer needed deps + +# ---------------------------------------------------------- +# 0.11013_02 2012-09-23 +# ---------------------------------------------------------- + +* Fix missing dep (List::MoreUtils) + +# ---------------------------------------------------------- +# 0.11013_01 2012-09-22 +# ---------------------------------------------------------- + +* Convert SQL::Translator, ::Schema and ::Schema::* to Moo +* Fix leaks by weakening circular references between schema objects + +# ---------------------------------------------------------- +# 0.11013 2012-09-22 +# ---------------------------------------------------------- + +* Make MySQL producer add NULL after every nullable field, conforming to SQL + standard, and avoiding MySQL bugs + +# ---------------------------------------------------------- +# 0.11012 2012-07-02 +# ---------------------------------------------------------- + +* Fix/update quoting in PostgreSQL producer +* Add missing quote function to SQLServer producer +* Fix incorrect Parser::DBI documentation (RT#60878) + +# ---------------------------------------------------------- +# 0.11011 2012-05-09 +# ---------------------------------------------------------- + +!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! +*** INCOMPATIBLE CHANGES: +* SQLT no longer supports setting separate conflicting values for the now + deprecated 'quote_table_names' and 'quote_field_names'. Instead their values + are proxied to the new 'quote_identifiers'. If 'quote_identifiers' is + supplied, the legacy settings are ignored (with a warning). If nothing is + specified the default is TRUE as before. If only one is specified - default + to its value for everything, and if both are specified with a conflicting + value an exception is thrown. +* Partial quoting support has been added in SQLite. It is currently disabled by + default, you need to request is explicitly with quote_identifiers => 1. In a + future version of SQL::Translator *THIS DEFAULT BEHAVIOR WILL CHANGE*. + If you do NOT WANT quoting, set quote_identifiers to a false value to + protect yourself from changes in a future release. +* Bump the default MySQL parser version to MySQL 4.0 +!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! +* script/sqlt-graph now accepts a --trace option * Fixes to SQLite foreign keys production (patch from Johan Viklund) closes RT#16412, RT#44769 * ON DELETE/UPDATE actions for SQLite (patch from Lukas Thiemeier) closes RT#70734, RT#71283, RT#70378 -* Proper quoting support in SQLite +* Fix data preservation on SQLite diffs involving adding/dropping columns * Support for triggers in PostgreSQL producer and parser * Correct Data Type in SQLT::Parser::DBI::PostgreSQL (patch from Andrew Pam) * Fix index issue in SQLT::Parser::DBI::PostgreSQL * Add column and table comments in SQLT::Parser::DBI::PostgreSQL(patch from Andrew Pam) +* Stop the DBI parser from disconnecting externally supplied DBI handles (RT#35868) * Fixed alter_drop_constraint for foreign keys and applying multiple changes via alter_field to a column in Postgres Producer * Added a working mechanism for naming foreign keys in the PostgreSQL producer * Fix PostgreSQL ignoring default values with specified data type +* Fix PostgreSQL parser support for (N)::int defaults (patch by Tina Müller) * Fix possible name duplication in SQLlite producer * Oracle does not accept ON DELETE/UPDATE RESTRICT (though it is the actual default) fix by not adding the ON DELETE/UPDATE clause at all * Changed dependency on Digest::SHA1 to the core-bundled Digest::SHA (RT#67989) * Support for double quoted and bit strings as default values in MySQL parser +* Improved VIEW support in MySQL parser * Proper handling of CURRENT_TIMESTAMP default values in MySQL parser (RT#65844) * Check in MySQL parser to avoid trying to parse a table defined twice in the same file as indices (and probably other things) get messed up @@ -33,7 +122,11 @@ * Fix ignored option to script/sqlt-diagram (RT#5992) * Fix t/17sqlfxml-producer.t failures due to whitespace differences introduced by environment config snippets (RT#70786) +* Fix assembly of Table objects with numbered columns being added out of order + (RT#74771) (based on patch from Jonathan Otsuka) +* Fix syntax error in SQL::Translator::Producer::Latex (RT#74953) * Deprecate SQL::Translator::Schema::Graph and the as_graph() schema method +* Bump minimum supported perl version to 5.8.1 (mostly due to Moo) # ---------------------------------------------------------- # 0.11010 2011-10-05