[
https://issues.apache.org/jira/browse/TRAFODION-1792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah resolved TRAFODION-1792.
---------------------------------------
Resolution: Fixed
> UPSERT with parameters in VALUES clause fails
> ---------------------------------------------
>
> Key: TRAFODION-1792
> URL: https://issues.apache.org/jira/browse/TRAFODION-1792
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 1.2-incubating
> Reporter: Suresh Subbiah
> Assignee: Suresh Subbiah
> Fix For: 2.0-incubating
>
>
> When a table with an index is upserted into using a statement of this form
> UPSERT INTO <table> VALUES (?,?,...)
> we get a compiler assertion failure in the Normalizer.
> CREATE TABLE DEC
> (
> ID int unsigned GENERATED BY DEFAULT AS IDENTITY (CACHE 5000) NOT NULL,
> codeValue varchar(1000),
> title varchar(100),
> shortName varchar(200),
> description varchar(1000),
> path varchar(1000),
> synonyms varchar(1000),
> objectClassCode varchar(100),
> propertyCode varchar(100),
> PRIMARY KEY (ID)
> );
> CREATE INDEX IDX3_DEC_T_CodeValue ON DEC(codeValue);
> -- will fail an assertion in the Normalizer
> prepare s2 from UPSERT INTO DEC (ID, codeValue, title , description, path,
> synonyms, objectClassCode, propertyCode) VALUES (?a, ?b, ?c, ?d, ?e, null,
> ?f, null) ;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
