Bug #38337 Creating a view with replace clause
Submitted: 24 Jul 2008 8:54 Modified: 29 Jul 2008 15:43
Reporter: Sören Krings Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0 Revision 3198 OS:Windows (XP 64)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any
Tags: sql create script, VIEW

[24 Jul 2008 8:54] Sören Krings 
Description:

If you create a new view with an OR REPLACE clause the sql create script output contains the OR REPLACE clause twice.

How to repeat:
Create a new view:

CREATE OR REPLACE  `test`.`fooview` AS
select `foo` from bar;

The script output will be:

CREATE OR REPLACE  OR REPLACE `test`.`fooview` AS
select `foo` from bar;

Suggested fix:

Check if there is already an OR REPLACE clause.
[29 Jul 2008 10:29] Johannes Taxacher 
this is fixed now. fix will be in release 5.0.24
[29 Jul 2008 15:43] Tony Bedford 
Added an entry to the 5.0.24 changelog:

If you created a new view with an OR REPLACE clause, the Forward Engineer SQL CREATE Script output contained the OR REPLACE clause twice.