X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=Changes;h=e86953978a5d34722b862b80eb33f7ac9cb7472d;hb=715b82950282ae3475e24d9b5c407d8d112399dc;hp=efa208c19594187144c1209d892f3f19a9a8a594;hpb=0dbd236211c36acbb89774189389357f48631685;p=dbsrgits%2FSQL-Translator.git diff --git a/Changes b/Changes index efa208c..e869539 100644 --- a/Changes +++ b/Changes @@ -1,3 +1,53 @@ +* All parser grammars are now precompiled for speed +* 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 +* 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) +* 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 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 +* 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) + +# ---------------------------------------------------------- +# 0.11010 2011-10-05 +# ---------------------------------------------------------- + +* Add "if exists" to drop view statements in Pg. + +# ---------------------------------------------------------- +# 0.11009 2011-09-02 +# ---------------------------------------------------------- + +* Fix MySQL producer to properly quote all table names on output (patch from geistteufel) + +# ---------------------------------------------------------- +# 0.11008 2011-05-04 +# ---------------------------------------------------------- * Correctly create and parse FK constraints in SQLite * Correct postgis geography type insertion and linebreak fix for multiple geometry/geography columns @@ -8,6 +58,8 @@ * Quote everything in SQL Server * Turn off constraints before dropping tables in SQL Server * Make true unique constraints if needed in SQL Server +* Fixed Producer::PostgresSQL to output array type after type size, + i.e. varchar(64)[] rather than varchar[](64) # ---------------------------------------------------------- # 0.11007 2010-11-30