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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.