[news.eclipse.birt] Bug in BIRT data export engine

[saiful.raju@xxxxxxxxx (raju )]

Greetings all

Issue is, if you create a report from two table where two table contains 
same column name then at time of data extraction using birt  
IDataExtractionTask class , you will see BIRT ignores one column of that 
two same column name from the two table.

Consider the following query which is provided as  BIRT exampled db,


SELECT ORDERDETAILS."ORDERLINENUMBER",
ORDERDETAILS."ORDERNUMBER",
ORDERDETAILS."PRICEEACH",
ORDERDETAILS."PRODUCTCODE",
ORDERDETAILS."QUANTITYORDERED",
ORDERS."COMMENTS",
ORDERS."CUSTOMERNUMBER",
ORDERS."ORDERDATE",
ORDERS."ORDERNUMBER",
ORDERS."REQUIREDDATE",
ORDERS."SHIPPEDDATE",
ORDERS."STATUS"  
FROM ORDERDETAILS,ORDERS  WHERE ( ORDERDETAILS."ORDERNUMBER" (+)= 
ORDERS."ORDERNUMBER" )


Here is a column named ORDERNUMBER  in both ORDERDETAILS and ORDERS table.

if you create a report with that query, you will see report will show the 
data correctly.But when you want to extract data from rptdocument file of 
that report something goes wrong.

You see there is 12 column above ,But if you use the following api it 
shows there is 11 column.

IResultMetaData metdata = iData.getResultMetaData();
int numberOfcol = metdata.getColumnCount()


And if you just print the column name using the following  code you will 
see BIRT shows 11 column where there is only one ORDERNUMBER column.

for (int i = 0; i < metdata.getColumnCount(); i++) {
  String columnLabel = metdata.getColumnLabel(i);
  //String columnName = metdata.getColumnName(i)
}


But it should print 12 column with two ORDERNUMBER column name


I have tested this problem in BIRT 2.1 and 2.3 .I have also tested this 
problem with birt 2.3 webviewer,where user can export data.The webviewer 
export
data dialog also cant show two column with same name.


Plz help me if you have any idea.