Bug #85012 Forward Engineer SQL Options are MISSING
Submitted: 15 Feb 2017 17:46 Modified: 9 Feb 2018 21:28
Reporter: Kuthair Habboush Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:6.3.9 OS:MacOS (macOS 10.12.x Sierra x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[15 Feb 2017 17:46] Kuthair Habboush 
Description:
The SQL Options are missing from the Forward Engineer SQL Script dialog.

Please see attached screenshot.

How to repeat:
1. Open a DB Model.

2. Click on File.

3. Click on Export.

4. Click on Forward Engineer SQL CREATE Script...
[15 Feb 2017 17:48] Kuthair Habboush 
Forward Engineer SQL Script dialog, missing SQL Options.

Attachment: missing_sql_options.png (image/png, text), 78.48 KiB.
[15 Feb 2017 20:35] MySQL Verification Team 
Thank you for the bug report. Verified as described.
[1 Mar 2017 13:54] MySQL Verification Team 
https://bugs.mysql.com/bug.php?id=85249 marked as duplicate of this one.
[26 Mar 2017 16:10] MySQL Verification Team 
https://bugs.mysql.com/bug.php?id=85628 marked as duplicate of this one.
[25 Jul 2017 15:47] Michael Floeser 
Workbench generates "SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;” but when the script is executed it reports the error:

Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails . . .
[11 Sep 2017 20:32] Rebecca Page 
I am having the same issues wiith SQL Workbench 6.3.9 (64 bit) on Mac OS X 10.12.6 (Sierra).  I do not know about 6.3.9 on another platform, but I tried the same steps on SQL Workbench 6.2 (32 bit) on Ubuntu 17.04 and everthing worked.  That made me decide to back my iMac version down one level, which was SQL Workbench 6.2 (32 bit).  Note, I could not find a 64 bit version of 6.2.  And again everything worked.  The problem lies in the 6.3.9 release for Mac OS X.  I also want to take he time to point out that on the 6.3.9 release.  The Catalog Tree does not display any text, only the icons, so in order to move a table to an EER Diagram you litteraly have to do it “blind"
[9 Feb 2018 21:28] Christine Cole 
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.0 release, and here's the changelog entry:

All SQL options were missing during the SQL Export Options step of the
Forward Engineering SQL Script wizard when a valid model was exported and
the host platform was macOS.

Thank you for the bug report.