Status/Resolution/Reason: Closed/Withdrawn/Duplicate
Reporter/Name(from Bugbase): Giancarlo Gomez / Giancarlo Gomez (Giancarlo Gomez)
Created: 05/02/2016
Components: Database
Versions: 11.0
Failure Type:
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Major / All users will encounter
Locale/System: English / Win 2012 Server x64
Vote Count: 1
Duplicate ID: CF-4087462
Problem Description: Caching Not Working with QueryExecute
Steps to Reproduce: Test with the following code, set your own SQL string.
<cfset sqlString = "SELECT TOP 5 productID FROM products" />
<cfquery name="q1" cachedWithin="#createTimeSpan(0, 1, 0, 0)#">
#sqlString#
</cfquery>
<cfscript>
writeDump(q1);
writeDump(
QueryExecute(
sqlString,
{},
{ cachedWithin :createTimeSpan(0, 1, 0, 0), name: "q2"}
)
);
writeDump(
new Query(
sql : sqlString,
cachedWithin : createTimeSpan(0, 1, 0, 0),
name : "q3"
).execute().getResult()
);
</cfscript>
Actual Result: q2 is never cached
Expected Result: q2 to be cached
Any Workarounds: don't use QueryExecute
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4147522
External Customer Info:
External Company:
External Customer Name: Giancarlo Gomez
External Customer Email:Attachments:
Comments: