Bug #49 of split_sum_func() in some Items

• Submitted: 28 Jan 2003 23:24
• Modified: 15 Feb 2003 23:18
• Reporter: Oleksandr Byelkin
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 3.23
• OS: Any (any)
• Assigned to: Oleksandr Byelkin
• CPU Architecture: Any

[28 Jan 2003 23:24] Oleksandr Byelkin

Description:
Items Item_func_interval and Item_func_case have not split_sum_func() method.  

How to repeat:
DROP TABLE IF EXISTS t1; 
create table t1 (a int, b int); 
insert into t1 values (1, 4); 
insert into t1 values (10, 40); 
insert into t1 values (1, 4); 
insert into t1 values (10, 43); 
insert into t1 values (1, 4); 
insert into t1 values (10, 41); 
insert into t1 values (1, 4); 
insert into t1 values (1, 4); 
insert into t1 values (10, 43); 
insert into t1 values (1, 4); 
insert into t1 values (1, 4); 
select a, INTERVAL (MAX(b), 1,3,10,30,39,40,50,60,100,1000) from t1 group by a; 
 

Suggested fix:
add split_sum_func() method to whole Items which can hold agregate function

[29 Jan 2003 9:46] MySQL Developer

waiting for code review

[15 Feb 2003 23:18] Michael Widenius

Done in 3.23.36