db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-672) Re-enable user defined aggregates
Date Mon, 03 Sep 2012 11:18:07 GMT

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

Rick Hillegas updated DERBY-672:

    Attachment: derby-672-06-aa-grantRevoke.diff

Attaching derby-672-06-aa-grantRevoke.diff. This patch adds GRANT/REVOKE USAGE support for
user-defined aggregates. Regression tests passed cleanly for me. Committed at subversion revision

Touches the following files:


M       java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj
M       java/engine/org/apache/derby/iapi/sql/dictionary/StatementGenericPermission.java
M       java/engine/org/apache/derby/iapi/sql/dictionary/PermDescriptor.java
M       java/engine/org/apache/derby/impl/sql/compile/PrivilegeNode.java
M       java/engine/org/apache/derby/impl/sql/depend/BasicDependencyManager.java

Add user-defined aggregates to the dependency/privilege managers.


M       java/engine/org/apache/derby/impl/sql/compile/AggregateNode.java
M       java/engine/org/apache/derby/impl/sql/compile/UserAggregateDefinition.java

Wire-in dependency and privilege checking for invocations of user-defined aggregates.


M       java/tools/org/apache/derby/impl/tools/dblook/DB_GrantRevoke.java
M       java/tools/org/apache/derby/loc/toolsmessages.properties

Support for reconstructing permissions on aggregates when the database schema is dumped.


A       java/testing/org/apache/derbyTesting/functionTests/tests/lang/UDAPermsTest.java
M       java/testing/org/apache/derbyTesting/functionTests/tests/lang/_Suite.java

Add a new test for USAGE privilege on user-defined aggregates


M       java/testing/org/apache/derbyTesting/functionTests/tests/lang/UserDefinedAggregatesTest.java

Add a test case for dependencies of view/triggers on user-defined aggregates.

> Re-enable user defined aggregates
> ---------------------------------
>                 Key: DERBY-672
>                 URL: https://issues.apache.org/jira/browse/DERBY-672
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>         Attachments: derby-672-01-aa-ddl.diff, derby-672-02-ac-nonDistinct.diff, derby-672-03-aa-distinct.diff,
derby-672-03-ab-distinct.diff, derby-672-04-aa-fixJSR169test.diff, derby-672-05-aa-java7testOrderProblem.diff,
derby-672-06-aa-grantRevoke.diff, UserDefinedAggregates.html, UserDefinedAggregates.html
> Nicolas Dufour in an email thread titled "functions and list" started on November 2,
2005 requests the ability to create user defined aggregates.
> This functionality used to be in Cloudscape. It was disabled presumably because it was
considered non-standard. However, most of the machinery needed for this feature is still in
the code. We should re-enable user defined aggregates after we agree on acceptable syntax.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

View raw message