Uploaded image for project: '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
        chaase3 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
        chaase3 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
        rhillegas Rick Hillegas added a comment -

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

        Show
        rhillegas Rick Hillegas added a comment - Thanks, Kim. That's much better. +1
        Hide
        jira-bot 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
        jira-bot 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
        jira-bot 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
        jira-bot 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
        jira-bot 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
        jira-bot 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
        jira-bot 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
        jira-bot 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
        chaase3 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
        chaase3 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:
            chaase3 Kim Haase
            Reporter:
            rhillegas Rick Hillegas
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development