Bug #30995 CREATE VIEW without checking

Submitted: 13 Sep 2007 10:13 Modified: 16 Sep 2007 5:38
Reporter: Sebastian Mendel (Basic Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S4 (Feature request)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[13 Sep 2007 10:13] Sebastian Mendel
Description:
copying (all or selected) tables and views from one DB to another or import

produces an error if a view is created before the table/view derived from is created

How to repeat:
run an import with an SQL file or copy from one db to another providing first the VIEW than the table definition ...

Suggested fix:
add an option to CREATE VIEW which disables checking for required tables/views

f. e.:

CREATE VIEW ... NOCHECK

or (better?):

set DISABLE_VIEW_CHECK 1;
// run import or copy
// ...
set DISABLE_VIEW_CHECK 0;
[16 Sep 2007 5:38] Valeriy Kravchuk
Thank you for a reasonable feature request.

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

Page generated in 0.042 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.