db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lashan Faliq (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6395) SYSCS_UTIL.SYSCS_COMPRESS_TABLE message for not found table says: 'ALTER TABLE' cannot be performed
Date Sat, 19 Aug 2017 06:15:00 GMT

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

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

The patch is attached below with all the tests.
!patch.png!
  
The corrected issue
!corrected error.png!
 
 i have uploaded the test to a drive since they wont let me attach a rar file.
https://drive.google.com/drive/folders/0B54oc6UMXehdbzZTb2p2VzNPeXM?usp=sharing
I have trouble understanding the tests so can you please help me see if the test cases pass
and if my implementation is ok.
Thank you

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

Mime
View raw message