Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6116

Confusing description of limitation on user-defined aggregate names.

    XMLWordPrintableJSON

    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.

        Attachments

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

          Activity

            People

            • Assignee:
              chaase3 Camilla Haase
              Reporter:
              rhillegas Richard N. Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: