You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Weishiun Tsai (JIRA)" <ji...@apache.org> on 2015/08/21 19:42:45 UTC
[jira] [Closed] (TRAFODION-714) LP Bug: 1384485 - Alter table
allows adding a constraint to a _MD_ table
[ https://issues.apache.org/jira/browse/TRAFODION-714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Weishiun Tsai closed TRAFODION-714.
-----------------------------------
Resolution: Fixed
Old Launchpad bug report that was migrated to JIRA. Was verified and closed on 12/11/2014 originally in Launchpad. Closed it again in JIRA.
> LP Bug: 1384485 - Alter table allows adding a constraint to a _MD_ table
> ------------------------------------------------------------------------
>
> Key: TRAFODION-714
> URL: https://issues.apache.org/jira/browse/TRAFODION-714
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmu
> Reporter: Weishiun Tsai
> Assignee: Roberta Marton
> Priority: Critical
>
> Alter table does not return an error when the user tries to add a constraint to a _MD_ table, although it’s hard to tell if the constraint is actually added or the statement simply aborts internally without returning an error to the user.
> This is seen on the v1021_0830 build installed on a workstation.
> -------------------------------------------------------------------------
> Here is the entire script to reproduce this problem
> showddl "_MD_".views_usage;
> alter table "_MD_".views_usage add constraint c1 check (used_object_uid != 0);
> showddl "_MD_".views_usage;
> -------------------------------------------------------------------------
> Here is the execution output:
> >>showddl "_MD_".views_usage;
> CREATE TABLE TRAFODION."_MD_".VIEWS_USAGE
> (
> USING_VIEW_UID LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
> , USED_OBJECT_UID LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
> , USED_OBJECT_TYPE CHAR(2) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
> , PRIMARY KEY (USING_VIEW_UID ASC, USED_OBJECT_UID ASC)
> )
> ;
> --- SQL operation complete.
> >>alter table "_MD_".views_usage add constraint c1 check (used_object_uid != 0);
> --- SQL operation complete.
> >>showddl "_MD_".views_usage;
> CREATE TABLE TRAFODION."_MD_".VIEWS_USAGE
> (
> USING_VIEW_UID LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
> , USED_OBJECT_UID LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
> , USED_OBJECT_TYPE CHAR(2) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
> , PRIMARY KEY (USING_VIEW_UID ASC, USED_OBJECT_UID ASC)
> )
> ;
> --- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)