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

Parameter names required in CREATE FUNCTION

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.0.2.0
    • 10.3.1.4
    • SQL
    • None

    Description

      A statement like
      create function s2.f2( char(8), integer) returns int
      language java parameter style java external name 'myclass.mymethod'
      fails with the message
      ERROR 42X01: Syntax error: Encountered "char" at line 1, column 24
      However
      create function s2.f2( p1 char(8), p2 integer) returns int
      language java parameter style java external name 'myclass.mymethod'
      is accepted.
      The Derby documentation (at http://incubator.apache.org/derby/manuals/reference/sqlj27.html#CREATE+PROCEDURE+Statement), the SQL2003 standard, and DB2 all agree that the parameter name is optional.

      Attachments

        1. Derby183.patch.txt
          2 kB
          James F. Adams
        2. Derby183.patch2.txt
          7 kB
          James F. Adams
        3. Derby183.patch3.txt
          11 kB
          James F. Adams
        4. Derby183.patch4.txt
          5 kB
          James F. Adams

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            james.f.adams James F. Adams
            jackklebanoff Jack Klebanoff
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment