Bug #18282 INFORMATION_SCHEMA.TABLES provides inconsistent info about invalid views

Description:
When definitions of several views using stored functions are processed in order to build contents of I_S.TABLES, information about validity of these view might be wrong.

See "how to repeat" section for clarification.

How to repeat:
drop database mysqltest;
create database mysqltest;
\u mysqltest
create table t1 (i int);
create function f1 () returns int return (select max(i) from t1);
create view v1 as select f1();
create table t2 (id int);
create function f2 () returns int return (select max(i) from t2);
create view v2 as select f2();
select table_name, table_type, table_comment from information_schema.tables where table_schema='mysqltest';
#+------------+------------+---------------+
#| table_name | table_type | table_comment |
#+------------+------------+---------------+
#| t1         | BASE TABLE |               |
#| t2         | BASE TABLE |               |
#| v1         | VIEW       | VIEW          |
#| v2         | VIEW       | VIEW          |
#+------------+------------+---------------+

drop table t2;
select table_name, table_type, table_comment from information_schema.tables where table_schema='mysqltest';
# The fact that v2 is invalid is not reported!!!
#+------------+------------+---------------+
#| table_name | table_type | table_comment |
#+------------+------------+---------------+
#| t1         | BASE TABLE |               |
#| v1         | VIEW       | VIEW          |
#| v2         | VIEW       | VIEW          |
#+------------+------------+---------------+

drop table t1;
select table_name, table_type, table_comment from information_schema.tables where table_schema='mysqltest';
# Note the difference between v1 and v2 !!!
#+------------+------------+----------------------------------------------------------------------------------+
#| table_name | table_type | table_comment                                                                    |
#+------------+------------+----------------------------------------------------------------------------------+
#| v1         | VIEW       | View 'mysqltest.v1' references invalid table(s) or column(s) or #function(s) or d |
#| v2         | VIEW       | VIEW                                                                             |
#+------------+------------+----------------------------------------------------------------------------------+

Thank you for the bug report.

Jim, 

Be sure and have Gluh be one of your reviewers.  Thanks!

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/4273

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/5452

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/6561

Approved by email (second reviewer).

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/7001

fixed in 5.0.23

Noted in 5.0.23 changelog.

INFORMATION_SCHEMA.TABLES provided inconsistent info about invalid
views. This could cause server crashes or result in incorrect data
being returned for queries that attempt to obtain information from
INFORMATION_SCHEMA tables about views using stored functions.