db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jack Klebanoff (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-183) Parameter names required in CREATE FUNCTION
Date Sat, 26 Mar 2005 01:44:16 GMT
Parameter names required in CREATE FUNCTION
-------------------------------------------

         Key: DERBY-183
         URL: http://issues.apache.org/jira/browse/DERBY-183
     Project: Derby
        Type: Bug
    Versions: 10.0.2.0    
    Reporter: Jack Klebanoff
    Priority: Minor


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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


Mime
View raw message