Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Aaron Neff / Aaron Neff (Aaron Neff)
Created: 03/09/2016
Versions: 2016
Failure Type:
Found In Build/Fixed In Build: Alpha_v12 /
Priority/Frequency: Critical / Most users will encounter
Locale/System: English / Win All
Vote Count: 1
Related Bugs:
CF-4073814 - Similar to
QoQ breaks on cached query
Repro:
<cfscript>
q1 = queryExecute("SELECT artID FROM art WHERE artID = 1", [], {datasource="cfartgallery", cachedwithin=createTimeSpan(0,0,1,0)});//cachedwithin breaks future QoQ
q2 = queryExecute("SELECT * FROM q1", [], {dbtype="query"});
writeDump(var=[q2.getResult(), q2.RecordCount], format="text");
/*
Returns:
----------------------
array
1) [struct]
CACHED: false
EXECUTIONTIME: 0
RECORDCOUNT: 0
SQL: SELECT * FROM q1
2) 0 (bug: should be 1)
---------------------- */
q3 = queryNew("myCol", "", [["a"]]);
q4 = queryExecute("SELECT myCol FROM q3", [], {dbtype="query", cachedwithin=createTimeSpan(0,0,1,0)});//cachedwithin breaks future QoQ
writeDump(var=[q4.getResult(), q4.RecordCount], format="text");
q5 = queryExecute("SELECT myCol FROM q4", [], {dbtype="query"});
writeDump(var=[q5.getResult(), q5.RecordCount],format="text");
/*
Returns:
----------------------
array
1) [undefined array element] (bug: should be result struct)
2) 1
array
1) [struct]
CACHED: false
EXECUTIONTIME: 0
RECORDCOUNT: 0
SQL: SELECT myCol FROM q4
2) 0 (bug: should be 1)
----------------------
*/
</cfscript>
Workaround: Don't use cached queries.
Please provide fix ASAP via CF Admin's update mechanism so that I can test Raijin on more servers.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4126554
External Customer Info:
External Company:
External Customer Name: Aaron Neff
External Customer Email: adobelabs@itisdesign.com
External Test Config:Attachments:
Comments: