Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
23.02, 23.08, 24.02, 25.01, 25.10
-
None
-
MXS-SPRINT-275
Description
With selects=verify_cacheable, the cache will not store the resultsets of SELECTs that use functions or fields that are not cacheable; e.g. CURRENT_TIME(). However, it does not detect all functions that could be detected.
A workaround is to create an unlike rule that causes SELECTs that use a particular function not to be cached.
Futher, the cache should also not cache the result of SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE.