[jira] [Closed] (TRAFODION-550) LP Bug: 1359316 - Upsert using load sees error 4486 when a table has constraints

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-550?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah closed TRAFODION-550.
------------------------------------

> LP Bug: 1359316 - Upsert using load sees error 4486 when a table has constraints
> --------------------------------------------------------------------------------
>
>                 Key: TRAFODION-550
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-550
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-exe
>            Reporter: Weishiun Tsai
>            Assignee: Apache Trafodion
>            Priority: Blocker
>             Fix For: 0.9 (pre-incubation)
>
>
> Upsert using load now sees error 4486 if the table has constraints.  This is seen on the 0819_0830 daily build installed on a workstation.
> This is a regression and it is preventing QA from populating its tables for testing, hence the issue is marked as critical.
> -------------------------------------------------------------------
> Here is the entire script to reproduce this problem:
> create table t0 (a int, b int);
> create table t1 (a int, b int constraint myconst check (b < 10));
> insert into t0 values (1, 1);
> upsert using load into t1 select * from t0;
> -------------------------------------------------------------------
> Here is the execution output and the error:
> >>create table t0 (a int, b int);
> --- SQL operation complete.
> >>create table t1 (a int, b int constraint myconst check (b < 10));
> --- SQL operation complete.
> >>insert into t0 values (1, 1);
> --- 1 row(s) inserted.
> >>upsert using load into t1 select * from t0;
> *** ERROR[4486] Constraints are not supported with upsert using load. Disable the constraints and try again.
> *** ERROR[8822] The statement was not prepared.
> Assigned to LaunchPad User khaled Bouaziz



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)