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 Sat, 14 Oct 2006 18:40:36 GMT
     [ http://issues.apache.org/jira/browse/DERBY-183?page=all ]

James F. Adams updated DERBY-183:

    Attachment: Derby183.patch4.txt

The lookahead in the grammar of my previous patches did not work for some parameter types.
 I have reworked the lookahead to use syntactic lookahead similar to that used elsewhere in
the grammar.  I have included an additional test that would have failed with the previous
patch.  I have run the lang/functions.sql and lang/procedure.java using the various frameworks
without error.

> 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
>             Fix For:
>         Attachments: Derby183.patch.txt, Derby183.patch2.txt, Derby183.patch3.txt, Derby183.patch4.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