Community
Participate
Working Groups
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
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.
Mark as fixed. see commit b9a176b3b16689ef141ebe654b0a2d5dd9a39657.
It works as expected, ex is no error in runtime, verified in the build from 9/09/14 in Birt v.4.4.1
