tracker issue : CF-4170636

select a category, or use search below
(searches all categories and all time range)
Title:

[ANeff] Bug for: queryAddRow|Column() causes cachedQuery.getResult() to return NULL

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Aaron Neff / Aaron Neff (Aaron Neff)

Created: 07/05/2016

Components: Caching

Versions: 2016

Failure Type:

Found In Build/Fixed In Build: CF2016_Final /

Priority/Frequency: Normal / Few users will encounter

Locale/System: English / Win All

Vote Count: 0

queryAddRow(cachedQuery, ..)/queryAddColumn(cachedQuery, ..) causes cachedQuery.getResult() to return NULL

In CF11, cachedQuery.getResult() always returns the result struct (good). In CF2016, cachedQuery.getResult() returns NULL if queryAddRow|Column() was used on the cached query (bad).

Repro:

<cfscript>
  q1 = queryNew("foo", "", [["foobar"]]);
  q2 = queryExecute("SELECT foo FROM q1", [], {dbtype="query", cachedWithin=createTimeSpan(0,0,1,0)});
  q2.addRow({foo="foobar2"});
  q2.addColumn("bar", []);
  writeDump(q2.getResult());//returns result struct in CF11 (good), but returns undefined in CF2016 (bad)
</cfscript>

Actual result in build 2016.0.01.298513: undefined

Expected result in build 2016.0.01.298513 (and actual in build 11,0,07,296330): the result struct

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

Watson Bug ID:	4170636

External Customer Info:
External Company:  
External Customer Name: Aaron Neff
External Customer Email:

Attachments:

Comments:

Could you please apply an update to CF2016. Update 2 don't have this issue. cachedQuery.getResult() works.
Comment by Poonam J.
2237 | July 11, 2016 12:14:58 AM GMT
Hi Poonam, I've verified this is fixed in CF2016 Update 2 (build 2016.0.02.299200). Thanks!, -Aaron
Comment by External U.
2238 | July 13, 2016 12:48:16 AM GMT
Thanks Aaron for the response. I am closing this track.
Comment by Poonam J.
2239 | July 13, 2016 12:58:01 AM GMT
Hi Poonam, You're welcome and thanks very much! -Aaron
Comment by External U.
2240 | July 14, 2016 11:16:40 AM GMT