[jira] [Created] (TRAFODION-2775) Insert does not raise duplicate row error for hbase format table with defaulted first column

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

Suresh Subbiah created TRAFODION-2775:
-----------------------------------------

             Summary: Insert does not raise duplicate row error for hbase format table with defaulted first column 
                 Key: TRAFODION-2775
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2775
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
    Affects Versions: any
            Reporter: Suresh Subbiah
            Assignee: Suresh Subbiah
             Fix For: 2.3-incubating


With HBase format Trafodion tables (each column in a row is a separate Cell), if the first column in the table can be defaulted, then uniqueness violations are not raised as expected for INSERT statements. Here is an example

create table def1 (c1 int, c2 int not null, c3 int, primary key (c2)) attributes hbase format;
insert into def1 (c2) values (1);

-- raises unique constraint error as expected
insert into def1 (c2, c3) values (1,3);

-- does not raise constraint error
insert into def1 (c1, c2) values (1,1);

The problem is that during the checkAndPut for INSERTcall we are specifying the column to be checked as the one that has index 0 in the row being inserted. This would the first column being inserted into for the row, as specified by DDL, once omitted columns are removed. Columns with default value could be omitted in a given INSERT, if they are not part of the clustering key.

The fix utilizes that fact that clustering key columns are always present in the row being inserted, even if they can be defaulted and not explicitly in the INSERT statement. We now pass in the index of the first clustering key column, in the row being inserted, to the java layer. The java layer will get the column name/qualifier from the java byte buffer version of row being inserted and use it in the CheckAndPut call. Not that the index of first clustering key column will depend on both which default columns are being skipped and order of columns in DDL. This index does not depend only on DDL.

With the change we get the expected error
>>insert into def1 (c1, c2) values (1,1);

*** ERROR[8102] The operation is prevented by a unique constraint.

--- 0 row(s) inserted.
>>insert into def1 (c2, c1) values (51,1);

--- 1 row(s) inserted.
>>insert into def1 (c2, c1) values (1,51);

*** ERROR[8102] The operation is prevented by a unique constraint.

--- 0 row(s) inserted.





--
This message was sent by Atlassian JIRA
(v6.4.14#64029)