SQL-Translator (0.11007)

Really nice tool, but found some problem while compare existing Database schema in MySQL and schema defined by XML SQLFairy using SQL::Translator::Diff.

The problem is that SQL::Translator::Parser::MySQL parses default field's value NULL as is, but SQL::Translator::Parser::XML for default NULL value sets undef (see cpan.uwinnipeg.ca/htdocs/SQL-Translat....

This makes SQL::Translator ::Diff to generate unnecessary ALTERs for nullable fields with default value NULL.

Alexander Fat - 2010-12-20T02:45:29