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

Parameter names required in CREATE FUNCTION

    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

          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: