MySQL Bugs: #86878: SQL script not included in the script generated by the 'Forward engineering...'

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:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	forward engineering, sql script

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'.

Sample model with one table and sql script

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

Hello Kuba Gasiorowski,

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

Thanks,
Umesh

This bug also affects the Linux version (well, obviously, it's not really an OS-specific problem)

Hi,

I'm on Mac -- macOS Catalina 10.15.3.

This is still broken on Mac with latest production release of MySQL Workbench 8.0.19.