[
https://issues.apache.org/jira/browse/CASSANDRA-20260?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17936958#comment-17936958
]
David Capwell commented on CASSANDRA-20260:
-------------------------------------------
Found another seed, but this one on a single node!
https://github.com/apache/cassandra/pull/3995
SHA: 24429dd7464e159f3580857a5beadc98098cc979
Test: org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest
Seed: 8266206739438895335
Error
{code}
accord.utils.Property$PropertyError: Property error detected:
Seed = 8266206739438895335
Examples = 2147483647
Pure = true
Steps: 400
Values:
State:
Setup:
CREATE KEYSPACE IF NOT EXISTS ks1 WITH replication = {'class':
'SimpleStrategy', 'replication_factor': 1};
CREATE TYPE IF NOT EXISTS ks1."oPT5" (
f0 blob
);;
CREATE TABLE ks1.tbl (
pk0 timestamp,
pk1 boolean,
ck0 double,
v1 vector<frozen<list<ascii>>, 3>,
v2 frozen<tuple<frozen<tuple<timeuuid>>,
frozen<set<bigint>>>>,
v0 set<frozen<set<bigint>>>,
v3 map<frozen<"oPT5">, frozen<list<float>>>,
v4
set<vector<'org.apache.cassandra.db.marshal.LexicalUUIDType', 3>>,
PRIMARY KEY ((pk0, pk1), ck0)
) WITH CLUSTERING ORDER BY (ck0 ASC)
AND additional_write_policy = '99p'
AND allow_auto_snapshot = true
AND bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'NONE', 'rows_per_partition': 'ALL'}
AND cdc = false
AND comment = ''
AND compaction = {'class':
'org.apache.cassandra.db.compaction.UnifiedCompactionStrategy',
'only_purge_repaired_tombstones': 'false', 'unchecked_tombstone_compaction':
'false'}
AND compression = {'enabled': 'false'}
AND memtable = 'default'
AND crc_check_chance = 1.0
AND default_time_to_live = 0
AND extensions = {}
AND gc_grace_seconds = 864000
AND incremental_backups = true
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair = 'BLOCKING'
AND speculative_retry = '99p';
CREATE CUSTOM INDEX tbl_pk0 ON ks1.tbl(pk0) USING
'StorageAttachedIndex';
CREATE CUSTOM INDEX tbl_pk1 ON ks1.tbl(pk1) USING
'StorageAttachedIndex';
CREATE INDEX tbl_ck0 ON ks1.tbl(ck0) USING 'SAI';
CREATE INDEX tbl_v2 ON ks1.tbl(v2) USING 'SAI';:
org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.State
History:
97: INSERT INTO ks1.tbl (pk0, pk1, ck0, v1, v0, v2, v3) VALUES
('2037-08-12T22:14:26.259Z', false, -9.274161954448436E-263, [['[{}/Jgjb'],
['Tjt\u0010\u001As\u000FF', '-)\u00010P'], ['4\u0012,c}2\u0013%_q', '
\u0012\u0014\u007FK']], {{-8688884050631457010}, {-8118507756657536958,
-2640675262949664, 5526420285858055456}, {-5154053449672996051,
-129212908671047615, 5059596628554492897}},
((00000000-0000-1400-b400-000000000000), {1557874998166205222,
9079798474849577816}), {{f0: 0x5e850022462a9e4581}: [-176178.17,
-3.652127E-32], {f0: 0xcdc8069c9e6a74}: [8.987075E30, -2.2282504E-14], {f0:
0xd9443b105380a41c8a}: [-2.702378E7, 6.655837E32, -4.8635408E-23]}) USING
TIMESTAMP 17 -- on node1
114: UPDATE ks1.tbl USING TIMESTAMP 22 SET
v0={{-7786344996111158257, 1502246465112781733}, {-5994846455621471703,
-5834937678051872753, -3132227036282455703}, {131444918155683521,
1730494078169215414, 7317185112255618514}} WHERE pk0 =
'2037-08-12T22:14:26.259Z' AND pk1 = false AND ck0 = 9.182912721548173E-125 +
-1.6951939329820845E-179 -- on node1
133: UPDATE ks1.tbl USING TIMESTAMP 26 SET
v2=((00000000-0000-1c00-bc00-000000000000), {-4272382564782953140}),
v1=[['\u000D$'], ['ve%'], ['z@bu(^}I']] WHERE pk0 = '2037-08-12T22:14:26.259Z'
AND pk1 = false AND ck0 = 7.220280587612847E-219 -- on node1
162: DELETE v2, v3, v4, v1 FROM ks1.tbl USING TIMESTAMP 30
WHERE pk0 = '2037-08-12T22:14:26.259Z' AND pk1 = false AND ck0 =
8.133344319084387E-143 -- on node1
178: SELECT * FROM ks1.tbl WHERE v1 =
[['\u0012G\u0009\u000E9d\u0004{\u000CK'], ['[7bf\u000D\u00181', '\u001B\u000Fg
\u0013tNC\u0016', '\u0001^Ycn'], ['\u001F[\u0016', '+^\u001Foad|_']] AND v2 =
((00000000-0000-1400-b400-000000000000), {1557874998166205222,
9079798474849577816}) AND pk1 = false AND pk0 = '2037-08-12T22:14:26.259Z' AND
ck0 = -9.274161954448436E-263 ALLOW FILTERING -- v1 vector<frozen<list<ascii>>,
3>, v2 frozen<tuple<frozen<tuple<timeuuid>>, frozen<set<bigint>>>> (indexed
with SAI), pk1 boolean (indexed with SAI), pk0 timestamp (indexed with SAI),
ck0 double (indexed with SAI), on node1, fetch size 1000
SELECT *
FROM ks1.tbl
WHERE
v1 = [['\u0012G\u0009\u000E9d\u0004{\u000CK'], ['[7bf\u000D\u00181',
'\u001B\u000Fg \u0013tNC\u0016', '\u0001^Ycn'], ['\u001F[\u0016',
'+^\u001Foad|_']]
AND v2 = ((00000000-0000-1400-b400-000000000000), {1557874998166205222,
9079798474849577816})
AND pk1 = false
AND pk0 = '2037-08-12T22:14:26.259Z'
AND ck0 = -9.274161954448436E-263
ALLOW FILTERING -- v1 vector<frozen<list<ascii>>, 3>, v2
frozen<tuple<frozen<tuple<timeuuid>>, frozen<set<bigint>>>> (indexed with SAI),
pk1 boolean (indexed with SAI), pk0 timestamp (indexed with SAI), ck0 double
(indexed with SAI), on node1, fetch size 1000
Caused by: java.lang.AssertionError: Unexpected rows found:
v1 = [['[{}/Jgjb'], ['Tjt\u0010\u001As\u000FF', '-)\u00010P'],
['4\u0012,c}2\u0013%_q', ' \u0012\u0014\u007FK']] -- not match
v2 = ((00000000-0000-1400-b400-000000000000), {1557874998166205222,
9079798474849577816}) -- match
pk0 | pk1 | ck0 | v0
| v1
| v2
| v3
| v4
'2037-08-12T22:14:26.259Z' | false | -9.274161954448436E-263 |
{{-8688884050631457010}, {-8118507756657536958, -2640675262949664,
5526420285858055456}, {-5154053449672996051, -129212908671047615,
5059596628554492897}} | [['[{}/Jgjb'], ['Tjt\u0010\u001As\u000FF',
'-)\u00010P'], ['4\u0012,c}2\u0013%_q', ' \u0012\u0014\u007FK']] |
((00000000-0000-1400-b400-000000000000), {1557874998166205222,
9079798474849577816}) | {{f0: 0x5e850022462a9e4581}: [-176178.17,
-3.652127E-32], {f0: 0xcdc8069c9e6a74}: [8.987075E30, -2.2282504E-14], {f0:
0xd9443b105380a41c8a}: [-2.702378E7, 6.655837E32, -4.8635408E-23]} | null
Expected:
pk0 | pk1 | ck0 | v0 | v1 | v2 | v3 | v4
{code}
the column that should have caused us to return nothing is v1
we search for v1 = [['\u0012G\u0009\u000E9d\u0004{\u000CK'],
['[7bf\u000D\u00181', '\u001B\u000Fg \u0013tNC\u0016', '\u0001^Ycn'],
['\u001F[\u0016', '+^\u001Foad|_']]
but we get back v1 = [['[{}/Jgjb'], ['Tjt\u0010\u001As\u000FF', '-)\u00010P'],
['4\u0012,c}2\u0013%_q', ' \u0012\u0014\u007FK']]
these 2 values do not match
> Partition restricted SAI query returned rows that didn't match the clustering
> index column predicate
> ----------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-20260
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20260
> Project: Apache Cassandra
> Issue Type: Bug
> Components: Feature/SAI
> Reporter: David Capwell
> Assignee: Caleb Rackliffe
> Priority: Normal
> Fix For: 5.0.x, 5.1
>
>
> This was found by CASSANDRA-20156
> The failing query is
> {code}
> SELECT * FROM ks1.tbl WHERE pk0 = 00000000-0000-1a00-9a00-000000000000 AND
> pk1 = 0x43c4 AND ck1 = -4662398.5 -- ck1 float, indexed with SAI, on node1,
> fetch size 10
> {code}
> The error was that this returned more rows than expected
> {code}
> Caused by: java.lang.AssertionError: Unexpected rows found:
> pk0 | pk1 | ck0 | ck1
> | s0 | v0
> | v1 | v2 | v3
>
> 00000000-0000-1a00-9a00-000000000000 | 0x43c4 | 4.429273E27 | 1.079069E-27
> | 00000000-0000-1e00-a800-000000000000 |
> 'c94d:711c:637a:b57d:871:63ed:eccf:b326' | 'BC4<=[A*;q'
> | null | 00000000-0000-4100-b200-000000000000
> 00000000-0000-1a00-9a00-000000000000 | 0x43c4 | -8.426509E26 | -7.034981E-18
> | 00000000-0000-1e00-a800-000000000000 |
> '63b4:2e9b:8a42:52f6:6f96:ba1:a154:5f47' | '|Vp'
> | '13:50:58.890279934' | 00000000-0000-4200-a900-000000000000
> 00000000-0000-1a00-9a00-000000000000 | 0x43c4 | 1.4277632E-17 | 1.4851762E-14
> | 00000000-0000-1e00-a800-000000000000 |
> '1f4a:9b86:63e6:4cb4:41ec:8a5a:35a5:c2d1' | null
> | '19:02:44.792645046' | 00000000-0000-4c00-b900-000000000000
> 00000000-0000-1a00-9a00-000000000000 | 0x43c4 | 2.800979E-6 | -4.773874E-16
> | 00000000-0000-1e00-a800-000000000000 |
> '404c:4877:5f2f:1862:b0f7:ef78:b77b:8ed0' |
> 'l|#8Q\u000C:5\u0011a_e\u0002_1S\u0005a' | '07:24:14.125849387' |
> 00000000-0000-4000-9e00-000000000000
> Expected:
> pk0 | pk1 | ck0 | ck1 |
> s0 | v0 | v1 | v2 | v3
> 00000000-0000-1a00-9a00-000000000000 | 0x43c4 | -1.9557544E-23 | -4662398.5 |
> 00000000-0000-1e00-a800-000000000000 | null | null | null | null
> {code}
> Looking at the rows, the partition column matched the query, but "ck1 =
> -4662398.5” did not; below is the same table above, but only showing ck1
> {code}
> ck1
> 1.079069E-27
> -7.034981E-18
> 1.4851762E-14
> -4.773874E-16
> {code}
> The history is as follows
> {code}
> Setup:
> CREATE KEYSPACE IF NOT EXISTS ks1 WITH replication = {'class':
> 'SimpleStrategy', 'replication_factor': 3};
> CREATE TABLE ks1.tbl (
> pk0 timeuuid,
> pk1 blob,
> ck0 float,
> ck1 float,
> s0 timeuuid static,
> v0 inet,
> v1 ascii,
> v2 time,
> v3 uuid,
> PRIMARY KEY ((pk0, pk1), ck0, ck1)
> ) WITH CLUSTERING ORDER BY (ck0 DESC, ck1 ASC)
> AND additional_write_policy = '99p'
> AND allow_auto_snapshot = true
> AND bloom_filter_fp_chance = 0.01
> AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
> AND cdc = false
> AND comment = ''
> AND compaction = {'class':
> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
> 'max_threshold': '32', 'min_threshold': '4'}
> AND compression = {'chunk_length_in_kb': '16', 'class':
> 'org.apache.cassandra.io.compress.LZ4Compressor'}
> AND memtable = 'default'
> AND crc_check_chance = 1.0
> AND default_time_to_live = 0
> AND extensions = {}
> AND gc_grace_seconds = 864000
> AND incremental_backups = true
> AND max_index_interval = 2048
> AND memtable_flush_period_in_ms = 0
> AND min_index_interval = 128
> AND read_repair = 'BLOCKING'
> AND speculative_retry = '99p';
> CREATE CUSTOM INDEX tbl_pk0 ON ks1.tbl(pk0) USING
> 'StorageAttachedIndex';
> CREATE CUSTOM INDEX tbl_ck0 ON ks1.tbl(ck0) USING
> 'StorageAttachedIndex';
> CREATE CUSTOM INDEX tbl_ck1 ON ks1.tbl(ck1) USING
> 'StorageAttachedIndex';
> CREATE INDEX tbl_s0 ON ks1.tbl(s0) USING 'SAI';
> CREATE CUSTOM INDEX tbl_v0 ON ks1.tbl(v0) USING
> 'StorageAttachedIndex';
> CREATE CUSTOM INDEX tbl_v1 ON ks1.tbl(v1) USING
> 'StorageAttachedIndex';
> CREATE INDEX tbl_v2 ON ks1.tbl(v2) USING 'SAI';
> CREATE CUSTOM INDEX tbl_v3 ON ks1.tbl(v3) USING
> 'StorageAttachedIndex';:
> org.apache.cassandra.distributed.test.cql3.MultiNodeTableWalkTest.MultiNodeState
> History:
> 1: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v1, v2) VALUES
> (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b, 3.9126408E7,
> -0.06042214, 00000000-0000-1500-8800-000000000000,
> '\u000C^N8\u0018l\u001E\u0002\u0005''\u007F', '22:44:12.829686634') -- on
> node1
> 2: UPDATE ks1.tbl SET v2='14:23:05.206758317',
> v3=00000000-0000-4300-a300-000000000000,
> s0=00000000-0000-1400-bc00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = -3939631.5 AND ck1 = -7.4054367E-34 -- on node1
> 3: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2)
> VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, -4.7884533E-11,
> 6.49744E-12, 00000000-0000-1a00-af00-000000000000, '42.113.254.246',
> 'x2"\u0008aYTEf\u0018\u000E', '19:50:33.039644700') -- on node1
> 4: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND v1
> = '\u000C^N8\u0018l\u001E\u0002\u0005''\u007F' ALLOW FILTERING -- v1 ascii,
> indexed with SAI, on node2, fetch size 1000
> 5: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc -- on node2
> 6: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v1, v2, v3)
> VALUES (00000000-0000-1300-9b00-000000000000, 0xbc616cacf8cc, -0.0,
> -1.46183056E16, 00000000-0000-1d00-9a00-000000000000, 'T',
> '06:40:16.782581528', 00000000-0000-4f00-af00-000000000000) -- on node2
> 7: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = -3.573471E-37 AND ck1 = -149226.8 -- on node1
> 8: UPDATE ks1.tbl SET s0=00000000-0000-1600-9d00-000000000000,
> v0='177.89.230.119', v1='vw9_\u0012jZe', v2='11:20:38.697601884',
> v3=00000000-0000-4100-af00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 = 3.90934E-38
> AND ck1 = 2.92058989E11 -- on node1
> 9: UPDATE ks1.tbl SET s0=00000000-0000-1100-a500-000000000000,
> v0='b168:4b5f:b9de:57fc:7b51:331a:5b5e:950b', v1='Ij\u0014`u:',
> v2='11:21:01.474103891', v3=00000000-0000-4700-a500-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> 2.66345938E13 AND ck1 = -1.07220136E27 -- on node2
> 10: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND s0 =
> 00000000-0000-1d00-9a00-000000000000 -- s0 timeuuid, indexed with SAI, on
> node3, fetch size 100
> 11: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc -- on node2
> 12: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> 5.155775E-6, -2.620963E-11, 00000000-0000-1400-ab00-000000000000,
> 'e84a:ac9c:7fa8:4bb:cea4:244d:3c5d:ba7', 'Y', '20:30:58.344516505',
> 00000000-0000-4a00-a900-000000000000) -- on node1
> 13: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node1
> 14: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 -- on node1
> 15: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck1 = 2.92058989E11
> -- ck1 float, indexed with SAI, on node1, fetch size 10
> 16: UPDATE ks1.tbl SET s0=00000000-0000-1b00-8800-000000000000,
> v0='132.86.121.70', v1='=\u0006fQ_J\u0010\u000B\u0010O',
> v2='12:47:47.609919903', v3=00000000-0000-4600-b600-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 1.1019037E26 AND ck1 = 8.7040635E9 -- on node3
> 17: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, -1.0525443E-26,
> -1.5053063E-4, 00000000-0000-1400-b200-000000000000,
> '795:bbfb:41de:2654:2a5:6b3c:a682:39fc', 'H$#@#r', '12:21:41.976260492',
> 00000000-0000-4600-aa00-000000000000) -- on node1
> 18: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc -- on node2
> 19: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1) VALUES
> (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b, 2.30954479E17,
> -7.715345E34, 00000000-0000-1400-b100-000000000000,
> '9389:9a9d:fb6:5bfd:981a:29d8:90db:f1bb', '#S\u0011--') -- on node2
> 20: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, 3416809.8,
> 1.01050435E-17, 00000000-0000-1a00-b000-000000000000,
> 'c4e1:cc15:d478:fc19:e2b3:9c5e:f7d6:4177', '\u0009I*\u00194K\u0002Z\u001Db',
> '03:33:41.422901564', 00000000-0000-4100-8a00-000000000000) -- on node1
> 21: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> 8.585775E-12 AND ck1 = -1.05110884E13 -- on node3
> 22: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND ck0
> >= 5.155775E-6 -- ck0 float (reversed), indexed with SAI, on node3, fetch
> size 100
> 23: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 >=
> 'x2"\u0008aYTEf\u0018\u000E' ALLOW FILTERING -- v1 ascii, indexed with SAI,
> on node2, fetch size 100
> 24: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> -2.6011115E-33, -1.7275234E-17, 00000000-0000-1e00-a100-000000000000,
> 'd392:bb8:d805:da47:434f:2ddb:cf36:9267', '\u00055\u000A''\u001D;i\u0006}v',
> '04:26:42.020486427', 00000000-0000-4200-9700-000000000000) -- on node1
> 25: UPDATE ks1.tbl SET s0=00000000-0000-1800-9c00-000000000000,
> v0='199.214.11.4', v1='\u0007\u0017qN&nspRK\u0014#C\u0019T[''',
> v2='04:50:12.420767866', v3=00000000-0000-4a00-bb00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 3.51062621E17 AND ck1 = -2.81644225E14 -- on node3
> 26: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v1, v2) VALUES
> (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b, 5.343385E-18,
> 1.2030147E-8, '\u0011Yx', '18:49:28.608173405') -- on node3
> 27: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v1) VALUES
> (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b, -6.6781567E34,
> -8.591845E-18, '.\u000F') -- on node3
> 28: UPDATE ks1.tbl SET s0=00000000-0000-1700-b800-000000000000,
> v0='7064:c6d0:27c9:3cdf:36e:20c3:80e2:dc3c', v1='P#QU',
> v2='12:21:35.813656611', v3=00000000-0000-4300-b400-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> -8.3304162E13 AND ck1 = -2.45042315E16 -- on node2
> 29: UPDATE ks1.tbl SET s0=00000000-0000-1600-8d00-000000000000,
> v0='153.38.240.170', v1='q\u0006\u0016/|XSvx', v2='20:18:56.821436104',
> v3=00000000-0000-4800-8c00-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> 1.7990661E-9 AND ck1 = -5.6950928E-8 -- on node1
> 30: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND ck0
> = 5.155775E-6 -- ck0 float (reversed), indexed with SAI, on node3, fetch size
> 10
> 31: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND v0 =
> '7064:c6d0:27c9:3cdf:36e:20c3:80e2:dc3c' -- v0 inet, indexed with SAI, on
> node2, fetch size 1
> 32: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node1
> 33: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v3 >=
> 00000000-0000-4100-af00-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node3, fetch size 1
> 34: UPDATE ks1.tbl SET v2='18:12:35.632896927' WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 5.6399273E-22 AND ck1 = -2.1478418E28 -- on node2
> 35: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v3 <
> 00000000-0000-4100-8a00-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node3, fetch size 10
> 36: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b -- on
> node3
> 37: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node3
> 38: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node3
> 39: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, -6.1585875E-12,
> 3.4527965E-33, 00000000-0000-1e00-b700-000000000000,
> 'bfdf:496b:1cab:6f0e:e718:c5b5:7ac2:ddd1', '\u0008\u0003\u000E6\u000Av<',
> '06:31:33.726388233', 00000000-0000-4a00-9600-000000000000) -- on node2
> 40: UPDATE ks1.tbl SET v1='Rs5s[C',
> v3=00000000-0000-4100-a100-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> -7.2468062E10 AND ck1 = -2.2010754E27 -- on node2
> 41: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> 5.2063176E-21, -4.1464355E21, 00000000-0000-1600-a100-000000000000,
> '119.189.172.145', 'U0dPAm\u0005f', '11:45:07.755440093',
> 00000000-0000-4600-9d00-000000000000) -- on node1
> 42: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 >=
> 'vw9_\u0012jZe' ALLOW FILTERING -- v1 ascii, indexed with SAI, on node1,
> fetch size 10
> 43: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 = 3.90934E-38
> -- ck0 float (reversed), indexed with SAI, on node2, fetch size 5000
> 44: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc -- on node1
> 45: UPDATE ks1.tbl SET
> v0='e153:7d81:413:9742:2e30:df64:f584:3324', v1='m\u000F64,|T8Cv',
> v2='12:07:25.854423899' WHERE pk0 = 00000000-0000-1700-8900-000000000000 AND
> pk1 = 0x1435e5 AND ck0 = 8.3323105E36 AND ck1 = 9.2144515E-36 -- on node1
> 46: DELETE v2, v3 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -4.058501E-6 AND ck1 = -2.07374275E10 -- on node1
> 47: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v0 =
> '177.89.230.119' -- v0 inet, indexed with SAI, on node1, fetch size 5000
> 48: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 >=
> 8.3323105E36 -- ck0 float (reversed), indexed with SAI, on node3, fetch size 1
> 49: UPDATE ks1.tbl SET s0=00000000-0000-1d00-b700-000000000000,
> v0='6491:a7b4:a77:d39:bb46:ef54:d5f9:e8a8', v1='7`I',
> v2='16:34:17.992969423', v3=00000000-0000-4200-a800-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -0.25732863 AND ck1 = 125350.484 -- on node3
> 50: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v2 <=
> '19:50:33.039644700' -- v2 time, indexed with SAI, on node2, fetch size 100
> 51: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND ck1
> <= -8.591845E-18 -- ck1 float, indexed with SAI, on node2, fetch size 10
> 52: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056,
> -2.1885552E-32, -2.08532E-18, 00000000-0000-1000-9300-000000000000,
> '248.106.108.246', 'I', '11:31:40.621078157',
> 00000000-0000-4d00-b500-000000000000) -- on node1
> 53: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node3
> 54: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056,
> 1.2107823E20, 8.042996E21, 00000000-0000-1a00-b900-000000000000,
> '134.13.208.237', 'qP\u0013\u00112,', '18:30:09.221625748',
> 00000000-0000-4600-8600-000000000000) -- on node1
> 55: UPDATE ks1.tbl SET s0=00000000-0000-1700-8300-000000000000,
> v0='158.53.2.250', v1='B}q5m\u0015\u000BW9|X\u000F\u000E{',
> v2='04:34:06.433542223', v3=00000000-0000-4e00-a300-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> 1.4019448E-32 AND ck1 = -2.396157E-7 -- on node2
> 56: UPDATE ks1.tbl SET s0=00000000-0000-1300-a200-000000000000,
> v0='160.156.231.46', v1='\X?p', v2='22:30:28.375490223',
> v3=00000000-0000-4c00-a300-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> 7.0859328E8 AND ck1 = -3.8087862E34 -- on node1
> 57: UPDATE ks1.tbl SET v1='1mO[4&\u0017:9',
> v2='14:48:50.322052601', v3=00000000-0000-4c00-b800-000000000000,
> s0=00000000-0000-1d00-9100-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 1.975547E38 AND ck1 = 3.4453657E33 -- on node2
> 58: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 >
> 'x2"\u0008aYTEf\u0018\u000E' ALLOW FILTERING -- v1 ascii, indexed with SAI,
> on node1, fetch size 100
> 59: UPDATE ks1.tbl SET v0='72.225.118.249', v1='AQbF@n',
> v2='16:05:50.089049508', v3=00000000-0000-4d00-af00-000000000000,
> s0=00000000-0000-1e00-8000-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -4.810356E-38 AND ck1 = 1.2137657E-28 -- on node2
> 60: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -1.1656982E21 AND ck1 = 7.1127294E22 -- on node3
> 61: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = 1.8637896E-38 AND ck1 = -2480595.2 -- on node3
> 62: UPDATE ks1.tbl SET s0=00000000-0000-1700-8e00-000000000000,
> v0='223.36.11.182', v1='\u001F\u000D4"', v2='00:08:27.756976755',
> v3=00000000-0000-4c00-af00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = -3.55155837E11 AND ck1 = 3.4343927E-6 -- on node2
> 63: UPDATE ks1.tbl SET v0='228.1.156.39', v1=' p\u00027x',
> v2='15:27:16.693227703' WHERE pk0 = 00000000-0000-1300-9b00-000000000000 AND
> pk1 = 0xbc616cacf8cc AND ck0 = 1.8803083E-22 AND ck1 = -1.23644405E36 --
> on node3
> 64: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, 4.376347E30,
> 8.8932185E-31, 00000000-0000-1e00-ad00-000000000000,
> '3477:92ae:db38:8495:588f:987c:9df:e42a', 'U ?Z(\u0014_U\u0018',
> '07:04:05.355452240', 00000000-0000-4700-9500-000000000000) -- on node2
> 65: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node3
> 66: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> -3.3634148E34, 4.641004E-27, 00000000-0000-1800-b100-000000000000,
> '252.176.61.74', '6\u007F0(>', '17:06:48.008883597',
> 00000000-0000-4d00-bf00-000000000000) -- on node1
> 67: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v1 >= '\X?p'
> ALLOW FILTERING -- v1 ascii, indexed with SAI, on node2, fetch size 5000
> 68: UPDATE ks1.tbl SET v1='v\u000DO#<',
> v2='04:51:16.923863548', v3=00000000-0000-4900-9300-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 = Infinity
> AND ck1 = -1.9526293E34 -- on node3
> 69: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node3
> 70: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v3 =
> 00000000-0000-4c00-a300-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node2, fetch size 10
> 71: UPDATE ks1.tbl SET v1='J\u0012P\u00015',
> v2='10:44:59.002808237', v3=00000000-0000-4900-9100-000000000000,
> s0=00000000-0000-1b00-bb00-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> -4.31642301E14 AND ck1 = 9.7875485E13 -- on node2
> 72: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> 6.32699E-18, -7.510096E-11, 00000000-0000-1400-8400-000000000000,
> '110.251.229.209', 'e=M', '06:18:47.114143060',
> 00000000-0000-4c00-8700-000000000000) -- on node3
> 73: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> -2.3078774E23, -206246.1, 00000000-0000-1900-a900-000000000000,
> '5.217.44.228', '''\u0009v_\u001F\u0010y', '14:55:16.971936812',
> 00000000-0000-4000-b100-000000000000) -- on node3
> 74: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v0 =
> '160.156.231.46' -- v0 inet, indexed with SAI, on node3, fetch size 1
> 75: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node3
> 76: UPDATE ks1.tbl SET
> v1='KWC\u0000\u001F\u0007\u0016\u0006F)\u0006x\u001EbD6l2',
> v2='01:40:42.973544636', v3=00000000-0000-4e00-8300-000000000000,
> s0=00000000-0000-1300-9d00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> 4.518522E-39 AND ck1 = -2.926469E-13 -- on node2
> 77: UPDATE ks1.tbl SET
> v0='f75c:d13e:463a:e7d6:7790:260b:d965:244b', v1='4\u0006J',
> v2='10:13:03.378535819', v3=00000000-0000-4d00-ac00-000000000000,
> s0=00000000-0000-1800-8700-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> -5.621223E24 AND ck1 = 6.5077058E11 -- on node1
> 78: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc -- on node3
> 79: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1700-8900-000000000000, 0x1435e5, 1.3133216E7,
> 2.1733237E-22, 00000000-0000-1100-bf00-000000000000,
> '3dce:9ae4:3d4a:1869:94c6:fb6:8b32:b99e', '\u000B\u0009PK\\u0016',
> '05:29:49.439073439', 00000000-0000-4600-8700-000000000000) -- on node1
> 80: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> 0.0, -3.112209E-14, 00000000-0000-1900-ab00-000000000000,
> 'e784:6246:b8c9:f171:576b:b71a:ad36:230f',
> '\u0008\u0009\u000E\u0005+nmh\\u0019', '03:40:47.037865345',
> 00000000-0000-4400-9300-000000000000) -- on node1
> 81: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v3 =
> 00000000-0000-4d00-ac00-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node3, fetch size 1000
> 82: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck1 < -2.396157E-7
> -- ck1 float, indexed with SAI, on node2, fetch size 1
> 83: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v3) VALUES
> (00000000-0000-1300-9b00-000000000000, 0xbc616cacf8cc, -3.76594739E9,
> -9.810602E29, 00000000-0000-1500-8200-000000000000,
> 00000000-0000-4c00-9800-000000000000) -- on node3
> 84: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v3 <
> 00000000-0000-4600-8700-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node1, fetch size 1000
> 85: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node2
> 86: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v1 = '4\u0006J'
> ALLOW FILTERING -- v1 ascii, indexed with SAI, on node2, fetch size 1
> 87: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND v2
> = '20:30:58.344516505' -- v2 time, indexed with SAI, on node2, fetch size 10
> 88: UPDATE ks1.tbl SET s0=00000000-0000-1500-9b00-000000000000,
> v0='60.110.247.209', v1='w8\u000D\u0019hA', v2='13:47:50.190036504',
> v3=00000000-0000-4200-a400-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -5.016579E-17 AND ck1 = 8087597.5 -- on node1
> 89: UPDATE ks1.tbl SET s0=00000000-0000-1a00-8400-000000000000,
> v0='88ac:e7d9:a50f:31c6:aee9:6c95:5523:8c46', v1='\u0010T',
> v2='22:46:35.659978440', v3=00000000-0000-4a00-a000-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -0.005143338 AND ck1 = 5.7509618E-31 -- on node3
> 90: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node2
> 91: UPDATE ks1.tbl SET v0='46.191.219.198', v1='!'' ,Tr~\u0000'
> WHERE pk0 = 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0
> = 1.37012879E14 AND ck1 = -5.7003304E29 -- on node1
> 92: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v3 <=
> 00000000-0000-4d00-ac00-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node3, fetch size 1000
> 93: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v0 =
> '3dce:9ae4:3d4a:1869:94c6:fb6:8b32:b99e' -- v0 inet, indexed with SAI, on
> node1, fetch size 1
> 94: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND s0 =
> 00000000-0000-1300-9d00-000000000000 -- s0 timeuuid, indexed with SAI, on
> node3, fetch size 10
> 95: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -6.659146E-30 AND ck1 = -6.980914E-4 -- on node1
> 96: DELETE v0, v1, v2, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 = -2.9E-44
> AND ck1 = 26550.854 -- on node2
> 97: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node3
> 98: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056,
> 7.7252524E-20, 3244093.8, 00000000-0000-1200-b100-000000000000,
> '220.176.189.38', '_m\u000E', '03:08:35.869991516',
> 00000000-0000-4900-b000-000000000000) -- on node2
> 99: UPDATE ks1.tbl SET s0=00000000-0000-1600-9500-000000000000,
> v0='205.64.4.156', v1='r\u001AQ\u000A''NY(`', v2='16:39:31.907841655',
> v3=00000000-0000-4200-a800-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> 2.8970135E31 AND ck1 = 2.6218152E-27 -- on node2
> 100: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v1) VALUES
> (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b, 1.96096047E15,
> -3.9188064E-29, 'dbbe:ec0e:5acd:24b5:40ac:d0b6:edf1:f457',
> 'da5\u000Ab$@\u007FiU`6\u0019\u0014|B\u0003') -- on node3
> 101: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1700-8900-000000000000, 0x1435e5, -5.1704368E26,
> 2.6147E36, 00000000-0000-1d00-b100-000000000000,
> '88e7:8962:639f:335f:aa67:122d:d261:f1e8',
> 't\u0007Xag44Ox:\u0013Y\u0008\u0016', '06:14:01.888847098',
> 00000000-0000-4f00-9e00-000000000000) -- on node3
> 102: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b -- on
> node2
> 103: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND v1 =
> 'r\u001AQ\u000A''NY(`' ALLOW FILTERING -- v1 ascii, indexed with SAI, on
> node3, fetch size 10
> 104: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v2 =
> '06:31:33.726388233' -- v2 time, indexed with SAI, on node3, fetch size 1000
> 105: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 3.5965996E32 AND ck1 = -2925.2776 -- on node3
> 106: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node1
> 107: DELETE v0, v1, v2, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> 8.7705308E12 AND ck1 = 183195.17 -- on node1
> 108: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b -- on
> node3
> 109: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck1 > 2.6147E36
> -- ck1 float, indexed with SAI, on node3, fetch size 10
> 110: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND v3 <
> 00000000-0000-4c00-9800-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node2, fetch size 5000
> 111: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> 5.115253E36 AND ck1 = -1.4953537E35 -- on node2
> 112: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 =
> '\u0009I*\u00194K\u0002Z\u001Db' ALLOW FILTERING -- v1 ascii, indexed with
> SAI, on node3, fetch size 10
> 113: UPDATE ks1.tbl SET
> s0=00000000-0000-1c00-a300-000000000000, v0='155.51.77.178',
> v1='''X6=\u0000;\u000AnQ)}HY\u001F\u0004', v2='04:30:56.067584635',
> v3=00000000-0000-4400-be00-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -2.6579422E34 AND ck1 = 141.55142 -- on node2
> 114: UPDATE ks1.tbl SET
> s0=00000000-0000-1400-9600-000000000000,
> v0='4fbe:a70d:1039:3fae:f10b:cc12:1ea4:ef7f', v1='bI3!\u001DQ',
> v2='19:50:00.785693976', v3=00000000-0000-4300-9c00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -1.0240982E-31 AND ck1 = 1.297678E-18 -- on node3
> 115: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v1, v2)
> VALUES (00000000-0000-1300-9b00-000000000000, 0xbc616cacf8cc, -3.7644042E22,
> 1.3635951E25, '202.130.164.73', '\u001A2\u0006}#nF\u0006',
> '10:31:33.305812753') -- on node3
> 116: UPDATE ks1.tbl SET
> s0=00000000-0000-1000-9400-000000000000, v0='95.159.239.28',
> v1='s\u0011Ly:v\u0017', v2='05:22:23.488941521',
> v3=00000000-0000-4c00-b600-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> Infinity AND ck1 = -4.5929028E-6 -- on node2
> 117: DELETE v1, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> 3.0441892E25 AND ck1 = 0.94670504 -- on node3
> 118: UPDATE ks1.tbl SET v0='164.165.155.50',
> v1='\u000B|H\u000E@mfhojJC1\u000EZH',
> v3=00000000-0000-4700-9f00-000000000000,
> s0=00000000-0000-1b00-9300-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 1.73990773E11 AND ck1 = 2.5369937E15 -- on node3
> 119: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 > 1.4019448E-32
> -- ck0 float (reversed), indexed with SAI, on node3, fetch size 5000
> 120: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck1 <
> -1.23644405E36 -- ck1 float, indexed with SAI, on node3, fetch size 5000
> 121: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b -- on
> node2
> 122: DELETE v0, v1, v3, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> 5.054E-42 AND ck1 = -1.8021822E34 -- on node2
> 123: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -1.3458954E32 AND ck1 = 1.4795695E22 -- on node1
> 124: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND ck1
> = 141.55142 -- ck1 float, indexed with SAI, on node3, fetch size 5000
> 125: UPDATE ks1.tbl SET
> s0=00000000-0000-1500-ad00-000000000000, v0='141.86.44.108',
> v1='m+M\u0013}\u0011u]um', v2='07:46:57.501593589',
> v3=00000000-0000-4400-af00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 7.46962E-40 AND ck1 = 8.334567E33 -- on node2
> 126: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 -- on node1
> 127: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1700-8900-000000000000, 0x1435e5, -5.41859248E14,
> 5.242651E16, 00000000-0000-1500-9400-000000000000,
> '1896:a017:1ed4:40e3:ddf9:52e3:237d:99f0',
> '^\u001F\u001B\u000C\u0010~\u000F', '09:16:59.028775830',
> 00000000-0000-4000-9000-000000000000) -- on node1
> 128: UPDATE ks1.tbl SET
> s0=00000000-0000-1800-8a00-000000000000,
> v0='404c:4877:5f2f:1862:b0f7:ef78:b77b:8ed0',
> v1='l|#8Q\u000C:5\u0011a_e\u0002_1S\u0005a', v2='07:24:14.125849387',
> v3=00000000-0000-4000-9e00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 = 2.800979E-6
> AND ck1 = -4.773874E-16 -- on node1
> 129: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck1 = -4.773874E-16
> -- ck1 float, indexed with SAI, on node1, fetch size 10
> 130: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND v2
> = '07:46:57.501593589' -- v2 time, indexed with SAI, on node3, fetch size 1000
> 131: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND ck0
> > -2.6579422E34 -- ck0 float (reversed), indexed with SAI, on node2, fetch
> size 1000
> 132: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND v2
> = '07:46:57.501593589' -- v2 time, indexed with SAI, on node3, fetch size 5000
> 133: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck1 <=
> 5.242651E16 -- ck1 float, indexed with SAI, on node1, fetch size 5000
> 134: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v3)
> VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, 4.429273E27,
> 1.079069E-27, 00000000-0000-1200-b700-000000000000,
> 'c94d:711c:637a:b57d:871:63ed:eccf:b326', 'BC4<=[A*;q',
> 00000000-0000-4100-b200-000000000000) -- on node3
> 135: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND s0 =
> 00000000-0000-1500-9400-000000000000 -- s0 timeuuid, indexed with SAI, on
> node1, fetch size 100
> 136: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v2, v3)
> VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, 1.4277632E-17,
> 1.4851762E-14, '1f4a:9b86:63e6:4cb4:41ec:8a5a:35a5:c2d1',
> '19:02:44.792645046', 00000000-0000-4c00-b900-000000000000) -- on node2
> 137: UPDATE ks1.tbl SET
> s0=00000000-0000-1100-b600-000000000000,
> v0='64e0:308:4625:33a:351c:2b56:b0e9:7962',
> v1='ZGa\u001AXl\u0013@C^,je\u000C', v2='17:33:24.704732628',
> v3=00000000-0000-4e00-9d00-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> -6.5684874E9 AND ck1 = -2.0885974E38 -- on node1
> 138: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0) VALUES
> (00000000-0000-1300-9b00-000000000000, 0xbc616cacf8cc, -1.2198655E31,
> -941.34375, 00000000-0000-1d00-b300-000000000000) -- on node1
> 139: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc -- on node3
> 140: UPDATE ks1.tbl SET
> s0=00000000-0000-1d00-9900-000000000000, v0='46.47.8.185', v1='H?[\u001AA[Q',
> v2='07:50:19.302086792', v3=00000000-0000-4300-9a00-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> 1.8296492E-33 AND ck1 = -7.4892119E18 -- on node1
> 141: UPDATE ks1.tbl SET
> s0=00000000-0000-1400-8700-000000000000,
> v0='a002:b391:67a8:bc7b:cf6f:dced:ec97:248',
> v1='=s\u0016\u001Ff*My3\u001F\u0007', v2='19:51:01.081965539',
> v3=00000000-0000-4400-9f00-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> 3.4142426E29 AND ck1 = -218.01987 -- on node3
> 142: DELETE v0, v1, v2, v3 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = -1.6435483E30 AND ck1 = -1.2726513E-15 -- on node1
> 143: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> -6.8868025E30 AND ck1 = -169792.25 -- on node2
> 144: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v2, v3) VALUES
> (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056, 4.5550785E-24,
> 1.5267758E-22, '22:01:22.759393760', 00000000-0000-4800-8700-000000000000) --
> on node1
> 145: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node1
> 146: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND s0
> <= 00000000-0000-1500-ad00-000000000000 -- s0 timeuuid, indexed with SAI, on
> node2, fetch size 1000
> 147: UPDATE ks1.tbl SET v2='16:32:05.834483616',
> s0=00000000-0000-1600-b200-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> 6.739983E28 AND ck1 = 5.1827553E34 -- on node1
> 148: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND v0
> = '164.165.155.50' -- v0 inet, indexed with SAI, on node2, fetch size 1000
> 149: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node3
> 150: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b -- on
> node1
> 151: UPDATE ks1.tbl SET
> s0=00000000-0000-1a00-b700-000000000000,
> v0='63b4:2e9b:8a42:52f6:6f96:ba1:a154:5f47', v1='|Vp',
> v2='13:50:58.890279934', v3=00000000-0000-4200-a900-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -8.426509E26 AND ck1 = -7.034981E-18 -- on node2
> 152: DELETE v2, v3, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -6.1000307E25 AND ck1 = 1.845821E30 -- on node1
> 153: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v1, v2, v3)
> VALUES (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056,
> 2.3308414E-5, -1.3970188E-12, '138.249.40.209', '\u001DL\u0010*',
> '19:05:35.977999420', 00000000-0000-4600-8300-000000000000) -- on node3
> 154: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v3) VALUES
> (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b, 3.5642678E-30,
> -1.32221716E10, 00000000-0000-1b00-9000-000000000000,
> 00000000-0000-4a00-8600-000000000000) -- on node3
> 155: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v3 =
> 00000000-0000-4100-b200-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node1, fetch size 1000
> 156: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b -- on
> node1
> 157: UPDATE ks1.tbl SET
> v0='6b44:db72:fee7:6b90:7618:dd1:af51:ba8b', v1='^pk\u001Cg#8r\u000C{',
> v2='18:36:14.687739598', v3=00000000-0000-4e00-8c00-000000000000,
> s0=00000000-0000-1b00-a400-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -0.0015161237 AND ck1 = -0.07879668 -- on node1
> 158: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND s0 =
> 00000000-0000-1a00-b700-000000000000 -- s0 timeuuid, indexed with SAI, on
> node3, fetch size 5000
> 159: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0) VALUES
> (00000000-0000-1a00-9a00-000000000000, 0x43c4, -1.9557544E-23, -4662398.5,
> 00000000-0000-1500-a000-000000000000) -- on node1
> 160: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc -- on node1
> 161: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND v2
> >= '19:05:35.977999420' -- v2 time, indexed with SAI, on node3, fetch size
> 1000
> 162: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056,
> 169352.6, 3.1821653E-29, 00000000-0000-1800-b300-000000000000,
> 'c51:8aa8:b931:738c:2c48:73df:e07c:2710', '\u001B\B\u0017tA@bWT''',
> '02:35:48.450959617', 00000000-0000-4500-ae00-000000000000) -- on node3
> 163: UPDATE ks1.tbl SET v2='17:43:31.055411177' WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = -2.0465186E-22 AND ck1 = -5.416531E-32 -- on node2
> 164: UPDATE ks1.tbl SET
> s0=00000000-0000-1100-b200-000000000000,
> v0='6569:766:e43f:cd13:5964:dcfc:4e55:8ee5',
> v1='E\u0012\u001Ad\u000EFM?\u000C', v2='12:14:31.926081833',
> v3=00000000-0000-4b00-9a00-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -9.430983E26 AND ck1 = -4.9213124E27 -- on node3
> 165: UPDATE ks1.tbl SET
> s0=00000000-0000-1400-9700-000000000000, v0='230.147.134.119', v1='J#N{#',
> v2='15:00:36.501664717', v3=00000000-0000-4700-b000-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 9.1612353E24 AND ck1 = Infinity -- on node2
> 166: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node2
> 167: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v1, v2, v3)
> VALUES (00000000-0000-1700-8900-000000000000, 0x1435e5, -3.2666418E-7,
> -Infinity, '210.227.70.142', 'ne4', '08:53:29.549448969',
> 00000000-0000-4100-8600-000000000000) -- on node3
> 168: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> -3.5367293E34, -2.671921E36, 00000000-0000-1600-9800-000000000000,
> '6050:8d3b:bce0:71e6:e530:7301:1bb1:25ec', 'Jgjs\0\u0015-9vK',
> '20:55:39.790823592', 00000000-0000-4200-a600-000000000000) -- on node3
> 169: UPDATE ks1.tbl SET
> s0=00000000-0000-1900-af00-000000000000,
> v0='8d1e:95a6:32d1:a476:d4c0:f46a:6ce6:f265', v1='"_.x<5\u001A<{du',
> v2='08:07:43.997748514', v3=00000000-0000-4d00-b100-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> -3.6642891E16 AND ck1 = -2.3244775E-36 -- on node2
> 170: UPDATE ks1.tbl SET v0='174.36.208.187',
> v1='6GFB2,f|`+\u0008', v2='16:04:05.989678722',
> v3=00000000-0000-4e00-9400-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> -4.25435752E17 AND ck1 = 3.8912956E-10 -- on node3
> 171: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node3
> 172: UPDATE ks1.tbl SET
> s0=00000000-0000-1e00-a400-000000000000, v0='164.138.209.142', v1='/i|L$',
> v2='23:20:24.580231280', v3=00000000-0000-4c00-bf00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = -9.817127E17 AND ck1 = 1.61168304E16 -- on node1
> 173: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND v2
> > '12:14:31.926081833' -- v2 time, indexed with SAI, on node1, fetch size 100
> 174: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0) VALUES
> (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056,
> -2.8363295E-24, -1.6050915E-32, 00000000-0000-1f00-b000-000000000000,
> 'ac86:643d:e68c:2281:46ee:973b:3ca8:e7d0') -- on node3
> 175: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v1, v3)
> VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> 6.4036305E32, -1.559556E28, 00000000-0000-1f00-9000-000000000000,
> 'q4\u000DVg\u001Ds\u0009\u0016\u000B', 00000000-0000-4f00-9000-000000000000)
> -- on node1
> 176: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v2) VALUES
> (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056, 1.5440257E36,
> -9.89419E20, '13:13:39.417627537') -- on node1
> 177: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck1 =
> -9.810602E29 -- ck1 float, indexed with SAI, on node2, fetch size 1
> 178: UPDATE ks1.tbl SET
> s0=00000000-0000-1f00-a200-000000000000,
> v0='aca0:41b2:8f5c:ce93:f2eb:641f:8bf6:857b', v1='\u0010',
> v2='18:27:06.811070434', v3=00000000-0000-4900-ac00-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> -1.7123172E-20 AND ck1 = -1.815043E30 -- on node3
> 179: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0) VALUES
> (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056, -1.994664E33,
> -6.6795436E-10, 00000000-0000-1e00-bf00-000000000000, '121.241.27.111') -- on
> node1
> 180: UPDATE ks1.tbl SET
> s0=00000000-0000-1200-8c00-000000000000, v0='197.253.181.241', v1='\u0005$>N
> Rr\u0001', v2='14:22:43.286043646', v3=00000000-0000-4a00-9500-000000000000
> WHERE pk0 = 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND
> ck0 = 7.897556E-38 AND ck1 = -5.7388403E15 -- on node2
> 181: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 = '|Vp' ALLOW
> FILTERING -- v1 ascii, indexed with SAI, on node3, fetch size 100
> 182: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND v0
> = '6050:8d3b:bce0:71e6:e530:7301:1bb1:25ec' -- v0 inet, indexed with SAI, on
> node2, fetch size 10
> 183: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node3
> 184: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND s0
> > 00000000-0000-1e00-bf00-000000000000 -- s0 timeuuid, indexed with SAI, on
> node3, fetch size 1
> 185: UPDATE ks1.tbl SET
> v0='959f:33af:a799:4ba9:3963:1fde:1ff0:499', v1='\u000D\u0014QC(d\u000D#?',
> v3=00000000-0000-4100-8900-000000000000,
> s0=00000000-0000-1900-a100-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = 1.6164839E22 AND ck1 = -8.9732003E-13 -- on node3
> 186: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> -1.6586984E38 AND ck1 = -7.8906546 -- on node1
> 187: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v2, v3)
> VALUES (00000000-0000-1300-9b00-000000000000, 0xbc616cacf8cc, 3.0868463E27,
> -3.4876246E-6, 00000000-0000-1c00-9200-000000000000, '162.66.201.39',
> '13:03:09.037525107', 00000000-0000-4600-be00-000000000000) -- on node1
> 188: UPDATE ks1.tbl SET
> s0=00000000-0000-1600-9f00-000000000000,
> v0='5d05:27f3:f720:a231:3507:ac6f:d38a:4fcd', v1=';',
> v2='20:08:08.493955526', v3=00000000-0000-4c00-bc00-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = 9.8860102E12 AND ck1 = 3.27723E24 -- on node1
> 189: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND v1 >=
> 'H?[\u001AA[Q' ALLOW FILTERING -- v1 ascii, indexed with SAI, on node1, fetch
> size 1
> 190: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> -2.2532921E-14, -Infinity, 00000000-0000-1600-ab00-000000000000,
> '6834:6500:7328:6683:fca7:356a:f1e4:91ef', '?9+v\u000Fb\u0006''Up_\u0000',
> '04:53:42.167112131', 00000000-0000-4c00-a600-000000000000) -- on node2
> 191: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -6.6272735E12 AND ck1 = -3.6597164E24 -- on node3
> 192: UPDATE ks1.tbl SET
> s0=00000000-0000-1e00-a800-000000000000, v0='215.75.110.198', v1='U"',
> v2='16:13:07.973684672', v3=00000000-0000-4200-8200-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> 2.7056329E16 AND ck1 = 9.522172E28 -- on node1
> 193: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck1 = -4662398.5 --
> ck1 float, indexed with SAI, on node1, fetch size 10
> at accord.utils.Property$StatefulBuilder.check(Property.java:504)
> at
> org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.test(SingleNodeTableWalkTest.java:367)
> Caused by: java.lang.AssertionError: Unexpected rows found:
> pk0 | pk1 | ck0 | ck1
> | s0 | v0
> | v1 | v2 | v3
>
> 00000000-0000-1a00-9a00-000000000000 | 0x43c4 | 4.429273E27 | 1.079069E-27
> | 00000000-0000-1e00-a800-000000000000 |
> 'c94d:711c:637a:b57d:871:63ed:eccf:b326' | 'BC4<=[A*;q'
> | null | 00000000-0000-4100-b200-000000000000
> 00000000-0000-1a00-9a00-000000000000 | 0x43c4 | -8.426509E26 | -7.034981E-18
> | 00000000-0000-1e00-a800-000000000000 |
> '63b4:2e9b:8a42:52f6:6f96:ba1:a154:5f47' | '|Vp'
> | '13:50:58.890279934' | 00000000-0000-4200-a900-000000000000
> 00000000-0000-1a00-9a00-000000000000 | 0x43c4 | 1.4277632E-17 | 1.4851762E-14
> | 00000000-0000-1e00-a800-000000000000 |
> '1f4a:9b86:63e6:4cb4:41ec:8a5a:35a5:c2d1' | null
> | '19:02:44.792645046' | 00000000-0000-4c00-b900-000000000000
> 00000000-0000-1a00-9a00-000000000000 | 0x43c4 | 2.800979E-6 | -4.773874E-16
> | 00000000-0000-1e00-a800-000000000000 |
> '404c:4877:5f2f:1862:b0f7:ef78:b77b:8ed0' |
> 'l|#8Q\u000C:5\u0011a_e\u0002_1S\u0005a' | '07:24:14.125849387' |
> 00000000-0000-4000-9e00-000000000000
> Expected:
> pk0 | pk1 | ck0 | ck1 |
> s0 | v0 | v1 | v2 | v3
> 00000000-0000-1a00-9a00-000000000000 | 0x43c4 | -1.9557544E-23 | -4662398.5 |
> 00000000-0000-1e00-a800-000000000000 | null | null | null | null
> {code}
> I trimmed this history down (but didn’t test) to just this partition
> {code}
> History:
> 3: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2)
> VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, -4.7884533E-11,
> 6.49744E-12, 00000000-0000-1a00-af00-000000000000, '42.113.254.246',
> 'x2"\u0008aYTEf\u0018\u000E', '19:50:33.039644700') -- on node1
> 8: UPDATE ks1.tbl SET s0=00000000-0000-1600-9d00-000000000000,
> v0='177.89.230.119', v1='vw9_\u0012jZe', v2='11:20:38.697601884',
> v3=00000000-0000-4100-af00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 = 3.90934E-38
> AND ck1 = 2.92058989E11 -- on node1
> 14: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 -- on node1
> 15: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck1 = 2.92058989E11
> -- ck1 float, indexed with SAI, on node1, fetch size 10
> 17: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, -1.0525443E-26,
> -1.5053063E-4, 00000000-0000-1400-b200-000000000000,
> '795:bbfb:41de:2654:2a5:6b3c:a682:39fc', 'H$#@#r', '12:21:41.976260492',
> 00000000-0000-4600-aa00-000000000000) -- on node1
> 20: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, 3416809.8,
> 1.01050435E-17, 00000000-0000-1a00-b000-000000000000,
> 'c4e1:cc15:d478:fc19:e2b3:9c5e:f7d6:4177', '\u0009I*\u00194K\u0002Z\u001Db',
> '03:33:41.422901564', 00000000-0000-4100-8a00-000000000000) -- on node1
> 23: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 >=
> 'x2"\u0008aYTEf\u0018\u000E' ALLOW FILTERING -- v1 ascii, indexed with SAI,
> on node2, fetch size 100
> 33: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v3 >=
> 00000000-0000-4100-af00-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node3, fetch size 1
> 35: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v3 <
> 00000000-0000-4100-8a00-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node3, fetch size 10
> 39: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, -6.1585875E-12,
> 3.4527965E-33, 00000000-0000-1e00-b700-000000000000,
> 'bfdf:496b:1cab:6f0e:e718:c5b5:7ac2:ddd1', '\u0008\u0003\u000E6\u000Av<',
> '06:31:33.726388233', 00000000-0000-4a00-9600-000000000000) -- on node2
> 42: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 >=
> 'vw9_\u0012jZe' ALLOW FILTERING -- v1 ascii, indexed with SAI, on node1,
> fetch size 10
> 43: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 = 3.90934E-38
> -- ck0 float (reversed), indexed with SAI, on node2, fetch size 5000
> 47: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v0 =
> '177.89.230.119' -- v0 inet, indexed with SAI, on node1, fetch size 5000
> 50: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v2 <=
> '19:50:33.039644700' -- v2 time, indexed with SAI, on node2, fetch size 100
> 55: UPDATE ks1.tbl SET s0=00000000-0000-1700-8300-000000000000,
> v0='158.53.2.250', v1='B}q5m\u0015\u000BW9|X\u000F\u000E{',
> v2='04:34:06.433542223', v3=00000000-0000-4e00-a300-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> 1.4019448E-32 AND ck1 = -2.396157E-7 -- on node2
> 58: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 >
> 'x2"\u0008aYTEf\u0018\u000E' ALLOW FILTERING -- v1 ascii, indexed with SAI,
> on node1, fetch size 100
> 60: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -1.1656982E21 AND ck1 = 7.1127294E22 -- on node3
> 64: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, 4.376347E30,
> 8.8932185E-31, 00000000-0000-1e00-ad00-000000000000,
> '3477:92ae:db38:8495:588f:987c:9df:e42a', 'U ?Z(\u0014_U\u0018',
> '07:04:05.355452240', 00000000-0000-4700-9500-000000000000) -- on node2
> 76: UPDATE ks1.tbl SET
> v1='KWC\u0000\u001F\u0007\u0016\u0006F)\u0006x\u001EbD6l2',
> v2='01:40:42.973544636', v3=00000000-0000-4e00-8300-000000000000,
> s0=00000000-0000-1300-9d00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> 4.518522E-39 AND ck1 = -2.926469E-13 -- on node2
> 82: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck1 < -2.396157E-7
> -- ck1 float, indexed with SAI, on node2, fetch size 1
> 91: UPDATE ks1.tbl SET v0='46.191.219.198', v1='!'' ,Tr~\u0000'
> WHERE pk0 = 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0
> = 1.37012879E14 AND ck1 = -5.7003304E29 -- on node1
> 94: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND s0 =
> 00000000-0000-1300-9d00-000000000000 -- s0 timeuuid, indexed with SAI, on
> node3, fetch size 10
> 95: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -6.659146E-30 AND ck1 = -6.980914E-4 -- on node1
> 96: DELETE v0, v1, v2, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 = -2.9E-44
> AND ck1 = 26550.854 -- on node2
> 104: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v2 =
> '06:31:33.726388233' -- v2 time, indexed with SAI, on node3, fetch size 1000
> 112: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 =
> '\u0009I*\u00194K\u0002Z\u001Db' ALLOW FILTERING -- v1 ascii, indexed with
> SAI, on node3, fetch size 10
> 114: UPDATE ks1.tbl SET
> s0=00000000-0000-1400-9600-000000000000,
> v0='4fbe:a70d:1039:3fae:f10b:cc12:1ea4:ef7f', v1='bI3!\u001DQ',
> v2='19:50:00.785693976', v3=00000000-0000-4300-9c00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -1.0240982E-31 AND ck1 = 1.297678E-18 -- on node3
> 117: DELETE v1, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> 3.0441892E25 AND ck1 = 0.94670504 -- on node3
> 119: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 > 1.4019448E-32
> -- ck0 float (reversed), indexed with SAI, on node3, fetch size 5000
> 123: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -1.3458954E32 AND ck1 = 1.4795695E22 -- on node1
> 126: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 -- on node1
> 128: UPDATE ks1.tbl SET
> s0=00000000-0000-1800-8a00-000000000000,
> v0='404c:4877:5f2f:1862:b0f7:ef78:b77b:8ed0',
> v1='l|#8Q\u000C:5\u0011a_e\u0002_1S\u0005a', v2='07:24:14.125849387',
> v3=00000000-0000-4000-9e00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 = 2.800979E-6
> AND ck1 = -4.773874E-16 -- on node1
> 129: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck1 = -4.773874E-16
> -- ck1 float, indexed with SAI, on node1, fetch size 10
> 134: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v3)
> VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, 4.429273E27,
> 1.079069E-27, 00000000-0000-1200-b700-000000000000,
> 'c94d:711c:637a:b57d:871:63ed:eccf:b326', 'BC4<=[A*;q',
> 00000000-0000-4100-b200-000000000000) -- on node3
> 136: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v2, v3)
> VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, 1.4277632E-17,
> 1.4851762E-14, '1f4a:9b86:63e6:4cb4:41ec:8a5a:35a5:c2d1',
> '19:02:44.792645046', 00000000-0000-4c00-b900-000000000000) -- on node2
> 151: UPDATE ks1.tbl SET
> s0=00000000-0000-1a00-b700-000000000000,
> v0='63b4:2e9b:8a42:52f6:6f96:ba1:a154:5f47', v1='|Vp',
> v2='13:50:58.890279934', v3=00000000-0000-4200-a900-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -8.426509E26 AND ck1 = -7.034981E-18 -- on node2
> 155: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v3 =
> 00000000-0000-4100-b200-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node1, fetch size 1000
> 158: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND s0 =
> 00000000-0000-1a00-b700-000000000000 -- s0 timeuuid, indexed with SAI, on
> node3, fetch size 5000
> 159: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0) VALUES
> (00000000-0000-1a00-9a00-000000000000, 0x43c4, -1.9557544E-23, -4662398.5,
> 00000000-0000-1500-a000-000000000000) -- on node1
> 181: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 = '|Vp' ALLOW
> FILTERING -- v1 ascii, indexed with SAI, on node3, fetch size 100
> 192: UPDATE ks1.tbl SET
> s0=00000000-0000-1e00-a800-000000000000, v0='215.75.110.198', v1='U"',
> v2='16:13:07.973684672', v3=00000000-0000-4200-8200-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> 2.7056329E16 AND ck1 = 9.522172E28 -- on node1
> 193: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck1 = -4662398.5 --
> ck1 float, indexed with SAI, on node1, fetch size 10
> {code}
> If these histories do not reproduce, that is likely because of functions… the
> queries above are not the “real” queries as I “apply” the operations (+, -,
> /) and inline the value… Below is the raw unmodified history
> {code}
> History:
> 1: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v1, v2) VALUES
> (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b, 3.9126408E7,
> 1.2770186E-15 + -0.06042214, 00000000-0000-1500-8800-000000000000,
> '\u000C^N8\u0018l' + '\u001E\u0002\u0005''\u007F', '22:44:12.829686634') --
> on node1
> 2: UPDATE ks1.tbl SET v2='14:23:05.206758317',
> v3=00000000-0000-4300-a300-000000000000,
> s0=00000000-0000-1400-bc00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = -3939631.5 AND ck1 = -7.4054367E-34 -- on node1
> 3: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2)
> VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, -2.0522589E-35 +
> -4.7884533E-11, 6.49744E-12, 00000000-0000-1a00-af00-000000000000,
> '42.113.254.246', 'x2"\u0008aYTEf\u0018' + '\u000E', '19:50:33.039644700') --
> on node1
> 4: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND v1
> = '\u000C^N8\u0018l\u001E\u0002\u0005''\u007F' ALLOW FILTERING -- v1 ascii,
> indexed with SAI, on node2, fetch size 1000
> 5: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc -- on node2
> 6: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v1, v2, v3)
> VALUES (00000000-0000-1300-9b00-000000000000, 0xbc616cacf8cc, -1.2622806E-25
> * 1.0532843E-36, 4.17486E-34 - 1.46183056E16,
> 00000000-0000-1d00-9a00-000000000000, 'T', '06:40:16.782581528',
> 00000000-0000-4f00-af00-000000000000) -- on node2
> 7: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = -3.573471E-37 AND ck1 = -149226.8 -- on node1
> 8: UPDATE ks1.tbl SET s0=00000000-0000-1600-9d00-000000000000,
> v0='177.89.230.119', v1='vw9_\u0012jZe', v2='11:20:38.697601884',
> v3=00000000-0000-4100-af00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 = 3.90934E-38
> AND ck1 = 2.92058989E11 - -1.6660906E-33 -- on node1
> 9: UPDATE ks1.tbl SET s0=00000000-0000-1100-a500-000000000000,
> v0='b168:4b5f:b9de:57fc:7b51:331a:5b5e:950b', v1='Ij\u0014`' + 'u:',
> v2='11:21:01.474103891', v3=00000000-0000-4700-a500-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> 2.66345938E13 + 0.2303875 AND ck1 = 0.0046333377 - 1.07220136E27 -- on node2
> 10: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND s0 =
> 00000000-0000-1d00-9a00-000000000000 -- s0 timeuuid, indexed with SAI, on
> node3, fetch size 100
> 11: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc -- on node2
> 12: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> 5.155775E-6, 8.1087446E-25 - 2.620963E-11,
> 00000000-0000-1400-ab00-000000000000,
> 'e84a:ac9c:7fa8:4bb:cea4:244d:3c5d:ba7', 'Y', '20:30:58.344516505',
> 00000000-0000-4a00-a900-000000000000) -- on node1
> 13: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node1
> 14: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 -- on node1
> 15: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck1 = 2.92058989E11
> -- ck1 float, indexed with SAI, on node1, fetch size 10
> 16: UPDATE ks1.tbl SET s0=00000000-0000-1b00-8800-000000000000,
> v0='132.86.121.70', v1='=\u0006' + 'fQ_J\u0010\u000B\u0010O',
> v2='12:47:47.609919903', v3=00000000-0000-4600-b600-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 1.1019037E26 + -8.896373E-21 AND ck1 = 8.7040635E9 -- on node3
> 17: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, -1.0525443E-26,
> -1.5053063E-4, 00000000-0000-1400-b200-000000000000,
> '795:bbfb:41de:2654:2a5:6b3c:a682:39fc', 'H$#@#' + 'r', '12:21:41.976260492',
> 00000000-0000-4600-aa00-000000000000) -- on node1
> 18: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc -- on node2
> 19: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1) VALUES
> (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b, 2.30954479E17,
> -7.715345E34 - -2.518413E23, 00000000-0000-1400-b100-000000000000,
> '9389:9a9d:fb6:5bfd:981a:29d8:90db:f1bb', '#S\u0011-' + '-') -- on node2
> 20: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, 3416809.8 +
> -2.2406131E-7, 1.01050435E-17, 00000000-0000-1a00-b000-000000000000,
> 'c4e1:cc15:d478:fc19:e2b3:9c5e:f7d6:4177', '\u0009I' +
> '*\u00194K\u0002Z\u001Db', '03:33:41.422901564',
> 00000000-0000-4100-8a00-000000000000) -- on node1
> 21: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> 8.585775E-12 AND ck1 = -1.05110884E13 -- on node3
> 22: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND ck0
> >= 5.155775E-6 -- ck0 float (reversed), indexed with SAI, on node3, fetch
> size 100
> 23: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 >=
> 'x2"\u0008aYTEf\u0018\u000E' ALLOW FILTERING -- v1 ascii, indexed with SAI,
> on node2, fetch size 100
> 24: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> -2.6011115E-33, -1.7275234E-17 + -5.5765382E-27,
> 00000000-0000-1e00-a100-000000000000,
> 'd392:bb8:d805:da47:434f:2ddb:cf36:9267', '\u00055\u000A' +
> '''\u001D;i\u0006}v', '04:26:42.020486427',
> 00000000-0000-4200-9700-000000000000) -- on node1
> 25: UPDATE ks1.tbl SET s0=00000000-0000-1800-9c00-000000000000,
> v0='199.214.11.4', v1='\u0007\u0017qN&nspRK' + '\u0014#C\u0019T[''',
> v2='04:50:12.420767866', v3=00000000-0000-4a00-bb00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = -2.8522713E19 * -0.0123081785 AND ck1 = -2.81644225E14 -- on node3
> 26: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v1, v2) VALUES
> (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b, 5.343385E-18,
> -3.964605E21 * -3.0343873E-30, '\u0011Yx', '18:49:28.608173405') -- on node3
> 27: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v1) VALUES
> (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b, -6.6781567E34,
> -8.591845E-18, '.\u000F') -- on node3
> 28: UPDATE ks1.tbl SET s0=00000000-0000-1700-b800-000000000000,
> v0='7064:c6d0:27c9:3cdf:36e:20c3:80e2:dc3c', v1='P#QU',
> v2='12:21:35.813656611', v3=00000000-0000-4300-b400-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> -8.3304162E13 AND ck1 = -2.45002694E16 - 3.9623257E12 -- on node2
> 29: UPDATE ks1.tbl SET s0=00000000-0000-1600-8d00-000000000000,
> v0='153.38.240.170', v1='q\u0006\u0016/|XSvx', v2='20:18:56.821436104',
> v3=00000000-0000-4800-8c00-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> 1.7990661E-9 + -4.1670916E-21 AND ck1 = -5.6303154E-17 + -5.6950928E-8 -- on
> node1
> 30: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND ck0
> = 5.155775E-6 -- ck0 float (reversed), indexed with SAI, on node3, fetch size
> 10
> 31: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND v0 =
> '7064:c6d0:27c9:3cdf:36e:20c3:80e2:dc3c' -- v0 inet, indexed with SAI, on
> node2, fetch size 1
> 32: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node1
> 33: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v3 >=
> 00000000-0000-4100-af00-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node3, fetch size 1
> 34: UPDATE ks1.tbl SET v2='18:12:35.632896927' WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 5.6399273E-22 AND ck1 = -2.1478418E28 + 2.763306E7 -- on node2
> 35: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v3 <
> 00000000-0000-4100-8a00-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node3, fetch size 10
> 36: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b -- on
> node3
> 37: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node3
> 38: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node3
> 39: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, -6.1585875E-12,
> 3.4527965E-33, 00000000-0000-1e00-b700-000000000000,
> 'bfdf:496b:1cab:6f0e:e718:c5b5:7ac2:ddd1', '\u0008\u0003\u000E6\u000Av<',
> '06:31:33.726388233', 00000000-0000-4a00-9600-000000000000) -- on node2
> 40: UPDATE ks1.tbl SET v1='Rs5s[C',
> v3=00000000-0000-4100-a100-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> -7.2468062E10 - 8.6083034E-8 AND ck1 = -2.2010754E27 - -2.504704E8 -- on
> node2
> 41: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> 3.182638E-34 * 1.63584965E13, 3886759.8 * -1.06681035E15,
> 00000000-0000-1600-a100-000000000000, '119.189.172.145', 'U0dPAm\u0005f',
> '11:45:07.755440093', 00000000-0000-4600-9d00-000000000000) -- on node1
> 42: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 >=
> 'vw9_\u0012jZe' ALLOW FILTERING -- v1 ascii, indexed with SAI, on node1,
> fetch size 10
> 43: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 = 3.90934E-38
> -- ck0 float (reversed), indexed with SAI, on node2, fetch size 5000
> 44: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc -- on node1
> 45: UPDATE ks1.tbl SET
> v0='e153:7d81:413:9742:2e30:df64:f584:3324', v1='m\u000F64,|T8C' + 'v',
> v2='12:07:25.854423899' WHERE pk0 = 00000000-0000-1700-8900-000000000000 AND
> pk1 = 0x1435e5 AND ck0 = 4.103479 * 2.030548E36 AND ck1 = 9.2144515E-36 --
> on node1
> 46: DELETE v2, v3 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -1.9038166E-34 - 4.058501E-6 AND ck1 = -2.07374275E10 - 4.7874258E-26
> -- on node1
> 47: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v0 =
> '177.89.230.119' -- v0 inet, indexed with SAI, on node1, fetch size 5000
> 48: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 >=
> 8.3323105E36 -- ck0 float (reversed), indexed with SAI, on node3, fetch size 1
> 49: UPDATE ks1.tbl SET s0=00000000-0000-1d00-b700-000000000000,
> v0='6491:a7b4:a77:d39:bb46:ef54:d5f9:e8a8', v1='7`I',
> v2='16:34:17.992969423', v3=00000000-0000-4200-a800-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -0.25732863 AND ck1 = 125350.484 -- on node3
> 50: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v2 <=
> '19:50:33.039644700' -- v2 time, indexed with SAI, on node2, fetch size 100
> 51: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND ck1
> <= -8.591845E-18 -- ck1 float, indexed with SAI, on node2, fetch size 10
> 52: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056,
> -2.1885552E-32, -6.8744534E-24 - 2.0853132E-18,
> 00000000-0000-1000-9300-000000000000, '248.106.108.246', 'I',
> '11:31:40.621078157', 00000000-0000-4d00-b500-000000000000) -- on node1
> 53: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node3
> 54: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056,
> 8.203147E17 + 1.20257914E20, 6.6712116E16 * 120562.75,
> 00000000-0000-1a00-b900-000000000000, '134.13.208.237', 'qP\u0013\u00112,',
> '18:30:09.221625748', 00000000-0000-4600-8600-000000000000) -- on node1
> 55: UPDATE ks1.tbl SET s0=00000000-0000-1700-8300-000000000000,
> v0='158.53.2.250', v1='B}q5m\u0015' + '\u000BW9|X\u000F\u000E{',
> v2='04:34:06.433542223', v3=00000000-0000-4e00-a300-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 = -32419.412
> * -4.3243994E-37 AND ck1 = -2.396157E-7 -- on node2
> 56: UPDATE ks1.tbl SET s0=00000000-0000-1300-a200-000000000000,
> v0='160.156.231.46', v1='\X?p', v2='22:30:28.375490223',
> v3=00000000-0000-4c00-a300-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> 7.2292781E8 + -1.4334497E7 AND ck1 = -8.0352246E-11 + -3.8087862E34 -- on
> node1
> 57: UPDATE ks1.tbl SET v1='1mO[4&\u0017:9',
> v2='14:48:50.322052601', v3=00000000-0000-4c00-b800-000000000000,
> s0=00000000-0000-1d00-9100-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 1.975547E38 - -7.49231E-14 AND ck1 = 3.4453657E33 -- on node2
> 58: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 >
> 'x2"\u0008aYTEf\u0018\u000E' ALLOW FILTERING -- v1 ascii, indexed with SAI,
> on node1, fetch size 100
> 59: UPDATE ks1.tbl SET v0='72.225.118.249', v1='AQbF@n',
> v2='16:05:50.089049508', v3=00000000-0000-4d00-af00-000000000000,
> s0=00000000-0000-1e00-8000-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -4.810356E-38 AND ck1 = 1.2137657E-28 -- on node2
> 60: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 = -46345.223
> - 1.1656982E21 AND ck1 = 5.1113192E15 + 7.112729E22 -- on node3
> 61: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = 1.8637896E-38 AND ck1 = -2480595.2 -- on node3
> 62: UPDATE ks1.tbl SET s0=00000000-0000-1700-8e00-000000000000,
> v0='223.36.11.182', v1='\u001F\u000D4"', v2='00:08:27.756976755',
> v3=00000000-0000-4c00-af00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = -3.55155837E11 AND ck1 = 3.4343927E-6 -- on node2
> 63: UPDATE ks1.tbl SET v0='228.1.156.39', v1=' p\u00027x',
> v2='15:27:16.693227703' WHERE pk0 = 00000000-0000-1300-9b00-000000000000 AND
> pk1 = 0xbc616cacf8cc AND ck0 = 1.8803083E-22 AND ck1 = -1.23644405E36 --
> on node3
> 64: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, 4.376082E30 +
> 2.649682E26, 8.8932185E-31, 00000000-0000-1e00-ad00-000000000000,
> '3477:92ae:db38:8495:588f:987c:9df:e42a', 'U ?Z(\u0014' + '_U\u0018',
> '07:04:05.355452240', 00000000-0000-4700-9500-000000000000) -- on node2
> 65: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node3
> 66: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> -3.3634148E34 + -9.212552E-18, 4.641004E-27,
> 00000000-0000-1800-b100-000000000000, '252.176.61.74', '6\u007F0(>',
> '17:06:48.008883597', 00000000-0000-4d00-bf00-000000000000) -- on node1
> 67: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v1 >= '\X?p'
> ALLOW FILTERING -- v1 ascii, indexed with SAI, on node2, fetch size 5000
> 68: UPDATE ks1.tbl SET v1='v\u000DO#<',
> v2='04:51:16.923863548', v3=00000000-0000-4900-9300-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> -7.5658074E23 * -2.5736355E31 AND ck1 = -7.7963757E-29 - 1.9526293E34 -- on
> node3
> 69: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node3
> 70: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v3 =
> 00000000-0000-4c00-a300-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node2, fetch size 10
> 71: UPDATE ks1.tbl SET v1='J\u0012P\u00015',
> v2='10:44:59.002808237', v3=00000000-0000-4900-9100-000000000000,
> s0=00000000-0000-1b00-bb00-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> -4.31642301E14 AND ck1 = 9.7875485E13 + 3.1455703E-32 -- on node2
> 72: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> 6.32699E-18, -7.510096E-11, 00000000-0000-1400-8400-000000000000,
> '110.251.229.209', 'e=M', '06:18:47.114143060',
> 00000000-0000-4c00-8700-000000000000) -- on node3
> 73: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> -2.3078774E23, -206246.1, 00000000-0000-1900-a900-000000000000,
> '5.217.44.228', '''\u0009v_\u001F\u0010y', '14:55:16.971936812',
> 00000000-0000-4000-b100-000000000000) -- on node3
> 74: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v0 =
> '160.156.231.46' -- v0 inet, indexed with SAI, on node3, fetch size 1
> 75: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node3
> 76: UPDATE ks1.tbl SET v1='KWC\u0000\u001F\u0007\u0016\u0006F)'
> + '\u0006x\u001EbD6l2', v2='01:40:42.973544636',
> v3=00000000-0000-4e00-8300-000000000000,
> s0=00000000-0000-1300-9d00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -2.965508E-38 * -0.15236926 AND ck1 = -2.926469E-13 + -3.5367273E-34 -- on
> node2
> 77: UPDATE ks1.tbl SET
> v0='f75c:d13e:463a:e7d6:7790:260b:d965:244b', v1='4\u0006J',
> v2='10:13:03.378535819', v3=00000000-0000-4d00-ac00-000000000000,
> s0=00000000-0000-1800-8700-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> -5.621223E24 - 7.0664289E16 AND ck1 = -0.71652716 - -6.5077058E11 -- on node1
> 78: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc -- on node3
> 79: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1700-8900-000000000000, 0x1435e5, 1.3133216E7,
> 2.1733237E-22, 00000000-0000-1100-bf00-000000000000,
> '3dce:9ae4:3d4a:1869:94c6:fb6:8b32:b99e', '\u000B\u0009PK\\u0016',
> '05:29:49.439073439', 00000000-0000-4600-8700-000000000000) -- on node1
> 80: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> 9.3119203E-38 * 1.4801453E-33, -3.112209E-14,
> 00000000-0000-1900-ab00-000000000000,
> 'e784:6246:b8c9:f171:576b:b71a:ad36:230f', '\u0008' +
> '\u0009\u000E\u0005+nmh\\u0019', '03:40:47.037865345',
> 00000000-0000-4400-9300-000000000000) -- on node1
> 81: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v3 =
> 00000000-0000-4d00-ac00-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node3, fetch size 1000
> 82: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck1 < -2.396157E-7
> -- ck1 float, indexed with SAI, on node2, fetch size 1
> 83: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v3) VALUES
> (00000000-0000-1300-9b00-000000000000, 0xbc616cacf8cc, -1.6708728E8 *
> 22.538803, -9.8105275E29 + -7.4435143E24,
> 00000000-0000-1500-8200-000000000000, 00000000-0000-4c00-9800-000000000000)
> -- on node3
> 84: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v3 <
> 00000000-0000-4600-8700-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node1, fetch size 1000
> 85: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node2
> 86: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v1 = '4\u0006J'
> ALLOW FILTERING -- v1 ascii, indexed with SAI, on node2, fetch size 1
> 87: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND v2
> = '20:30:58.344516505' -- v2 time, indexed with SAI, on node2, fetch size 10
> 88: UPDATE ks1.tbl SET s0=00000000-0000-1500-9b00-000000000000,
> v0='60.110.247.209', v1='w8\u000D\u0019hA', v2='13:47:50.190036504',
> v3=00000000-0000-4200-a400-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -5.016579E-17 AND ck1 = 8087597.5 -- on node1
> 89: UPDATE ks1.tbl SET s0=00000000-0000-1a00-8400-000000000000,
> v0='88ac:e7d9:a50f:31c6:aee9:6c95:5523:8c46', v1='\u0010T',
> v2='22:46:35.659978440', v3=00000000-0000-4a00-a000-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -3.275359E-35 + -0.005143338 AND ck1 = 2.8276326E-34 * 2033.8434 -- on
> node3
> 90: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node2
> 91: UPDATE ks1.tbl SET v0='46.191.219.198', v1='!'' ,Tr' +
> '~\u0000' WHERE pk0 = 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4
> AND ck0 = 1.37012879E14 AND ck1 = -5.7003304E29 + -1.7479499E19 -- on node1
> 92: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v3 <=
> 00000000-0000-4d00-ac00-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node3, fetch size 1000
> 93: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND v0 =
> '3dce:9ae4:3d4a:1869:94c6:fb6:8b32:b99e' -- v0 inet, indexed with SAI, on
> node1, fetch size 1
> 94: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND s0 =
> 00000000-0000-1300-9d00-000000000000 -- s0 timeuuid, indexed with SAI, on
> node3, fetch size 10
> 95: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -6.659146E-30 AND ck1 = -6.980914E-4 - -1.1539498E-26 -- on node1
> 96: DELETE v0, v1, v2, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -3.2783727E-20 * 8.98499E-25 AND ck1 = 26550.854 -- on node2
> 97: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node3
> 98: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056,
> 7.7252524E-20, 3244093.8, 00000000-0000-1200-b100-000000000000,
> '220.176.189.38', '_m\u000E', '03:08:35.869991516',
> 00000000-0000-4900-b000-000000000000) -- on node2
> 99: UPDATE ks1.tbl SET s0=00000000-0000-1600-9500-000000000000,
> v0='205.64.4.156', v1='r\u001AQ\u000A''NY(`', v2='16:39:31.907841655',
> v3=00000000-0000-4200-a800-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> 10.519851 + 2.8970135E31 AND ck1 = 2.6218152E-27 -- on node2
> 100: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v1) VALUES
> (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b, -5.181001E-33
> - -1.96096047E15, -3.9188064E-29, 'dbbe:ec0e:5acd:24b5:40ac:d0b6:edf1:f457',
> 'da5\u000Ab$@\u007Fi' + 'U`6\u0019\u0014|B\u0003') -- on node3
> 101: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1700-8900-000000000000, 0x1435e5, -5.1704368E26 -
> 3.3644576E-6, 2.6146981E36 - -1.8503501E30,
> 00000000-0000-1d00-b100-000000000000,
> '88e7:8962:639f:335f:aa67:122d:d261:f1e8', 't\u0007Xag44Ox' +
> ':\u0013Y\u0008\u0016', '06:14:01.888847098',
> 00000000-0000-4f00-9e00-000000000000) -- on node3
> 102: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b -- on
> node2
> 103: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND v1 =
> 'r\u001AQ\u000A''NY(`' ALLOW FILTERING -- v1 ascii, indexed with SAI, on
> node3, fetch size 10
> 104: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v2 =
> '06:31:33.726388233' -- v2 time, indexed with SAI, on node3, fetch size 1000
> 105: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 3.5965996E32 + 3.9372128E-7 AND ck1 = 4.901881E-31 * -5.967663E33 --
> on node3
> 106: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node1
> 107: DELETE v0, v1, v2, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> -1.1688785E-7 * -7.503373E19 AND ck1 = 183195.17 -- on node1
> 108: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b -- on
> node3
> 109: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck1 > 2.6147E36
> -- ck1 float, indexed with SAI, on node3, fetch size 10
> 110: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND v3 <
> 00000000-0000-4c00-9800-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node2, fetch size 5000
> 111: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> 1.2617534E7 - -5.115253E36 AND ck1 = -1.5329274E33 * 97.5489 -- on node2
> 112: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 =
> '\u0009I*\u00194K\u0002Z\u001Db' ALLOW FILTERING -- v1 ascii, indexed with
> SAI, on node3, fetch size 10
> 113: UPDATE ks1.tbl SET
> s0=00000000-0000-1c00-a300-000000000000, v0='155.51.77.178', v1='''X6=\u0000'
> + ';\u000AnQ)}HY\u001F\u0004', v2='04:30:56.067584635',
> v3=00000000-0000-4400-be00-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -2.6579422E34 + -1.4424903E26 AND ck1 = 141.55142 -- on node2
> 114: UPDATE ks1.tbl SET
> s0=00000000-0000-1400-9600-000000000000,
> v0='4fbe:a70d:1039:3fae:f10b:cc12:1ea4:ef7f', v1='bI3!\u001D' + 'Q',
> v2='19:50:00.785693976', v3=00000000-0000-4300-9c00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -0.008441127 * 1.2132245E-29 AND ck1 = 1.297678E-18 -- on node3
> 115: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v1, v2)
> VALUES (00000000-0000-1300-9b00-000000000000, 0xbc616cacf8cc, -3.7644042E22,
> 1.3635951E25 + 7.007998E10, '202.130.164.73', '\u001A2\u0006}' + '#nF\u0006',
> '10:31:33.305812753') -- on node3
> 116: UPDATE ks1.tbl SET
> s0=00000000-0000-1000-9400-000000000000, v0='95.159.239.28', v1='s\u0011Ly' +
> ':v\u0017', v2='05:22:23.488941521', v3=00000000-0000-4c00-b600-000000000000
> WHERE pk0 = 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc
> AND ck0 = -27334.166 * -2.8864159E38 AND ck1 = -4.5929028E-6 -- on node2
> 117: DELETE v1, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -2.3481108E-34 + 3.0441892E25 AND ck1 = -1832.5112 * -5.166162E-4 -- on node3
> 118: UPDATE ks1.tbl SET v0='164.165.155.50',
> v1='\u000B|H\u000E@mfhoj' + 'JC1\u000EZH',
> v3=00000000-0000-4700-9f00-000000000000,
> s0=00000000-0000-1b00-9300-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = -3.0667435E26 * -5.67347E-16 AND ck1 = 2.5369937E15 -- on node3
> 119: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 > 1.4019448E-32
> -- ck0 float (reversed), indexed with SAI, on node3, fetch size 5000
> 120: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck1 <
> -1.23644405E36 -- ck1 float, indexed with SAI, on node3, fetch size 5000
> 121: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b -- on
> node2
> 122: DELETE v0, v1, v3, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> 6.2343286E-21 * 8.1081315E-22 AND ck1 = -1.802182E34 - 2.1776817E27 -- on
> node2
> 123: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> -1.3458954E32 AND ck1 = -3.2532647E-11 - -1.4795695E22 -- on node1
> 124: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND ck1
> = 141.55142 -- ck1 float, indexed with SAI, on node3, fetch size 5000
> 125: UPDATE ks1.tbl SET
> s0=00000000-0000-1500-ad00-000000000000, v0='141.86.44.108', v1='m+M\u0013}'
> + '\u0011u]um', v2='07:46:57.501593589',
> v3=00000000-0000-4400-af00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 7.355247E-17 * 1.0155505E-23 AND ck1 = -8660040.0 * -9.624167E26 -- on
> node2
> 126: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 -- on node1
> 127: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1700-8900-000000000000, 0x1435e5, 0.0077440715 -
> 5.41859248E14, 5.242651E16, 00000000-0000-1500-9400-000000000000,
> '1896:a017:1ed4:40e3:ddf9:52e3:237d:99f0',
> '^\u001F\u001B\u000C\u0010~\u000F', '09:16:59.028775830',
> 00000000-0000-4000-9000-000000000000) -- on node1
> 128: UPDATE ks1.tbl SET
> s0=00000000-0000-1800-8a00-000000000000,
> v0='404c:4877:5f2f:1862:b0f7:ef78:b77b:8ed0', v1='l|#8Q\u000C:5' +
> '\u0011a_e\u0002_1S\u0005a', v2='07:24:14.125849387',
> v3=00000000-0000-4000-9e00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 = 2.800979E-6
> AND ck1 = -4.773874E-16 -- on node1
> 129: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck1 = -4.773874E-16
> -- ck1 float, indexed with SAI, on node1, fetch size 10
> 130: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND v2
> = '07:46:57.501593589' -- v2 time, indexed with SAI, on node3, fetch size 1000
> 131: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND ck0
> > -2.6579422E34 -- ck0 float (reversed), indexed with SAI, on node2, fetch
> size 1000
> 132: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND v2
> = '07:46:57.501593589' -- v2 time, indexed with SAI, on node3, fetch size 5000
> 133: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck1 <=
> 5.242651E16 -- ck1 float, indexed with SAI, on node1, fetch size 5000
> 134: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v3)
> VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, 4.429273E27,
> 1.079069E-27, 00000000-0000-1200-b700-000000000000,
> 'c94d:711c:637a:b57d:871:63ed:eccf:b326', 'BC4<=[A' + '*;q',
> 00000000-0000-4100-b200-000000000000) -- on node3
> 135: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND s0 =
> 00000000-0000-1500-9400-000000000000 -- s0 timeuuid, indexed with SAI, on
> node1, fetch size 100
> 136: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v2, v3)
> VALUES (00000000-0000-1a00-9a00-000000000000, 0x43c4, 1.4277632E-17,
> 1.4851762E-14, '1f4a:9b86:63e6:4cb4:41ec:8a5a:35a5:c2d1',
> '19:02:44.792645046', 00000000-0000-4c00-b900-000000000000) -- on node2
> 137: UPDATE ks1.tbl SET
> s0=00000000-0000-1100-b600-000000000000,
> v0='64e0:308:4625:33a:351c:2b56:b0e9:7962', v1='ZGa\u001AX' +
> 'l\u0013@C^,je\u000C', v2='17:33:24.704732628',
> v3=00000000-0000-4e00-9d00-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> -6.5684874E9 AND ck1 = -2.0885974E38 -- on node1
> 138: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0) VALUES
> (00000000-0000-1300-9b00-000000000000, 0xbc616cacf8cc, -1.2198655E31,
> -941.34375 - 5.444576E-6, 00000000-0000-1d00-b300-000000000000) -- on node1
> 139: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc -- on node3
> 140: UPDATE ks1.tbl SET
> s0=00000000-0000-1d00-9900-000000000000, v0='46.47.8.185', v1='H?[\u001AA[Q',
> v2='07:50:19.302086792', v3=00000000-0000-4300-9a00-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> 1.53364825E-27 * 1.1930044E-6 AND ck1 = -4.2647176E-37 + -7.4892119E18 -- on
> node1
> 141: UPDATE ks1.tbl SET
> s0=00000000-0000-1400-8700-000000000000,
> v0='a002:b391:67a8:bc7b:cf6f:dced:ec97:248', v1='=s' +
> '\u0016\u001Ff*My3\u001F\u0007', v2='19:51:01.081965539',
> v3=00000000-0000-4400-9f00-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> 3.4142426E29 AND ck1 = -218.01987 -- on node3
> 142: DELETE v0, v1, v2, v3 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = -1.6435483E30 AND ck1 = -1.2726513E-15 -- on node1
> 143: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> 4.0122724E-29 - 6.8868025E30 AND ck1 = -169792.25 -- on node2
> 144: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v2, v3) VALUES
> (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056, 4.5550785E-24,
> 3.0355893E-27 - -1.5267454E-22, '22:01:22.759393760',
> 00000000-0000-4800-8700-000000000000) -- on node1
> 145: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node1
> 146: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND s0
> <= 00000000-0000-1500-ad00-000000000000 -- s0 timeuuid, indexed with SAI, on
> node2, fetch size 1000
> 147: UPDATE ks1.tbl SET v2='16:32:05.834483616',
> s0=00000000-0000-1600-b200-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> 6.739983E28 AND ck1 = 5.1827553E34 - -1.4345801E-9 -- on node1
> 148: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND v0
> = '164.165.155.50' -- v0 inet, indexed with SAI, on node2, fetch size 1000
> 149: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node3
> 150: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b -- on
> node1
> 151: UPDATE ks1.tbl SET
> s0=00000000-0000-1a00-b700-000000000000,
> v0='63b4:2e9b:8a42:52f6:6f96:ba1:a154:5f47', v1='|Vp',
> v2='13:50:58.890279934', v3=00000000-0000-4200-a900-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> 1.6891052E25 + -8.595419E26 AND ck1 = -7.034981E-18 -- on node2
> 152: DELETE v2, v3, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -6.1000307E25 AND ck1 = -2.8604097E29 * -6.4529953 -- on node1
> 153: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v1, v2, v3)
> VALUES (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056,
> 2.3308414E-5, 1045.8298 * -1.3357993E-15, '138.249.40.209', '\u001DL\u0010*',
> '19:05:35.977999420', 00000000-0000-4600-8300-000000000000) -- on node3
> 154: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v3) VALUES
> (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b, 3.5642678E-30,
> -1.30488125E10 - 1.73359488E8, 00000000-0000-1b00-9000-000000000000,
> 00000000-0000-4a00-8600-000000000000) -- on node3
> 155: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v3 =
> 00000000-0000-4100-b200-000000000000 ALLOW FILTERING -- v3 uuid, indexed with
> SAI, on node1, fetch size 1000
> 156: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b -- on
> node1
> 157: UPDATE ks1.tbl SET
> v0='6b44:db72:fee7:6b90:7618:dd1:af51:ba8b', v1='^' + 'pk\u001Cg#8r\u000C{',
> v2='18:36:14.687739598', v3=00000000-0000-4e00-8c00-000000000000,
> s0=00000000-0000-1b00-a400-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -0.0015161237 - -5.2146132E-23 AND ck1 = -1.0040361E-14 + -0.07879668
> -- on node1
> 158: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND s0 =
> 00000000-0000-1a00-b700-000000000000 -- s0 timeuuid, indexed with SAI, on
> node3, fetch size 5000
> 159: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0) VALUES
> (00000000-0000-1a00-9a00-000000000000, 0x43c4, -1.9557544E-23, -7.996202E-23
> - 4662398.5, 00000000-0000-1500-a000-000000000000) -- on node1
> 160: DELETE s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc -- on node1
> 161: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND v2
> >= '19:05:35.977999420' -- v2 time, indexed with SAI, on node3, fetch size
> 1000
> 162: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056,
> -0.030599704 - -169352.62, 3.1821653E-29,
> 00000000-0000-1800-b300-000000000000,
> 'c51:8aa8:b931:738c:2c48:73df:e07c:2710', '\u001B\B\u0017t' + 'A@bWT''',
> '02:35:48.450959617', 00000000-0000-4500-ae00-000000000000) -- on node3
> 163: UPDATE ks1.tbl SET v2='17:43:31.055411177' WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = -2.0465186E-22 AND ck1 = 4.400449E-13 * -1.2309042E-19 -- on node2
> 164: UPDATE ks1.tbl SET
> s0=00000000-0000-1100-b200-000000000000,
> v0='6569:766:e43f:cd13:5964:dcfc:4e55:8ee5',
> v1='E\u0012\u001Ad\u000EFM?\u000C', v2='12:14:31.926081833',
> v3=00000000-0000-4b00-9a00-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -8.65028E-33 + -9.430983E26 AND ck1 = -4.9213124E27 -- on node3
> 165: UPDATE ks1.tbl SET
> s0=00000000-0000-1400-9700-000000000000, v0='230.147.134.119', v1='J#N{#',
> v2='15:00:36.501664717', v3=00000000-0000-4700-b000-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 9.1612353E24 AND ck1 = 2.9754792E35 * 1.273944E21 -- on node2
> 166: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node2
> 167: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v1, v2, v3)
> VALUES (00000000-0000-1700-8900-000000000000, 0x1435e5, -3.2666418E-7 -
> -1.0896855E-27, -9.394811E22 * 4.0056397E32, '210.227.70.142', 'n' + 'e4',
> '08:53:29.549448969', 00000000-0000-4100-8600-000000000000) -- on node3
> 168: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> -3.5367293E34, -2.671921E36, 00000000-0000-1600-9800-000000000000,
> '6050:8d3b:bce0:71e6:e530:7301:1bb1:25ec', 'Jgjs\0\u0015-' + '9vK',
> '20:55:39.790823592', 00000000-0000-4200-a600-000000000000) -- on node3
> 169: UPDATE ks1.tbl SET
> s0=00000000-0000-1900-af00-000000000000,
> v0='8d1e:95a6:32d1:a476:d4c0:f46a:6ce6:f265', v1='"' + '_.x<5\u001A<{du',
> v2='08:07:43.997748514', v3=00000000-0000-4d00-b100-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> -3.6642891E16 AND ck1 = -2.3244775E-36 -- on node2
> 170: UPDATE ks1.tbl SET v0='174.36.208.187', v1='6GFB' +
> '2,f|`+\u0008', v2='16:04:05.989678722',
> v3=00000000-0000-4e00-9400-000000000000 WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck0 =
> -4.25435752E17 AND ck1 = 3.8912956E-10 -- on node3
> 171: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 -- on
> node3
> 172: UPDATE ks1.tbl SET
> s0=00000000-0000-1e00-a400-000000000000, v0='164.138.209.142', v1='/i|L$',
> v2='23:20:24.580231280', v3=00000000-0000-4c00-bf00-000000000000 WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND
> ck0 = 2.563945E-20 + -9.817127E17 AND ck1 = 1.61168304E16 -- on node1
> 173: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND v2
> > '12:14:31.926081833' -- v2 time, indexed with SAI, on node1, fetch size 100
> 174: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0) VALUES
> (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056,
> -2.8363295E-24, -1.6050915E-32, 00000000-0000-1f00-b000-000000000000,
> 'ac86:643d:e68c:2281:46ee:973b:3ca8:e7d0') -- on node3
> 175: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v1, v3)
> VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> 6.4036305E32, -1.559556E28, 00000000-0000-1f00-9000-000000000000,
> 'q4\u000DVg\u001Ds\u0009\u0016\u000B', 00000000-0000-4f00-9000-000000000000)
> -- on node1
> 176: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v2) VALUES
> (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056, -2758564.5 +
> 1.5440257E36, -9.894023E20 + -1.67435123E16, '13:13:39.417627537') -- on node1
> 177: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND ck1 =
> -9.810602E29 -- ck1 float, indexed with SAI, on node2, fetch size 1
> 178: UPDATE ks1.tbl SET
> s0=00000000-0000-1f00-a200-000000000000,
> v0='aca0:41b2:8f5c:ce93:f2eb:641f:8bf6:857b', v1='\u0010',
> v2='18:27:06.811070434', v3=00000000-0000-4900-ac00-000000000000 WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> -1.7123172E-20 AND ck1 = -1.815043E30 -- on node3
> 179: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0) VALUES
> (00000000-0000-1a00-8400-000000000000, 0x2871dff2bf1dde889056, -1.994664E33,
> -6.6795436E-10, 00000000-0000-1e00-bf00-000000000000, '121.241.27.111') -- on
> node1
> 180: UPDATE ks1.tbl SET
> s0=00000000-0000-1200-8c00-000000000000, v0='197.253.181.241', v1='\u0005$>N
> Rr\u0001', v2='14:22:43.286043646', v3=00000000-0000-4a00-9500-000000000000
> WHERE pk0 = 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND
> ck0 = 7.897556E-38 AND ck1 = -3.07570606E11 * 18658.611 -- on node2
> 181: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND v1 = '|Vp' ALLOW
> FILTERING -- v1 ascii, indexed with SAI, on node3, fetch size 100
> 182: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND v0
> = '6050:8d3b:bce0:71e6:e530:7301:1bb1:25ec' -- v0 inet, indexed with SAI, on
> node2, fetch size 10
> 183: DELETE s0, s0 FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 -- on node3
> 184: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-8400-000000000000 AND pk1 = 0x2871dff2bf1dde889056 AND s0
> > 00000000-0000-1e00-bf00-000000000000 -- s0 timeuuid, indexed with SAI, on
> node3, fetch size 1
> 185: UPDATE ks1.tbl SET
> v0='959f:33af:a799:4ba9:3963:1fde:1ff0:499', v1='\u000D\u0014QC(d\u000D#?',
> v3=00000000-0000-4100-8900-000000000000,
> s0=00000000-0000-1900-a100-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = 1.6164839E22 + 1.234501E-13 AND ck1 = 5.6219395E-24 - 8.9732003E-13 --
> on node3
> 186: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1700-8900-000000000000 AND pk1 = 0x1435e5 AND ck0 =
> -1.6586984E38 AND ck1 = -7.8906546 -- on node1
> 187: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v2, v3)
> VALUES (00000000-0000-1300-9b00-000000000000, 0xbc616cacf8cc, 3.074501E27 -
> -1.2345058E25, 9.653552E-28 + -3.4876246E-6,
> 00000000-0000-1c00-9200-000000000000, '162.66.201.39', '13:03:09.037525107',
> 00000000-0000-4600-be00-000000000000) -- on node1
> 188: UPDATE ks1.tbl SET
> s0=00000000-0000-1600-9f00-000000000000,
> v0='5d05:27f3:f720:a231:3507:ac6f:d38a:4fcd', v1=';',
> v2='20:08:08.493955526', v3=00000000-0000-4c00-bc00-000000000000 WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = 9.8860102E12 AND ck1 = 3.27723E24 -- on node1
> 189: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1300-9b00-000000000000 AND pk1 = 0xbc616cacf8cc AND v1 >=
> 'H?[\u001AA[Q' ALLOW FILTERING -- v1 ascii, indexed with SAI, on node1, fetch
> size 1
> 190: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
> v3) VALUES (00000000-0000-1800-a200-000000000000, 0x2a7f4d48e4f1b36aa12b,
> -2.2532921E-14, 4.4884517E30 * -1.87364621E9,
> 00000000-0000-1600-ab00-000000000000,
> '6834:6500:7328:6683:fca7:356a:f1e4:91ef', '?9+v\u000Fb\u0006''' +
> 'Up_\u0000', '04:53:42.167112131', 00000000-0000-4c00-a600-000000000000) --
> on node2
> 191: DELETE FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1800-a200-000000000000 AND pk1 = 0x2a7f4d48e4f1b36aa12b AND
> ck0 = -6.6272735E12 + 0.007368169 AND ck1 = -3.6597225E24 - -6.1410644E18 --
> on node3
> 192: UPDATE ks1.tbl SET
> s0=00000000-0000-1e00-a800-000000000000, v0='215.75.110.198', v1='U"',
> v2='16:13:07.973684672', v3=00000000-0000-4200-8200-000000000000 WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck0 =
> 2.7056329E16 AND ck1 = 9.522172E28 + -2.66899284E17 -- on node1
> 193: SELECT * FROM ks1.tbl WHERE pk0 =
> 00000000-0000-1a00-9a00-000000000000 AND pk1 = 0x43c4 AND ck1 = -4662398.5 --
> ck1 float, indexed with SAI, on node1, fetch size 10
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
