Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Tim Soslow / Tim Soslow (Tim Soslow)
Created: 07/19/2016
Components: Database
Versions: 2016
Failure Type:
Found In Build/Fixed In Build: CF2016_Update2 /
Priority/Frequency: Major / All users will encounter
Locale/System: English / Linux Ubuntu 14.04
Vote Count: 0
Problem Description:
cfquery returns cached results even when the cachedafter date is updated to be after the date of the cached data
Steps to Reproduce:
See example.cfm to reproduce
Actual Result:
On the last row, the "Database Return" date is a cached date, even though the result says that it is not cached. If you run this page again, the "Database Return" date will all be the same even though the "Cached" column says some of the results should not be cached. To reset the test, you must clear query cache in CF Administrator.
Expected Result:
The "Database Return" column should have a different datetime for every row except the 3rd row which should be cached. Running the example.cfm page a second time should also work instead of just displaying the previously saved return.
Any Workarounds:
Do not use cachedafter
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4173565
External Customer Info:
External Company:
External Customer Name: Tim Soslow
External Customer Email:
External Test Config: My Hardware and Environment details:
ColdFusion 2016.0.02.299200 installed on Ubuntu 14.04.2 LTS and Apache
Microsoft SQL Server 2008Attachments:
- July 19, 2016 00:00:00: 1_example.cfm
Comments: