Bug #54137 ER_VIEW_INVALID should be split into more specific errors

• Submitted: 1 Jun 2010 11:56
• Modified: 1 Jun 2010 12:24
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Verified
• Category: MySQL Server: Errors
• Severity: S4 (Feature request)
• Version: 5.1.47, 5.5.3
• OS: Any
• CPU Architecture: Any
• Tags: ER_VIEW_INVALID

[1 Jun 2010 11:56] Shane Bester

Description:
ER_VIEW_INVALID is defined as
"View '%-.192s.%-.192s' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them"

It's not evident whether the view's problem is structural or permissions.
We should return an error that identifies which it is.

How to repeat:
drop table if exists t1,v1;
create table t1(a int)engine=myisam;
create or replace view v1 as select a from t1;
drop table if exists t1;
select * from v1; #fails