- Add parser support for MySQL default values with a single quote
- Properly quote absolute table names in the MySQL producer
- 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
- 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
- Support parsing of all DROP clauses
- Rewind exhausted globs before attempting a read