Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Aaron Neff / Aaron Neff (Aaron Neff)
Created: 11/15/2015
Components: Caching
Versions: 11.0
Failure Type:
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Major / Most users will encounter
Locale/System: English / Windows 10 64 bit
Vote Count: 2
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.Attachments:
Comments: