> -- Error messages contain a keyspace name. Make the output stable.
> CREATE KEYSPACE ks
>     WITH replication = {'class': 'NetworkTopologyStrategy', 'replication_factor': 1} AND
>     tablets = {'enabled': false};
OK
> 
> -- do range delete in batch
> create table ks.t (pk int, ck int, v int, primary key(pk, ck)) with cdc = {'enabled': true, 'preimage': true, 'postimage': true};
OK
> 
> begin batch insert into ks.t (pk, ck, v) values (1, 1, 100); delete from ks.t where pk = 1 and ck >= 1 and ck <= 2; apply batch;
OK
> 
> select "cdc$batch_seq_no", "cdc$operation", pk, ck, v from ks.t_scylla_cdc_log;
+--------------------+-----------------+------+------+------+
|   cdc$batch_seq_no |   cdc$operation |   pk |   ck | v    |
|--------------------+-----------------+------+------+------|
|                  0 |               2 |    1 |    1 | 100  |
|                  1 |               5 |    1 |    1 | null |
|                  2 |               7 |    1 |    2 | null |
+--------------------+-----------------+------+------+------+
> 
> -- do pk delete in batch
> create table ks.t2 (pk int, ck int, v int, primary key(pk, ck)) with cdc = {'enabled': true, 'preimage': true, 'postimage': true};
OK
> 
> begin batch insert into ks.t2 (pk, ck, v) values (1, 1, 100); delete from ks.t2 where pk = 1; apply batch;
OK
> 
> select "cdc$batch_seq_no", "cdc$operation", pk, ck, v from ks.t2_scylla_cdc_log;
+--------------------+-----------------+------+------+------+
|   cdc$batch_seq_no |   cdc$operation |   pk | ck   | v    |
|--------------------+-----------------+------+------+------|
|                  0 |               2 |    1 | 1    | 100  |
|                  1 |               4 |    1 | null | null |
+--------------------+-----------------+------+------+------+
> 
> -- do range delete in batch, but not matching ck
> create table ks.t3 (pk int, ck int, v int, primary key(pk, ck)) with cdc = {'enabled': true, 'preimage': true, 'postimage': true};
OK
> 
> -- do range delete in batch
> begin batch insert into ks.t3 (pk, ck, v) values (1, 1, 100); delete from ks.t3 where pk = 1 and ck >= 2 and ck <= 3; apply batch;
OK
> 
> select "cdc$batch_seq_no", "cdc$operation", pk, ck, v from ks.t3_scylla_cdc_log;
+--------------------+-----------------+------+------+------+
|   cdc$batch_seq_no |   cdc$operation |   pk |   ck | v    |
|--------------------+-----------------+------+------+------|
|                  0 |               2 |    1 |    1 | 100  |
|                  1 |               5 |    1 |    2 | null |
|                  2 |               7 |    1 |    3 | null |
|                  3 |               9 |    1 |    1 | 100  |
+--------------------+-----------------+------+------+------+
> DROP KEYSPACE ks;
OK