You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Appajee Papolu (JIRA)" <ji...@apache.org> on 2006/01/20 18:06:41 UTC
[jira] Created: (DDLUTILS-61) column DEFAULT - SQL error during
create table in databaseToDdl( to MySQL) using files produced by
ddlToDatabase(from MSSQL)
column DEFAULT - SQL error during create table in databaseToDdl( to MySQL) using files produced by ddlToDatabase(from MSSQL)
-------------------------------------------------------------------------------------------------------------------------------
Key: DDLUTILS-61
URL: http://issues.apache.org/jira/browse/DDLUTILS-61
Project: DdlUtils
Type: Bug
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
- 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
[jira] Updated: (DDLUTILS-61) column DEFAULT - SQL error during
create table in ddlToDatabase( to MySQL) using files produced by
databaseToDdl(from MSSQL)
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-61?page=all ]
Thomas Dudziak updated DDLUTILS-61:
-----------------------------------
Fix Version: 1.0
> 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
> Type: Bug
> 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
> Assignee: 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
[jira] Commented: (DDLUTILS-61) column DEFAULT - SQL error during
create table in ddlToDatabase( to MySQL) using files produced by
databaseToDdl(from MSSQL)
Posted by "Appajee Papolu (JIRA)" <ji...@apache.org>.
[ 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
[jira] Resolved: (DDLUTILS-61) column DEFAULT - SQL error during
create table in ddlToDatabase( to MySQL) using files produced by
databaseToDdl(from MSSQL)
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-61?page=all ]
Thomas Dudziak resolved DDLUTILS-61.
------------------------------------
Resolution: Fixed
This should be fixed (as noted in my previous comment).
> 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
[jira] Updated: (DDLUTILS-61) column DEFAULT - SQL error during
create table in ddlToDatabase( to MySQL) using files produced by
databaseToDdl(from MSSQL)
Posted by "Appajee Papolu (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-61?page=all ]
Appajee Papolu updated DDLUTILS-61:
-----------------------------------
Summary: column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL) using files produced by databaseToDdl(from MSSQL) (was: column DEFAULT - SQL error during create table in databaseToDdl( to MySQL) using files produced by ddlToDatabase(from MSSQL))
> 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
> Type: Bug
> 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
> Assignee: Thomas Dudziak
>
> - 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
[jira] Updated: (DDLUTILS-61) column DEFAULT - SQL error during
create table in ddlToDatabase( to MySQL) using files produced by
databaseToDdl(from MSSQL)
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-61?page=all ]
Thomas Dudziak updated DDLUTILS-61:
-----------------------------------
Component: Core - SqlServer
> 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
> 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
> Assignee: 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
[jira] Commented: (DDLUTILS-61) column DEFAULT - SQL error during
create table in ddlToDatabase( to MySQL) using files produced by
databaseToDdl(from MSSQL)
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ 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