I think this is a bug in Group By, I would just like to confirm before I submit a bug report. sql>SELECT payout_type, count(*) FROM test.aggregated_detail_data_2009_week_33 stats WHERE date_added >= 1250222400 AND date_added < 1250308799 GROUP BY payout_type; SELECT payout_type, count(*) FROM test.aggregated_detail_data_2009_week_33 stats WHERE date_added >= 1250222400 AND date_added < 1250308799 GROUP BY payout_type; +-------------+-------+ | payout_type | L206 | +=============+=======+ | 1 | 99021 | | 5 | 8719 | | 4 | 8940 | | 2 | 72 | | 3 | 39 | +-------------+-------+ 5 tuples Timer 13.464 msec 5 rows sql>SELECT 0 as breakdown_id, payout_type, count(*) FROM test.aggregated_detail_data_2009_week_33 stats WHERE date_added >= 1250222400 AND date_added < 1250308799 GROUP BY breakdown_id, payout_type; !TypeException:user.s2_1[6]:'group.new' undefined in: (ext14:any, grp12:any) := group.new(_11:bte) !TypeException:user.s2_1[33]:'group.derive' undefined in: (ext52:any, grp50:any) := group.derive(ext14:any, _14:any, _48:bat[:oid,:int]) !TypeException:user.s2_1[35]:'bat.mirror' undefined in: _53:any := bat.mirror(ext52:any) !TypeException:user.s2_1[36]:'algebra.join' undefined in: _54:any := algebra.join(_53:any, _48:bat[:oid,:int]) !TypeException:user.s2_1[39]:'aggr.count' undefined in: _57:bat[:any,:wrd] := aggr.count(_56:bat[:oid,:any], _52:any, _53:any) !SQLException:SQLengine:Program contains errors 0 tuples Timer 1.234 msec 0 rows