tracker issue : CF-4173565

select a category, or use search below
(searches all categories and all time range)


| View in Tracker

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

Listed in the version 2016.0.03.300466 Issues Fixed doc
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 2008


  1. July 19, 2016 00:00:00: 1_example.cfm


This issue is resolved now. The fix for this issue will be available as part of an upcoming update of ColdFusion 2016.
Comment by Nimit S.
2170 | August 08, 2016 07:53:31 AM GMT