Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ddlutils-dev@db.apache.org
Message-ID: <31310398.1153286235263.JavaMail.jira@brutus>
Date: Tue, 18 Jul 2006 22:17:15 -0700 (PDT)
From: "Thomas Dudziak (JIRA)" <jira@apache.org>
To: ddlutils-dev@db.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)
In-Reply-To: <1512010482.1137776801969.JavaMail.jira@ajax.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

    [ 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