Bug #5812 Query decomposition and query cache support
Submitted: 29 Sep 2004 20:25 Modified: 7 Nov 2005 22:57
Reporter: Mark Nicholas Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version: OS:
Assigned to: Assigned Account CPU Architecture:Any

[29 Sep 2004 20:25] Mark Nicholas 
Description:
As I understand it the following SQL would not be able to take advantage of the query cache:
select * from a where col1=condition1;
select * from a where col1=condition1 and col2=condition2;

I would suggest that it would be benifical if queries were decomposed into their composing subqueries and that the query cache processing look to see if appropriate queries and subqueries are present to optimze from.

Thanks.

How to repeat:
Try any simple simple queries matching description

Suggested fix:
requires design and development
[7 Oct 2005 22:57] Hartmut Holzgraefe 
what makes you think these queries wouldn't be cached?
[8 Nov 2005 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".