Group By bug?

[Guillaume Theoret]

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

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
MonetDB-users mailing list
MonetDB-users@...
https://lists.sourceforge.net/lists/listinfo/monetdb-users