Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 316259

Summary: Cancel for multiple result sets setting works incorrectly in stored procedure data set
Product: z_Archived Reporter: mindan xu <mindan.xu>
Component: BIRTAssignee: Mingxia Wu <mwu>
Status: VERIFIED FIXED QA Contact: Xiaoying Gu <bluesoldier>
Severity: normal    
Priority: P3 CC: bluesoldier, mwu, wtu
Version: unspecified   
Target Milestone: 2.6.1   
Hardware: PC   
OS: Windows XP   
Whiteboard: Obsolete
Attachments:
Description Flags
Report none

Description mindan xu CLA 2010-06-09 04:53:48 EDT
Created attachment 171503 [details]
Report

Description:
Cancel for multiple result sets setting works incorrectly in stored procedure data set

Build:
2.6.0.v20100609-0630

Steps:
1, Create a Stored procedure data set and execute a stored procedure which has
more than two result sets
2, In setting page, Enable Result Set Selection
3, Specify 1 in Select Result Set by Number
4, Preview result
5, Reopen data set, Specify 2 in Select Result Set by Number
6, Preview result, and cancel to close
7, Reopen data set, Preview result directly

Actual result:
Exception thrown out.
If I switch to setting page first then preview result, there will be no error.

Expect result:
No Exception.

ErrorLog:
org.eclipse.birt.data.engine.core.DataException: Column binding "employeeNumber" has referred to a data set column "employeeNumber" which does not exist.
at org.eclipse.birt.data.engine.impl.ResultIterator.validateManualBindingExpressions(ResultIterator.java:360)
at org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:148)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:194)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage.populateRecords(ResultSetPreviewPage.java:568)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage.access$5(ResultSetPreviewPage.java:562)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:483)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Comment 1 Wenjie Tu CLA 2010-08-06 04:41:40 EDT
The exception I detected in 100805 build is, however, ArrayIndexOutOfBoundsException.

Anyway, fix this issue so that no exception anymore.
Comment 2 Xiaoying Gu CLA 2010-08-09 23:43:43 EDT
Verified in daily build 2.6.1.20100810-0630