[jira] [Created] (TRAFODION-1792) UPSERT with parameters in VALUES clause fails

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

Suresh Subbiah created TRAFODION-1792:
-----------------------------------------

             Summary: 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)