[birt-dev] Add multi-pass support to data project.

["Lin Zhu" <lzhu@xxxxxxxxxxx>]

-           Summary:

Add multi-pass support to data project.

 

-Bugzilla Bug (s) Resolved:

None

 

-Description:

The following limitations of current implementation are known:

1. Do not support direct nested aggregations. i.e. Total.sum(Total.sum(row.col))

2. Use filters together with computed columns with aggregation functions will lead to mal-calculated result set.

3. Do not support aggregations in Filter (say, Top N filters).

 

-Tests Description  :
Unit test
-Files Edited:
In CVS/ org.eclipse.birt.data :

test/org/eclipse/birt/data/engine/api/golden/ComputedColumnTest.testGroupOnComputedColumn.txt;

test/org/eclipse/birt/data/engine/api/golden/ComputedColumnTest.testAggregationOnComputedColumn.txt test/org/eclipse/birt/data/engine/api/ScriptedDSTest.java; test/org/eclipse/birt/data/engine/api/UsesDetailFalseTest.java;

test/org/eclipse/birt/data/engine/api/SubQueryTest.java;

test/org/eclipse/birt/data/engine/api/NestedQueryTest.java;

test/org/eclipse/birt/data/engine/api/FeaturesTest.java test/org/eclipse/birt/data/engine/api/InputParameterTest.java;

test/org/eclipse/birt/data/engine/api/GroupOnRowTest.java;

test/org/eclipse/birt/data/engine/api/ComputedColumnTest.java;

test/org/eclipse/birt/data/engine/api/APITestCase.java;

src/org/eclipse/birt/data/engine/executor/BaseQuery.java;

src/org/eclipse/birt/data/engine/executor/CachedResultSet.java;

src/org/eclipse/birt/data/engine/executor/ResultObject.java;

src/org/eclipse/birt/data/engine/impl/PreparedQuery.java;

src/org/eclipse/birt/data/engine/impl/AggregateCalculator.java;

src/org/eclipse/birt/data/engine/impl/AggregateTable.java;

src/org/eclipse/birt/data/engine/impl/ComputedColumnHelper.java;

src/org/eclipse/birt/data/engine/executor/cache/OdiAdapter.java;

src/org/eclipse/birt/data/engine/executor/cache/SmartCache.java;

src/org/eclipse/birt/data/engine/odi/IQuery.java;

src/org/eclipse/birt/data/engine/i18n/Messages.properties;

src/org/eclipse/birt/data/engine/i18n/ResourceConstants.java;

src/org/eclipse/birt/data/engine/api/querydefn/ComputedColumn.java;

src/org/eclipse/birt/data/engine/api/IComputedColumn.java;

 

- Files Added:

test/org/eclipse/birt/data/engine/api/golden/ComputedColumnTest.testMultipass_Sort.txt

test/org/eclipse/birt/data/engine/api/golden/ComputedColumnTest.testMultiPass_Group.txt

src/org/eclipse/birt/data/engine/executor/ExpressionProcessorManager.java;

src/org/eclipse/birt/data/engine/executor/IComputedColumnsState.java;

src/org/eclipse/birt/data/engine/executor/IExpressionProcessor.java;

src/org/eclipse/birt/data/engine/executor/ComputedColumnsState.java;

src/org/eclipse/birt/data/engine/impl/AggregateObject.java;

src/org/eclipse/birt/data/engine/impl/AggregationTablePopulator.java;

src/org/eclipse/birt/data/engine/impl/ExpressionProcessor.java;

 

- Notes to Build Team:
- Notes to Developers:
- Notes to QA:  

- Notes to Documentation: