update Changes
[dbsrgits/SQL-Translator.git] / Changes
CommitLineData
3b9249fb 1* Fix Producer::Oracle generation of too long unique constraint names
2* Producer::Oracle tests now use Test::Differences
6af0ff59 3* Prettify output of SQLite producer (less bogus newlines)
4* Augment SQLite and Pg producers to accept a perl-formatted
98ff5583 5 (%d.%03d%03d) and 3-part (X.X.X) *_version producer args
6af0ff59 6
e0ae2f7d 7# ----------------------------------------------------------
7b8cffe3 8# 0.11006
9# ----------------------------------------------------------
10* Fix Producer::Oracle varchar2 without size def (ORA-00906: missing right parenthesis)
07720cf1 11* Fix Producer::Oracle translate float and double to float instead of number
7b8cffe3 12
13# ----------------------------------------------------------
e0ae2f7d 14# 0.11005 2010-02-24
15# ----------------------------------------------------------
1f5b2625 16* Fix Parser::DBI::Oracle reading too many tables (RT#49413)
17* Fix Parser::MySQL tripping up on PRIMARY KEY ... USING (currently value is ignored) (RT#50468)
18* Fix runaway debug trace (RT#52276)
19* Fix Parser::PostgreSQL choking on commit; statements in DDL (#RT52277)
e0ae2f7d 20* Producer::Oracle now respects quote_field|table_names, and
fb2ccad1 21 no longer does name munging of reserved table names
06debaa8 22* Producer::Oracle now correctly outputs databse-unique index names
1f5b2625 23
24# ----------------------------------------------------------
25# 0.11004 2010-02-14
26# ----------------------------------------------------------
f4428c33 27* Fix PG producer numeric precision regression (RT#49301)
28* Add DB2 producer numeric/decimal precision output
64ac5763 29* Fix Oracle producer creating numeric precision statements that the test case expects (no whitespace)
30* Add Oracle producer creating drop view statements like PG producer does
1f5b2625 31* Fix SQL::Translator::Diff to use producer_args instead of producer_options
f4428c33 32
6142e635 33# ----------------------------------------------------------
34# 0.11003 2009-09-28
35# ----------------------------------------------------------
343e2a8c 36* Pg parser fixes to deal properly with MATCH <type>
b5a782a0 37* Pg parser fixes to parse timestamp attributes correctly
3e1ed76b 38* Fix broken default detection in script/sqlt (RT#27438)
39* Fix dependency issues with LibXML and TT
343e2a8c 40
1d195bd6 41# ----------------------------------------------------------
b6790235 42# 0.11002 2009-08-30
475a7db7 43# ----------------------------------------------------------
44* Depend on fixed Parse::RecDescent
45* Added skip-tables and skip-tables-like options to Diagram
46
47# ----------------------------------------------------------
1d195bd6 48# 0.11001 2009-08-18
49# ----------------------------------------------------------
50* Removed last use of Readonly
51* Adjusted YAML dependency
11ad2df9 52
53# ----------------------------------------------------------
54# 0.11000 2009-08-18
55# ----------------------------------------------------------
56* Re-add version numbers to files, else cpan's "upgrade" gets very confused
57* Replaced code using Readonly, since most of the rest uses constant, and thats already a dep
58* Moved YAML and XML::LibXML back to recommends, the tests for both now skip if not installed
59* Bumped to 0.11000 to supercede 0.10 which has incorrect numbering scheme
60
347abf9d 61# ----------------------------------------------------------
ba506e52 62# 0.10 2009-08-13
8d693a85 63# ----------------------------------------------------------
ba506e52 64* Resolved the following RT bugs (thanks to everyone for reporting!):
9d69b5b7 6525791 does not recognize PostgreSQL ON_ERROR_STOP
6629265 sqlt-diagram: --natural-join needs Graph::Directed
6737814 SQLite translator failing to parse schema
ba506e52 6842548 Producer::PostgreSQL incorrectly inserts the size in
69 'time(stamp)? with(out) time zone' fields
9d69b5b7 7043173 SQL::Translator::Parser without versionnumber - will install
71 old 0.09002
7246805 (No subject)
7347026 META.yml is not packaged due to MANIFEST.SKIP (easyfix)
7432130 Move from XML::XPath to XML::LibXML::XPathContext
7522261 MySQL parse
7613915 missing optional prerequisite cause make test to fail
778847 Diagram.pm: BINMODE missing in printing of graphic file.
7821065 GraphViz producer fails on tables named 'node'
7935448 Producer::PostgreSQL types without size
8022026 sqlt-diagram uses -f arg twice
8147897 [PATCH] Fix uninitialized value within @_ in (uc|lc)
8247668 Mysql Parser doesn't recognize key types
8346448 sqlt-graph errors out on MySQL DDL with btree keys
8447176 Add Foreign Key support to Parser::DBI::PostgreSQL.pm
8548025 MySQL Producer: Case inconsistency between elements in
86 @no_length_attr and $data_type
8748569 sqlt-diagram fails to load SQLite schema
8848596 SQL::Translator::Diff::schema_diff should produce a list in
89 list context
9044907 SQL::Translator::Producer::PostgreSQL produce() in list context
ba506e52 91 should return a list of statements
c1e2579f 92
b245a5f3 93# ----------------------------------------------------------
94# 0.09007 2009-06-25
95# ----------------------------------------------------------
9fa2a755 96* Fixed Pg parser - caching the compiled P::RD schema is a *very*
97 bad idea
f9a5ee79 98* Fix MSSQL handling of ON UPDATE/DELETE RESTRICT
99* Delay MSSQL FK constraint deployment until after all CREATE TABLE
100 statements
101* Coerce other engine's bytea/blob/clob datatypes to VarBinary
9fa2a755 102
c1e2579f 103# ----------------------------------------------------------
104# 0.09006 2009-06-10
105# ----------------------------------------------------------
01bdc5ca 106* Multiple test and dependency adhustments to make smokers happy
107* Fix YAML producer wrt extra attribute
ad258776 108* Added support for "time(stamp) (p) with time zone" for Pg producer (mo)
109
bd3c4e06 110# ----------------------------------------------------------
111# 0.09005 2009-06-08
112# ----------------------------------------------------------
8b075c9f 113* Add parser support for MySQL default values with a single quote
8d693a85 114* Properly quote absolute table names in the MySQL producer
ba506e52 115* Added CREATE VIEW subrules for mysql parser (wreis)
116* Many fixes to code and tests for trigger's "database_events"
938464ee 117* Added semi-colon for (DROP|CREATE) TYPE statements in the Pg producer (wreis)
90726ffd 118* ALTER TABLE/ALTER COLUMN/DROP DEFAULT support in Pg producer (mo)
19f36a90 119* XML parser support for multi-event triggers
120* SQLite producer support for multi-event triggers
121* XML parser switched from XML::XPath to XML::LibXML
122* Pg producer ALTER TABLE/COLUMN and DROP DEFAULT support
de176728 123* MySQL producer skips length attribute for columns which do not support that
124 attribute. Currently following column types are added to that list:
125 date time timestamp datetime year
0a2d7cf1 126* Switch to Module::Install (mandates minimum perl 5.005)
bd3c4e06 127* Major cleanup of GraphViz proucer
0a2d7cf1 128* Massive amount of fixes to SQLite/Pg/Mysql/MSSQL parsers/producers
129 Fix most of the problems uncovered by the roundtrip test framework
130 Some highlights:
131 - Rewind exhausted globs before attempting a read
132 - Do not add xml comment header if no_comments is set
133 - table/field counts are held per schema object, not globally
134 - no more variable table and column names in SQLite and MSSQL
0a2d7cf1 135 - VIEW support for Pg parser, also some cleanups
136 - The way we generate Pg create view statements was not standards compliant
137 (per RhodiumToad in #postgresql)
bd3c4e06 138 - Disable MSSQL view/procedure production - they never worked in the first place
0a2d7cf1 139 - SQLite/MSSQL improvements:
140 - Support parsing of all DROP clauses
141 - Support parsing of field-level comments
142 - When producing do not append table names to constraint/index names
8d693a85 143
144# ----------------------------------------------------------
b419bb2c 145# 0.09004 2009-02-13
347abf9d 146# ----------------------------------------------------------
3e98f7d9 147* Add support for temporary tables in Pg (nachos)
d0fcb05d 148* Create Trigger support for SQLite
347abf9d 149* GraphViz producer improvements
d0fcb05d 150
ec59a597 151# ----------------------------------------------------------
b419bb2c 152# 0.09003 2009-02-07
153# ----------------------------------------------------------
154 <BORKED RELEASE DELETED OFF CPAN>
155
156# ----------------------------------------------------------
5094211e 157# 0.09002 2008-12-05
ec59a597 158# ----------------------------------------------------------
3406fd5b 159* parsing MySQL CURRENT_TIMESTAMP as scalar ref so it can be produced without
160 quotes (jgoulah)
f7f81963 161* Add ignore_opts parser arg (to ignore table options) in Parser::MySQL (jgoulah)
cc48d354 162* Skip tests for buggy Spreadsheet::ParseExcel versions (rbo)
7d89539d 163* Add support for skip tables parser arg in Parser::DBI::MySQL (jgoulah)
3406fd5b 164* Changed behaviour of ::Producer::Oracle when returning an array of statements
165 to make it compatible to DBI->do()
64f82436 166* Fixed a few bugs in ::Producer::Oracle
9a96648f 167* Applied patch from jgoulah to support mysql's MERGE option
8742e408 168* Applied patch from rbo to add support of multiple database events on a trigger
3406fd5b 169* Applied patch from lukes to allow drop if exists in sqlite producer, with
170 version >= 3.3
171* Applied patch from rjbs with minor changes, now we support scalar refs in
172 default values!
24d9fe69 173* Fixed SQLite producer to end index statements in newlines, in scalar context
174* Decreed that all list context statements shall not end in ; or ;\n
175* Fixed SQLite, Diff and MySQL producers to agree with Decree.
296c2701 176* Added support for CREATE VIEW + tests in the Pg producer (wreis)
ec59a597 177* Added support for CREATE VIEW + tests in the sqlite producer (groditi)
3406fd5b 178* Added proper argument parsing and documentation to MySQL Parser and
179 Producer (ribasushi)
180* Using DROP VIEW instead of OR REPLACE clause in the Pg producer, as replace
181 only allows replacement with identical set of columns (wreis)
182* Added support for DROP VIEW and fixed CREATE VIEW statement in the sqlite
183 producer (wreis)
184* Removed source_db and target_db accessors from Diff (throwback to old version,
185 only output_db is used)
e30b71b8 186
187
3406fd5b 188* Support for longer varchar fields in MySQL
e802b210 189
c6e5ac68 190# ----------------------------------------------------------
191# 0.09001 2008-08-19
192# ----------------------------------------------------------
d28afa66 193* Added support for CREATE VIEW + tests in the mysql producer (groditi)
7c1aae02 194* Added support for SET fields in the mysql producer + test (groditi)
3406fd5b 195* Added support for proper booleans in the mysql producer, when a mysql version
196 of at least 4.x is supplied
197* Added support for proper enums under pg (as of 8.3), with pg version check,
198 and deferrable constraints
199* Added support to truncate long constraint and index names in the mysql
200 producer, because of a change to DBIx::Class to produce such long names in
201 some cases.
e802b210 202
13243123 203# ----------------------------------------------------------
c6e5ac68 204# 0.09000 2008-02-25
13243123 205# ----------------------------------------------------------
da5a1bae 206
296c2701 207* Fix Pg produces idea of which field types need a size param (wreis)
a7f49dfb 208* Add support for COLLATE table option to MySQL parser
bb4c66d1 209* Allow DEFAULT CHARACTER SET without '=' (as produced by mysqldump)
a7f49dfb 210
da5a1bae 211# -----------------------------------------------------------
11bebd6e 212# 0.0899_02 2008-01-29
213# ----------------------------------------------------------
214
215* Major refactoring of SQL::Translator::Diff again:
216* Diff is no longer one huge monolithic function.
217* Added more tests for diff
3406fd5b 218* When producing diffs for MySQL you will (by default) get single alter
219 statements per table
220* SQLite can also do remove columns (by creating a temp table as shown in
221 http://sqlite.org/faq.html#q11
222* Columns can be renamed if the new schema is from a form that can have metadata
223 (which is pretty much anything but an SQL file.) It does this by looking at
224 renamed_from in the $field->extra
11bebd6e 225* Updated Oracle and Postgres producers
226* More tests!
227
228# -----------------------------------------------------------
da5a1bae 229# 0.0899_01 2007-10-21
230# ----------------------------------------------------------
231
232* SQL::Translator::Diff now uses the ::Producer modules to create diffs
233 This *will* break back-compatibility
234 Use sqlt-diff-old for the previous one, and fix producers!
235
18a8d640 236# -----------------------------------------------------------
f51d8e46 237# 0.08001 2007-09-26
238# ----------------------------------------------------------
239
240* Patched to ignore all TT versions >= 2.15 until TT is fixed :(
241
242# -----------------------------------------------------------
243# 0.08 2006-12-07
244# -----------------------------------------------------------
245
3406fd5b 246* Patched 18ttschema-producer.t and 33tt-table-producter.t to skip on TT 2.15,
247 thanks Ash!
f51d8e46 248
249# -----------------------------------------------------------
af27376e 250# 0.08_04 2006-11-10
251# -----------------------------------------------------------
252
fb149f81 253* Patched MySQL producer to name constraints sanely, thanks Ash
af27376e 254* Added patch to Producer::DB2 to avoid dependency issues with foreign keys
255* Added patch to remove single quotes for numeric default values in Producer::DB2
256* Fixed Parser::SQLite to require a semicolon after a create trigger statement
ca1b7c76 257* Added patch from avinash to add CASCADE to pg table drops
af27376e 258
259# -----------------------------------------------------------
f39e9c12 260# 0.08_03
261# -----------------------------------------------------------
262
263* Added patch to use default values for Pg timestamp fields
264
265# -----------------------------------------------------------
266# 0.08_02 2006-11-03
267# -----------------------------------------------------------
268
3406fd5b 269* Added patch from Ash to separate DROP statements in mysql producer in
270 list-context
f39e9c12 271* Fixed up SQLites usage of no-comments
272
273# -----------------------------------------------------------
18a8d640 274# 0.08_01 2006-07-23
275# -----------------------------------------------------------
6cedfc23 276
18a8d640 277* Made Trigger check that a give table exists in on_table - castaway
3406fd5b 278* Split some producers (DB2, MySQL, SQLite, PostgreSQL) into sub methods (others
279 to follow) - castaway
280* Add alter_* methods to some Producers and docs to Producer.pm (for use by Diff
281 later) - castaway
18a8d640 282* Made changes to allow producers to return a list of statements - castaway
283* Split sqlt-diff into script and module - castaway
284* Added quote_table_names and quote_field_names patch (omega, zamolxes) - castaway
285* Added DB2 Producer - castaway
6cedfc23 286* Added mysql_character_set for 4.1+ -mda
8dc6a4a3 287* New filters, Names and Globals. -mda
35a1938f 288* Added the initial work on a template based Dia UML producer. -mda
6cedfc23 289
f5d44dd7 290# -----------------------------------------------------------
18a8d640 291# 0.07 2005-06-10
f5d44dd7 292# -----------------------------------------------------------
1ded8513 293* YAML parser supports extra attributes on tables.
294
7fc38348 295* All schema objects now support the extra attribute, so can
296 have arbitary name/value data attached to them.
297
298* Refactoring: Added SQL::Translator::Schema::Object - base
299 class for all Schema objects.
300
13aec984 301* Changes to MySQL Parser (Dave Howorth)
302 - ignore INSERT statements
303 - permit ALTER TABLE ADD FOREIGN KEY
304 - allow trailing comma on last field in CREATE statements
305 - collect the database name
306
f9725390 307* TTSchema Producer
308 - Can pass extra variables using tt_vars producer arg.
309 - Can pass extra config using tt_conf producer arg.
310 - Variables and config can be passed on the command line
311 with --tt-var and --tt-conf options to sqlt.
312
185c34d5 313* Added schema filters.
f9725390 314
5a0c7b43 315* MySQL Producer
316 - Added 'mysql_table_type' extra attribute on tables.
317 - Works out InnoDB tables from constraints.
1ded8513 318 - mysql_charset and mysql_collate extra attributes for tables and fiels.
5a0c7b43 319
320
c4bf7f53 321# -----------------------------------------------------------
322# 0.06 2004-05-13
323# -----------------------------------------------------------
324* Added SQL::Translator::Manual
325
326* Installation process now uses Module::Build
327
328* Added new "Dumper" producer
329
3e069fa1 330* Changed the native SQL Fairy XML format to a fixed mapping.
331 *NB:* You should convert your existing XML schema. See the
332 SQL::Translator::Parser::XML::SQLFairy docs.
333
334* Added producers: TT::Base and TT::Table.
335
eabd66e6 336# -----------------------------------------------------------
7c67b302 337# 0.05 2004-02-27
338# -----------------------------------------------------------
bc40219c 339* Added "COMMENT ON *" syntax to PostgreSQL parser
340
341* Some fixes to Oracle parser as reported by Gail Binkley
342
343* Added support in PostgreSQL parser for all "ALTER TABLE" statements
7c67b302 344
345* Now distributing sqlt-diff script as it's pretty usable
346
347* Added new options to sqlt-graph and GraphViz producer (Dave Cash)
348
349# -----------------------------------------------------------
d6b47dd5 350# 0.04 2003-11-07
eabd66e6 351# -----------------------------------------------------------
b9952639 352
d6b47dd5 353* Increased version of Constants module to 1.41 to avoid a problem
354 where 0.02 has 1.4 of that file and 0.03 had 1.06 which confused
355 CPAN
356
357* Hard-coded all the PREREQ_PM modules in Makefile.PL (rather than
358 setting them dynamically) so that automated tests would pass
359
360# -----------------------------------------------------------
361# 0.03 2003-11-06
362# -----------------------------------------------------------
363
364* Added parsers: XML::SQLFairy, Sybase, SQLite, DBI-MySQL,
365 DBI-PostgreSQL, DBI-SQLite, DBI-Sybase, Storable, YAML
366
367* Added producers: XML::SQLFairy, TTSchema, Storable, YAML
368
369* HTML producer now uses stylesheets to allow easy customization of colors
370
371* Many bug fixes to most every module
372
373* Added "sqlt-dumper" script to help create a script for dumping
374 a database a la "mysqldump"
375
376* Reversed the arrowheads on the graphical producers to show the
377 relationships in a more standard way
378
379* Changes all included script names to start with "sqlt"
380
381* Added capturing and printing most embedded table and field comments
b9952639 382
eabd66e6 383# -----------------------------------------------------------
384# 0.02 2003-06-17
385# -----------------------------------------------------------
b9952639 386
eabd66e6 387* Added parsers for Excel and Oracle
b9952639 388
eabd66e6 389* Removed Sybase parser because it didn't actually work
b9952639 390
eabd66e6 391* Added ClassDBI, Diagram, GraphViz, HTML, POD, SQLite, Sybase producers
b9952639 392
eabd66e6 393* Added Schema classes to represent schema as objects
b9952639 394
eabd66e6 395* Removed "Raw" producer in favor of the Schema classes
b9952639 396
eabd66e6 397* Removed "Validator" class as the Schema classes validate themselves
b9952639 398
eabd66e6 399* Improved all existing parsers and producers, expanding them to
400 handle foreign keys much better, produce better output, etc.
b9952639 401
eabd66e6 402* Added sqlt-diagram.pl and sqlt-graphviz.pl as CLI frontends to the
403 graphical producers
b9952639 404
eabd66e6 405* Added sql_translator.cgi as a web-form frontend to graphical producers
150797b1 406
eabd66e6 407* Expanded test suite
d3e95970 408
409# -----------------------------------------------------------
d6b47dd5 410# 0.01 2003-02-27
f6aed479 411# -----------------------------------------------------------
412
7c67b302 413* Added parsers: XML::SQLFairy, Sybase, SQLite, DBI-MySQL,
414 DBI-PostgreSQL, DBI-SQLite, DBI-Sybase, Storable, YAML
415
416* Added producers: XML::SQLFairy, TTSchema, Storable, YAML
417
418* HTML producer now uses stylesheets to allow easy customization of colors
419
420* Many bug fixes to most every module
421
422* Added "sqlt-dumper" script to help create a script for dumping
423 a database a la "mysqldump"
424
425* Reversed the arrowheads on the graphical producers to show the
426 relationships in a more standard way
427
428* Changes all included script names to start with "sqlt"
429
430* Added capturing and printing most embedded table and field comments