You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Bryan Pendleton (JIRA)" <de...@db.apache.org> on 2006/10/14 19:03:36 UTC
[jira] Resolved: (DERBY-183) Parameter names required in CREATE
FUNCTION
[ http://issues.apache.org/jira/browse/DERBY-183?page=all ]
Bryan Pendleton resolved DERBY-183.
-----------------------------------
Fix Version/s: 10.3.0.0
Resolution: Fixed
Derby Info: (was: [Patch Available])
Committed Derby183.patch3.txt, plus a comment-only change to RoutineAliasInfo.java,
to subversion as revision 463982.
James, thanks for the patch and for the tests and for the good comments. Could you
please verify that the changes look correct to you, and then close this issue? Thanks!
> 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: 10.0.2.0
> Reporter: Jack Klebanoff
> Assigned To: James F. Adams
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: Derby183.patch.txt, Derby183.patch2.txt, Derby183.patch3.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