Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <649502952.1253233557559.JavaMail.jira@brutus>
Date: Thu, 17 Sep 2009 17:25:57 -0700 (PDT)
From: "Bryan Pendleton (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-3002) Add support for GROUP BY ROLLUP
In-Reply-To: <8295663.1186932103844.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DERBY-3002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bryan Pendleton updated DERBY-3002:
-----------------------------------

    Attachment: useAggregateObserver.diff

Attached 'useAggregateObserver.diff' has one major change from the
previous patch proposal: it restores the use of the AggregateSortObserver
for the following common and important special case:
 - the input data is not already in sorted order
 - the GROUP BY does not use ROLLUP
 - the GROUP BY does not use distinct aggregates

The patch is also up to date with current trunk, and resolves some merge conflicts.

This revised patch passes all the regression tests, including the new ROLLUP tests.

More importantly, this revised patch matches the current trunk in performance
on the DERBY-4363 benchmark of GROUP BY performance.

I still have to investigate the other issues raised during the previous round of code
review, but this patch seemed to be at a state worth posting so here it is.


> Add support for GROUP BY ROLLUP
> -------------------------------
>
>                 Key: DERBY-3002
>                 URL: https://issues.apache.org/jira/browse/DERBY-3002
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.4.1.3
>            Reporter: Bryan Pendleton
>            Assignee: Bryan Pendleton
>            Priority: Minor
>         Attachments: fixWhiteSpace.diff, IncludesASimpleTest.diff, passesRegressionTests.diff, prototypeChangeNoTests.diff, rewriteGroupByRS.diff, rollupNullability.diff, UpdateToTrunkSep2009.diff, useAggregateObserver.diff, useLookahead.diff
>
>
> Provide an implementation of the ROLLUP form of multi-dimensional grouping according to the SQL standard.
> See http://wiki.apache.org/db-derby/OLAPRollupLists for some more detailed information about this aspect of the SQL standard.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.