, ...) fails
[ https://issues.apache.org/jira/browse/TRAFODION-1590?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah resolved TRAFODION-1590.
---------------------------------------
Resolution: Fixed
> 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)