[
https://issues.apache.org/jira/browse/TRAFODION-125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14696119#comment-14696119
]
Atanu Mishra commented on TRAFODION-125:
----------------------------------------
Weishiun Tsai (wei-shiun-tsai) wrote on 2013-10-24: #1
Verified with the build from 10/23/2013, this bug has been fixed:
>>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 ?
2 b
3 c
--- 3 row(s) selected.
Anoop Sharma (anoop-sharma) on 2013-10-31
Changed in trafodion:
assignee: nobody → Anoop Sharma (anoop-sharma)
Weishiun Tsai (wei-shiun-tsai) on 2013-11-05
Changed in trafodion:
status: New → Fix Released
> 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)
