Bug #72366 View SQL not being generated when placeholder turned off
Submitted: 17 Apr 2014 11:42 Modified: 14 May 2014 15:45
Reporter: Michael Peeler Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S2 (Serious)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: forward engineer, placeholder, Views
Triage: Needs Triage: D2 (Serious)

[17 Apr 2014 11:42] Michael Peeler
Generate the "FORWARD ENGINEER SQL CREATE SCRIPT" with the tables and views from the model developed within this tool.

How to repeat:
Create a table with 1 column.  Create a view to display this table.  "SELECT * FROM TBL_X".  Use the FORWARD ENGINEER SQL CREATE SCRIPT option to generate the SQL and generate the script with defaults.  The views will be the table style placeholders.

Repeat the process but this time select the option "Don't create table placeholder for views" and continue on with the same defaults as last time.

Your end results for SQL for the views will be the same.

Suggested fix:
Have it generate the SQL "create view X as select * from TBL_X" as it is supposed to.
[17 Apr 2014 12:41] Miguel Solorzano
Thank you for the bug report.
[14 May 2014 15:45] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.1.6 release, and here's the changelog entry:

The "Don't create table placeholder for views" option of the "Forward
Engineer SQL Create Script" wizard did not function.

Thank you for the bug report.