[ http://issues.apache.org/jira/browse/DERBY-183?page=all ]
James F. Adams updated DERBY-183:
---------------------------------
Attachment: Derby183.patch3.txt
Thanks Bryan for reviewing my patches.
Attached is a new patch that modifies the following files and resolves the
testing issues:
java/engine/org/apache/derby/impl/sql/compile/CreateAliasNode.java
java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj
java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure.java
java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/procedure.out
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/procedure.out
java/testing/org/apache/derbyTesting/functionTests/master/functions.out
java/testing/org/apache/derbyTesting/functionTests/master/procedure.out
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/procedure.out
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/procedure.out
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/procedure.out
java/testing/org/apache/derbyTesting/functionTests/util/ProcedureTest.java
I ran the lang/procedure.java and lang/functions.sql tests using the embedded,
DerbyNet,
and DerbyNetClient frameworks with Java versions 1.3, 1.4, 1.5, and 1.6 and saw
no errors.
> 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
> 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
