tracker issue : CF-4126387

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

[ANeff] Bug for: queryNew() mistreating ordered struct

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

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

Created: 03/09/2016

Components: Language

Versions: 2016

Failure Type:

Found In Build/Fixed In Build: RC1_v12 /

Priority/Frequency: Major / Some users will encounter

Locale/System: English / Win All

Vote Count: 0

Listed in the version 2016.0.02.299200 Issues Fixed doc
queryNew() mistreats ordered struct

Repro 1 (3rd parameter is struct):

<cfscript>
  s = [a="a",b="b"];
  q = queryNew("a,b", "varchar,varchar", s);
  writeDump(q);
</cfscript>

Actual result: exception: "Only struct or array of struct is allowed for adding a row"

Expected results: query created successfully

Repro 2 (3rd parameter is array-of-struct):

<cfscript>
  s = [a="a",b="b"];
  q = queryNew("a,b", "varchar,varchar", [s]);
  writeDump(q);
</cfscript>

Actual result: puts s into q.a[1] (very bad b/c this is data corruption)

Expected results: query created correctly

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

Watson Bug ID:	4126387

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-29 12:52:55.0 action: updated fieldName: Fix By Product Milestone newValue: HF2 oldValue: Alpha oprid: vmannebo recordName: RQ_DEFECT timpestamp: 2016-02-29 12:52:55.0 action: updated fieldName: Owner newValue: mchandna oldValue: awdhesh oprid: mchandna recordName: RQ_DEFECT timpestamp: 2016-02-15 09:11:59.0 action: updated fieldName: Dev Assigned newValue: mchandna oldValue: awdhesh oprid: mchandna recordName: RQ_DEFECT timpestamp: 2016-02-15 09:11:59.0 action: updated fieldName: Priority newValue: 3 oldValue: 0 oprid: suchsing recordName: RQ_DEFECT timpestamp: 2016-02-15 07:03:28.0 action: updated fieldName: Owner newValue: awdhesh oldValue: inoel oprid: suchsing recordName: RQ_DEFECT timpestamp: 2016-02-15 07:03:18.0 action: updated fieldName: Fix By Product Milestone newValue: Alpha oldValue: Blank oprid: suchsing recordName: RQ_DEFECT timpestamp: 2016-02-15 07:03:18.0 action: updated fieldName: Reason newValue: BugVerified oldValue: Blank oprid: suchsing recordName: RQ_DEFECT timpestamp: 2016-02-15 07:03:18.0 action: updated fieldName: Fix By Milestone newValue: Alpha oldValue: Blank oprid: suchsing recordName: RQ_DEFECT timpestamp: 2016-02-15 07:03:18.0 action: updated fieldName: QE Assigned newValue: suchsing oldValue: inoel oprid: suchsing recordName: RQ_DEFECT timpestamp: 2016-02-15 07:03:18.0 action: updated fieldName: Status newValue: ToFix oldValue: Unverified oprid: suchsing recordName: RQ_DEFECT timpestamp: 2016-02-15 07:03:18.0
Comment by CFwatson U.
4312 | March 09, 2016 01:52:11 AM GMT
Added By: PreRelease User User Name:Aaron Neff Note Added: The forum thread discussing this ticket is: http://prerelease.adobe.com/r/?8a4684765f0c45ac88a7a32ca253d00f Date Added :2016-02-12 15:46:48.0 Added By: PreRelease User User Name:Aaron Neff Note Added: Entered Bug. Date Added :2016-02-12 15:26:53.0
Comment by CFwatson U.
4313 | March 09, 2016 01:52:12 AM GMT
test note
Comment by CFwatson U.
4314 | June 07, 2016 04:18:51 AM GMT
The fix for this bug is available as part of the early-access build for ColdFusion 2016 Update 2.
Comment by CFwatson U.
4315 | June 07, 2016 04:25:29 AM GMT