Ops :) that's a bug, i will create a jira issue

2014-09-24 15:48 GMT-03:00 Roberto Spadim <roberto@spadim.com.br>:

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

--

Roberto Spadim
SPAEmpresarial

Eng. Automação e Controle