SELECT VERSION(); -- 5.0.90-community-nt

USE test;

DROP TABLE IF EXISTS k;

CREATE TABLE k (a VARCHAR(20));

DROP TABLE IF EXISTS l;

CREATE TABLE l (b VARCHAR(20));

CREATE VIEW m AS SELECT k.a, l.b FROM k,l;

ALTER TABLE `test`.`k` CHANGE `a` `aa` VARCHAR(20);

SHOW CREATE VIEW m; --success

SHOW FULL FIELDS FROM m;

/*

Error Code : 1356

View 'test.m' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them*/

SELECT VERSION(); -- 5.1.57-community

USE test;

DROP TABLE IF EXISTS k;

CREATE TABLE k (a VARCHAR(20));

DROP TABLE IF EXISTS l;

CREATE TABLE l (b VARCHAR(20));

DROP VIEW IF EXISTS m;

CREATE VIEW m AS SELECT k.a, l.b FROM k,l;

ALTER TABLE `test`.`k` CHANGE `a` `aa` VARCHAR(20);

SHOW CREATE VIEW m;

/*

Error Code : 1356

View 'test.m' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them */

SHOW FULL FIELDS FROM m; -- same error

SELECT * FROM `information_schema`.`VIEWS` WHERE table_name = 'm' -- success!!

SELECT * FROM `INFORMATION_SCHEMA`.`VIEWS` WHERE TABLE_SCHEMA='database' AND TABLE_NAME='view_name'

MariaDB [private_17_production]> show create view data_view_854;

ERROR 1356 (HY000): View 'private_17_production.data_view_854' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

MariaDB [private_17_production]> show create table data_view_854;

ERROR 1356 (HY000): View 'private_17_production.data_view_854' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

MariaDB [private_17_production]> desc data_view_854;

ERROR 1356 (HY000): View 'private_17_production.data_view_854' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them