You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Lashan Faliq (JIRA)" <ji...@apache.org> on 2017/08/19 06:11:00 UTC
[jira] [Updated] (DERBY-6395) SYSCS_UTIL.SYSCS_COMPRESS_TABLE
message for not found table says: 'ALTER TABLE' cannot be performed
[ https://issues.apache.org/jira/browse/DERBY-6395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lashan Faliq updated DERBY-6395:
--------------------------------
Attachment: patch.png
> 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: corrected error.png, patch.png
>
>
> 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)