[MDEV-7642] Insert queries using CURDATE in query cache Created: 2015-02-27  Updated: 2015-02-27

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Marc Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

I'm not sure, if the entries in the query cache have an expiry time, if so, queries using CURDATE/CURRENT_DATE/... could also be inserted in the cache an last there up to 24 hours.
If you have many queries in the form
select ... WHERE `date` between (CURRENT_DATE - INTERVAL 1 WEEK) AND CURRENT_DATE()
the cache is not used.
Generated at Thu Feb 08 07:21:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.