[
https://issues.apache.org/jira/browse/DERBY-1963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12463865
]
Saurabh Vyas commented on DERBY-1963:
-------------------------------------
I tried reproducing this, but while using the dblook output to create the
function again, I got this error "ERROR X0Y68: FUNCTION 'FRED' already exists."
Did I missed any step.
Comments/Suggestions ?
Following are the steps I tried :
[EMAIL PROTECTED]/JavaDB/NewTest$ java org.apache.derby.tools.ij
ij version 10.3
ij> connect 'jdbc:derby:TestDB;create=true';
ij> CREATE FUNCTION FRED ("paramOne" INTEGER) RETURNS INTEGER
LANGUAGE JAVA PARAMETER STYLE JAVA
EXTERNAL NAME 'fred.foo' ;
0 rows inserted/updated/deleted
ij> exit;
[EMAIL PROTECTED]/JavaDB/NewTest$ java org.apache.derby.tools.dblook -d
'jdbc:derby:TestDB'
-- Timestamp: 2007-01-11 16:44:49.285
-- Source database is: TestDB
-- Connection URL is: jdbc:derby:TestDB
-- appendLogs: false
-- ----------------------------------------------
-- DDL Statements for functions
-- ----------------------------------------------
CREATE FUNCTION "APP"."FRED" (paramOne INTEGER) RETURNS INTEGER LANGUAGE JAVA
PARAMETER STYLE JAVA READS SQL DATA CALLED ON NULL INPUT EXTERNAL NAME
'fred.foo' ;
[EMAIL PROTECTED]/JavaDB/NewTest$ java org.apache.derby.tools.ij
ij version 10.3
ij> connect 'jdbc:derby:TestDB';
ij> CREATE FUNCTION "APP"."FRED" (paramOne INTEGER) RETURNS INTEGER LANGUAGE
JAVA PARAMETER STYLE JAVA READS SQL DATA CALLED ON NULL INPUT EXTERNAL NAME
'fred.foo' ;
ERROR X0Y68: FUNCTION 'FRED' already exists.
ij> exit;
> Routine parameter names displayed by dblook are not escaped.
> ------------------------------------------------------------
>
> Key: DERBY-1963
> URL: https://issues.apache.org/jira/browse/DERBY-1963
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.3.0.0
> Reporter: Daniel John Debrunner
> Priority: Minor
> Fix For: 10.3.0.0
>
>
> After using this SQL to create a function with a delimited parameter name
> CREATE FUNCTION FRED ("paramOne" INTEGER) RETURNS INTEGER
> LANGUAGE JAVA PARAMETER STYLE JAVA
> EXTERNAL NAME 'fred.foo'
> dblook will output a CREATE FUNCTION statement with the parameter name
> without quotes:
> CREATE FUNCTION "APP"."FRED" (paramOne INTEGER) RETURNS INTEGER
> LANGUAGE JAVA PARAMETER STYLE JAVA
> READS SQL DATA CALLED ON NULL INPUT
> EXTERNAL NAME 'fred.foo';
> Using the output from dblook to re-create the function will result in a
> function with a different parameter name.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
