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:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.1.4.11773 OS:Any
Assigned to: CPU Architecture:Any
Tags: forward engineer, placeholder, Views

[17 Apr 2014 11:42] Michael Peeler 
Description:
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] MySQL Verification Team 
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.