db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James F. Adams (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-183) Parameter names required in CREATE FUNCTION
Date Sun, 08 Oct 2006 04:02:21 GMT
     [ http://issues.apache.org/jira/browse/DERBY-183?page=all ]

James F. Adams updated DERBY-183:

    Attachment: Derby183.patch.txt

I have attached a patch that:

1) Modifies java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj
    a) Initializes parameterName to "" in procedureParameterDefinition and functionParameterDefinition
    b) Makes parameterName optional in procedureParameterDefinition and functionParameterDefinition

2) Modifies java/engine/org/apache/derby/impl/sql/compile/CreateAliasNode.java to ignore function
and procedure parameter names equal to "" when checking for duplicate parameter names.

I have run derbyall with no additional failures noted.  I also ran dblook on a database which
contained functions and procedures with parameters that had just parameter types specified.
 The resultant DML looked good.

> Parameter names required in CREATE FUNCTION
> -------------------------------------------
>                 Key: DERBY-183
>                 URL: http://issues.apache.org/jira/browse/DERBY-183
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions:
>            Reporter: Jack Klebanoff
>         Assigned To: James F. Adams
>            Priority: Minor
>         Attachments: Derby183.patch.txt
> 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
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message