db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: [jira] Created: (DERBY-337) dblook doesn't generate SQL statements for SQL functions.
Date Sun, 05 Jun 2005 17:37:08 GMT
I think it would be good to address this bug for 10.1 release, though I
haven't marked it as such. I will let Andrew, the release czar, to
decide on the matter.

Satheesh

Satheesh Bandaram (JIRA) wrote:

>dblook doesn't generate SQL statements for SQL functions.
>---------------------------------------------------------
>
>         Key: DERBY-337
>         URL: http://issues.apache.org/jira/browse/DERBY-337
>     Project: Derby
>        Type: Bug
>  Components: Tools  
>    Versions: 10.0.2.0    
> Environment: All platforms.
>    Reporter: Satheesh Bandaram
>    Priority: Critical
>
>
>DBLOOK schema dumping tool doesn't emit SQL statements for functions. It covers procedures
and all other database objects, but not funtions. Here is an example I tried:
>
>[bandaram:satheesh] java org.apache.derby.tools.dblook -d 'jdbc:derby:tdb'
>-- Timestamp: 2005-06-05 09:41:20.603
>-- Source database is: tdb
>-- Connection URL is: jdbc:derby:tdb
>-- appendLogs: false
>
>-- ----------------------------------------------
>-- DDL Statements for tables
>-- ----------------------------------------------
>
>CREATE TABLE "APP"."T" ("I" INTEGER);
>
>At this point, the database has only one table 'T'. Now create a function:
>
>C:\DerbyCode\bug>java -Dij.protocol=jdbc:derby: org.apache.derby.tools.ij
>ij version 10.1
>ij> connect 'tdb';
>ij> create procedure insertAsciiColumn( stmtText varchar( 256), colNumber int) P
>ARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA
>  EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.StreamUtil.insertAsciiColumn';
>0 rows inserted/updated/deleted
>
>Now the output of DBLOOK should show the procedure, but it doesn't.
>
>[bandaram:satheesh] java org.apache.derby.tools.dblook -d 'jdbc:derby:tdb'
>-- Timestamp: 2005-06-05 09:41:20.603
>-- Source database is: tdb
>-- Connection URL is: jdbc:derby:tdb
>-- appendLogs: false
>
>-- ----------------------------------------------
>-- DDL Statements for tables
>-- ----------------------------------------------
>
>CREATE TABLE "APP"."T" ("I" INTEGER);
>
>Now create a procedure:
>
>C:\DerbyCode\bug>java -Dij.protocol=jdbc:derby: org.apache.derby.tools.ij
>ij version 10.1
>ij> connect 'tdb';
>ij> create procedure insertAsciiColumn( stmtText varchar( 256), colNumber int) P
>ARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA
>  EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.StreamUtil.insertAsc
>iiColumn';
>0 rows inserted/updated/deleted
>ij> 
>
>DBLOOK output include newly created procedure, but still not function statement.
>
>[bandaram:satheesh] java org.apache.derby.tools.dblook -d 'jdbc:derby:tdb'
>-- Timestamp: 2005-06-05 09:43:09.5
>-- Source database is: tdb
>-- Connection URL is: jdbc:derby:tdb
>-- appendLogs: false
>
>-- ----------------------------------------------
>-- DDL Statements for stored procedures
>-- ----------------------------------------------
>
>CREATE PROCEDURE "APP"."INSERTASCIICOLUMN" (IN STMTTEXT VARCHAR(256),IN COLNUMBE
>R INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA EXTERNAL NAME 'o
>rg.apache.derbyTesting.functionTests.util.StreamUtil.insertAsciiColumn' ;
>
>-- ----------------------------------------------
>-- DDL Statements for tables
>-- ----------------------------------------------
>
>CREATE TABLE "APP"."T" ("I" INTEGER);
>
>
>  
>


Mime
View raw message