Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 316259 - Cancel for multiple result sets setting works incorrectly in stored procedure data set
Summary: Cancel for multiple result sets setting works incorrectly in stored procedure...
Status: VERIFIED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: 2.6.1   Edit
Assignee: Mingxia Wu CLA
QA Contact: Xiaoying Gu CLA
URL:
Whiteboard: Obsolete
Keywords:
Depends on:
Blocks:
 
Reported: 2010-06-09 04:53 EDT by mindan xu CLA
Modified: 2010-08-09 23:43 EDT (History)
3 users (show)

See Also:


Attachments
Report (42.82 KB, application/octet-stream)
2010-06-09 04:53 EDT, mindan xu CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
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