Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Incomplete
-
10.0.10
-
None
Description
In reading about the query cache, I came across an undocumented situation.
https://mariadb.com/kb/en/query-cache/
Basically, the cache should consume queries that always return the same results. With that said, I have noticed that the query cache will cache a query with a LIMIT clause without an ORDER BY clause. This seems incorrect because the LIMIT could return different results for different queries.
For completeness sake, I would suggest not caching queries that use a LIMIT without an ORDER BY clause.