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

Bug 333060

Summary: DataException when using * in select clause and changing datasource
Product: z_Archived Reporter: swaczinna
Component: BIRTAssignee: Zhiqiang Qian <zqian>
Status: VERIFIED WORKSFORME QA Contact: Galina Derenshteyn <gderenshteyn>
Severity: minor    
Priority: P3 CC: bluesoldier, wyan, zqian
Version: 2.5.2   
Target Milestone: 4.4.1   
Hardware: All   
OS: All   
Whiteboard:

Description swaczinna CLA 2010-12-22 04:51:00 EST 
Build Identifier: 20100218-1602

When using a query like "select * from ..." in a dataset the report is not portable between databases. BIRT will throw a "DataException: The new column name or alias abc is already used by the column at index x" when the order of the column definitions of the underlying table is different between the databases. There's no problem when all columns are listed in the select clause because the column order is always the same then.

Reproducible: Always

Steps to Reproduce:
1. Design a report with a "select *" query against database A.
2. Create a database B with same table and columns but with different default column order.
3. Change datasource to database B.
4. Run report against B

Reproduced with BIRT 2.5.2 and Oracle 10.2
Comment 1 Xiaoying Gu CLA 2011-03-09 05:57:46 EST 
This error occurs in certain condition, could you help to confirm?

I tried with latest 2.6.2 release build. If I change the data source in dataset dialog and click OK button, this error won't happen. But if I click the cancel button, the output column will messed up. And if I reopen the dataset dialog and try to check output column, such error will appear. 
But it doesn't impact the report preview, which still works fine.
Comment 2 Zhiqiang Qian CLA 2014-07-28 18:10:45 EDT 
Mark as fixed. see commit b9a176b3b16689ef141ebe654b0a2d5dd9a39657.
Comment 3 Galina Derenshteyn CLA 2014-09-12 19:01:57 EDT 
It works as expected, ex is no error in runtime, verified in the build from 9/09/14 in Birt v.4.4.1