[ http://issues.apache.org/jira/browse/DDLUTILS-111?page=all ]
Vincent Siveton updated DDLUTILS-111: ------------------------------------- Attachment: DDLUTILS-111.diff A naive approach could be to catch the AssertionFailedError for mysql (see the patch). But, the best way is to change the API to include silent change... It is a big patch due to a lot of trailing whitespaces. Maybe consider using anyedit Eclipse plugin (http://andrei.gmxhome.de/anyedit/index.html) > Handle Silent Column Specification Changes in the test cases > ------------------------------------------------------------ > > Key: DDLUTILS-111 > URL: http://issues.apache.org/jira/browse/DDLUTILS-111 > Project: DdlUtils > Type: Bug > Components: Tests > Environment: trunk + mysql 4.1 > Reporter: Vincent Siveton > Assignee: Thomas Dudziak > Attachments: DDLUTILS-111.diff > > In some cases, MySQL silently changes column specifications from those given > in a CREATE TABLE or ALTER TABLE statement [1] > So TestAlteration.testAddColumns() failed with: > junit.framework.ComparisonFailure: Type not the same for column avalue4. > expected:<...> but was:<VAR...> > at junit.framework.Assert.assertEquals(Assert.java:81) > at > org.apache.ddlutils.io.RoundtripTestBase.assertEquals(RoundtripTestBase.java:441) > at > org.apache.ddlutils.io.RoundtripTestBase.assertEquals(RoundtripTestBase.java:369) > at > org.apache.ddlutils.io.RoundtripTestBase.assertEquals(RoundtripTestBase.java:315) > at > org.apache.ddlutils.io.TestAlteration.testAddColumns(TestAlteration.java:526) > [1] http://dev.mysql.com/doc/refman/5.0/en/silent-column-changes.html -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira