Title:
Bug 82724:This issue happens when a stored procedure is returning more than one result set and the first result set is trying to be duplicated using duplicate() or passed into cfthread as an argument
| View in TrackerStatus/Resolution/Reason: Closed/Withdrawn/
Reporter/Name(from Bugbase): Jason Fill / Jason Fill (Jfill)
Created: 04/20/2010
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 9,0,0,251028 /
Priority/Frequency: Normal / Unknown
Locale/System: English / Win All
Vote Count: 3
Problem:
This issue happens when a stored procedure is returning more than one result set and the first result set is trying to be duplicated using duplicate() or passed into cfthread as an argument. When duplicating using duplicate() any result sets other than the first one their is not a problem.
Method:
Create a stored procedure that returns more than one result set then try to put each result set into a struct, then duplicate the strucure. Below is the logic that is used to recreate the issue. This issue was isolated down to the code below. However, the real implementation passes the struct into cfthread as an argument which looks to try to duplicate the variable and produces the same result.<cfstoredproc procedure="MyProc" datasource="MyDsn"><cfprocparam type="in" value="100" cfsqltype="CF_SQL_INTEGER" dbvarname="@UserID" /><cfprocresult name="Questions" resultset="1" /><cfprocresult name="Answers_RegularScoring" resultset="2" /><cfprocresult name="Answers_ReverseScoring" resultset="3" /></cfstoredproc><cfset MyStruct = StructNew() /><cfset MyStruct.QUESTIONS = Questions /><cfset MyStruct.ANSWERS_REGULARSCORING = Answers_RegularScoring /><cfset MyStruct.ANSWERS_REVERSESCORING = Answers_ReverseScoring /><cfdump var="#Duplicate(MyStruct)#">
Result:
java.lang.ArrayIndexOutOfBoundsException: 4
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3041355
External Customer Info:
External Company:
External Customer Name: Jason Fill
External Customer Email: 13ED3943409A5C5F992016B6
External Test Config: 04/20/2010Attachments:
Comments: