[jira] [Created] (TRAFODION-2464) failure to upsert into a table with an index

["Eric Owhadi (JIRA)" <ji...@apache.org>]

Eric Owhadi created TRAFODION-2464:
--------------------------------------

             Summary: failure to upsert into a table with an index
                 Key: TRAFODION-2464
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2464
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
    Affects Versions: 2.2-incubating
            Reporter: Eric Owhadi
         Attachments: osim.tar

create table files
(
directory_id char(36) NOT NULL,
name varchar(256) NOT NULL,
fsize largeint,
owner varchar(50),
primary key (directory_id,name))
SALT USING 8 partitions on (directory_id)
HBASE_OPTIONS (DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'SNAPPY');

create index files_idx_by_directory_id on files(name,directory_id)
SALT LIKE TABLE 
HBASE_OPTIONS (DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'SNAPPY');

prepare s from upsert into files values (?,?,?,?);

*** ERROR[3241] This MERGE statement is not supported. Reason:  Non-unique ON clause not allowed with INSERT. [2017-01-20 00:38:54]
*** ERROR[8822] The statement was not prepared. [2017-01-20 00:38:54]





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)