Title:
Nested Grouped Query Outputs incorrectly group data resulting in Array index out of range error
| View in TrackerStatus/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Rawdyn Nutting / Rawdyn Nutting (Rawdyn Nutting)
Created: 03/09/2016
Components: Database
Versions: 2016
Failure Type: Unspecified
Found In Build/Fixed In Build: Alpha_v12 /
Priority/Frequency: Major / Unknown
Locale/System: English / Win All
Vote Count: 2
Problem Description:
When nesting more than two grouped query outputs the grouping of data is incorrect and results in a Java Array index out of range error.
Steps to Reproduce:
See attached file: grouped-query-output-bug-V002.cfm
1. Create a query of hierarchical data more than two levels deep.
2. Output data in nested grouped outputs
Notes:
Only occurs nesting more that two outputs.
Changing the order of the query affects the results highlighting the apparent loss of index.
Output of the test file shows the hierarchy of each records (showing where records are incorrectly placed in group) and the (CR:currentrow) of the query record set.
Actual Result:
Data incorrectly grouped and some missing.
Error thrown: java.lang.ArrayIndexOutOfBoundsException: Array index out of range:
See attached file: ACF-11-and-12-Nested-Grouped-Query-Output-Test.PNG noting ACF version in address bar for each test.
Expected Result:
Output should show all records correctly grouped and not throw an error.
See attached file: ACF-11-and-12-Nested-Grouped-Query-Output-Test.PNG noting ACF version in address bar for each test.
Any Workarounds:
Nothing feasible.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4126729
External Customer Info:
External Company:
External Customer Name: Rawdyn Nutting
External Customer Email: ADOBE@RAWDYN.COM
External Test Config:
Bug File Paths:
\\sjshare.corp.adobe.com\Prereleasebugfiles\ColdFusion\12.0\Alpha_v12\4020403\ACF12-Nested-Grouped-Query-Output-Error.docx
\\sjshare.corp.adobe.com\Prereleasebugfiles\ColdFusion\12.0\Alpha_v12\4020403\ACF-11-and-12-Nested-Grouped-Query-Output-Test.PNG
\\sjshare.corp.adobe.com\Prereleasebugfiles\ColdFusion\12.0\Alpha_v12\4020403\grouped-query-output-bug-V002.cfmAttachments:
Comments: