CF-4087462

Title

[ANeff] Bug for: QueryExecute() ignores CachedWithin

Description

QueryExecute() ignores CachedWithin regardless if "Use internal cache to store queries" is enabled or not.

Repro:

1) Run this

<cfscript>
  q = queryExecute("SELECT artName FROM art WHERE artID = 1", [], {datasource="cfartgallery", cachedwithin=createTimeSpan(0,0,0,15)});
  writeOutput(q.artName);
  queryExecute("UPDATE art SET artName = 'charles1_temp' WHERE artID = 1", [], {datasource="cfartgallery"});
  q = queryExecute("SELECT artName FROM art WHERE artID = 1", [], {datasource="cfartgallery", cachedwithin=createTimeSpan(0,0,0,15)});
  writeOutput(q.artName);
</cfscript>

Expected output: charles1charles1

Actual output: charles1charles1_temp

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4087462

External Customer Info:
External Company:  
External Customer Name: Aaron Neff
External Customer Email:  
External Test Config: Verified in CF11 Update 5 (build 11,0,05,293506). The issue does not exist in build 11,0,0,296013. But the issue should be fixed in CF11 as query caching is a commonly used feature and should be reliable w/o requiring version upgrade.

Comments

Will this be fixed in a future update for CF11?

Comment by External U.

03/02/2016 19:21:50 GMT

Hi Adobe, +1 to Carl's question. Are you only fixing this in CF2016? It should also be fixed in -CF11-. So, to repeat Carl's question, will this be fixed in CF11? You know it'd streamline communication if you populate the "Fixed In Build" field. Thanks!, -Aaron

Comment by External U.

04/01/2016 13:03:58 GMT

This issue is fixed and it will be available as part of an upcoming update of ColdFusion 11.

Comment by Nimit S.

04/02/2016 22:27:27 GMT

Verified this is fixed in CF2106 Update 1 (build 2016.0.01.298513). This should be listed on https://helpx.adobe.com/content/dam/help/attachments/cf2016-issues-fixed.pdf, since CF11's fix came after CF2016 was released. Thanks!, -Aaron

Comment by Aaron N.

07/26/2017 08:09:15 GMT

Status:

Closed

Details

Date Created:

11/15/2015

Component:

Caching

Version:

Gold Master

Failure Type

Found In Build:

CF11_Final

Fixed In Build:

Priority:

Major

Frequency:

Most users will encounter

System:

Windows 10 64 bit

Browser:

Resolution

Fixed

Reason Code:

Votes:

Vote Comments:

+1 ..... Have noticed similar behavior.

Comment by External U.

11/15/2015 22:09:07 GMT

+1 Will be moving to CF11 soon and will need to be able to cache queries using queryExecute().

Comment by External U.

11/16/2015 09:45:46 GMT