Bug #26743 | Created SQL Syntax failed for "DEFAULT USER" | ||
---|---|---|---|
Submitted: | 1 Mar 2007 9:02 | Modified: | 30 Apr 2007 9:06 |
Reporter: | Rolf LANG | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Migration Toolkit | Severity: | S3 (Non-critical) |
Version: | 1.1.11, 1.1.10, 1.1.9 | OS: | Windows (Win XP) |
Assigned to: | CPU Architecture: | Any |
[1 Mar 2007 9:02]
Rolf LANG
[4 Mar 2007 19:40]
Valeriy Kravchuk
Please, try to repeat with a newer version, 1.1.10 (from GUI Tools 5.0-r10), and inform about the results.
[5 Mar 2007 8:35]
Rolf LANG
2007-03-05 Thanks for advise to try newer version. I could reproduce the bug using 1.1.10. The generated SQL statement still has an illegal syntax CREATE TABLE ... ...`field-name` varchar(30) BINARY NOT NULL DEFAULT USER .... I think Oracles SQL supports "DEFAULT USER", where MySQL doesn't.
[24 Apr 2007 10:20]
Valeriy Kravchuk
This is a bug, as default value is just copied from Oracle. Verified by code review of 1.1.11.
[30 Apr 2007 9:06]
Michael G. Zinner
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at http://dev.mysql.com/doc/en/installing-source.html