db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-61) column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL) using files produced by databaseToDdl(from MSSQL)
Date Wed, 19 Jul 2006 05:17:15 GMT
    [ http://issues.apache.org/jira/browse/DDLUTILS-61?page=comments#action_12422037 ] 
            
Thomas Dudziak commented on DDLUTILS-61:
----------------------------------------

Could you state the row as it is in the database, e.g by copying from some SQL tool ? I'm
interested in the default value as it is in the database.
You can also try to run your test again, as I've made some changes to strip away stuff that
Sql Server adds to the concrete default value, like parentheses.

> 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

        

Mime
View raw message