tracker issue : CF-4126391

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

[ANeff] Bug for: duplicate() not including rows/columns of cached queries

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

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

Created: 03/09/2016

Components: Database, General

Versions: 2016

Failure Type:

Found In Build/Fixed In Build: RC1_v12 /

Priority/Frequency: Normal / Some users will encounter

Locale/System: English / Win All

Vote Count: 0

Listed in the version 2016.0.01.298513 Issues Fixed doc
Verification notes: verified_fixed on July 30, 2017 using build 2016.0.01.298513
duplicate() not including rows/columns of cached queries

Repro:

<cfscript>
  q = queryNew("foo", "varchar", [["bar"]]);
  q2 = queryExecute("SELECT * FROM q", [], {dbtype="query", cachedwithin=createTimeSpan(0,0,0,10)});
  q3 = duplicate(q2);
  writeDump(q3);
  
  q4 = queryExecute("SELECT * FROM art WHERE artID = 1", [], {datasource="cfartgallery", cachedwithin=createTimeSpan(0,0,0,10)});
  q5 = duplicate(q4);
  writeDump(q5);
</cfscript>

Actual result: The duplicated queries have 0-rows/0-columns

Expected result: The duplicated queries have all rows and columns

Workaround: None; Uninstall CF2016 and revert to CF11

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

Watson Bug ID:	4126391

External Customer Info:
External Company:  
External Customer Name: Aaron Neff
External Customer Email: adobelabs@itisdesign.com
External Test Config:

Attachments:

Comments:

Adding BUG AUDIT TRAIL ********action: updated fieldName: Fix By Milestone newValue: Post Release oldValue: Alpha oprid: vmannebo recordName: RQ_DEFECT timpestamp: 2016-02-12 07:29:51.0 action: updated fieldName: Fix By Product Milestone newValue: HF1 oldValue: Alpha oprid: vmannebo recordName: RQ_DEFECT timpestamp: 2016-02-12 07:29:51.0 action: updated fieldName: Severity newValue: 3 oldValue: 4 oprid: hkallae recordName: RQ_DEFECT timpestamp: 2016-02-12 05:18:19.0 action: updated fieldName: Priority newValue: 2 oldValue: 0 oprid: hkallae recordName: RQ_DEFECT timpestamp: 2016-02-12 05:18:19.0 action: updated fieldName: Status newValue: ToTest oldValue: ToFix oprid: himar recordName: RQ_DEFECT timpestamp: 2016-02-11 08:53:12.0 action: updated fieldName: Date Fixed newValue: 2016-02-11 00:53:11.0 oldValue: Blank oprid: himar recordName: RQ_DEFECT timpestamp: 2016-02-11 08:53:12.0 action: updated fieldName: Fixed By newValue: himar oldValue: Blank oprid: himar recordName: RQ_DEFECT timpestamp: 2016-02-11 08:53:12.0 action: updated fieldName: Owner newValue: nimsharm oldValue: himar oprid: himar recordName: RQ_DEFECT timpestamp: 2016-02-11 08:53:12.0 action: updated fieldName: Changelist newValue: 298011 oldValue: Blank oprid: himar recordName: RQ_DEFECT timpestamp: 2016-02-11 08:53:12.0 action: updated fieldName: Reason newValue: Fixed oldValue: Blank oprid: himar recordName: RQ_DEFECT timpestamp: 2016-02-11 08:53:12.0 action: updated fieldName: Fix By Product Milestone newValue: Alpha oldValue: Blank oprid: hkallae recordName: RQ_DEFECT timpestamp: 2016-02-11 04:46:40.0 action: updated fieldName: Fix By Milestone newValue: Alpha oldValue: Blank oprid: hkallae recordName: RQ_DEFECT timpestamp: 2016-02-11 04:46:40.0 action: updated fieldName: Owner newValue: himar oldValue: aksriniv oprid: hkallae recordName: RQ_DEFECT timpestamp: 2016-02-11 04:46:29.0 action: updated fieldName: Reason newValue: Blank oldValue: Blank oprid: hkallae recordName: RQ_DEFECT timpestamp: 2016-02-11 04:46:29.0 action: updated fieldName: Status newValue: ToFix oldValue: Unverified oprid: hkallae recordName: RQ_DEFECT timpestamp: 2016-02-11 04:46:29.0 action: updated fieldName: QE Assigned newValue: nimsharm oldValue: aksriniv oprid: hkallae recordName: RQ_DEFECT timpestamp: 2016-02-11 04:46:29.0 action: updated fieldName: Dev Assigned newValue: himar oldValue: sanniset oprid: hkallae recordName: RQ_DEFECT timpestamp: 2016-02-11 04:46:29.0
Comment by CFwatson U.
4297 | March 09, 2016 01:54:03 AM GMT
Added By: PreRelease User User Name:Adam Cameron Note Added: This does not appear to be fixed. See https://bugbase.adobe.com/index.cfm?event=bug&id=CF-4122530 Date Added :2016-02-27 18:25:46.0 Added By: PreRelease User User Name:Aaron Neff Note Added: q3.getMetadata().getColumnLabels() returns ["foo"] q5.getMetadata().getColumnLabels() returns ["ARTID","ARTISTID","ARTNAME","DESCRIPTION","PRICE","LARGEIMAGE","MEDIAID","ISSOLD"] q3.getMetadata().getExtendedMetadata() returns undefined q5.getMetadata().getExtendedMetadata() returns undefined So.. the columns are there. Maybe it has something to do w/ the NULL extended metadata? Date Added :2016-02-10 17:46:49.0 Added By: PreRelease User User Name:Aaron Neff Note Added: q3.RecordCount returns 1 q5.RecordCount returns 1 q3.ColumnList returns [empty string] q5.ColumnList returns [empty string] So.. the duplicated queries do have rows. They just has 0 columns. Date Added :2016-02-10 17:27:53.0 Added By: PreRelease User User Name:Aaron Neff Note Added: Entered Bug. Date Added :2016-02-10 17:08:18.0
Comment by CFwatson U.
4298 | March 09, 2016 01:54:04 AM GMT
This issue is fixed now. The fix will be available as part of upcoming update of ColdFusion 2016.
Comment by Nimit S.
4299 | March 27, 2016 05:57:15 AM GMT
Hi Nimit, Thanks very much! -Aaron
Comment by External U.
4300 | July 05, 2016 01:40:11 AM GMT
Hi Adobe, Please change "Reported By External User" to "Reported By Aaron Neff". Thanks!, -Aaron
Comment by External U.
4301 | July 05, 2016 01:40:50 AM GMT
Verified, on April 12, 2016, that this is fixed in CF2016 Update 1 (build 2016.0.01.298513). Thanks!, -Aaron
Comment by Aaron N.
4302 | July 30, 2017 06:18:23 PM GMT