X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=Changes;h=7131d887008c3c6108f6f44749d928f4d55d6db6;hb=3f281c08cba69dc1e4ba3b6ca4a8758e9c6e2aa3;hp=a0cc90eeb478717388f139bcbd996baf61f1ad47;hpb=c96cd4a82bc9447c278ecf2416a7f8fb052853a7;p=dbsrgits%2FSQL-Translator.git diff --git a/Changes b/Changes index a0cc90e..7131d88 100644 --- a/Changes +++ b/Changes @@ -1,13 +1,62 @@ +!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! +*** 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 +* 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 +* 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 +* Workaround for some MySQL quirks on primary key definitions +* Fix dropping primary keys in MySQL diffs (RT#62250, patch from Nick Bertrand) +* MySQL producer does not attempt to write out non-existent unique constraint names +* MySQL parser correctly differentiates between signed and unsigned integer column + display sizes +* Replace Class::Accessor::Fast dependency with already-included Moo +* Entire codebase is now free of tabs and trailing whitespace +* Spellfixes (RT#68912) +* Fix Diagram Producer POD (RT#71397, RT#71398) +* Fix Diagram Producer to use correct binmode on output (RT#71399) +* 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