← Back to team overview

maria-discuss team mailing list archive

Re: doubt about view and query cache

 

https://mariadb.atlassian.net/browse/MDEV-6781
created

2014-09-24 15:56 GMT-03:00 Roberto Spadim <roberto@xxxxxxxxxxxxx>:

> Ops :) that's a bug, i will create a jira issue
>
> 2014-09-24 15:48 GMT-03:00 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
>>
>
>
>
> --
> Roberto Spadim
> SPAEmpresarial
> Eng. Automação e Controle
>



-- 
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle

References