Description
The following test seabase/TEST022 shows strange symptoms on updates on external tables mapped to hbase table.
Commenting out this part of the test. It needs to be re-enabled /uncommented after this JIRA is fixed.
>>select * from t022hbm1;
A B
---- -----------
b ?
— 1 row(s) selected.
>>update t022hbm1 set b = 10;
— 1 row(s) updated.
>>select * from t022hbm1;
— 0 row(s) selected.
>>update t022hbm1 set b = null;
— 0 row(s) updated.
>>select * from t022hbm1;
— 0 row(s) selected.
Part of test script that fails :
cqd traf_hbase_mapped_tables 'ON';
drop hbase table t022hbm1;
create hbase table t022hbm1 (column family 'cf');
insert into hbase."ROW".t022hbm1 values ('a1',
column_create(('cf:B', '100 ')));
insert into hbase."ROW".t022hbm1 values ('a2', column_create(('cf:A', 'a2')));
create external table t022hbm1 (a varchar(4) not null, b int)
primary key (a)
attribute default column family 'cf'
map to hbase table t022hbm1
data format native;
insert into t022hbm1 values ('a', 1);
select * from t022hbm1;
--Non deterministic results from all updates below.
update t022hbm1 set b = b + 1;
select * from t022hbm1;
insert into t022hbm1 values ('a', 1); – should fail
insert into t022hbm1 values ('b', null);
select * from t022hbm1;
delete from t022hbm1 where a = 'a';
select * from t022hbm1;
update t022hbm1 set b = 10;
select * from t022hbm1;
update t022hbm1 set b = null;
select * from t022hbm1;
delete from t022hbm1;
select * from t022hbm1;