Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Aaron Neff / Aaron Neff (Aaron Neff)
Created: 03/09/2016
Components: Caching
Versions: 2016
Failure Type: Unspecified
Found In Build/Fixed In Build: Beta2_v12 /
Priority/Frequency: Trivial / Unknown
Locale/System: English / Win All
Vote Count: 0
cached query breaks serializeJSON()
Repro:
<cfscript>
q = queryExecute("SELECT * FROM art WHERE artID = 1", [], {datasource="cfartgallery", cachedWithin=createTimeSpan(0,0,0,30)});
writeDump(q);
writeDump(serializeJSON(q));
</cfscript>
Actual serializeJSON(q) result: {"COLUMNS":[],"DATA":[[]]}
Expected serializeJSON(q) result: {"COLUMNS":["ARTID","ARTISTID","ARTNAME","DESCRIPTION","PRICE","LARGEIMAGE","MEDIAID","ISSOLD"],"DATA":[[1,1,"charles1","Pastels/Charcoal",10000,"aiden01.jpg",1,1]]}
Thanks to David for coming across this. Related thread: http://prerelease.adobe.com/r/?8214383bf8d743d4baead8f89becdbbd
The cached query issues have been plentiful. Please put extra focus on this area.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4126485
External Customer Info:
External Company:
External Customer Name: Aaron Neff
External Customer Email: adobelabs@itisdesign.com
External Test Config:Attachments:
Comments: