-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Results WITH TOTALS were not cached in Query Cache #48677
Copy link
Copy link
Closed
Labels
potential bugTo be reviewed by developers and confirmed/rejected.To be reviewed by developers and confirmed/rejected.
Description
You have to provide the following information whenever possible.
Describe what's wrong
When WITH TOTALS and Query Cache are used in queries, the results returned by query cache do not contain the WITH TOTALS results.
Before the query cache takes effect
:) select t1,count() from t5 group by t1 with totals order by t1 desc limit 11
┌─t1─┬─count()─┐
│ aa │ 28 │
└────┴─────────┘
Totals:
┌─t1─┬─count()─┐
│ │ 28 │
└────┴─────────┘
After the query cache takes effect
:) select t1,count() from t5 group by t1 with totals order by t1 desc limit 11
┌─t1─┬─count()─┐
│ aa │ 28 │
└────┴─────────┘
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
potential bugTo be reviewed by developers and confirmed/rejected.To be reviewed by developers and confirmed/rejected.