Skip to content

validation job does not handle empty rows with static columns #301

Open
@arvy

Description

@arvy

Given the following data, validation job reports missing row (error - 24/09/05 16:29:33 ERROR DiffJobSession: Missing target row found for key: [A %% %% ]):

cqlsh> create keyspace test with replication = {'class':'SimpleStrategy', 'replication_factor': 1};
cqlsh> use test;
cqlsh:test> CREATE TABLE test.test (     pk text,     ck1 text,     ck2 text,     static_col text static,     col text,     PRIMARY KEY (pk, ck1, ck2) );
cqlsh:test> insert into test(pk, ck1, ck2, static_col , col ) values ('A', 'A', 'A', 'shared attribute', 'blah');
cqlsh:test> select * from test.test;

 pk | ck1 | ck2 | static_col       | col
----+-----+-----+------------------+------
  A |   A |   A | shared attribute | blah

(1 rows)
cqlsh:test> delete from test.test where pk = 'A' AND ck1 = 'A' AND ck2 = 'A';
cqlsh:test> select * from test.test ;

 pk | ck1  | ck2  | static_col       | col
----+------+------+------------------+------
  A | null | null | shared attribute | null

(1 rows)

See full job output attached..
problematic-validation.txt

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions