tracker issue : CF-3740141

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

[ANeff] Bug for: Outer query loop mangles inner grouped query loop

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

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

Created: 04/10/2014

Components: Core Runtime

Versions: 11.0

Failure Type: Data Corruption

Found In Build/Fixed In Build: PublicBeta /

Priority/Frequency: Critical / Some users will encounter

Locale/System: English / Win All

Vote Count: 1

Listed in the version 2016.0.0.297996 Issues Fixed doc
Verification notes: verified_fixed on August 06, 2017 using build 2016.0.01.298513
A grouped query loop gets mangled if wrapped w/ another query loop

Steps to reproduce:

1) Run this:

<cfset tagsAndFunctions = queryNew("type,name", "", [["tag","cfif"],["tag","cfset"],["function","now"],["function","len"]]) />
<cfloop query="tagsAndFunctions" group="type">
  <cfoutput>#type#: </cfoutput>
  <cfloop><cfoutput>#name# </cfoutput></cfloop><br />
</cfloop>

Expected Output:
tag: cfif cfset
function: now len 

Actual Output:
tag: cfif cfset
function: now len 

Good!

2) Run this:

<cfset outerQuery = queryNew("BreakThe", "", [["InnerGrouped"],["QueryLoop"]]) />
<cfset tagsAndFunctions = queryNew("type,name", "", [["tag","cfif"],["tag","cfset"],["function","now"],["function","len"]]) />
<cfloop query="outerQuery">
<cfloop query="tagsAndFunctions" group="type">
  <cfoutput>#type#: </cfoutput>
  <cfloop><cfoutput>#name# </cfoutput></cfloop><br />
</cfloop>
</cfloop>

Expected Output:
tag: cfif cfset
function: now len 
tag: cfif cfset
function: now len 

Actual Output:
tag: cfif cfset
tag: cfif cfset 

Bad!

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

Watson Bug ID:	3740141

External Customer Info:
External Company:  
External Customer Name: itisdesign
External Customer Email:

Attachments:

Comments:

Related thread: http://prerelease.adobe.com/r/?baee5bcaf4d64e0da93f672578ee3888
Comment by External U.
12734 | April 10, 2014 12:06:08 AM GMT
+1 / subscribe -- Adam
Vote by External U.
12737 | April 10, 2014 03:17:38 AM GMT
Please include fix in CF11 Update 3 (11,0,03,292245(PreRelease)). Thanks!, -Aaron
Comment by External U.
12735 | November 24, 2014 03:37:28 AM GMT
Verified this is fixed in CF2016 Update 1 (build 2016.0.01.298513). Thanks!, -Aaron
Comment by Aaron N.
12736 | August 06, 2017 12:19:51 AM GMT