[jira] [Created] (TRAFODION-1590) UPSERT into VALUES (, ...) fails

Suresh Subbiah created TRAFODION-1590:
-----------------------------------------

             Summary: UPSERT into <table> VALUES (<subquery>, ...) fails
                 Key: TRAFODION-1590
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1590
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
    Affects Versions: 1.2-incubating
            Reporter: Suresh Subbiah
            Assignee: Suresh Subbiah
             Fix For: 1.3-incubating


UPSERT into a table with an index and a subquery in the values clause fails with errorcode 3241.

This will show the problem

create table t015t7 (a int not null, b largeint generated by default as identity not null not droppable unique, c int, primary key(a)) ;
upsert into t015t7 values (1, NVL((select b from t015t7 where a = 1),DEFAULT),10) ;
select * from t015t7;




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---