Skip to content

EXPLAIN CACHES doesn't reflect changes to fallback behavior #306

@ayymart

Description

@ayymart

If you cache a query:

CREATE CACHE FROM SELECT * FROM t WHERE c=1;

And then re-cache it, modifying the above statement to disallow fallback to upstream:

CREATE CACHE ALWAYS FROM SELECT * FROM t WHERE c=1;

Then the output of SHOW CACHES contains no fallback as expected, but the output of EXPLAIN CACHES doesn't include ALWAYS.

Also, after doing the above, if you DROP CACHE and recreate the cache using ALWAYS, you will see two copies of the same query in EXPLAIN CACHES.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Low priorityCreated by Linear-GitHub SyncbugSomething isn't working

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions