[jira] [Created] (TRAFODION-125) LP Bug: 1233404 - UPSERT/UPDATE cannot update a column to NULL

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-125:
------------------------------------

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


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)