[
https://issues.apache.org/jira/browse/TRAFODION-148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-148.
----------------------------------
Resolution: Fixed
Assignee: (was: Anoop Sharma)
Fix Version/s: 0.8 (pre-incubation)
> LP Bug: 1248732 - check (b < 99) constraint has no effect
> ---------------------------------------------------------
>
> Key: TRAFODION-148
> URL: https://issues.apache.org/jira/browse/TRAFODION-148
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Reporter: Weishiun Tsai
> Priority: Critical
> Fix For: 0.8 (pre-incubation)
>
>
> The check constraint has no effect. As shown in the following example, check
> (b < 99) constraint is in place for table t, but the insert statement is able
> to insert a row where b = 200. The insert statement is supposed to see the
> 8101 error, as in “*** ERROR[8101] The operation is prevented by check
> constraint SEABASE.MYTEST.MY_CONSTRAINT on table SEABASE.MYTEST.T.”
> >>set schema seabase.mytest;
> --- SQL operation complete.
> >>create table t (a char(2) not null not droppable primary key, b int,
> >>constrain
> t my_constraint check (b < 99));
> --- SQL operation complete.
> >>insert into t values ('AZ', 200);
> --- 1 row(s) inserted.
> >>select * from t;
> A B
> -- -----------
> AZ 200
> --- 1 row(s) selected.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
