db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2169) Schema does not exist exception for existing schema calling syscs_util.syscs_compress_table
Date Wed, 13 Dec 2006 19:49:23 GMT
     [ http://issues.apache.org/jira/browse/DERBY-2169?page=all ]

Daniel John Debrunner updated DERBY-2169:
-----------------------------------------

    Component/s: Documentation

The documentation for SYSCS_UTIL.SYSCS_COMPRESS_TABLE (and probably other procedures) could
be improved to state what is expected for the schema name and table name. This procedure's
documentation does have some comments for how the table name is treated but not for the schema
name. The ones for the table name could be improved, "passed to SQL", what does that mean
here, what SQL? Better just to say how the table name and schema name map to the actual objects.

> Schema does not exist exception for existing schema calling syscs_util.syscs_compress_table
> -------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2169
>                 URL: http://issues.apache.org/jira/browse/DERBY-2169
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.2.1.6
>         Environment: OS X, java version "1.5.0_06"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-112)
> Java HotSpot(TM) Client VM (build 1.5.0_06-64, mixed mode, sharing)
>            Reporter: Dieter Wimberger
>
> syscs_util.syscs_compress_table throws a "schema does not exist" exception for an existing
schema.
> Call is made according to the documentation in the reference manual:
> SYSCS_UTIL.SYSCS_COMPRESS_TABLE (IN SCHEMANAME VARCHAR(128), 
> IN TABLENAME VARCHAR(128), IN SEQUENTIAL SMALLINT)
> Testcase using ij:
> connect 'jdbc:derby:test;create=true';    
> create schema test;
> create table test.test(id varchar(255));
> insert into test.test values('test1');       
> insert into test.test values('test2');
> call syscs_util.syscs_compress_table('test','test',0);
> ERROR 38000: The exception 'java.sql.SQLException: Schema 'test' does not exist' was
thrown while evaluating an expression.
> ERROR 42Y07: Schema 'test' does not exist

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