db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-183) Parameter names required in CREATE FUNCTION
Date Wed, 11 Oct 2006 01:26:20 GMT
    [ http://issues.apache.org/jira/browse/DERBY-183?page=comments#action_12441319 ] 
            
Bryan Pendleton commented on DERBY-183:
---------------------------------------

When I ran derbyall, lang/procedure.java failed in the DerbyNet and DerbyNetClient frameworks.
There are multiple procedure.out files in the various frameworks. Unfortunately,
I think that all of them have to be updated. The diff should be the same in all of them,
since your test doesn't depend on any particular network or JVM features.

To see the problem:
java -Dframework=DerbyNetClient org.apache.derbyTesting.functionTests.harness.RunTest lang/procedure.java

To see all the procedure.out files that need to be updated, do:
find trunk/java -name procedure.out


> 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
>
>
> 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

        

Mime
View raw message