[
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)
