Derby
  1. Derby
  2. DERBY-6116

Confusing description of limitation on user-defined aggregate names.

    Details

    • Urgency:
      Normal

      Description

      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.

      1. rrefsqljcreateaggregate.html
        8 kB
        Kim Haase
      2. DERBY-6116.diff
        0.7 kB
        Kim Haase

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        207d 6h 32m 1 Kim Haase 14/Oct/13 21:30
        Resolved Resolved Closed Closed
        31d 16h 45m 1 Rick Hillegas 15/Nov/13 13:15
        Myrna van Lunteren made changes -
        Fix Version/s 10.10.2.0 [ 12326659 ]
        Fix Version/s 10.10.1.4 [ 12324247 ]
        Rick Hillegas made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Kim Haase made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Issue & fix info Patch Available [ 10102 ]
        Fix Version/s 10.10.1.3 [ 12324247 ]
        Fix Version/s 10.11.0.0 [ 12324243 ]
        Resolution Fixed [ 1 ]
        Hide
        Kim Haase added a comment -

        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.

        Show
        Kim Haase added a comment - 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.
        Hide
        ASF subversion and git services added a comment -

        Commit 1532072 from Kim Haase in branch 'docs/branches/10.10'
        [ https://svn.apache.org/r1532072 ]

        DERBY-6116 Confusing description of limitation on user-defined aggregate names.

        Merged DERBY-6116.diff to 10.10 doc branch from trunk revision 1532053.

        Show
        ASF subversion and git services added a comment - Commit 1532072 from Kim Haase in branch 'docs/branches/10.10' [ https://svn.apache.org/r1532072 ] DERBY-6116 Confusing description of limitation on user-defined aggregate names. Merged DERBY-6116 .diff to 10.10 doc branch from trunk revision 1532053.
        Hide
        ASF subversion and git services added a comment -

        Commit 1532072 from Kim Haase in branch 'docs/branches/10.10'
        [ https://svn.apache.org/r1532072 ]

        DERBY-6116 Confusing description of limitation on user-defined aggregate names.

        Merged DERBY-6116.diff to 10.10 doc branch from trunk revision 1532053.

        Show
        ASF subversion and git services added a comment - Commit 1532072 from Kim Haase in branch 'docs/branches/10.10' [ https://svn.apache.org/r1532072 ] DERBY-6116 Confusing description of limitation on user-defined aggregate names. Merged DERBY-6116 .diff to 10.10 doc branch from trunk revision 1532053.
        Hide
        ASF subversion and git services added a comment -

        Commit 1532053 from Kim Haase in branch 'docs/trunk'
        [ https://svn.apache.org/r1532053 ]

        DERBY-6116 Confusing description of limitation on user-defined aggregate names.

        Modified a Reference Manual topic.

        Patch: DERBY-6116.diff

        Show
        ASF subversion and git services added a comment - Commit 1532053 from Kim Haase in branch 'docs/trunk' [ https://svn.apache.org/r1532053 ] DERBY-6116 Confusing description of limitation on user-defined aggregate names. Modified a Reference Manual topic. Patch: DERBY-6116 .diff
        Hide
        ASF subversion and git services added a comment -

        Commit 1532053 from Kim Haase in branch 'docs/trunk'
        [ https://svn.apache.org/r1532053 ]

        DERBY-6116 Confusing description of limitation on user-defined aggregate names.

        Modified a Reference Manual topic.

        Patch: DERBY-6116.diff

        Show
        ASF subversion and git services added a comment - Commit 1532053 from Kim Haase in branch 'docs/trunk' [ https://svn.apache.org/r1532053 ] DERBY-6116 Confusing description of limitation on user-defined aggregate names. Modified a Reference Manual topic. Patch: DERBY-6116 .diff
        Hide
        Rick Hillegas added a comment -

        Thanks, Kim. That's much better. +1

        Show
        Rick Hillegas added a comment - Thanks, Kim. That's much better. +1
        Kim Haase made changes -
        Issue & fix info Patch Available [ 10102 ]
        Kim Haase made changes -
        Attachment DERBY-6116.diff [ 12608328 ]
        Attachment rrefsqljcreateaggregate.html [ 12608329 ]
        Hide
        Kim Haase added a comment -

        I hope this added phrase does the job. Attaching DERBY-6116.diff and rrefsqljcreateaggregate.html, with this change:

        M src/ref/rrefsqljcreateaggregate.dita

        Please let me know if further edits would be useful.

        Show
        Kim Haase added a comment - I hope this added phrase does the job. Attaching DERBY-6116 .diff and rrefsqljcreateaggregate.html, with this change: M src/ref/rrefsqljcreateaggregate.dita Please let me know if further edits would be useful.
        Kim Haase made changes -
        Assignee Kim Haase [ chaase3 ]
        Gavin made changes -
        Workflow jira [ 12772654 ] Default workflow, editable Closed status [ 12801697 ]
        Mamta A. Satoor made changes -
        Field Original Value New Value
        Labels derby_triage10_11
        Rick Hillegas created issue -

          People

          • Assignee:
            Kim Haase
            Reporter:
            Rick Hillegas
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development