Bug #30507 MySQL migraction wizard will use empty_clob() while Server does not support it

• Submitted: 20 Aug 2007 13:42
• Modified: 20 Aug 2007 16:24
• Reporter: Gunnar von Boehn
• Status: Duplicate
• Category: MySQL Migration Toolkit
• Severity: S2 (Serious)
• Version: 1.1.12
• OS: Any
• CPU Architecture: Any

[20 Aug 2007 13:42] Gunnar von Boehn

Description:
When trying to migrate an Oracle database to MySQL.
The Migration Toolkit will use Oracle specific SQL.

Oracle blob definitions will be translated to this:
`ldtrec` LONGTEXT BINARY NULL DEFAULT empty_clob()

As the MySQL server does not support empty_clob() this will not work.

How to repeat:
Try to convert an Oracel database which uses empty_clob() as the blob default value

Suggested fix:
Remove empty_clob() from created SQL

[20 Aug 2007 16:24] Valeriy Kravchuk

Please do not submit the same bug more than once. An existing bug report, bug #28484, already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.