X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=Changes;h=9c06b9b71f3964bff0ef34f9908fa6f339899595;hb=3b9249fb0058ac9896a10c9ca8b87ddd40f6c074;hp=38681b675ccdf86820d790fab423c8df1399a438;hpb=467b72826293d3d134832d31ccd3c398dbcca3cb;p=dbsrgits%2FSQL-Translator.git diff --git a/Changes b/Changes index 38681b6..9c06b9b 100644 --- a/Changes +++ b/Changes @@ -1,16 +1,121 @@ +* Fix Producer::Oracle generation of too long unique constraint names +* Producer::Oracle tests now use Test::Differences +* Prettify output of SQLite producer (less bogus newlines) +* Augment SQLite and Pg producers to accept a perl-formatted + (%d.%03d%03d) *_version producer args (to facilitate direct + use of the DBIC normalized rdbms version) + +# ---------------------------------------------------------- +# 0.11006 +# ---------------------------------------------------------- +* Fix Producer::Oracle varchar2 without size def (ORA-00906: missing right parenthesis) +* Fix Producer::Oracle translate float and double to float instead of number + +# ---------------------------------------------------------- +# 0.11005 2010-02-24 +# ---------------------------------------------------------- +* Fix Parser::DBI::Oracle reading too many tables (RT#49413) +* Fix Parser::MySQL tripping up on PRIMARY KEY ... USING (currently value is ignored) (RT#50468) +* Fix runaway debug trace (RT#52276) +* Fix Parser::PostgreSQL choking on commit; statements in DDL (#RT52277) +* Producer::Oracle now respects quote_field|table_names, and + no longer does name munging of reserved table names +* Producer::Oracle now correctly outputs databse-unique index names + +# ---------------------------------------------------------- +# 0.11004 2010-02-14 +# ---------------------------------------------------------- +* Fix PG producer numeric precision regression (RT#49301) +* Add DB2 producer numeric/decimal precision output +* Fix Oracle producer creating numeric precision statements that the test case expects (no whitespace) +* Add Oracle producer creating drop view statements like PG producer does +* Fix SQL::Translator::Diff to use producer_args instead of producer_options + +# ---------------------------------------------------------- +# 0.11003 2009-09-28 +# ---------------------------------------------------------- +* Pg parser fixes to deal properly with MATCH +* Pg parser fixes to parse timestamp attributes correctly +* Fix broken default detection in script/sqlt (RT#27438) +* Fix dependency issues with LibXML and TT + +# ---------------------------------------------------------- +# 0.11002 2009-08-30 +# ---------------------------------------------------------- +* Depend on fixed Parse::RecDescent +* Added skip-tables and skip-tables-like options to Diagram + +# ---------------------------------------------------------- +# 0.11001 2009-08-18 +# ---------------------------------------------------------- +* Removed last use of Readonly +* Adjusted YAML dependency + # ---------------------------------------------------------- -# x.xxxxx xxxx-xx-xx +# 0.11000 2009-08-18 # ---------------------------------------------------------- -* Adjust two tests so they pass under prove -l -* Add missing dependency on IO::Scalar +* Re-add version numbers to files, else cpan's "upgrade" gets very confused +* Replaced code using Readonly, since most of the rest uses constant, and thats already a dep +* Moved YAML and XML::LibXML back to recommends, the tests for both now skip if not installed +* Bumped to 0.11000 to supercede 0.10 which has incorrect numbering scheme + +# ---------------------------------------------------------- +# 0.10 2009-08-13 +# ---------------------------------------------------------- +* Resolved the following RT bugs (thanks to everyone for reporting!): +25791 does not recognize PostgreSQL ON_ERROR_STOP +29265 sqlt-diagram: --natural-join needs Graph::Directed +37814 SQLite translator failing to parse schema +42548 Producer::PostgreSQL incorrectly inserts the size in + 'time(stamp)? with(out) time zone' fields +43173 SQL::Translator::Parser without versionnumber - will install + old 0.09002 +46805 (No subject) +47026 META.yml is not packaged due to MANIFEST.SKIP (easyfix) +32130 Move from XML::XPath to XML::LibXML::XPathContext +22261 MySQL parse +13915 missing optional prerequisite cause make test to fail +8847 Diagram.pm: BINMODE missing in printing of graphic file. +21065 GraphViz producer fails on tables named 'node' +35448 Producer::PostgreSQL types without size +22026 sqlt-diagram uses -f arg twice +47897 [PATCH] Fix uninitialized value within @_ in (uc|lc) +47668 Mysql Parser doesn't recognize key types +46448 sqlt-graph errors out on MySQL DDL with btree keys +47176 Add Foreign Key support to Parser::DBI::PostgreSQL.pm +48025 MySQL Producer: Case inconsistency between elements in + @no_length_attr and $data_type +48569 sqlt-diagram fails to load SQLite schema +48596 SQL::Translator::Diff::schema_diff should produce a list in + list context +44907 SQL::Translator::Producer::PostgreSQL produce() in list context + should return a list of statements + +# ---------------------------------------------------------- +# 0.09007 2009-06-25 +# ---------------------------------------------------------- +* Fixed Pg parser - caching the compiled P::RD schema is a *very* + bad idea +* Fix MSSQL handling of ON UPDATE/DELETE RESTRICT +* Delay MSSQL FK constraint deployment until after all CREATE TABLE + statements +* Coerce other engine's bytea/blob/clob datatypes to VarBinary + +# ---------------------------------------------------------- +# 0.09006 2009-06-10 +# ---------------------------------------------------------- +* Multiple test and dependency adhustments to make smokers happy +* Fix YAML producer wrt extra attribute +* Added support for "time(stamp) (p) with time zone" for Pg producer (mo) # ---------------------------------------------------------- # 0.09005 2009-06-08 # ---------------------------------------------------------- * Add parser support for MySQL default values with a single quote * Properly quote absolute table names in the MySQL producer -* Added semi-colon for (DROP|CREATE) TYPE statements in the Pg producer (wreis) * Added CREATE VIEW subrules for mysql parser (wreis) +* Many fixes to code and tests for trigger's "database_events" +* Added semi-colon for (DROP|CREATE) TYPE statements in the Pg producer (wreis) * ALTER TABLE/ALTER COLUMN/DROP DEFAULT support in Pg producer (mo) * XML parser support for multi-event triggers * SQLite producer support for multi-event triggers