You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anoop Sharma (JIRA)" <ji...@apache.org> on 2016/09/27 21:02:20 UTC
[jira] [Created] (TRAFODION-2247) upsert on altered aligned format
table with missing columns inserts incorrect values
Anoop Sharma created TRAFODION-2247:
---------------------------------------
Summary: upsert on altered aligned format table with missing columns inserts incorrect values
Key: TRAFODION-2247
URL: https://issues.apache.org/jira/browse/TRAFODION-2247
Project: Apache Trafodion
Issue Type: Bug
Reporter: Anoop Sharma
Assignee: Selvaganesan Govindarajan
Priority: Minor
If following conditions are present, incorrect values are inserted/returned.
-- table is an aligned format table
-- a column is added to it
-- upsert is used with missing columns
-- cqd traf_upsert_mode is 'MERGE'
If cqd is changed to 'REPLACE', correct values are inserted.
Example 1: (incorrect value inserted)
>>cqd traf_upsert_mode 'MERGE';
--- SQL operation complete.
>>drop table ta;
--- SQL operation complete.
>>create table ta
+>(a char(15) not null primary key,b int)
+>attribute aligned format;
--- SQL operation complete.
>>alter table ta add c int;
--- SQL operation complete.
>>upsert into ta (a, c) values ('0001', 2);
--- 1 row(s) inserted.
>>select c from ta;
C
-----------
-1340071904
--- 1 row(s) selected.
>>
>>
Example 2: (correct value inserted)
>>cqd traf_upsert_mode 'REPLACE';
--- SQL operation complete.
>>drop table ta;
--- SQL operation complete.
>>create table ta
+>(a char(15) not null primary key,b int)
+>attribute aligned format;
--- SQL operation complete.
>>alter table ta add c int;
--- SQL operation complete.
>>upsert into ta (a, c) values ('0001', 2);
--- 1 row(s) inserted.
>>select c from ta;
C
-----------
2
--- 1 row(s) selected.
>>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)