Suresh Subbiah created TRAFODION-1458:
-----------------------------------------
Summary: UPSERT into table with index through ODB fails
Key: TRAFODION-1458
URL: https://issues.apache.org/jira/browse/TRAFODION-1458
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Affects Versions: 1.1 (pre-incubation)
Reporter: Suresh Subbiah
Assignee: Suresh Subbiah
Fix For: 2.0-incubating
The upsert command fails where there is a primary key in the table and with an
index. It looks like the ODB tool is broken due to this issue.
drop table selva.region ;
create table selva.region
( region_id INT NOT NULL
, region_sub_id int not null
, region_name VARCHAR2(25)
, primary key (region_id))
salt using 4 partitions on (region_id)
;
create index region_idx on selva.region(region_sub_id) ;
prepare s1 from upsert into selva.region values (?[5000], ?[5000], ?[5000]);
>>create table selva.region
+>( region_id INT NOT NULL
+> , region_sub_id int not null
+> , region_name VARCHAR2(25)
+> , primary key (region_id))
+> salt using 4 partitions on (region_id)
+>;
--- SQL operation complete.
>>
>>create index region_idx on selva.region(region_sub_id) ;
--- SQL operation complete.
>>prepare s1 from upsert into selva.region values (?,?,?) ;
--- SQL command prepared.
>>explain options 'f' s1 ;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
5 . 6 root o x 1.00E+002
1 4 5 nested_join 1.00E+002
2 3 4 blocked_union 2.00E+000
. . 3 trafodion_insert REGION_IDX 1.00E+000
. . 2 trafodion_delete REGION_IDX 1.00E+000
. . 1 trafodion_merge REGION 5.00E+001
--- SQL operation complete.
>>prepare s1 from upsert into selva.region values (?[5000], ?[5000], ?[5000])
+>;
*** ERROR[2006] Internal error: assertion failure
((getGroupAttr()->getCharacteristicInputs().contains
(child(0)->getGroupAttr()->getCharacteristicInputs())) || (getGroupAttr()->) in
file ../optimizer/NormRelExpr.cpp at line 7062.
*** ERROR[8822] The statement was not prepared.
Issue was found and reported by Selva.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
