Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Mon, 14 Oct 2013 20:31:42 +0000 (UTC)
From: "Kim Haase (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <JIRA.12638239.1363874261453.61825.1381782702566@arcas>
In-Reply-To: <JIRA.12638239.1363874261453@arcas>
References: <JIRA.12638239.1363874261453@arcas>
Subject: [jira] [Resolved] (DERBY-6116) Confusing description of limitation
 on user-defined aggregate names.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Kim Haase resolved DERBY-6116.
------------------------------

          Resolution: Fixed
       Fix Version/s: 10.11.0.0
                      10.10.1.3
    Issue & fix info:   (was: Patch Available)

Thanks, Rick -- that was quick!

Committed patch DERBY-6116.diff to documentation trunk at revision 1532053. 
Merged to 10.10 doc branch at revision 1532072.

> Confusing description of limitation on user-defined aggregate names.
> --------------------------------------------------------------------
>
>                 Key: DERBY-6116
>                 URL: https://issues.apache.org/jira/browse/DERBY-6116
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.10.1.1
>            Reporter: Rick Hillegas
>            Assignee: Kim Haase
>              Labels: derby_triage10_11
>             Fix For: 10.10.1.3, 10.11.0.0
>
>         Attachments: DERBY-6116.diff, rrefsqljcreateaggregate.html
>
>
> The Reference Manual section titled "CREATE DERBY AGGREGATE statement" makes the following ambiguous claim:
> "An unqualified UDA name may not be the name of an aggregate defined in part 2 of the SQL Standard, section 10.9"
> The term "unqualified UDA name" is supposed to mean the name of the UDA without any schema name. So if the full, schema qualified name of the UDA is MYSCHEMA.FOO, then FOO may not be a SQL Standard aggregate name like MAX, MIN, ANY, etc..
> This was not clear during buddy-testing of UDAs. From the wording in the Reference Manual, the buddy-tester expected to be able to create an aggregate called APP.ANY.


--
This message was sent by Atlassian JIRA
(v6.1#6144)