[DDLUTILS-61] column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL) using files produced by databaseToDdl(from MSSQL)

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.0 RC1
• Component/s: 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
• Assignee: Thomas Dudziak
• Reporter: Appajee Papolu
• Created: 21/Jan/06 02:05
• Updated: 04/Jun/07 02:33
• Resolved: 10/Oct/06 18:05

Description

• 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.

Issue Links

• is cloned by: DDLUTILS-62 column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL) using files produced by databaseToDdl(from MSSQL)