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

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

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development