[
https://issues.apache.org/jira/browse/TRAFODION-125?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-125.
----------------------------------
Resolution: Fixed
Fix Version/s: 1.0 (pre-incubation)
> LP Bug: 1233404 - UPSERT/UPDATE cannot update a column to NULL
> --------------------------------------------------------------
>
> Key: TRAFODION-125
> URL: https://issues.apache.org/jira/browse/TRAFODION-125
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Reporter: Weishiun Tsai
> Assignee: Anoop Sharma
> Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> Updating a column to NULL using UPSERT or UPDATE in TOPL has no effect, even
> though the statement execution says that the row is inserted/updated, as
> shown in the following example:
> >>cqd mode_seabase 'on';
> --- SQL operation complete.
> >>set schema seabase.phoenix;
> --- SQL operation complete.
> >>create table t (a int not null not droppable primary key, b char(10));
> --- SQL operation complete.
> >>insert into t values (1, 'a'),(2, 'b'),(3, 'c');
> --- 3 row(s) inserted.
> >>upsert into t (a, b) values(1, null);
> --- 1 row(s) inserted.
> >>select * from t;
> A B
> ----------- ----------
> 1 a
> 2 b
> 3 c
> --- 3 row(s) selected.
> >>update t set b=null where a=1;
> --- 1 row(s) updated.
> >>select * from t;
> A B
> ----------- ----------
> 1 a
> 2 b
> 3 c
> --- 3 row(s) selected.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
