You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "David Wayne Birdsall (JIRA)" <ji...@apache.org> on 2017/10/05 15:29:00 UTC
[jira] [Resolved] (TRAFODION-2630) Merge returns internal error
when the table has a constraint
[ https://issues.apache.org/jira/browse/TRAFODION-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wayne Birdsall resolved TRAFODION-2630.
---------------------------------------------
Resolution: Fixed
Fix Version/s: 2.3-incubating
> Merge returns internal error when the table has a constraint
> ------------------------------------------------------------
>
> Key: TRAFODION-2630
> URL: https://issues.apache.org/jira/browse/TRAFODION-2630
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.2-incubating
> Environment: Reproduced this on a workstation; I suspect it will happen in any environment.
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
> Fix For: 2.3-incubating
>
>
> Consider the following script:
> create table mytable1 (a int not null not droppable primary key, b int, c int);
> insert into mytable1 values (1,1,1),(2,2,2),(3,3,3);
> merge into mytable1 on a=1 when matched then update set c=100;
> create table mytable2 (a int not null not droppable primary key, b int, c int, check (b > 0));
> insert into mytable2 values (1,1,1),(2,2,2),(3,3,3);
> merge into mytable2 on a=1 when matched then update set c=100;
> When this script is executed, the first MERGE statement executes normally but the second fails as follows:
> >>merge into mytable2 on a=1 when matched then update set c=100;
> *** ERROR[7000] An internal error occurred in the code generator in file ../generator/GenRelUpdate.cpp at line 1721: Should not reach here. This update should have been transformed to delete/insert.
> *** ERROR[2235] Compiler Internal Error: An unknown error, originated from file ../generator/Generator.cpp at line 3065.
> *** ERROR[8822] The statement was not prepared.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)