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

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development