[ 
https://issues.apache.org/jira/browse/DERBY-6395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16169308#comment-16169308
 ] 

Lashan Faliq commented on DERBY-6395:
-------------------------------------

i added a test to compressTable.sql
{code:java}
--test case for derby 6395
--perfoming compress table when there is no table
--gives incorrect error

--This should generate an error 'Compress table cannot be performed on TABLE 
because it does not exist.' 
CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP','testTable',1);

--Now we create a table
create table testTable (ID INT PRIMARY KEY,
    NAME VARCHAR(12));

--This should not generate any error since we created a table called 'table'
CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP','testTable',1);

drop table testTable;

--end of derby 6395

{code}
 And then i tried running the test as shown in the link , at first i got the 
error that there was no build file but then i added the build file i had in my 
duplicate trunk in the same location and now it says that
BUILD FAILED
Target "org.apache.derbyTesting.functionTests.tests.lang.TriggerWhenClauseTest" 
does not exist in the project "null".
Can you please guide me on what i should do next? do i need to create a new 
build.xml ?

> SYSCS_UTIL.SYSCS_COMPRESS_TABLE message for not found table says: 'ALTER 
> TABLE' cannot be performed 
> ----------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-6395
>                 URL: https://issues.apache.org/jira/browse/DERBY-6395
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.11.1.1
>            Reporter: Kathey Marsden
>            Assignee: Lashan Faliq
>            Priority: Trivial
>         Attachments: derby6395fix.diff
>
>
> For historical reasons SYCSCS_UTIL.SYSCS_COMPRESS_TABLE gives a not very 
> sensible message. The user did not actually execute an ALTER TABLE command.
> ij>  CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP','NOTTHERE',1);
> ERROR 38000: The exception 'java.sql.SQLException: 'ALTER TABLE' cannot be 
> performed on 'APP.NOTTHERE' because it does n
> ot exist.' was thrown while evaluating an expression.
> ERROR 42Y55: 'ALTER TABLE' cannot be performed on 'APP.NOTTHERE' because it 
> does not exist.
> ij>



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to