Bug #86878 SQL script not included in the script generated by the 'Forward engineering...'
Submitted: 29 Jun 2017 20:44 Modified: 30 Jun 2017 8:00
Reporter: Kuba Gasiorowski Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:6.3.9 OS:Microsoft Windows
Assigned to: CPU Architecture:Any
Tags: forward engineering, sql script

[29 Jun 2017 20:44] Kuba Gasiorowski
Description:
The script defined in the model 'SQL scripts' section is not added to database creation script generated by 'Forward engineering SQL CREATE script' menu option. None of the SQL script forward engineering options 'Top of the script', 'Before DDL', 'After DDL', etc. works -> all they behave like 'Do not include'.
Expected behavior is to add this script according to the selected 'forward engineering' option to the generated database creation script.

Bug is similar to #76521, however the script does not disappear when closed. The only problem is that it is not being included in the creation script when doing 'forward engineering SQL CREATE script'.

How to repeat:
Define a model with the SQL script and generate database creation script with 'Forward engineering SQL CREATE script' menu option.

Suggested fix:
The script should be attached to the DB create script according to the selected 'forward engineering' script option when doing 'forward engineering SQL CREATE script'.
[29 Jun 2017 20:45] Kuba Gasiorowski
Sample model with one table and sql script

Attachment: test.mwb (application/octet-stream, text), 6.36 KiB.

[30 Jun 2017 8:00] Umesh Shastry
Hello Kuba Gasiorowski,

Thank you for the report and model file.
Verified as described with WB 6.3.9 on Win7.

Thanks,
Umesh
[16 Sep 2017 15:14] Zoltan Czirkos
This bug also affects the Linux version (well, obviously, it's not really an OS-specific problem)