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] [Created] (DERBY-6116) Confusing description of limitation on user-defined aggregate names.
Date Thu, 21 Mar 2013 13:59:15 GMT
Rick Hillegas created DERBY-6116:

             Summary: 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:
            Reporter: Rick Hillegas

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 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