[jira] [Commented] (DERBY-6395) SYSCS_UTIL.SYSCS_COMPRESS_TABLE message for not found table says: 'ALTER TABLE' cannot be performed

["Bryan Pendleton (JIRA)" <ji...@apache.org>]

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

Bryan Pendleton commented on DERBY-6395:
----------------------------------------

Thanks for the update, and thanks for your work on this problem!

I think it might be useful to pursue a Test-Driven-Development approach to this issue.

Perhaps you could add some test cases to the test suite

java\testing\org\apache\derbyTesting\functionTests\tests\lang\CompressTableTest.java

to demonstrate the behavior of this issue.

In order to run the test, after you have modified it, here are instructions on what to do:

https://wiki.apache.org/db-derby/DerbyJUnitTesting#Running_tests_using_ant_in_a_code_line

In particular, see the sub-heading: "Running a single JUnit test suite using ant in a code line"

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