[ http://issues.apache.org/jira/browse/DDLUTILS-61?page=comments#action_12442190 ] Appajee Papolu commented on DDLUTILS-61: ----------------------------------------
[[ Old comment, sent by email on Mon, 31 Jul 2006 13:37:32 -0700 ]] Thomas, Thanks for the note. I will retry my attempt later this week and hopefully every thing would work as I expect. Otherwise, I will let you know. As noted in the other email, unfortunately I do not have previously produced ddlutils data files and I do not quite remember the the specific table/row/column that caused the following error. So I can not provide you with the actual data in this case. But as I said if I run into any issue later, I will definitely let you know. Thanks again! Appajee > column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL) > using files produced by databaseToDdl(from MSSQL) > ------------------------------------------------------------------------------------------------------------------------------- > > Key: DDLUTILS-61 > URL: http://issues.apache.org/jira/browse/DDLUTILS-61 > Project: DdlUtils > Issue Type: Bug > Components: Core - SqlServer > Environment: Windows 2K > MSSQL 2000 > JDBC Driver - jtds > MySQL 5.0 > JDBC driver - MySQL Connector/J - mysql-connector-java-5.0.0-beta > Reporter: Appajee Papolu > Assigned To: Thomas Dudziak > Fix For: 1.0 > > > - Dumped out a database from MSSQL using ddlutils ant task > - Using these files, attempting creating the equivalent database on MySQL 5.0 > > - Getting few errors as below: > CREATE TABLE `whatever` > ( > `col1` INTEGER NOT NULL, > `col2` INTEGER NOT NULL, > `col3` CHAR(1) DEFAULT '('0')' NULL > ) failed with You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use near > '0')' NULL > - I changed the col3 line to as follows and then the ddltodatabase works fine > `col3` CHAR(1) DEFAULT '0' NULL > - I could not find info if there were any user configurable settings that can > overcome this problem. -- 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
