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.