maria-developers team mailing list archive

[worklog-noreply@xxxxxxxxxxxx]

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Extended Aggregates Functionality
CREATION DATE..: Tue, 19 Jul 2011, 13:43
SUPERVISOR.....: 
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Server-RawIdeaBin
TASK ID........: 230 (http://askmonty.org/worklog/?tid=230)
VERSION........: WorkLog-4.0
STATUS.........: Un-Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 0 (hours remain)
ORIG. ESTIMATE.: 0

PROGRESS NOTES:



DESCRIPTION:

This idea is really an extension to SQL. It was implemented at my suggestion for
the SQL like EPL (Event Processing language) over at Esper project
(http://esper.codehaus.org).

Basically the idea is to extend all aggregates (count(), avg() etc) so that they
can accept an optional boolean filter expression as a second argument.

Example use case:

select count(*, color='black'), count(*) as percentBlack from Marbles;

This is more expressive and more efficient than using subselects.

original suggestion can be found at
http://old.nabble.com/Feature-suggestion--filtering-inside-aggregates-to31935740.html

Mitch


ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v4.0.0)