Bug 200144 Exception occurs when nested table share the parent table's result set.[0005]
Description: Exception occurs when nested table share the parent table's result set.[0005] Build number: 2.2.1.v20070816-0630 Steps to reproduce: 1, New a table1 with one binding 2, Insert another table into table1 and share the table1's resultset 3, Preview Actual result: Exception occurs when preview Error log: org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report; nested exception is: java.lang.IllegalStateException: forward reference dataset org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.createQuery(ReportQueryBuilder.java:912) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitTableItem(ReportQueryBuilder.java:609) org.eclipse.birt.report.engine.ir.TableItemDesign.accept(TableItemDesign.java:44) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:246) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitCell(ReportQueryBuilder.java:806) org.eclipse.birt.report.engine.ir.CellDesign.accept(CellDesign.java:156) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:246) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitRow(ReportQueryBuilder.java:792) org.eclipse.birt.report.engine.ir.RowDesign.accept(RowDesign.java:100) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:246) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.handleListingBand(ReportQueryBuilder.java:705) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitTableItem(ReportQueryBuilder.java:641) org.eclipse.birt.report.engine.ir.TableItemDesign.accept(TableItemDesign.java:44) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:246) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:228) org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:136) org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:94) org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:59) org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:50) org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:59) org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:138)
data/org.eclipse.birt.data.tests/test/org/eclipse/birt/data/engine/api/APITestCase.java
* @return queryDefn
		 */
		protected IQueryDefinition getDefaultQueryDefnWithSubQuery( String dataSetName )
		{
			IQueryDefinition queryDefn = getDefaultQueryDefn( dataSetName );
			
			
			GroupDefinition groupDefn = (GroupDefinition) queryDefn.getGroups().get(1);
			
			
			SubqueryDefinition subqueryDefn = new SubqueryDefinition( "IAMTEST", queryDefn );
			groupDefn.addSubquery( subqueryDefn );
			
			String[] bindingNameGroup = new String[1];
			bindingNameGroup[0] = "GROUP_COL2";
			IBaseExpression[] bindingExprGroup = new IBaseExpression[1];
			bindingExprGroup[0] = new ScriptExpression("dataSetRow.COL2");
			GroupDefinition[] subGroupDefn = new GroupDefinition[] { new GroupDefinition(
					"group2") };
			
			subGroupDefn[0].setKeyExpression( "row.GROUP_COL2" );
			
			for (int k = 0; k < subGroupDefn.length; k++) {
				if (bindingNameGroup != null)
					for (int i = 0; i < bindingNameGroup.length; i++)
						subqueryDefn.addResultSetExpression(
								bindingNameGroup[i], bindingExprGroup[i]);
				
				for (int i = 0; i < subGroupDefn.length; i++)
					subqueryDefn.addGroup(subGroupDefn[i]);