Project: Birt
Bug 199503 Error occurs when join two datasets with alias name[0706]
Reported: 2007-08-09 20:52:48 | Status: closed fixed

Description: Error occurs when join two datasets with alias name[0706] Build number: 2.2.1.v20070810-0630 Steps to reproduce: 1, New two datasets: CUSTOMERS and ORDERS 2, Edit the both CUSTOMERNUMBER's alias to cus and cus2 3, Create a joint dataset with two datasets and the join key is cus and cus2 4, Preview in dataset Expected result: Preview should be successful Actual result: Error occurs: A BIRT exception occurred. Plug-in Provider:Eclipse.org Plug-in Name:BIRT Data Engine Plug-in ID:org.eclipse.birt.data Version:2.2.1.v20070809 Error Code:data.engine.possibleMixedDataTypeInColumn Error Message:An error happen during population of data. This might be caused by including data of mixed type in a column of "ANY" type. Error log: org.eclipse.birt.data.engine.core.DataException: An error happen during population of data. This might be caused by including data of mixed type in a column of "ANY" type. at org.eclipse.birt.data.engine.impl.ComputedColumnHelperInstance.process(ComputedColumnHelper.java:396) at org.eclipse.birt.data.engine.impl.ComputedColumnHelper.process(ComputedColumnHelper.java:109) at org.eclipse.birt.data.engine.executor.cache.RowResultSet.processFetchEvent(RowResultSet.java:132) at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96) at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:62) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:288) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:261) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:224) at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:68) at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:145) at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:66)

Files changed in fix:
data/org.eclipse.birt.report.data.adapter/src/org/eclipse/birt/report/data/adapter/impl/QueryExecutionHelper.java