db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3674) 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall - store/TransactionTable.sql
Date Thu, 15 May 2008 05:01:55 GMT

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

Mamta A. Satoor commented on DERBY-3674:
----------------------------------------

Prior to my checkin for DERBY-1062, all the work for inplace compress was handled outside
of compile and execute hierarchy and the code for inplace compress was in OnlineCompress class.
In that class, we checked if we are trying to compress a VTI (which in this jira entry's case
is SYSCS_DIAG.TRANSACTION_TABLE) and if yes, then we did nothing and simply returned from
the OnlineCompress class. 

With changes for DERBY-1062, we have moved the code from OnlineCompress into ALTER TABLE related
compile and execute classes(namely AlterTableNode and AlterTableConstantAction). In ALTER
TABLE, we can tell in the bind phase in AlterTableNode.bindStatement() that we are dealing
with VTI but there is no easy way to say we are done since we are dealing with inplace compress
of VTI and hence let's quit. I can try to change code in compile and execute time to somehow
ignore inplace compress on VTI but I was curious if there is a more graceful way to just quit
out of compile phase (and skip execute phase all together) since we know inplace compress
on VTI should be treated as no-op.

> 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in
derbyall - store/TransactionTable.sql
> ----------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3674
>                 URL: https://issues.apache.org/jira/browse/DERBY-3674
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure, Test
>    Affects Versions: 10.5.0.0
>         Environment: OS: SunOS 5.10
> JVM: Sun 1.6.0_04
> SVN: r >= 655989
>            Reporter: Ole Solberg
>            Assignee: Mamta A. Satoor
>            Priority: Minor
>
> See e.g. http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/655989-derbyall_diff.txt
> <method>
> store/TransactionTable.sql
> </method>
> <signature>
> 268 del
> < 0 rows inserted/updated/deleted
> 268a268,269
> > ERROR 38000: The exception 'java.sql.SQLException: 'ALTER TABLE' is not allowed
on the System table '"SY\
> SCS_DIAG"."TRANSACTION_TABLE"'.' was thrown while evaluating an expression.
> > ERROR X0Y56: 'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"'.
> </signature>

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message