Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 367624

Summary: Some aggregation functions (quartile, percentile) throw AggrException when all values are filtered
Product: z_Archived Reporter: Michal Tkacz <Michal.Tkacz>
Component: BIRTAssignee: Zhang Lei <LZhang>
Status: VERIFIED FIXED QA Contact: Hao Zhou <hao.zhou>
Severity: normal    
Priority: P3 CC: bluesoldier
Version: unspecified   
Target Milestone: 3.7.2   
Hardware: PC   
OS: Linux   
Whiteboard:

Description Michal Tkacz CLA 2011-12-29 08:15:52 EST 
Build Identifier: 3.7.1.v20110905

Aggregate functions like QUARTILE or PERCENTILE throw AggrException when all values are filtered using Filter Condition (no value is left to calculate aggregate value). Other aggregate functions like AVG or MEDIAN return null in this case, which IMHO is the correct behaviour. 

Data (id = 87):
+ A BIRT exception occurred. See next exception for more information.
Not all the values for percentile can be null. (Element ID:87) 


Reproducible: Always

Steps to Reproduce:
1. Create a table based on a non-empty data set of your choice
2. Put QUARTILE aggregation in the header/footer and set Filter Condition so that all values are filtered out.
Comment 1 Zhang Lei CLA 2012-03-16 02:16:30 EDT 
return null value when getting the summary value for these functions. fix this issue.
Comment 2 Hao Zhou CLA 2012-03-16 02:20:40 EDT 
Verified.