Guys i'm with doubt about view and query cache

check:

reset query cache;

create table t (a int);

insert into t values (1);

insert into t values (2);

create view v as select * from t;

select * from teste.v;

select * from information_schema.QUERY_CACHE_QUERIES; (from mdev-4682)

select * from information_schema.QUERY_CACHE_QUERIES_tables; (from mdev-4682)

select * from information_schema.QUERY_CACHE_tables; (from mdev-4682)

at 2 last command, i got this:

|| *QUERY_CACHE_ID* || *SCHEMA* || *TABLE* ||

|| 1 || teste || ||

|| 1 || teste || t ||

|| *TABLE_SCHEMA* || *TABLE_NAME* || *TABLE_HASHED* || *TABLE_TYPE* || *QUERIES_IN_CACHE* ||

|| teste || t || 1 || NON_TRANSACT || 1 ||

|| teste || || 1 || NON_TRANSACT || 1 ||

the table "" shouldn't be "v" view? why it's blank?

Roberto Spadim