X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=Changes;h=e1a2946ddcb7bd258d5f57906dc5ea86eef1c20a;hb=1ced2a25380c28174c07743b19820ec6d1d4f74f;hp=98d71c16875318fe6c88a3a328f57b1d3e155769;hpb=6e64adbe068b34d9fdad49f6bcd02fb265ca0bce;p=dbsrgits%2FSQL-Translator.git diff --git a/Changes b/Changes index 98d71c1..e1a2946 100644 --- a/Changes +++ b/Changes @@ -1,9 +1,93 @@ +* 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 + +# ---------------------------------------------------------- +# 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 + +# ---------------------------------------------------------- +# 0.11000 2009-08-18 +# ---------------------------------------------------------- +* 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) + # ---------------------------------------------------------- -# x.xxxxx xxxx-xx-xx +# 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 @@ -12,7 +96,23 @@ * MySQL producer skips length attribute for columns which do not support that attribute. Currently following column types are added to that list: date time timestamp datetime year -* Sitch to Module::Install (mandates minimum perl 5.005) +* Switch to Module::Install (mandates minimum perl 5.005) +* Major cleanup of GraphViz proucer +* Massive amount of fixes to SQLite/Pg/Mysql/MSSQL parsers/producers + Fix most of the problems uncovered by the roundtrip test framework + Some highlights: + - Rewind exhausted globs before attempting a read + - Do not add xml comment header if no_comments is set + - table/field counts are held per schema object, not globally + - no more variable table and column names in SQLite and MSSQL + - VIEW support for Pg parser, also some cleanups + - The way we generate Pg create view statements was not standards compliant + (per RhodiumToad in #postgresql) + - Disable MSSQL view/procedure production - they never worked in the first place + - SQLite/MSSQL improvements: + - Support parsing of all DROP clauses + - Support parsing of field-level comments + - When producing do not append table names to constraint/index names # ---------------------------------------------------------- # 0.09004 2009-02-13