maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

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