Bug #36707 Extra OR REPLACE when forward engineering DB

• Submitted: 14 May 2008 5:19
• Modified: 14 Jun 2008 6:31
• Reporter: Jesse Jarrell
• Status: No Feedback
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 5.0.21 SE
• OS: Windows
• CPU Architecture: Any

[14 May 2008 5:19] Jesse Jarrell

Description:
When forward engineering a DB model or exporting a SQL script that contains views, an extra OR REPLACE is generated in the view's CREATE command.

CREATE OR REPLACE  OR REPLACE VIEW `viewName` AS 
SELECT ....

How to repeat:
Forward engineer any model that contains a view.

Suggested fix:
Determine in logic where the "OR REPLACE" is added and remove the extra one.

[14 May 2008 6:31] Valeriy Kravchuk

Thank you for a problem report. Please, upload sample model to forward engineer to demonsrate the behaviour described. I can not repeat it in my simple tests.

[14 May 2008 12:59] Jesse Jarrell

Sample model including view

Attachment: sampleModel.mwb (application/octet-stream, text), 11.86 KiB.

[14 May 2008 13:00] Jesse Jarrell

Sample Forward Engineer CREATE script - duplicate OR REPLACE on line 206

Attachment: sampleExport.sql (text/x-sql), 7.52 KiB.

[14 Jun 2008 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".