Query Caching with cachedwithin = 0| View in Tracker
Failure Type: Non Functioning
Found In Build/Fixed In Build: ColdFusion 2016 Update 3 / 303574
Priority/Frequency: Normal / All users will encounter
Locale/System: English / Windows 10 64 bit
Vote Count: 3
Problem Description: I just recently switched my developer environment to ColdFusion 2016. We were previously running ColdFusion 11. We cache queries using the query tag cachedwithin. When we update the database, and rerun the query with a cachedwithin timespan of 0, ColdFusion 11 updates the cache and has the current data. In ColdFusion 2016, the query returns the current data, however, the cache is not updated as well. If you go to another page, or refresh the current page, that uses the same query cache, the data is no longer updated. Steps to Reproduce: 1. Cache a query with cachedwithin="#CreateTimeSpan(0, 1, 0, 0)#". 2. Update the database, rerun the query with cachedwithin="#CreateTimeSpan(0, 0, 0, 0)#". Reload the page with the query with cachedwithin="#CreateTimeSpan(0, 1, 0, 0)#". Results will be old data. Actual Result: Old data returned with old cache. Expected Result: New data returned. Any Workarounds:Run the cacheRemove function on the query id.
- August 08, 2017 00:00:00: 20170807_4198513.zip