Skip to content

Can the features of Query Cache support subqueries? #51656

@lzf575

Description

@lzf575

I see that the feature of Query Cache has been completed
I tried it, and it supports the result cache of the entire statement, but does not support the result cache of subquery?
I would like to ask if it(cache subquery)is not supported, or it is my usage problem.

  • the SQL statement select a from (SubQueryA setting use_query_cache = 1), if the result of SubQueryA can be cached, then the execution performance of the statement select b from (SubQueryA) can also be improved?

If it is not supported, please tell me when it will be supported in the future?

  • the featue in changelog:image

Metadata

Metadata

Assignees

No one assigned

    Labels

    developmentDevelopement process & source code & implementation detailsfeature

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions