maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #01872
Re: doubt about view and query cache
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
Follow ups
References