[
https://issues.apache.org/jira/browse/TRAFODION-1458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah closed TRAFODION-1458.
-------------------------------------
Tested with ODB on dev server.
> 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
>
> Original Estimate: 168h
> Remaining Estimate: 168h
>
> 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)
