X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=Changes;h=9b2e6cab2fed291d2c72150d2f930ac0a5c6d669;hb=ca4db6766e10b96c717fca81919e772d444af44e;hp=a8c17e76e890fb6ece9307c06f117714f5808ba3;hpb=938464eedb3957c058c18635aefac08188da4263;p=dbsrgits%2FSQL-Translator.git diff --git a/Changes b/Changes index a8c17e7..9b2e6ca 100644 --- a/Changes +++ b/Changes @@ -1,8 +1,109 @@ # ---------------------------------------------------------- -# x.xxxxx xxxx-xx-xx +# 0.11002 2009-08-28 # ---------------------------------------------------------- +* 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) + +# ---------------------------------------------------------- +# 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 +<<<<<<< .mine +* 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) +* Added CREATE VIEW subrules for mysql parser (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 +* XML parser switched from XML::XPath to XML::LibXML +* Pg producer ALTER TABLE/COLUMN and DROP DEFAULT support +* 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 +* 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 +>>>>>>> .r1584 # ---------------------------------------------------------- # 0.09004 2009-02-13