You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "David Capwell (Jira)" <ji...@apache.org> on 2025/02/04 00:40:00 UTC
[jira] [Commented] (CASSANDRA-20243) ALLOW FILTERING returned data that doesn't match the single column condition.
[ https://issues.apache.org/jira/browse/CASSANDRA-20243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17923536#comment-17923536 ]
David Capwell commented on CASSANDRA-20243:
-------------------------------------------
Hit a history that was using SAI, so this isn't isolated to ALLOW FILTERING
{code}
Seed = -3250806164917758198
Setup:
CREATE KEYSPACE IF NOT EXISTS ks1 WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 3};
CREATE TABLE ks1.tbl (
pk0 blob,
pk1 int,
ck0 uuid,
ck1 float,
s0 float static,
v0 uuid,
v1 boolean,
v2 int,
v3 blob,
v4 inet,
PRIMARY KEY ((pk0, pk1), ck0, ck1)
) WITH CLUSTERING ORDER BY (ck0 ASC, 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 INDEX tbl_pk1 ON ks1.tbl(pk1) USING 'SAI';
CREATE CUSTOM INDEX tbl_ck0 ON ks1.tbl(ck0) USING 'StorageAttachedIndex';
CREATE INDEX tbl_ck1 ON ks1.tbl(ck1) USING 'SAI';
CREATE INDEX tbl_s0 ON ks1.tbl(s0) USING 'SAI';
CREATE INDEX tbl_v0 ON ks1.tbl(v0) USING 'SAI';
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_v4 ON ks1.tbl(v4) USING 'StorageAttachedIndex';: org.apache.cassandra.distributed.test.cql3.MultiNodeTableWalkTest.MultiNodeState
History:
1: DELETE s0 FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 -- on node2
2: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v3) VALUES (0xaccda5063b5f859154, -1950131767, 00000000-0000-4100-a600-000000000000, -1.5642635E27, -0.0015426538, 00000000-0000-4600-8e00-000000000000, 0x7e6d4c46fb5dcf) -- on node2
3: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xaccda5063b5f859154, -1950131767) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node1, fetch size 1
4: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN token(0xaccda5063b5f859154, -1950131767) AND token(0xaccda5063b5f859154, -1950131767) -- by token range, on node1, fetch size 10
5: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xaccda5063b5f859154, -1950131767) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node3, fetch size 5000
6: UPDATE ks1.tbl SET v0=00000000-0000-4f00-9700-000000000000, v1=true, v2=1105511709 * 1520454163, v3=0x88, v4='129.18.80.135' WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4400-8900-000000000000 AND ck1 = -3.9780536E-4 + -551104.9 -- on node2
7: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4400-8900-000000000000 AND ck1 = -551104.9 -- Single Row, on node1, fetch size 1000
8: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4100-a600-000000000000 AND ck1 = -1.5642635E27 -- Single Row, on node3, fetch size 1000
9: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 -- Whole Partition, on node3, fetch size 1
10: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4100-a600-000000000000 AND ck1 = -1.5642635E27 -- Single Row, on node2, fetch size 1000
11: SELECT * FROM ks1.tbl WHERE v4 = '129.18.80.135' AND s0 = -0.0015426538 AND ck0 = 00000000-0000-4100-a600-000000000000 AND v0 = 00000000-0000-4f00-9700-000000000000 AND v2 = 1762984743 AND v1 = true ALLOW FILTERING -- v4 inet (indexed with SAI), s0 float (indexed with SAI), ck0 uuid (indexed with SAI), v0 uuid (indexed with SAI), v2 int (indexed with SAI), v1 boolean (indexed with SAI), on node3, fetch size 1
12: SELECT * FROM ks1.tbl WHERE s0 = -0.0015426538 AND v0 = 00000000-0000-4600-8e00-000000000000 ALLOW FILTERING -- s0 float (indexed with SAI), v0 uuid (indexed with SAI), on node1, fetch size 1000
13: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND v2 > 1762984743 -- v2 int, indexed with SAI, on node3, fetch size 1
14: SELECT * FROM ks1.tbl WHERE v2 = 1762984743 AND ck1 = -1.5642635E27 AND s0 = -0.0015426538 AND v0 = 00000000-0000-4600-8e00-000000000000 ALLOW FILTERING -- v2 int (indexed with SAI), ck1 float (indexed with SAI), s0 float (indexed with SAI), v0 uuid (indexed with SAI), on node1, fetch size 100
15: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 > 00000000-0000-4100-a600-000000000000 ALLOW FILTERING -- ck0 uuid, indexed with SAI, on node2, fetch size 100
16: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4400-8900-000000000000 AND ck1 = -551104.9 -- Single Row, on node1, fetch size 100
17: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v3) VALUES (0x172f, 1513825499, 00000000-0000-4d00-b700-000000000000, 2.0589582E-16, 0x0a2b64) -- on node1
18: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x172f, 1513825499) AND token(pk0, pk1) <= token(0xaccda5063b5f859154, -1950131767) -- by token range, on node2, fetch size 100
19: DELETE FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 -- on node2
20: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) = token(0x3db7b69ecdd6a6, -1459423004) -- by token, on node2, fetch size 100
21: SELECT * FROM ks1.tbl WHERE v4 = '129.18.80.135' AND ck0 = 00000000-0000-4100-a600-000000000000 AND ck1 = 2.0589582E-16 ALLOW FILTERING -- v4 inet (indexed with SAI), ck0 uuid (indexed with SAI), ck1 float (indexed with SAI), on node1, fetch size 1000
22: SELECT * FROM ks1.tbl WHERE ck1 = 2.0589582E-16 AND v4 = '129.18.80.135' AND v1 = true AND v2 = 1762984743 AND s0 = -0.0015426538 ALLOW FILTERING -- ck1 float (indexed with SAI), v4 inet (indexed with SAI), v1 boolean (indexed with SAI), v2 int (indexed with SAI), s0 float (indexed with SAI), on node2, fetch size 5000
23: DELETE s0 FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 -- on node3
24: SELECT * FROM ks1.tbl WHERE v2 = 1762984743 AND v0 = 00000000-0000-4600-8e00-000000000000 ALLOW FILTERING -- v2 int (indexed with SAI), v0 uuid (indexed with SAI), on node1, fetch size 10
25: SELECT * FROM ks1.tbl WHERE v2 = 1762984743 AND ck0 = 00000000-0000-4400-8900-000000000000 AND ck1 = -1.5642635E27 AND v4 = '129.18.80.135' AND v0 = 00000000-0000-4f00-9700-000000000000 AND s0 = -0.0015426538 AND v1 = true ALLOW FILTERING -- v2 int (indexed with SAI), ck0 uuid (indexed with SAI), ck1 float (indexed with SAI), v4 inet (indexed with SAI), v0 uuid (indexed with SAI), s0 float (indexed with SAI), v1 boolean (indexed with SAI), on node3, fetch size 100
26: UPDATE ks1.tbl SET v0=00000000-0000-4c00-ae00-000000000000, v2=-312382809 - 763152782, v3=0xb2e7b85d948c, v4='93fe:2b06:9d34:1be2:4962:5092:69ba:c21e', s0=-1.9764135E38 WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4a00-bd00-000000000000 AND ck1 = -8.377661E27 -- on node1
27: UPDATE ks1.tbl SET s0=8.537083E-17 - -2.6627855E-26, v0=00000000-0000-4100-8700-000000000000, v1=true, v2=1209803352, v3=0xc6, v4='dc5f:1749:6e74:509a:a3c5:9f4a:b1c3:3ccc' WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND ck0 = 00000000-0000-4700-9400-000000000000 AND ck1 = 2.0577075E20 + -0.0016678165 -- on node3
28: SELECT * FROM ks1.tbl WHERE v4 = '129.18.80.135' AND ck1 = -1.5642635E27 AND v1 = true ALLOW FILTERING -- v4 inet (indexed with SAI), ck1 float (indexed with SAI), v1 boolean (indexed with SAI), on node3, fetch size 1000
29: SELECT * FROM ks1.tbl WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND v0 < 00000000-0000-4100-8700-000000000000 ALLOW FILTERING -- v0 uuid, indexed with SAI, on node1, fetch size 5000
30: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x3027b5aa00a577, -652702739) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node1, fetch size 1
31: SELECT * FROM ks1.tbl WHERE ck1 = -1.5642635E27 AND v1 = true AND ck0 = 00000000-0000-4700-9400-000000000000 AND v0 = 00000000-0000-4100-8700-000000000000 AND v4 = 'dc5f:1749:6e74:509a:a3c5:9f4a:b1c3:3ccc' AND s0 = -1.9764135E38 ALLOW FILTERING -- ck1 float (indexed with SAI), v1 boolean (indexed with SAI), ck0 uuid (indexed with SAI), v0 uuid (indexed with SAI), v4 inet (indexed with SAI), s0 float (indexed with SAI), on node1, fetch size 5000
32: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x3db7b69ecdd6a6, -1459423004) AND token(pk0, pk1) < token(0x172f, 1513825499) -- by token range, on node2, fetch size 5000
33: SELECT * FROM ks1.tbl WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND v4 = 'dc5f:1749:6e74:509a:a3c5:9f4a:b1c3:3ccc' -- v4 inet, indexed with SAI, on node2, fetch size 5000
34: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4400-8900-000000000000 AND ck1 = -551104.9 -- Single Row, on node2, fetch size 1
35: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x3027b5aa00a577, -652702739) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node3, fetch size 10
36: SELECT * FROM ks1.tbl WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 -- Whole Partition, on node3, fetch size 1
37: SELECT * FROM ks1.tbl WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND s0 <= 8.537083E-17 -- s0 float, indexed with SAI, on node3, fetch size 10
38: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND ck0 = 00000000-0000-4d00-b700-000000000000 AND ck1 = 2.0589582E-16 -- Single Row, on node2, fetch size 10
39: SELECT * FROM ks1.tbl WHERE ck0 = 00000000-0000-4100-a600-000000000000 AND v0 = 00000000-0000-4c00-ae00-000000000000 ALLOW FILTERING -- ck0 uuid (indexed with SAI), v0 uuid (indexed with SAI), on node2, fetch size 100
40: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x3027b5aa00a577, -652702739) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node3, fetch size 100
41: SELECT * FROM ks1.tbl WHERE v2 = 1209803352 AND s0 = -0.0015426538 AND v4 = '93fe:2b06:9d34:1be2:4962:5092:69ba:c21e' AND ck1 = -551104.9 AND ck0 = 00000000-0000-4d00-b700-000000000000 AND v1 = true ALLOW FILTERING -- v2 int (indexed with SAI), s0 float (indexed with SAI), v4 inet (indexed with SAI), ck1 float (indexed with SAI), ck0 uuid (indexed with SAI), v1 boolean (indexed with SAI), on node3, fetch size 5000
42: SELECT * FROM ks1.tbl WHERE v2 = 1762984743 AND v0 = 00000000-0000-4600-8e00-000000000000 AND ck1 = 2.0577075E20 AND ck0 = 00000000-0000-4a00-bd00-000000000000 AND s0 = 8.537083E-17 AND v1 = true ALLOW FILTERING -- v2 int (indexed with SAI), v0 uuid (indexed with SAI), ck1 float (indexed with SAI), ck0 uuid (indexed with SAI), s0 float (indexed with SAI), v1 boolean (indexed with SAI), on node1, fetch size 10
43: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x172f, 1513825499) AND token(pk0, pk1) <= token(0xaccda5063b5f859154, -1950131767) -- by token range, on node2, fetch size 1000
44: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck1 <= -1.5642635E27 -- ck1 float, indexed with SAI, on node2, fetch size 10
45: SELECT * FROM ks1.tbl WHERE ck0 = 00000000-0000-4100-a600-000000000000 AND v4 = '129.18.80.135' ALLOW FILTERING -- ck0 uuid (indexed with SAI), v4 inet (indexed with SAI), on node3, fetch size 5000
46: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 -- Whole Partition, on node1, fetch size 1
47: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 -- Whole Partition, on node3, fetch size 5000
48: SELECT * FROM ks1.tbl WHERE ck0 = 00000000-0000-4400-8900-000000000000 AND ck1 = 2.0589582E-16 AND v0 = 00000000-0000-4f00-9700-000000000000 AND v1 = true AND v4 = 'dc5f:1749:6e74:509a:a3c5:9f4a:b1c3:3ccc' ALLOW FILTERING -- ck0 uuid (indexed with SAI), ck1 float (indexed with SAI), v0 uuid (indexed with SAI), v1 boolean (indexed with SAI), v4 inet (indexed with SAI), on node2, fetch size 1
49: UPDATE ks1.tbl SET v1=true, v3=0xe20bf597856212d846, v4='79.7.117.53' WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND ck0 = 00000000-0000-4300-9b00-000000000000 AND ck1 = 274055.72 + -2.2239226E-19 -- on node1
50: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4a00-bd00-000000000000 AND ck1 = -8.377661E27 -- Single Row, on node2, fetch size 5000
51: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xece9fe2f, 321314609) AND token(pk0, pk1) < token(0x3db7b69ecdd6a6, -1459423004) -- by token range, on node1, fetch size 100
52: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck1 <= -1.5642635E27 -- ck1 float, indexed with SAI, on node3, fetch size 100
53: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND s0 < -1.9764135E38 -- s0 float, indexed with SAI, on node2, fetch size 5000
54: UPDATE ks1.tbl SET v4='222.121.87.71' WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND ck0 = 00000000-0000-4900-bc00-000000000000 AND ck1 = -1.2753527E-34 -- on node2
55: SELECT * FROM ks1.tbl WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND ck0 = 00000000-0000-4700-9400-000000000000 AND ck1 = 2.0577075E20 -- Single Row, on node1, fetch size 10
56: SELECT * FROM ks1.tbl WHERE v4 = '79.7.117.53' AND ck0 = 00000000-0000-4300-9b00-000000000000 AND v1 = true AND s0 = -1.9764135E38 AND v2 = 1209803352 AND v0 = 00000000-0000-4c00-ae00-000000000000 AND ck1 = -1.2753527E-34 ALLOW FILTERING -- v4 inet (indexed with SAI), ck0 uuid (indexed with SAI), v1 boolean (indexed with SAI), s0 float (indexed with SAI), v2 int (indexed with SAI), v0 uuid (indexed with SAI), ck1 float (indexed with SAI), on node1, fetch size 5000
57: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v4) VALUES (0xf8bee2e5, -1995853855, 00000000-0000-4800-a500-000000000000, -3.2731786E-20, 1.31321574E9 + 4.5030833E23, '226.147.190.144') -- on node3
58: DELETE v0, v1, v2, v3, v4, s0 FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4200-9000-000000000000 AND ck1 = -9.234844E-14 + 1.8391459E-29 -- on node3
59: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4a00-bd00-000000000000 AND ck1 = -8.377661E27 -- Single Row, on node3, fetch size 100
60: SELECT * FROM ks1.tbl WHERE v0 = 00000000-0000-4c00-ae00-000000000000 AND s0 = 8.537083E-17 ALLOW FILTERING -- v0 uuid (indexed with SAI), s0 float (indexed with SAI), on node1, fetch size 10
61: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4100-a600-000000000000 AND ck1 = -1.5642635E27 -- Single Row, on node1, fetch size 1
62: UPDATE ks1.tbl SET v0=00000000-0000-4c00-9100-000000000000, v1=true, v2=1264143414 + -1137799562, v3=0xdaf51e075c8dee, v4='d9dd:4ba6:48a0:8cfc:a2bc:6a8d:9766:b6a6' WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND ck0 = 00000000-0000-4200-ba00-000000000000 AND ck1 = -2.20750702E17 -- on node2
63: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) < token(0x3027b5aa00a577, -652702739) -- by token range, on node2, fetch size 1
64: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node1, fetch size 1
65: SELECT * FROM ks1.tbl WHERE s0 = -1.9764135E38 AND v0 = 00000000-0000-4c00-ae00-000000000000 AND v1 = true AND v4 = '79.7.117.53' AND v2 = 126343852 AND ck0 = 00000000-0000-4300-9b00-000000000000 AND ck1 = -2.20750702E17 ALLOW FILTERING -- s0 float (indexed with SAI), v0 uuid (indexed with SAI), v1 boolean (indexed with SAI), v4 inet (indexed with SAI), v2 int (indexed with SAI), ck0 uuid (indexed with SAI), ck1 float (indexed with SAI), on node2, fetch size 10
66: SELECT * FROM ks1.tbl WHERE s0 = 8.537083E-17 AND ck1 = -1.5642635E27 AND v0 = 00000000-0000-4600-8e00-000000000000 AND v4 = '79.7.117.53' AND v2 = 1762984743 AND v1 = true ALLOW FILTERING -- s0 float (indexed with SAI), ck1 float (indexed with SAI), v0 uuid (indexed with SAI), v4 inet (indexed with SAI), v2 int (indexed with SAI), v1 boolean (indexed with SAI), on node3, fetch size 1000
67: UPDATE ks1.tbl SET v0=00000000-0000-4a00-8b00-000000000000, v1=true WHERE pk0 = 0x172f AND pk1 = 1513825499 AND ck0 = 00000000-0000-4a00-8c00-000000000000 AND ck1 = -0.0010212793 - 1.8163209E-29 -- on node1
68: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3, v4) VALUES (0xaccda5063b5f859154, -1950131767, 00000000-0000-4300-9600-000000000000, 1.5738453E-28, 8.9044437E17 * 1.21263606E10, 00000000-0000-4500-a200-000000000000, true, 1303111118 + -910979602, 0x7da25dcae258d7abd5c0, '168.140.203.197') -- on node3
69: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3, v4) VALUES (0x3db7b69ecdd6a6, -1459423004, 00000000-0000-4500-b300-000000000000, 2.4983933E23 - 2.8502192E28, -3.275344E-28 + -5.8791391E15, 00000000-0000-4200-9d00-000000000000, true, 1406841687 * 526394795, 0x66b2ed189ce7, '3e5d:1d00:c9b2:9060:6caa:c1fb:a03f:64fd') -- on node1
70: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND v1 = true ALLOW FILTERING -- v1 boolean, indexed with SAI, on node1, fetch size 10
71: SELECT * FROM ks1.tbl WHERE v2 = 126343852 AND ck0 = 00000000-0000-4300-9600-000000000000 AND v0 = 00000000-0000-4c00-ae00-000000000000 ALLOW FILTERING -- v2 int (indexed with SAI), ck0 uuid (indexed with SAI), v0 uuid (indexed with SAI), on node1, fetch size 100
72: SELECT * FROM ks1.tbl WHERE v0 = 00000000-0000-4f00-9700-000000000000 AND v4 = '129.18.80.135' AND v1 = true ALLOW FILTERING -- v0 uuid (indexed with SAI), v4 inet (indexed with SAI), v1 boolean (indexed with SAI), on node2, fetch size 1
73: SELECT * FROM ks1.tbl WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 -- Whole Partition, on node1, fetch size 10
74: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND ck0 = 00000000-0000-4800-a500-000000000000 AND ck1 = -3.2731786E-20 -- Single Row, on node1, fetch size 10
75: SELECT * FROM ks1.tbl WHERE v4 = '226.147.190.144' AND ck0 = 00000000-0000-4a00-bd00-000000000000 AND ck1 = -2.20750702E17 AND v2 = 1209803352 ALLOW FILTERING -- v4 inet (indexed with SAI), ck0 uuid (indexed with SAI), ck1 float (indexed with SAI), v2 int (indexed with SAI), on node1, fetch size 10
76: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND s0 <= 1.0797849E28 -- s0 float, indexed with SAI, on node2, fetch size 10
77: SELECT * FROM ks1.tbl WHERE v4 = '168.140.203.197' AND s0 = 1.0797849E28 AND v1 = true AND v0 = 00000000-0000-4100-8700-000000000000 ALLOW FILTERING -- v4 inet (indexed with SAI), s0 float (indexed with SAI), v1 boolean (indexed with SAI), v0 uuid (indexed with SAI), on node3, fetch size 1
78: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 -- Whole Partition, on node1, fetch size 10
79: SELECT * FROM ks1.tbl WHERE ck0 = 00000000-0000-4300-9b00-000000000000 AND v2 = 1762984743 AND ck1 = -551104.9 AND s0 = 8.537083E-17 AND v1 = true AND v0 = 00000000-0000-4500-a200-000000000000 AND v4 = '129.18.80.135' ALLOW FILTERING -- ck0 uuid (indexed with SAI), v2 int (indexed with SAI), ck1 float (indexed with SAI), s0 float (indexed with SAI), v1 boolean (indexed with SAI), v0 uuid (indexed with SAI), v4 inet (indexed with SAI), on node1, fetch size 5000
80: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node1, fetch size 1000
81: SELECT * FROM ks1.tbl WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND v4 = 'dc5f:1749:6e74:509a:a3c5:9f4a:b1c3:3ccc' -- v4 inet, indexed with SAI, on node3, fetch size 5000
82: DELETE FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 -- on node1
83: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v3) VALUES (0xece9fe2f, 321314609, 00000000-0000-4c00-9d00-000000000000, -0.011666143, 0xbbc620f4fc9720006c42) -- on node3
84: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) <= token(0x3027b5aa00a577, -652702739) -- by token range, on node1, fetch size 1000
85: UPDATE ks1.tbl SET s0=1.633698E-20 * 5.06841239E14, v0=00000000-0000-4300-ad00-000000000000, v1=true, v2=-897091260, v3=0x7f, v4='39.210.109.161' WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND ck0 = 00000000-0000-4600-8400-000000000000 AND ck1 = -2.4864038E-13 -- on node2
86: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 -- Whole Partition, on node2, fetch size 10
87: SELECT * FROM ks1.tbl WHERE s0 = 8.280255E-6 AND v1 = true AND ck1 = -551104.9 AND ck0 = 00000000-0000-4500-b300-000000000000 AND v4 = '39.210.109.161' ALLOW FILTERING -- s0 float (indexed with SAI), v1 boolean (indexed with SAI), ck1 float (indexed with SAI), ck0 uuid (indexed with SAI), v4 inet (indexed with SAI), on node1, fetch size 10
88: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND ck0 = 00000000-0000-4800-a500-000000000000 AND ck1 = -3.2731786E-20 -- Single Row, on node2, fetch size 1
89: SELECT * FROM ks1.tbl WHERE v1 = true AND v2 = 1762984743 AND v4 = '226.147.190.144' AND s0 = 8.280255E-6 ALLOW FILTERING -- v1 boolean (indexed with SAI), v2 int (indexed with SAI), v4 inet (indexed with SAI), s0 float (indexed with SAI), on node2, fetch size 1
90: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x172f, 1513825499) AND token(pk0, pk1) <= token(0x3027b5aa00a577, -652702739) -- by token range, on node3, fetch size 5000
91: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND v4 = '79.7.117.53' -- v4 inet, indexed with SAI, on node3, fetch size 5000
92: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND s0 <= 4.5030833E23 -- s0 float, indexed with SAI, on node1, fetch size 1000
93: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x3db7b69ecdd6a6, -1459423004) AND token(pk0, pk1) <= token(0x172f, 1513825499) -- by token range, on node1, fetch size 5000
94: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3, v4) VALUES (0x3db7b69ecdd6a6, -1459423004, 00000000-0000-4000-bd00-000000000000, -5.461435E-33, -1.3257327E-5, 00000000-0000-4100-bf00-000000000000, true, -479061530, 0xc095c6e222, '90dc:dac5:b94:b2b1:4821:9df9:b21a:8f0a') -- on node1
95: SELECT * FROM ks1.tbl WHERE v0 = 00000000-0000-4f00-9700-000000000000 AND v2 = -1075535591 AND ck1 = -1.2753527E-34 AND s0 = -1.3257327E-5 ALLOW FILTERING -- v0 uuid (indexed with SAI), v2 int (indexed with SAI), ck1 float (indexed with SAI), s0 float (indexed with SAI), on node2, fetch size 1
96: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND ck0 = 00000000-0000-4800-a500-000000000000 ALLOW FILTERING -- ck0 uuid, indexed with SAI, on node2, fetch size 1
97: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) < token(0x3db7b69ecdd6a6, -1459423004) -- by token range, on node2, fetch size 1
98: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND ck0 = 00000000-0000-4200-ba00-000000000000 ALLOW FILTERING -- ck0 uuid, indexed with SAI, on node1, fetch size 100
99: SELECT * FROM ks1.tbl WHERE ck1 = 2.0577075E20 AND v2 = -1075535591 ALLOW FILTERING -- ck1 float (indexed with SAI), v2 int (indexed with SAI), on node3, fetch size 1000
100: SELECT * FROM ks1.tbl WHERE s0 = 8.280255E-6 AND v4 = '129.18.80.135' AND v0 = 00000000-0000-4f00-9700-000000000000 AND ck1 = -2.8501942E28 AND ck0 = 00000000-0000-4d00-b700-000000000000 AND v2 = 1762984743 AND v1 = true ALLOW FILTERING -- s0 float (indexed with SAI), v4 inet (indexed with SAI), v0 uuid (indexed with SAI), ck1 float (indexed with SAI), ck0 uuid (indexed with SAI), v2 int (indexed with SAI), v1 boolean (indexed with SAI), on node2, fetch size 1000
101: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND ck0 = 00000000-0000-4300-9b00-000000000000 AND ck1 = 274055.72 -- Single Row, on node3, fetch size 5000
102: SELECT * FROM ks1.tbl WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 -- Whole Partition, on node3, fetch size 1
103: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) < token(0x3027b5aa00a577, -652702739) -- by token range, on node1, fetch size 1
104: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) <= token(0x3027b5aa00a577, -652702739) -- by token range, on node3, fetch size 10
105: DELETE FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND ck0 = 00000000-0000-4900-9b00-000000000000 AND ck1 = -8.24682E21 -- on node2
106: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) = token(0xf8bee2e5, -1995853855) -- by token, on node1, fetch size 1000
107: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) = token(0x3db7b69ecdd6a6, -1459423004) -- by token, on node2, fetch size 100
108: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND v0 > 00000000-0000-4c00-ae00-000000000000 ALLOW FILTERING -- v0 uuid, indexed with SAI, on node1, fetch size 5000
109: SELECT * FROM ks1.tbl WHERE v1 = true AND v2 = 126343852 AND v4 = '93fe:2b06:9d34:1be2:4962:5092:69ba:c21e' AND v0 = 00000000-0000-4100-bf00-000000000000 AND ck0 = 00000000-0000-4300-9b00-000000000000 AND ck1 = 2.0589582E-16 ALLOW FILTERING -- v1 boolean (indexed with SAI), v2 int (indexed with SAI), v4 inet (indexed with SAI), v0 uuid (indexed with SAI), ck0 uuid (indexed with SAI), ck1 float (indexed with SAI), on node3, fetch size 5000
110: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND v2 = -1075535591 -- v2 int, indexed with SAI, on node2, fetch size 100
111: DELETE FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 -- on node2
112: DELETE FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 -- on node1
113: SELECT * FROM ks1.tbl WHERE v2 = 1209803352 AND ck1 = -1.2753527E-34 AND ck0 = 00000000-0000-4700-9400-000000000000 ALLOW FILTERING -- v2 int (indexed with SAI), ck1 float (indexed with SAI), ck0 uuid (indexed with SAI), on node2, fetch size 1000
114: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 -- Whole Partition, on node1, fetch size 1
115: SELECT * FROM ks1.tbl WHERE v1 = true AND v4 = '129.18.80.135' AND ck1 = -3.2731786E-20 AND s0 = 8.280255E-6 AND v0 = 00000000-0000-4200-9d00-000000000000 AND v2 = -479061530 AND ck0 = 00000000-0000-4400-8900-000000000000 ALLOW FILTERING -- v1 boolean (indexed with SAI), v4 inet (indexed with SAI), ck1 float (indexed with SAI), s0 float (indexed with SAI), v0 uuid (indexed with SAI), v2 int (indexed with SAI), ck0 uuid (indexed with SAI), on node1, fetch size 10
116: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND v2 = 1755405853 -- v2 int, indexed with SAI, on node3, fetch size 100
117: SELECT * FROM ks1.tbl WHERE s0 = 4.5030833E23 AND v2 = -479061530 AND v4 = 'd9dd:4ba6:48a0:8cfc:a2bc:6a8d:9766:b6a6' AND v0 = 00000000-0000-4100-bf00-000000000000 ALLOW FILTERING -- s0 float (indexed with SAI), v2 int (indexed with SAI), v4 inet (indexed with SAI), v0 uuid (indexed with SAI), on node3, fetch size 1000
118: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) < token(0x3027b5aa00a577, -652702739) -- by token range, on node1, fetch size 10
119: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x3db7b69ecdd6a6, -1459423004) AND token(pk0, pk1) < token(0xf8bee2e5, -1995853855) -- by token range, on node1, fetch size 10
120: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND ck0 = 00000000-0000-4c00-9d00-000000000000 AND ck1 = -0.011666143 -- Single Row, on node2, fetch size 5000
121: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 -- Whole Partition, on node2, fetch size 1000
122: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x3db7b69ecdd6a6, -1459423004) AND token(pk0, pk1) < token(0xf8bee2e5, -1995853855) -- by token range, on node1, fetch size 1
123: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND s0 < -1.3257327E-5 -- s0 float, indexed with SAI, on node1, fetch size 1
124: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND ck0 = 00000000-0000-4800-a500-000000000000 AND ck1 = -3.2731786E-20 -- Single Row, on node1, fetch size 100
125: SELECT * FROM ks1.tbl WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND v2 < -897091260 -- v2 int, indexed with SAI, on node1, fetch size 10
126: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) < token(0x3db7b69ecdd6a6, -1459423004) -- by token range, on node3, fetch size 1000
127: SELECT * FROM ks1.tbl WHERE s0 = 4.5030833E23 AND v1 = true AND v4 = '226.147.190.144' AND ck0 = 00000000-0000-4600-8400-000000000000 AND ck1 = -0.011666143 AND v2 = 1209803352 AND v0 = 00000000-0000-4c00-9100-000000000000 ALLOW FILTERING -- s0 float (indexed with SAI), v1 boolean (indexed with SAI), v4 inet (indexed with SAI), ck0 uuid (indexed with SAI), ck1 float (indexed with SAI), v2 int (indexed with SAI), v0 uuid (indexed with SAI), on node2, fetch size 100
128: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND v2 = 126343852 -- v2 int, indexed with SAI, on node2, fetch size 1
129: SELECT * FROM ks1.tbl WHERE v4 = '129.18.80.135' AND ck1 = -551104.9 AND ck0 = 00000000-0000-4c00-9d00-000000000000 ALLOW FILTERING -- v4 inet (indexed with SAI), ck1 float (indexed with SAI), ck0 uuid (indexed with SAI), on node1, fetch size 1000
130: DELETE FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 -- on node3
131: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) < token(0x3027b5aa00a577, -652702739) -- by token range, on node2, fetch size 10
132: UPDATE ks1.tbl SET s0=3.9004706E-5, v0=00000000-0000-4800-9800-000000000000, v1=true, v2=-914400366 - 1576240917, v3=0x36c8643b9d52a57211, v4='6bfd:d7bb:19e0:c9d6:9491:a0cd:b229:fc7e' WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4a00-9a00-000000000000 AND ck1 = -3.373931E33 * 5.375124E-20 -- on node3
133: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 -- Whole Partition, on node1, fetch size 5000
134: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v1, v2, v3, v4) VALUES (0x172f, 1513825499, 00000000-0000-4100-b000-000000000000, -7.232424E-12 + -3.38531796E17, 2.2238539E-25 * 1.5909042E16, false, -1473298702, 0x4920e713b39a, 'dd52:ad91:1a93:11b9:8736:a380:c04d:f18e') -- on node2
135: DELETE FROM ks1.tbl WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 -- on node2
136: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 -- Whole Partition, on node3, fetch size 1
137: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) < token(0xf8bee2e5, -1995853855) -- by token range, on node3, fetch size 1
138: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) <= token(0xaccda5063b5f859154, -1950131767) -- by token range, on node2, fetch size 1
139: SELECT * FROM ks1.tbl WHERE v2 = 126343852 AND ck0 = 00000000-0000-4200-ba00-000000000000 AND s0 = 4.5030833E23 AND v1 = true AND ck1 = -3.2731786E-20 ALLOW FILTERING -- v2 int (indexed with SAI), ck0 uuid (indexed with SAI), s0 float (indexed with SAI), v1 boolean (indexed with SAI), ck1 float (indexed with SAI), on node3, fetch size 1000
140: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3, v4) VALUES (0x172f, 1513825499, 00000000-0000-4600-a500-000000000000, 7.915762E-29 + 5.1683244E35, -3688.4243, 00000000-0000-4100-a700-000000000000, true, 1077180437, 0x5fb7e4, '113.187.231.133') -- on node1
141: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) <= token(0xf8bee2e5, -1995853855) -- by token range, on node2, fetch size 10
142: SELECT * FROM ks1.tbl WHERE ck1 = -0.011666143 AND v1 = false AND v4 = '226.147.190.144' AND ck0 = 00000000-0000-4600-a500-000000000000 AND v2 = 1077180437 AND v0 = 00000000-0000-4800-9800-000000000000 AND s0 = 4.5030833E23 ALLOW FILTERING -- ck1 float (indexed with SAI), v1 boolean (indexed with SAI), v4 inet (indexed with SAI), ck0 uuid (indexed with SAI), v2 int (indexed with SAI), v0 uuid (indexed with SAI), s0 float (indexed with SAI), on node2, fetch size 1
143: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND ck0 = 00000000-0000-4200-ba00-000000000000 AND ck1 = -2.20750702E17 -- Single Row, on node2, fetch size 1
144: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) <= token(0x172f, 1513825499) -- by token range, on node3, fetch size 10
145: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3, v4) VALUES (0xf8bee2e5, -1995853855, 00000000-0000-4100-a400-000000000000, -8.3203575E-16, -3.28758272E16 * -834434.5, 00000000-0000-4500-a200-000000000000, false, -518023399, 0xb5e377568923e94b, '107.177.57.87') -- on node2
146: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4a00-9a00-000000000000 AND ck1 = -1.81352981E14 -- Single Row, on node3, fetch size 10
147: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND v2 > 1804326013 -- v2 int, indexed with SAI, on node3, fetch size 10
148: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND v4 = '113.187.231.133' -- v4 inet, indexed with SAI, on node2, fetch size 10
149: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 -- Whole Partition, on node3, fetch size 1
150: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND ck0 = 00000000-0000-4200-ba00-000000000000 AND ck1 = -2.20750702E17 -- Single Row, on node2, fetch size 100
151: SELECT * FROM ks1.tbl WHERE v4 = '107.177.57.87' AND v2 = 126343852 AND ck0 = 00000000-0000-4800-a500-000000000000 ALLOW FILTERING -- v4 inet (indexed with SAI), v2 int (indexed with SAI), ck0 uuid (indexed with SAI), on node1, fetch size 1
152: SELECT * FROM ks1.tbl WHERE ck1 = 274055.72 -- ck1 float, indexed with SAI, on node1, fetch size 1
153: SELECT * FROM ks1.tbl WHERE ck1 = -2.20750702E17 AND v4 = '107.177.57.87' ALLOW FILTERING -- ck1 float (indexed with SAI), v4 inet (indexed with SAI), on node1, fetch size 100
154: SELECT * FROM ks1.tbl WHERE v2 = 1804326013 AND s0 = -3688.4243 AND ck0 = 00000000-0000-4600-a500-000000000000 AND v1 = true ALLOW FILTERING -- v2 int (indexed with SAI), s0 float (indexed with SAI), ck0 uuid (indexed with SAI), v1 boolean (indexed with SAI), on node1, fetch size 10
155: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 -- Whole Partition, on node2, fetch size 5000
156: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) < token(0xf8bee2e5, -1995853855) -- by token range, on node3, fetch size 10
157: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4a00-9a00-000000000000 AND ck1 = -1.81352981E14 -- Single Row, on node2, fetch size 1000
158: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND v0 = 00000000-0000-4c00-9100-000000000000 ALLOW FILTERING -- v0 uuid, indexed with SAI, on node1, fetch size 1
159: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND v4 = '113.187.231.133' -- v4 inet, indexed with SAI, on node2, fetch size 1000
160: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v4) VALUES (0x3db7b69ecdd6a6, -1459423004, 00000000-0000-4d00-bf00-000000000000, 7.572559E-7, 2.4385695E-27, 00000000-0000-4b00-b100-000000000000, true, -2094450079 - 1697550453, '376d:2dac:d441:3759:6736:1ee5:b60c:71be') -- on node1
161: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x3db7b69ecdd6a6, -1459423004) AND token(pk0, pk1) <= token(0xf8bee2e5, -1995853855) -- by token range, on node3, fetch size 1
162: SELECT * FROM ks1.tbl WHERE v4 = 'dd52:ad91:1a93:11b9:8736:a380:c04d:f18e' -- v4 inet, indexed with SAI, on node1, fetch size 5000
163: SELECT * FROM ks1.tbl WHERE v1 = false AND v4 = '113.187.231.133' AND ck1 = -3.38531796E17 AND ck0 = 00000000-0000-4100-b000-000000000000 AND v0 = 00000000-0000-4b00-b100-000000000000 ALLOW FILTERING -- v1 boolean (indexed with SAI), v4 inet (indexed with SAI), ck1 float (indexed with SAI), ck0 uuid (indexed with SAI), v0 uuid (indexed with SAI), on node3, fetch size 1000
164: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN token(0xf8bee2e5, -1995853855) AND token(0xaccda5063b5f859154, -1950131767) -- by token range, on node3, fetch size 100
165: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND v2 = -1473298702 -- v2 int, indexed with SAI, on node2, fetch size 1
166: SELECT * FROM ks1.tbl WHERE ck0 = 00000000-0000-4d00-bf00-000000000000 AND v4 = 'dd52:ad91:1a93:11b9:8736:a380:c04d:f18e' AND s0 = 2.4385695E-27 AND v2 = 502966764 AND v1 = true AND ck1 = -2.20750702E17 AND v0 = 00000000-0000-4800-9800-000000000000 ALLOW FILTERING -- ck0 uuid (indexed with SAI), v4 inet (indexed with SAI), s0 float (indexed with SAI), v2 int (indexed with SAI), v1 boolean (indexed with SAI), ck1 float (indexed with SAI), v0 uuid (indexed with SAI), on node3, fetch size 100
167: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) = token(0x172f, 1513825499) -- by token, on node3, fetch size 10
168: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND v2 >= 126343852 -- v2 int, indexed with SAI, on node2, fetch size 10
169: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) < token(0x3db7b69ecdd6a6, -1459423004) -- by token range, on node3, fetch size 100
170: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x3db7b69ecdd6a6, -1459423004) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node3, fetch size 100
171: SELECT * FROM ks1.tbl WHERE s0 = 2.7432725E22 AND v4 = '113.187.231.133' AND v0 = 00000000-0000-4800-9800-000000000000 AND ck1 = -8.3203575E-16 AND v2 = -518023399 ALLOW FILTERING -- s0 float (indexed with SAI), v4 inet (indexed with SAI), v0 uuid (indexed with SAI), ck1 float (indexed with SAI), v2 int (indexed with SAI), on node3, fetch size 1
172: SELECT * FROM ks1.tbl WHERE v0 = 00000000-0000-4800-9800-000000000000 ALLOW FILTERING -- v0 uuid, indexed with SAI, on node1, fetch size 100
173: UPDATE ks1.tbl SET v0=00000000-0000-4a00-9400-000000000000, v2=2120610698 - -1366066011, v3=0xbe45ac0d67866f10f5f4, v4='113.47.220.169', s0=1.1725245E25 + 2.1901858E22 WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4500-8b00-000000000000 AND ck1 = 2.4715325E-8 -- on node3
174: SELECT * FROM ks1.tbl WHERE v0 = 00000000-0000-4100-a700-000000000000 AND s0 = -3688.4243 AND v4 = '113.187.231.133' AND v2 = -1473298702 AND ck1 = -0.011666143 ALLOW FILTERING -- v0 uuid (indexed with SAI), s0 float (indexed with SAI), v4 inet (indexed with SAI), v2 int (indexed with SAI), ck1 float (indexed with SAI), on node1, fetch size 1000
175: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) = token(0xece9fe2f, 321314609) -- by token, on node1, fetch size 1
176: UPDATE ks1.tbl SET s0=2.141363 * -3.3088107E21, v0=00000000-0000-4f00-9400-000000000000, v1=false, v2=413175930, v3=0x13039a4b5e, v4='54f2:4030:2288:8636:5ba3:7f49:c55e:370e' WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND ck0 = 00000000-0000-4800-8c00-000000000000 AND ck1 = 0.014722711 -- on node3
177: SELECT * FROM ks1.tbl WHERE ck0 = 00000000-0000-4800-8c00-000000000000 AND v0 = 00000000-0000-4c00-9100-000000000000 AND ck1 = -0.011666143 ALLOW FILTERING -- ck0 uuid (indexed with SAI), v0 uuid (indexed with SAI), ck1 float (indexed with SAI), on node2, fetch size 10
178: SELECT * FROM ks1.tbl WHERE v2 = -808290587 AND ck0 = 00000000-0000-4600-a500-000000000000 AND ck1 = -2.20750702E17 ALLOW FILTERING -- v2 int (indexed with SAI), ck0 uuid (indexed with SAI), ck1 float (indexed with SAI), on node1, fetch size 100
179: UPDATE ks1.tbl SET v3=0xe53fe39f, s0=-2.0550165E34 WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4400-9200-000000000000 AND ck1 = 8.0946107E-38 -- on node3
180: UPDATE ks1.tbl SET v2=459630936 - -599384039, v4='78b7:b580:f9e2:8fbf:86be:c946:7580:53e8', s0=4.9230716E-21 WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND ck0 = 00000000-0000-4d00-a700-000000000000 AND ck1 = -7.104186E19 - -3.0900873E26 -- on node1
181: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x172f, 1513825499) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node3, fetch size 1
182: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4500-8b00-000000000000 AND ck1 = 2.4715325E-8 -- Single Row, on node2, fetch size 10
183: DELETE FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 -- on node2
184: DELETE FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND ck0 = 00000000-0000-4200-be00-000000000000 AND ck1 = 3.3123795E22 -- on node2
185: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3, v4) VALUES (0xf8bee2e5, -1995853855, 00000000-0000-4500-b600-000000000000, 1.059721E-22, 3.7675504E-10 - -3.8332405E-14, 00000000-0000-4900-ae00-000000000000, true, -177266976 - -2076611048, 0x9490c447dd3c4a7698, '227.39.44.249') -- on node1
186: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node3, fetch size 10
187: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) <= token(0xaccda5063b5f859154, -1950131767) -- by token range, on node1, fetch size 100
188: SELECT * FROM ks1.tbl WHERE v2 = -1473298702 AND v4 = '6bfd:d7bb:19e0:c9d6:9491:a0cd:b229:fc7e' AND ck0 = 00000000-0000-4300-9b00-000000000000 ALLOW FILTERING -- v2 int (indexed with SAI), v4 inet (indexed with SAI), ck0 uuid (indexed with SAI), on node2, fetch size 1
189: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) <= token(0xaccda5063b5f859154, -1950131767) -- by token range, on node2, fetch size 100
190: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4a00-9a00-000000000000 ALLOW FILTERING -- ck0 uuid, indexed with SAI, on node3, fetch size 100
191: SELECT * FROM ks1.tbl WHERE v4 = '226.147.190.144' AND v2 = 1059014975 AND v1 = true AND v0 = 00000000-0000-4f00-9400-000000000000 AND ck0 = 00000000-0000-4300-9b00-000000000000 AND ck1 = -3.38531796E17 ALLOW FILTERING -- v4 inet (indexed with SAI), v2 int (indexed with SAI), v1 boolean (indexed with SAI), v0 uuid (indexed with SAI), ck0 uuid (indexed with SAI), ck1 float (indexed with SAI), on node2, fetch size 1000
192: UPDATE ks1.tbl SET s0=-2.379433E-9, v0=00000000-0000-4f00-a500-000000000000, v1=true, v2=-1700713109 * -1608141439, v3=0x5d, v4='33.54.24.0' WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4200-b600-000000000000 AND ck1 = 2.3472485E-29 -- on node3
193: DELETE FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 -- on node3
194: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v1, v2) VALUES (0xf8bee2e5, -1995853855, 00000000-0000-4a00-a900-000000000000, -3.3874763E-5, 00000000-0000-4b00-a400-000000000000, true, 2116155127) -- on node2
195: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 -- Whole Partition, on node1, fetch size 5000
196: DELETE v0, v1, v2, v3, v4 FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4a00-a900-000000000000 AND ck1 = 2.51875262E11 -- on node1
197: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3, v4) VALUES (0xf8bee2e5, -1995853855, 00000000-0000-4a00-9700-000000000000, 6.0350916E24, -2.501437E7, 00000000-0000-4f00-b400-000000000000, true, 1083223952, 0xcbce4ebb18, '197.85.144.58') -- on node1
198: SELECT * FROM ks1.tbl WHERE v2 = -808290587 AND ck0 = 00000000-0000-4200-ba00-000000000000 ALLOW FILTERING -- v2 int (indexed with SAI), ck0 uuid (indexed with SAI), on node3, fetch size 100
199: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND ck0 = 00000000-0000-4100-a400-000000000000 AND ck1 = -8.3203575E-16 -- Single Row, on node2, fetch size 1000
200: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) = token(0xaccda5063b5f859154, -1950131767) -- by token, on node2, fetch size 5000
201: SELECT * FROM ks1.tbl WHERE v2 = -518023399 AND v4 = '78b7:b580:f9e2:8fbf:86be:c946:7580:53e8' AND ck1 = -1.81352981E14 AND s0 = 4.9230716E-21 AND ck0 = 00000000-0000-4800-a500-000000000000 ALLOW FILTERING -- v2 int (indexed with SAI), v4 inet (indexed with SAI), ck1 float (indexed with SAI), s0 float (indexed with SAI), ck0 uuid (indexed with SAI), on node2, fetch size 5000
202: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 -- Whole Partition, on node1, fetch size 1000
203: UPDATE ks1.tbl SET s0=-2.59839216E17, v0=00000000-0000-4700-ac00-000000000000, v1=false, v2=1758201503, v3=0xdf, v4='40a5:cfbf:23ef:c168:de52:4ac4:c56d:6795' WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4800-b200-000000000000 AND ck1 = -2.8721284E-31 + 0.02575966 -- on node3
204: SELECT * FROM ks1.tbl WHERE pk1 >= 321314609 -- pk1 int, indexed with SAI, on node2, fetch size 10
205: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4a00-9a00-000000000000 AND ck1 = -1.81352981E14 -- Single Row, on node3, fetch size 1
206: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v1, v2, v3, v4) VALUES (0xf8bee2e5, -1995853855, 00000000-0000-4800-8b00-000000000000, -2.80564075E14 - 173114.28, 00000000-0000-4200-9300-000000000000, false, -101889607 - 648958792, 0x9c3ceebf12f7, '103.196.255.253') -- on node3
207: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) < token(0xf8bee2e5, -1995853855) -- by token range, on node1, fetch size 5000
208: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 -- Whole Partition, on node2, fetch size 10
209: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4800-b200-000000000000 AND ck1 = 0.02575966 -- Single Row, on node1, fetch size 10
210: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3, v4) VALUES (0xece9fe2f, 321314609, 00000000-0000-4900-8600-000000000000, 1.47932826E10 * -4.833228E-7, -691796.7 - 4.031331E-33, 00000000-0000-4000-bf00-000000000000, false, -738243497 * -1755363889, 0xf07278be96b9273a, '2c3:904a:86f7:1a36:b429:49a7:b63f:447') -- on node1
211: UPDATE ks1.tbl SET v0=00000000-0000-4600-b200-000000000000, v1=true, v2=-1146039531, v3=0x0d349311dc14, v4='30.144.158.89', s0=7.859694E-14 WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4700-8100-000000000000 AND ck1 = 3.210052E-20 -- on node3
212: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 -- Whole Partition, on node1, fetch size 5000
213: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x3db7b69ecdd6a6, -1459423004) AND token(pk0, pk1) < token(0xf8bee2e5, -1995853855) -- by token range, on node2, fetch size 5000
214: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND ck1 < -0.011666143 -- ck1 float, indexed with SAI, on node3, fetch size 10
215: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) <= token(0xaccda5063b5f859154, -1950131767) -- by token range, on node3, fetch size 10
216: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4a00-9a00-000000000000 AND ck1 = -1.81352981E14 -- Single Row, on node3, fetch size 1
217: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node1, fetch size 10
218: SELECT * FROM ks1.tbl WHERE v1 = true AND ck0 = 00000000-0000-4300-9b00-000000000000 AND v2 = -531944103 AND ck1 = -3.3874763E-5 AND v0 = 00000000-0000-4000-bf00-000000000000 AND s0 = -691796.7 ALLOW FILTERING -- v1 boolean (indexed with SAI), ck0 uuid (indexed with SAI), v2 int (indexed with SAI), ck1 float (indexed with SAI), v0 uuid (indexed with SAI), s0 float (indexed with SAI), on node1, fetch size 100
219: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND v4 = '6bfd:d7bb:19e0:c9d6:9491:a0cd:b229:fc7e' -- v4 inet, indexed with SAI, on node1, fetch size 5000
220: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4a00-9a00-000000000000 AND ck1 = -1.81352981E14 -- Single Row, on node1, fetch size 1
221: DELETE FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 -- on node3
222: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND v1 = true ALLOW FILTERING -- v1 boolean, indexed with SAI, on node2, fetch size 10
223: SELECT * FROM ks1.tbl WHERE v2 = 1899344072 AND ck0 = 00000000-0000-4d00-a700-000000000000 AND s0 = -2.501437E7 AND v0 = 00000000-0000-4b00-a400-000000000000 AND ck1 = 2.3472485E-29 AND v1 = false AND v4 = '54f2:4030:2288:8636:5ba3:7f49:c55e:370e' ALLOW FILTERING -- v2 int (indexed with SAI), ck0 uuid (indexed with SAI), s0 float (indexed with SAI), v0 uuid (indexed with SAI), ck1 float (indexed with SAI), v1 boolean (indexed with SAI), v4 inet (indexed with SAI), on node2, fetch size 100
224: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v2, v3, v4) VALUES (0x172f, 1513825499, 00000000-0000-4900-a900-000000000000, 9.702136E-28, -4.7723614E-13 + -1.5055728E36, 00000000-0000-4300-9d00-000000000000, -1803566013, 0xb939de, '7f60:5a74:68e:674d:3a88:ee:1a60:8774') -- on node2
225: SELECT * FROM ks1.tbl WHERE v4 = '33.54.24.0' AND ck1 = -2.20750702E17 AND v0 = 00000000-0000-4000-bf00-000000000000 AND s0 = -2.501437E7 AND v1 = false ALLOW FILTERING -- v4 inet (indexed with SAI), ck1 float (indexed with SAI), v0 uuid (indexed with SAI), s0 float (indexed with SAI), v1 boolean (indexed with SAI), on node2, fetch size 10
226: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND v0 = 00000000-0000-4200-9300-000000000000 ALLOW FILTERING -- v0 uuid, indexed with SAI, on node2, fetch size 5000
227: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND ck0 = 00000000-0000-4d00-a700-000000000000 AND ck1 = 3.0900866E26 -- Single Row, on node3, fetch size 100
228: SELECT * FROM ks1.tbl WHERE ck1 < 3.210052E-20 -- ck1 float, indexed with SAI, on node1, fetch size 1000
229: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 > 00000000-0000-4200-b600-000000000000 ALLOW FILTERING -- ck0 uuid, indexed with SAI, on node3, fetch size 100
230: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND ck0 = 00000000-0000-4900-a900-000000000000 AND ck1 = 9.702136E-28 -- Single Row, on node1, fetch size 1000
231: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v2, v3, v4) VALUES (0xaccda5063b5f859154, -1950131767, 00000000-0000-4c00-9b00-000000000000, -1.9875584E30, 00000000-0000-4800-af00-000000000000, 516657553, 0x330749cf, '8156:97e3:932f:dd95:fe4e:5be7:6d7b:f3') -- on node3
232: UPDATE ks1.tbl SET v0=00000000-0000-4600-a200-000000000000, v1=true, v4='8da5:726e:f619:65a9:1197:3d20:6518:834' WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4800-ae00-000000000000 AND ck1 = 2.9735068E36 -- on node3
233: UPDATE ks1.tbl SET s0=-9.0503953E-26, v0=00000000-0000-4100-9000-000000000000, v1=true, v2=633247507 - -979091978, v3=0x6506, v4='190.49.241.238' WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND ck0 = 00000000-0000-4200-b300-000000000000 AND ck1 = 2.4503163E-26 * 3.781675E-34 -- on node1
234: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node1, fetch size 10
235: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x3db7b69ecdd6a6, -1459423004) AND token(pk0, pk1) < token(0xf8bee2e5, -1995853855) -- by token range, on node1, fetch size 5000
236: nodetool flush ks1 tbl
237: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND s0 < 7.859694E-14 -- s0 float, indexed with SAI, on node1, fetch size 10
238: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x3db7b69ecdd6a6, -1459423004) AND token(pk0, pk1) <= token(0x172f, 1513825499) -- by token range, on node1, fetch size 1
239: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND v0 = 00000000-0000-4000-bf00-000000000000 ALLOW FILTERING -- v0 uuid, indexed with SAI, on node1, fetch size 5000
240: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 -- Whole Partition, on node1, fetch size 1
241: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x172f, 1513825499) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node1, fetch size 10
242: SELECT * FROM ks1.tbl WHERE v4 = 'd9dd:4ba6:48a0:8cfc:a2bc:6a8d:9766:b6a6' AND v0 = 00000000-0000-4800-af00-000000000000 ALLOW FILTERING -- v4 inet (indexed with SAI), v0 uuid (indexed with SAI), on node3, fetch size 5000
243: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND v2 = -1146039531 -- v2 int, indexed with SAI, on node1, fetch size 1
244: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND v0 > 00000000-0000-4300-9d00-000000000000 ALLOW FILTERING -- v0 uuid, indexed with SAI, on node1, fetch size 1
245: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1) VALUES (0x3027b5aa00a577, -652702739, 00000000-0000-4b00-8400-000000000000, -1.1792862E33, -1.7311013E-30, 00000000-0000-4a00-9b00-000000000000, false) -- on node3
246: SELECT * FROM ks1.tbl WHERE v2 = -518023399 -- v2 int, indexed with SAI, on node1, fetch size 1000
247: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) = token(0xece9fe2f, 321314609) -- by token, on node1, fetch size 100
248: SELECT * FROM ks1.tbl WHERE v0 = 00000000-0000-4a00-9b00-000000000000 AND ck0 = 00000000-0000-4100-a400-000000000000 AND v1 = false AND v2 = 1899344072 AND s0 = -1.5055728E36 ALLOW FILTERING -- v0 uuid (indexed with SAI), ck0 uuid (indexed with SAI), v1 boolean (indexed with SAI), v2 int (indexed with SAI), s0 float (indexed with SAI), on node3, fetch size 1000
249: UPDATE ks1.tbl SET v1=false, s0=-2.1365409E-8 WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND ck0 = 00000000-0000-4c00-9a00-000000000000 AND ck1 = 2.291301E19 + -7.706793E37 -- on node1
250: DELETE FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND ck0 = 00000000-0000-4100-b500-000000000000 AND ck1 = -1.906995E-27 + -2.2770047E38 -- on node2
251: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND ck0 <= 00000000-0000-4900-a900-000000000000 ALLOW FILTERING -- ck0 uuid, indexed with SAI, on node2, fetch size 1
252: UPDATE ks1.tbl SET s0=1.3152425E-17, v0=00000000-0000-4e00-bf00-000000000000, v1=true, v2=-1968859429, v3=0x22f387, v4='217.18.112.243' WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND ck0 = 00000000-0000-4800-8500-000000000000 AND ck1 = 1.2834523E-21 - 3.6848054E-5 -- on node1
253: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x3027b5aa00a577, -652702739) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node3, fetch size 5000
254: SELECT * FROM ks1.tbl WHERE v0 = 00000000-0000-4e00-bf00-000000000000 AND ck0 = 00000000-0000-4a00-9700-000000000000 AND ck1 = -3.6848054E-5 AND v4 = '103.196.255.253' AND v1 = true AND v2 = -531944103 AND s0 = 7.859694E-14 ALLOW FILTERING -- v0 uuid (indexed with SAI), ck0 uuid (indexed with SAI), ck1 float (indexed with SAI), v4 inet (indexed with SAI), v1 boolean (indexed with SAI), v2 int (indexed with SAI), s0 float (indexed with SAI), on node2, fetch size 5000
255: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN token(0x3027b5aa00a577, -652702739) AND token(0xaccda5063b5f859154, -1950131767) -- by token range, on node2, fetch size 100
256: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x3db7b69ecdd6a6, -1459423004) AND token(pk0, pk1) <= token(0xf8bee2e5, -1995853855) -- by token range, on node2, fetch size 5000
257: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xece9fe2f, 321314609) AND token(pk0, pk1) < token(0xf8bee2e5, -1995853855) -- by token range, on node3, fetch size 10
258: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND v0 = 00000000-0000-4f00-9400-000000000000 ALLOW FILTERING -- v0 uuid, indexed with SAI, on node1, fetch size 1
259: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x3db7b69ecdd6a6, -1459423004) AND token(pk0, pk1) < token(0x172f, 1513825499) -- by token range, on node1, fetch size 1000
260: SELECT * FROM ks1.tbl WHERE v4 = '113.47.220.169' AND ck1 = -2.20750702E17 ALLOW FILTERING -- v4 inet (indexed with SAI), ck1 float (indexed with SAI), on node3, fetch size 1000
261: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND v2 >= 1758201503 -- v2 int, indexed with SAI, on node2, fetch size 5000
262: SELECT * FROM ks1.tbl WHERE v0 = 00000000-0000-4c00-9100-000000000000 AND ck1 = -0.011666143 AND ck0 = 00000000-0000-4100-a400-000000000000 AND v1 = false ALLOW FILTERING -- v0 uuid (indexed with SAI), ck1 float (indexed with SAI), ck0 uuid (indexed with SAI), v1 boolean (indexed with SAI), on node2, fetch size 5000
263: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x172f, 1513825499) AND token(pk0, pk1) < token(0x3027b5aa00a577, -652702739) -- by token range, on node3, fetch size 1
264: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND ck0 = 00000000-0000-4300-9b00-000000000000 AND ck1 = 274055.72 -- Single Row, on node2, fetch size 10
265: DELETE FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 -- on node2
266: SELECT * FROM ks1.tbl WHERE v1 = false AND v0 = 00000000-0000-4700-ac00-000000000000 AND ck0 = 00000000-0000-4500-8b00-000000000000 AND v2 = -808290587 AND ck1 = -1.1792862E33 AND s0 = -691796.7 AND v4 = '8da5:726e:f619:65a9:1197:3d20:6518:834' ALLOW FILTERING -- v1 boolean (indexed with SAI), v0 uuid (indexed with SAI), ck0 uuid (indexed with SAI), v2 int (indexed with SAI), ck1 float (indexed with SAI), s0 float (indexed with SAI), v4 inet (indexed with SAI), on node3, fetch size 10
267: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 -- Whole Partition, on node3, fetch size 10
268: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x3027b5aa00a577, -652702739) AND token(pk0, pk1) <= token(0xaccda5063b5f859154, -1950131767) -- by token range, on node2, fetch size 10
269: DELETE FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND ck0 = 00000000-0000-4d00-8000-000000000000 AND ck1 = -2.4267937E22 -- on node3
270: SELECT * FROM ks1.tbl WHERE v1 = true AND s0 = -2.1365409E-8 AND v4 = '78b7:b580:f9e2:8fbf:86be:c946:7580:53e8' AND v0 = 00000000-0000-4f00-a500-000000000000 AND v2 = 413175930 AND ck0 = 00000000-0000-4500-8b00-000000000000 ALLOW FILTERING -- v1 boolean (indexed with SAI), s0 float (indexed with SAI), v4 inet (indexed with SAI), v0 uuid (indexed with SAI), v2 int (indexed with SAI), ck0 uuid (indexed with SAI), on node2, fetch size 1
271: SELECT * FROM ks1.tbl WHERE s0 = -691796.7 AND v1 = true AND v4 = '33.54.24.0' AND v2 = 126343852 ALLOW FILTERING -- s0 float (indexed with SAI), v1 boolean (indexed with SAI), v4 inet (indexed with SAI), v2 int (indexed with SAI), on node2, fetch size 10
272: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4c00-9b00-000000000000 AND ck1 = -1.9875584E30 -- Single Row, on node3, fetch size 10
273: SELECT * FROM ks1.tbl WHERE v0 = 00000000-0000-4c00-9100-000000000000 AND ck0 = 00000000-0000-4500-8b00-000000000000 AND v4 = '113.47.220.169' AND ck1 = -1.1792862E33 AND v2 = -1803566013 ALLOW FILTERING -- v0 uuid (indexed with SAI), ck0 uuid (indexed with SAI), v4 inet (indexed with SAI), ck1 float (indexed with SAI), v2 int (indexed with SAI), on node1, fetch size 5000
274: SELECT * FROM ks1.tbl WHERE v2 = -1146039531 AND s0 = 7.859694E-14 ALLOW FILTERING -- v2 int (indexed with SAI), s0 float (indexed with SAI), on node1, fetch size 5000
275: UPDATE ks1.tbl SET v0=00000000-0000-4100-b700-000000000000, v1=true, v2=-1291728150, v3=0x7935b63768, v4='c5c9:b492:3c3e:294b:10ec:7b9a:153f:4bae', s0=8.141546E-34 WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND ck0 = 00000000-0000-4600-b800-000000000000 AND ck1 = 3.764567E-23 * -8.060066E35 -- on node2
276: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x3027b5aa00a577, -652702739) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node2, fetch size 5000
277: SELECT * FROM ks1.tbl WHERE pk1 = -1459423004 -- pk1 int, indexed with SAI, on node3, fetch size 5000
278: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND ck0 = 00000000-0000-4900-a900-000000000000 AND ck1 = 9.702136E-28 -- Single Row, on node2, fetch size 100
279: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xece9fe2f, 321314609) AND token(pk0, pk1) < token(0xf8bee2e5, -1995853855) -- by token range, on node2, fetch size 5000
280: DELETE FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4e00-b600-000000000000 AND ck1 = -0.014325934 - -1.5835502E-24 -- on node2
281: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND ck0 = 00000000-0000-4600-b800-000000000000 AND ck1 = -3.03426605E13 -- Single Row, on node2, fetch size 10
282: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) <= token(0xaccda5063b5f859154, -1950131767) -- by token range, on node3, fetch size 10
283: SELECT * FROM ks1.tbl WHERE ck1 = -1.9875584E30 -- ck1 float, indexed with SAI, on node3, fetch size 5000
284: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v1, v3, v4) VALUES (0x3db7b69ecdd6a6, -1459423004, 00000000-0000-4a00-8400-000000000000, -8.5766152E7 - -4.2274656E7, true, 0x9c50, '230.216.82.197') -- on node1
285: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x3db7b69ecdd6a6, -1459423004) AND token(pk0, pk1) <= token(0xaccda5063b5f859154, -1950131767) -- by token range, on node1, fetch size 5000
286: SELECT * FROM ks1.tbl WHERE v2 = 516657553 AND v4 = '113.47.220.169' AND s0 = -691796.7 AND v0 = 00000000-0000-4600-a200-000000000000 ALLOW FILTERING -- v2 int (indexed with SAI), v4 inet (indexed with SAI), s0 float (indexed with SAI), v0 uuid (indexed with SAI), on node1, fetch size 1000
287: DELETE FROM ks1.tbl WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND ck0 = 00000000-0000-4100-8700-000000000000 AND ck1 = -2.7329296E32 * -4.3014748E-35 -- on node1
288: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node3, fetch size 1
289: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND v2 < -808290587 -- v2 int, indexed with SAI, on node3, fetch size 1
290: SELECT * FROM ks1.tbl WHERE v4 = '30.144.158.89' AND ck1 = -1.81352981E14 AND s0 = -691796.7 AND v1 = false ALLOW FILTERING -- v4 inet (indexed with SAI), ck1 float (indexed with SAI), s0 float (indexed with SAI), v1 boolean (indexed with SAI), on node3, fetch size 100
291: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) = token(0x3027b5aa00a577, -652702739) -- by token, on node2, fetch size 1
292: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) <= token(0x3027b5aa00a577, -652702739) -- by token range, on node1, fetch size 1000
293: SELECT * FROM ks1.tbl WHERE s0 = -2.1365409E-8 AND v1 = true ALLOW FILTERING -- s0 float (indexed with SAI), v1 boolean (indexed with SAI), on node3, fetch size 1
294: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 -- Whole Partition, on node3, fetch size 1
295: SELECT * FROM ks1.tbl WHERE ck0 = 00000000-0000-4c00-9b00-000000000000 AND s0 = -2.1365409E-8 AND v0 = 00000000-0000-4600-b200-000000000000 AND v2 = 1758201503 AND v1 = true AND v4 = '33.54.24.0' AND ck1 = -2.20750702E17 ALLOW FILTERING -- ck0 uuid (indexed with SAI), s0 float (indexed with SAI), v0 uuid (indexed with SAI), v2 int (indexed with SAI), v1 boolean (indexed with SAI), v4 inet (indexed with SAI), ck1 float (indexed with SAI), on node1, fetch size 5000
296: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) <= token(0x3db7b69ecdd6a6, -1459423004) -- by token range, on node2, fetch size 1000
297: SELECT * FROM ks1.tbl WHERE s0 = 7.859694E-14 AND v0 = 00000000-0000-4800-9800-000000000000 AND ck0 = 00000000-0000-4800-8c00-000000000000 AND v1 = false ALLOW FILTERING -- s0 float (indexed with SAI), v0 uuid (indexed with SAI), ck0 uuid (indexed with SAI), v1 boolean (indexed with SAI), on node1, fetch size 1
298: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4200-b600-000000000000 AND ck1 = 2.3472485E-29 -- Single Row, on node2, fetch size 1000
299: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x3027b5aa00a577, -652702739) AND token(pk0, pk1) <= token(0xaccda5063b5f859154, -1950131767) -- by token range, on node3, fetch size 1
300: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) < token(0x172f, 1513825499) -- by token range, on node1, fetch size 10
301: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN token(0xece9fe2f, 321314609) AND token(0x3db7b69ecdd6a6, -1459423004) -- by token range, on node1, fetch size 10
302: SELECT * FROM ks1.tbl WHERE v2 = 1758201503 AND v4 = '8da5:726e:f619:65a9:1197:3d20:6518:834' AND v1 = true AND s0 = -1.5055728E36 ALLOW FILTERING -- v2 int (indexed with SAI), v4 inet (indexed with SAI), v1 boolean (indexed with SAI), s0 float (indexed with SAI), on node1, fetch size 1000
303: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) < token(0x3027b5aa00a577, -652702739) -- by token range, on node3, fetch size 10
304: SELECT * FROM ks1.tbl WHERE s0 = -691796.7 AND ck1 = 3.0900866E26 AND v1 = false AND v4 = '113.47.220.169' AND v0 = 00000000-0000-4800-9800-000000000000 AND ck0 = 00000000-0000-4a00-8400-000000000000 ALLOW FILTERING -- s0 float (indexed with SAI), ck1 float (indexed with SAI), v1 boolean (indexed with SAI), v4 inet (indexed with SAI), v0 uuid (indexed with SAI), ck0 uuid (indexed with SAI), on node2, fetch size 1
305: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) < token(0x3027b5aa00a577, -652702739) -- by token range, on node1, fetch size 1
306: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND v4 = '230.216.82.197' -- v4 inet, indexed with SAI, on node2, fetch size 10
307: SELECT * FROM ks1.tbl WHERE v2 = -531944103 AND s0 = -2.59839216E17 AND v4 = 'd9dd:4ba6:48a0:8cfc:a2bc:6a8d:9766:b6a6' ALLOW FILTERING -- v2 int (indexed with SAI), s0 float (indexed with SAI), v4 inet (indexed with SAI), on node1, fetch size 1000
308: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4a00-8400-000000000000 AND ck1 = -4.3491496E7 -- Single Row, on node1, fetch size 10
309: SELECT * FROM ks1.tbl WHERE ck1 = -1.1792862E33 AND v2 = -1291728150 ALLOW FILTERING -- ck1 float (indexed with SAI), v2 int (indexed with SAI), on node2, fetch size 10
310: SELECT * FROM ks1.tbl WHERE ck0 < 00000000-0000-4800-8c00-000000000000 ALLOW FILTERING -- ck0 uuid, indexed with SAI, on node3, fetch size 1
311: UPDATE ks1.tbl SET v0=00000000-0000-4c00-aa00-000000000000, v1=true, v4='56c0:d3ff:b3aa:efa3:b15a:711f:10ac:2020' WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND ck0 = 00000000-0000-4900-8100-000000000000 AND ck1 = 2.9986876E-32 -- on node1
312: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) < token(0xf8bee2e5, -1995853855) -- by token range, on node3, fetch size 10
313: DELETE FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4f00-8000-000000000000 AND ck1 = -1.3626502E-27 -- on node1
314: SELECT * FROM ks1.tbl WHERE s0 = -2.1365409E-8 AND v4 = 'c5c9:b492:3c3e:294b:10ec:7b9a:153f:4bae' AND ck1 = 2.9735068E36 AND v0 = 00000000-0000-4800-af00-000000000000 AND v2 = 126343852 ALLOW FILTERING -- s0 float (indexed with SAI), v4 inet (indexed with SAI), ck1 float (indexed with SAI), v0 uuid (indexed with SAI), v2 int (indexed with SAI), on node2, fetch size 100
315: SELECT * FROM ks1.tbl WHERE v4 = 'c5c9:b492:3c3e:294b:10ec:7b9a:153f:4bae' AND v1 = false AND v2 = 413175930 AND v0 = 00000000-0000-4600-b200-000000000000 AND ck1 = -7149.931 AND ck0 = 00000000-0000-4300-9b00-000000000000 ALLOW FILTERING -- v4 inet (indexed with SAI), v1 boolean (indexed with SAI), v2 int (indexed with SAI), v0 uuid (indexed with SAI), ck1 float (indexed with SAI), ck0 uuid (indexed with SAI), on node3, fetch size 1000
316: DELETE FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4100-a300-000000000000 AND ck1 = -1.17564762E9 - -3.8797236E-7 -- on node1
317: UPDATE ks1.tbl SET v0=00000000-0000-4a00-b700-000000000000, v4='168.70.3.14' WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4f00-a100-000000000000 AND ck1 = 1.5297076E32 * -1.7596395E-37 -- on node2
318: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3, v4) VALUES (0x172f, 1513825499, 00000000-0000-4000-8800-000000000000, -0.0031379566 - -9.7774775E28, -5.2295632E7 + 2.5228513E-32, 00000000-0000-4e00-a800-000000000000, true, -1790941789 + 1638645349, 0x17, '225a:39c8:7f36:efe8:e832:98e4:5435:f356') -- on node3
319: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3, v4) VALUES (0xf8bee2e5, -1995853855, 00000000-0000-4200-b600-000000000000, 3.23033568E8, 4.04672384E9, 00000000-0000-4400-8100-000000000000, true, 635588626 - -2094568829, 0xa051b5a8d9757e, 'f295:7c78:f42f:3213:9adf:cf7:592a:6d2') -- on node1
320: DELETE FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4900-8a00-000000000000 AND ck1 = 9.721864E-11 + -7.5409435E28 -- on node2
321: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND s0 = -5.2295632E7 -- s0 float, indexed with SAI, on node1, fetch size 100
322: SELECT * FROM ks1.tbl WHERE v2 = -1564809841 AND v4 = '8da5:726e:f619:65a9:1197:3d20:6518:834' AND s0 = -5.2295632E7 ALLOW FILTERING -- v2 int (indexed with SAI), v4 inet (indexed with SAI), s0 float (indexed with SAI), on node1, fetch size 1
323: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4800-ae00-000000000000 AND ck1 = 2.9735068E36 -- Single Row, on node1, fetch size 5000
324: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND v4 = '8da5:726e:f619:65a9:1197:3d20:6518:834' -- v4 inet, indexed with SAI, on node2, fetch size 5000
325: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND ck0 = 00000000-0000-4000-8800-000000000000 AND ck1 = 9.7774775E28 -- Single Row, on node1, fetch size 100
326: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND v0 > 00000000-0000-4f00-a500-000000000000 ALLOW FILTERING -- v0 uuid, indexed with SAI, on node3, fetch size 1
327: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND ck0 = 00000000-0000-4900-a900-000000000000 AND ck1 = 9.702136E-28 -- Single Row, on node1, fetch size 10
328: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xece9fe2f, 321314609) AND token(pk0, pk1) <= token(0xf8bee2e5, -1995853855) -- by token range, on node1, fetch size 100
329: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND v1 >= true ALLOW FILTERING -- v1 boolean, indexed with SAI, on node1, fetch size 5000
330: DELETE v0, v1, v2, v4 FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4c00-8500-000000000000 AND ck1 = -0.3712973 -- on node2
331: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x3db7b69ecdd6a6, -1459423004) AND token(pk0, pk1) <= token(0x3027b5aa00a577, -652702739) -- by token range, on node1, fetch size 1
332: UPDATE ks1.tbl SET v1=true, v3=0x290b6b, v4='132.71.82.154', s0=4.2286161E16 WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND ck0 = 00000000-0000-4c00-8d00-000000000000 AND ck1 = -7.529702E25 -- on node1
333: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x3db7b69ecdd6a6, -1459423004) AND token(pk0, pk1) < token(0xf8bee2e5, -1995853855) -- by token range, on node3, fetch size 1
334: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND v1 = true ALLOW FILTERING -- v1 boolean, indexed with SAI, on node3, fetch size 100
335: SELECT * FROM ks1.tbl WHERE ck1 = 2.4715325E-8 AND s0 = 4.2286161E16 AND v1 = true ALLOW FILTERING -- ck1 float (indexed with SAI), s0 float (indexed with SAI), v1 boolean (indexed with SAI), on node2, fetch size 1
336: SELECT * FROM ks1.tbl WHERE ck0 = 00000000-0000-4300-9b00-000000000000 AND v2 = -1564809841 AND v4 = '78b7:b580:f9e2:8fbf:86be:c946:7580:53e8' ALLOW FILTERING -- ck0 uuid (indexed with SAI), v2 int (indexed with SAI), v4 inet (indexed with SAI), on node2, fetch size 1000
337: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND v1 = false ALLOW FILTERING -- v1 boolean, indexed with SAI, on node2, fetch size 5000
338: SELECT * FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND ck0 <= 00000000-0000-4900-8100-000000000000 ALLOW FILTERING -- ck0 uuid, indexed with SAI, on node3, fetch size 5000
339: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 -- Whole Partition, on node2, fetch size 10
340: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3, v4) VALUES (0x3027b5aa00a577, -652702739, 00000000-0000-4b00-b700-000000000000, -1.3971943E28 - 1.7235932E-18, -0.48479807 * 14961.616, 00000000-0000-4b00-ab00-000000000000, false, -307641927 + 1912882892, 0x17, '184.107.134.42') -- on node3
341: UPDATE ks1.tbl SET v1=false, v2=950206744, v3=0x1eabc8eb8f6b, v4='b7ed:26ed:ef02:6906:ee4b:f40:597:4b6b', s0=-8.0146734E18 WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND ck0 = 00000000-0000-4a00-af00-000000000000 AND ck1 = 5.3815134E-12 -- on node3
342: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3, v4) VALUES (0xaccda5063b5f859154, -1950131767, 00000000-0000-4c00-a100-000000000000, 4.35124253E12, -1.1874748E23, 00000000-0000-4200-b800-000000000000, true, -940494695 + -423800850, 0xcf2a5e19b2f71918, '169.6.251.129') -- on node1
343: SELECT * FROM ks1.tbl WHERE v0 = 00000000-0000-4a00-9b00-000000000000 AND v4 = '168.70.3.14' AND v1 = false AND ck0 = 00000000-0000-4f00-a100-000000000000 AND ck1 = 3.0900866E26 ALLOW FILTERING -- v0 uuid (indexed with SAI), v4 inet (indexed with SAI), v1 boolean (indexed with SAI), ck0 uuid (indexed with SAI), ck1 float (indexed with SAI), on node2, fetch size 1
344: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND ck0 = 00000000-0000-4200-ba00-000000000000 AND ck1 = -2.20750702E17 -- Single Row, on node1, fetch size 1000
345: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) <= token(0xaccda5063b5f859154, -1950131767) -- by token range, on node1, fetch size 1000
346: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xf8bee2e5, -1995853855) AND token(pk0, pk1) <= token(0xaccda5063b5f859154, -1950131767) -- by token range, on node1, fetch size 10
347: UPDATE ks1.tbl SET v0=00000000-0000-4d00-b600-000000000000 WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4600-a600-000000000000 AND ck1 = -5.3717714E-27 - -1.0102544E35 -- on node3
348: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND ck1 = 3.0900866E26 -- ck1 float, indexed with SAI, on node3, fetch size 5000
349: SELECT * FROM ks1.tbl WHERE v0 = 00000000-0000-4a00-b700-000000000000 AND v2 = 516657553 ALLOW FILTERING -- v0 uuid (indexed with SAI), v2 int (indexed with SAI), on node2, fetch size 1000
350: SELECT * FROM ks1.tbl WHERE ck1 = 2.4715325E-8 AND v4 = 'f295:7c78:f42f:3213:9adf:cf7:592a:6d2' ALLOW FILTERING -- ck1 float (indexed with SAI), v4 inet (indexed with SAI), on node2, fetch size 5000
351: SELECT * FROM ks1.tbl WHERE v0 = 00000000-0000-4700-ac00-000000000000 ALLOW FILTERING -- v0 uuid, indexed with SAI, on node3, fetch size 10
352: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND v2 <= -152296440 -- v2 int, indexed with SAI, on node3, fetch size 100
353: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3, v4) VALUES (0xece9fe2f, 321314609, 00000000-0000-4000-a000-000000000000, -1.19878246E10 * -3.68226498E15, -3.7029874E-8 - 8.2365045E-13, 00000000-0000-4000-9800-000000000000, false, -174507469, 0xcf43e912, '250.28.133.98') -- on node3
354: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4f00-a100-000000000000 AND ck1 = -2.691734E-5 -- Single Row, on node3, fetch size 10
355: SELECT * FROM ks1.tbl WHERE v2 = 1605240965 AND v1 = false AND s0 = -3.70307E-8 AND v0 = 00000000-0000-4800-af00-000000000000 ALLOW FILTERING -- v2 int (indexed with SAI), v1 boolean (indexed with SAI), s0 float (indexed with SAI), v0 uuid (indexed with SAI), on node3, fetch size 100
356: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND ck0 = 00000000-0000-4900-a900-000000000000 AND ck1 = 9.702136E-28 -- Single Row, on node1, fetch size 1
357: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x172f, 1513825499) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node2, fetch size 1
358: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 -- Whole Partition, on node2, fetch size 1
359: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4a00-8400-000000000000 AND ck1 = -4.3491496E7 -- Single Row, on node3, fetch size 1
360: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3, v4) VALUES (0x3027b5aa00a577, -652702739, 00000000-0000-4300-8f00-000000000000, -1.02680205E24 - 4.461203E-29, -2.7431481E-8, 00000000-0000-4200-af00-000000000000, true, -1602192398, 0x14015b5702bec1d3ee, 'c4:1a6a:45b3:a542:e070:8684:b15d:4e14') -- on node3
361: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 AND v4 = '250.28.133.98' -- v4 inet, indexed with SAI, on node1, fetch size 1000
362: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND v1 = true ALLOW FILTERING -- v1 boolean, indexed with SAI, on node3, fetch size 100
363: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v2, v4) VALUES (0xaccda5063b5f859154, -1950131767, 00000000-0000-4500-a700-000000000000, 9.4233146E36, -1.1116392E36, -352085577, 'a5d:c97c:9d25:3a36:445:6a65:9dcb:4512') -- on node2
364: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0x3027b5aa00a577, -652702739) AND token(pk0, pk1) < token(0xaccda5063b5f859154, -1950131767) -- by token range, on node3, fetch size 5000
365: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND s0 <= -2.59839216E17 -- s0 float, indexed with SAI, on node3, fetch size 100
366: DELETE FROM ks1.tbl WHERE pk0 = 0xf8bee2e5 AND pk1 = -1995853855 AND ck0 = 00000000-0000-4100-a600-000000000000 AND ck1 = -1.092129E-7 * 2.415992E-5 -- on node2
367: SELECT * FROM ks1.tbl WHERE v4 = '7f60:5a74:68e:674d:3a88:ee:1a60:8774' AND v2 = -531944103 AND s0 = -3.70307E-8 AND v0 = 00000000-0000-4c00-aa00-000000000000 AND ck0 = 00000000-0000-4600-a600-000000000000 AND ck1 = -3.03426605E13 ALLOW FILTERING -- v4 inet (indexed with SAI), v2 int (indexed with SAI), s0 float (indexed with SAI), v0 uuid (indexed with SAI), ck0 uuid (indexed with SAI), ck1 float (indexed with SAI), on node3, fetch size 1
368: SELECT * FROM ks1.tbl WHERE ck0 = 00000000-0000-4c00-9a00-000000000000 AND v2 = 1758201503 AND ck1 = 2.9735068E36 AND v0 = 00000000-0000-4e00-a800-000000000000 AND v1 = false ALLOW FILTERING -- ck0 uuid (indexed with SAI), v2 int (indexed with SAI), ck1 float (indexed with SAI), v0 uuid (indexed with SAI), v1 boolean (indexed with SAI), on node2, fetch size 1
369: SELECT * FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 -- Whole Partition, on node3, fetch size 5000
370: UPDATE ks1.tbl SET s0=-3.82811294E15 * -1.2470315E32, v0=00000000-0000-4900-9800-000000000000, v1=false, v2=1971659188, v3=0x5267ff7972cb3f0aff8a, v4='8144:978c:9f4e:2b5c:a541:f788:2638:88c3' WHERE pk0 = 0x172f AND pk1 = 1513825499 AND ck0 = 00000000-0000-4600-a600-000000000000 AND ck1 = -54082.992 -- on node2
371: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND s0 >= -2.59839216E17 -- s0 float, indexed with SAI, on node3, fetch size 100
372: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 -- Whole Partition, on node2, fetch size 100
373: SELECT * FROM ks1.tbl WHERE v4 = '132.71.82.154' AND v2 = 516657553 AND ck1 = 2.4715325E-8 ALLOW FILTERING -- v4 inet (indexed with SAI), v2 int (indexed with SAI), ck1 float (indexed with SAI), on node2, fetch size 10
374: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4800-b200-000000000000 ALLOW FILTERING -- ck0 uuid, indexed with SAI, on node2, fetch size 100
375: SELECT * FROM ks1.tbl WHERE v1 = false AND s0 = Infinity AND ck0 = 00000000-0000-4200-b600-000000000000 AND ck1 = 0.02575966 AND v2 = -174507469 ALLOW FILTERING -- v1 boolean (indexed with SAI), s0 float (indexed with SAI), ck0 uuid (indexed with SAI), ck1 float (indexed with SAI), v2 int (indexed with SAI), on node2, fetch size 1
376: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) <= token(0x3db7b69ecdd6a6, -1459423004) -- by token range, on node1, fetch size 5000
377: SELECT * FROM ks1.tbl WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 -- Whole Partition, on node3, fetch size 1
378: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 -- Whole Partition, on node2, fetch size 10
379: SELECT * FROM ks1.tbl WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND v2 = 1605240965 -- v2 int, indexed with SAI, on node2, fetch size 10
380: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x172f, 1513825499) AND token(pk0, pk1) <= token(0xf8bee2e5, -1995853855) -- by token range, on node1, fetch size 10
381: SELECT * FROM ks1.tbl WHERE pk0 = 0xaccda5063b5f859154 AND pk1 = -1950131767 AND ck0 = 00000000-0000-4c00-9b00-000000000000 AND ck1 = -1.9875584E30 -- Single Row, on node1, fetch size 10
382: SELECT * FROM ks1.tbl WHERE ck0 = 00000000-0000-4800-ae00-000000000000 AND v0 = 00000000-0000-4a00-b700-000000000000 AND v4 = 'f295:7c78:f42f:3213:9adf:cf7:592a:6d2' AND ck1 = 4.414235E25 AND v1 = true AND s0 = -2.7431481E-8 AND v2 = 1059014975 ALLOW FILTERING -- ck0 uuid (indexed with SAI), v0 uuid (indexed with SAI), v4 inet (indexed with SAI), ck1 float (indexed with SAI), v1 boolean (indexed with SAI), s0 float (indexed with SAI), v2 int (indexed with SAI), on node3, fetch size 10
383: SELECT * FROM ks1.tbl WHERE pk0 = 0x172f AND pk1 = 1513825499 AND ck0 = 00000000-0000-4000-8800-000000000000 AND ck1 = 9.7774775E28 -- Single Row, on node3, fetch size 100
384: SELECT * FROM ks1.tbl WHERE pk0 = 0x3027b5aa00a577 AND pk1 = -652702739 AND ck0 = 00000000-0000-4c00-9a00-000000000000 AND ck1 = -7.706793E37 -- Single Row, on node3, fetch size 1
385: SELECT * FROM ks1.tbl WHERE s0 = -2.7431481E-8 AND v2 = -1291728150 ALLOW FILTERING -- s0 float (indexed with SAI), v2 int (indexed with SAI), on node1, fetch size 100
386: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0x172f, 1513825499) AND token(pk0, pk1) <= token(0xf8bee2e5, -1995853855) -- by token range, on node3, fetch size 100
387: SELECT * FROM ks1.tbl WHERE s0 = -2.59839216E17 AND ck1 = 3.210052E-20 AND v2 = 1059014975 AND ck0 = 00000000-0000-4f00-a100-000000000000 AND v1 = false AND v4 = '7f60:5a74:68e:674d:3a88:ee:1a60:8774' AND v0 = 00000000-0000-4f00-9400-000000000000 ALLOW FILTERING -- s0 float (indexed with SAI), ck1 float (indexed with SAI), v2 int (indexed with SAI), ck0 uuid (indexed with SAI), v1 boolean (indexed with SAI), v4 inet (indexed with SAI), v0 uuid (indexed with SAI), on node2, fetch size 1000
388: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN token(0x3db7b69ecdd6a6, -1459423004) AND token(0x3027b5aa00a577, -652702739) -- by token range, on node1, fetch size 10
389: DELETE s0 FROM ks1.tbl WHERE pk0 = 0xece9fe2f AND pk1 = 321314609 -- on node3
390: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >= token(0xece9fe2f, 321314609) AND token(pk0, pk1) < token(0xf8bee2e5, -1995853855) -- by token range, on node2, fetch size 5000
391: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) > token(0xece9fe2f, 321314609) AND token(pk0, pk1) < token(0xf8bee2e5, -1995853855) -- by token range, on node3, fetch size 10
392: SELECT * FROM ks1.tbl WHERE ck1 = 3.23033568E8 AND s0 = -2.59839216E17 ALLOW FILTERING -- ck1 float (indexed with SAI), s0 float (indexed with SAI), on node1, fetch size 5000
393: UPDATE ks1.tbl SET v3=0x003c, v4='126.229.32.3' WHERE pk0 = 0x3db7b69ecdd6a6 AND pk1 = -1459423004 AND ck0 = 00000000-0000-4600-9f00-000000000000 AND ck1 = -3.854987E34 -- on node3
394: UPDATE ks1.tbl SET v0=00000000-0000-4d00-a300-000000000000, v2=-1603167056 WHERE pk0 = 0x172f AND pk1 = 1513825499 AND ck0 = 00000000-0000-4700-af00-000000000000 AND ck1 = 239.01569 * 2.892415E-5 -- on node1
395: SELECT * FROM ks1.tbl WHERE ck1 <= -1.1792862E33 -- ck1 float, indexed with SAI, on node3, fetch size 5000
at accord.utils.Property$StatefulBuilder.check(Property.java:504)
at org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.test(SingleNodeTableWalkTest.java:352)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)
at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)
at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)
at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235)
at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)
Caused by: java.lang.AssertionError: Unexpected results for query: SELECT * FROM ks1.tbl WHERE ck1 <= -1.1792862E33
Caused by: java.lang.AssertionError: Unexpected rows found:
pk0 | pk1 | ck0 | ck1 | s0 | v0 | v1 | v2 | v3 | v4
0x3db7b69ecdd6a6 | -1459423004 | 00000000-0000-4200-b600-000000000000 | 2.3472485E-29 | -2.59839216E17 | 00000000-0000-4f00-a500-000000000000 | true | 1355516395 | 0x5d | '33.54.24.0'
0x3db7b69ecdd6a6 | -1459423004 | 00000000-0000-4a00-8400-000000000000 | -4.3491496E7 | -2.59839216E17 | null | true | null | 0x9c50 | '230.216.82.197'
0x3db7b69ecdd6a6 | -1459423004 | 00000000-0000-4800-b200-000000000000 | 0.02575966 | -2.59839216E17 | 00000000-0000-4700-ac00-000000000000 | false | 1758201503 | 0xdf | '40a5:cfbf:23ef:c168:de52:4ac4:c56d:6795'
0x3db7b69ecdd6a6 | -1459423004 | 00000000-0000-4f00-a100-000000000000 | -2.691734E-5 | -2.59839216E17 | 00000000-0000-4a00-b700-000000000000 | null | null | null | '168.70.3.14'
Expected:
pk0 | pk1 | ck0 | ck1 | s0 | v0 | v1 | v2 | v3 | v4
0x3db7b69ecdd6a6 | -1459423004 | 00000000-0000-4600-9f00-000000000000 | -3.854987E34 | -2.59839216E17 | null | null | null | 0x003c | '126.229.32.3'
0x3027b5aa00a577 | -652702739 | 00000000-0000-4b00-8400-000000000000 | -1.1792862E33 | -2.7431481E-8 | 00000000-0000-4a00-9b00-000000000000 | false | null | null | null
0x3027b5aa00a577 | -652702739 | 00000000-0000-4c00-9a00-000000000000 | -7.706793E37 | -2.7431481E-8 | null | false | null | null | null
{code}
> ALLOW FILTERING returned data that doesn't match the single column condition.
> -----------------------------------------------------------------------------
>
> Key: CASSANDRA-20243
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20243
> Project: Apache Cassandra
> Issue Type: Bug
> Components: Consistency/Coordination
> Reporter: David Capwell
> Priority: Normal
> Fix For: 5.x
>
>
> This was found by CASSANDRA-20156
> The following history returns extra data that doesn’t match the condition
> {code}
> History:
> 19: INSERT INTO ks1.tbl (pk0, ck0, ck1, v0, v2) VALUES ('滲魶潁ꧏ', '㳩륓彫澳炬ᔕ?', 0x00000000000014008f00000000000000, 'a559:fe1:d87b:25:c95e:9029:44e5:6ad2', 1.85573747E16 + 1.3498884E31) -- on node2
> 21: INSERT INTO ks1.tbl (pk0, ck0, ck1, s0, s1, v0, v1, v2) VALUES ('滲魶潁ꧏ', '᱓흩窡' + '㯪?竲翐尞绸봧헑ꑖ', 0x0000000000004800a900000000000000, 00000000-0000-4900-b600-000000000000, 00000000-0000-1900-ac00-000000000000, '170.247.202.199', 7538904746043055610 + 7400846939126123242, -5.0338443E-27) -- on node3
> 22: SELECT * FROM ks1.tbl WHERE ck1 = 0x0000000000004800a900000000000000 ALLOW FILTERING -- ck1 'org.apache.cassandra.db.marshal.LexicalUUIDType' (reversed), on node1, fetch size 100
> {code}
> This fails with
> {code}
> Caused by: java.lang.AssertionError: Unexpected rows found:
> pk0 | ck0 | ck1 | s0 | s1 | v0 | v1 | v2
> '滲魶潁ꧏ' | '㳩륓彫澳炬ᔕ?' | 0x00000000000014008f00000000000000 | 00000000-0000-4900-b600-000000000000 | 00000000-0000-1900-ac00-000000000000 | 'a559:fe1:d87b:25:c95e:9029:44e5:6ad2' | null | 1.3498884E31
> Expected:
> pk0 | ck0 | ck1 | s0 | s1 | v0 | v1 | v2
> '滲魶潁ꧏ' | '᱓흩窡㯪?竲翐尞绸봧헑ꑖ' | 0x0000000000004800a900000000000000 | 00000000-0000-4900-b600-000000000000 | 00000000-0000-1900-ac00-000000000000 | '170.247.202.199' | -3506992388540372764 | -5.0338443E-27
> {code}
> Took this and created a non-fuzz test to repo
> {code}
> public class RepoTest extends TestBaseImpl
> {
> private static final Logger logger = LoggerFactory.getLogger(RepoTest.class);
> @Test
> public void test() throws IOException
> {
> boolean singleNode = false;
> try (Cluster cluster = Cluster.build(singleNode ? 1 : 3).start())
> {
> schemaChanges(cluster, "\t\tCREATE KEYSPACE IF NOT EXISTS ks1 WITH replication = {'class': 'SimpleStrategy', 'replication_factor': "+(singleNode ? 1 : 3)+"};\n" +
> "\t\tCREATE TABLE ks1.tbl (\n" +
> "\t\t pk0 text,\n" +
> "\t\t ck0 text,\n" +
> "\t\t ck1 'org.apache.cassandra.db.marshal.LexicalUUIDType',\n" +
> "\t\t s0 uuid static,\n" +
> "\t\t s1 timeuuid static,\n" +
> "\t\t v0 inet,\n" +
> "\t\t v1 bigint,\n" +
> "\t\t v2 float,\n" +
> "\t\t PRIMARY KEY (pk0, ck0, ck1)\n" +
> "\t\t) WITH CLUSTERING ORDER BY (ck0 DESC, ck1 DESC)\n" +
> "\t\t AND additional_write_policy = '99p'\n" +
> "\t\t AND allow_auto_snapshot = true\n" +
> "\t\t AND bloom_filter_fp_chance = 0.01\n" +
> "\t\t AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}\n" +
> "\t\t AND cdc = false\n" +
> "\t\t AND comment = ''\n" +
> "\t\t AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}\n" +
> "\t\t AND compression = {'chunk_length_in_kb': '16', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}\n" +
> "\t\t AND memtable = 'default'\n" +
> "\t\t AND crc_check_chance = 1.0\n" +
> "\t\t AND fast_path = 'keyspace'\n" +
> "\t\t AND default_time_to_live = 0\n" +
> "\t\t AND extensions = {}\n" +
> "\t\t AND gc_grace_seconds = 864000\n" +
> "\t\t AND incremental_backups = true\n" +
> "\t\t AND max_index_interval = 2048\n" +
> "\t\t AND memtable_flush_period_in_ms = 0\n" +
> "\t\t AND min_index_interval = 128\n" +
> "\t\t AND read_repair = 'BLOCKING'\n" +
> "\t\t AND transactional_mode = 'off'\n" +
> "\t\t AND transactional_migration_from = 'none'\n" +
> "\t\t AND speculative_retry = '99p';\n"
> );
> cluster.get(singleNode ? 1 : 2).executeInternal("INSERT INTO ks1.tbl (pk0, ck0, ck1, v0, v2) VALUES ('滲魶\uE2F7潁ꧏ', '㳩륓\uE799彫澳\uF38E炬\uEC9Dᔕ?', 0x00000000000014008f00000000000000, 'a559:fe1:d87b:25:c95e:9029:44e5:6ad2', 1.85573747E16 + 1.3498884E31)");
> cluster.get(singleNode ? 1 : 3).executeInternal("INSERT INTO ks1.tbl (pk0, ck0, ck1, s0, s1, v0, v1, v2) VALUES ('滲魶\uE2F7潁ꧏ', '᱓흩窡' + '㯪?竲\uEE38翐尞绸봧헑ꑖ', 0x0000000000004800a900000000000000, 00000000-0000-4900-b600-000000000000, 00000000-0000-1900-ac00-000000000000, '170.247.202.199', 7538904746043055610 + 7400846939126123242, -5.0338443E-27)");
> var qr = cluster.get(1).coordinator().executeWithResult("SELECT * FROM ks1.tbl WHERE ck1 = 0x0000000000004800a900000000000000 ALLOW FILTERING", ConsistencyLevel.ALL);
> AssertUtils.assertRows(qr, QueryResults.builder()
> .row("滲魶\uE2F7潁ꧏ", // pk0
> "᱓흩窡㯪?竲\uEE38翐尞绸봧헑ꑖ", // ck0
> UUID.fromString("00000000-0000-4800-a900-000000000000"), // ck1. The CQL literal is "0x0000000000004800a900000000000000" as this is a LexicalUUIDType, but jvm-dtest converts this to a UUID in the resultset
> UUID.fromString("00000000-0000-4900-b600-000000000000"), // s0
> UUID.fromString("00000000-0000-1900-ac00-000000000000"), // s1
> InetAddress.getByName("170.247.202.199"), // v0
> -3506992388540372764L, // v1
> -5.0338443E-27F // v2
> )
> .build());
> }
> }
> private static void schemaChanges(Cluster cluster, String cql)
> {
> for (String change : Splitter.on(';').omitEmptyStrings().trimResults().splitToList(cql))
> {
> logger.warn("Schema change: {}", change);
> cluster.schemaChange(change);
> }
> }
> }
> {code}
> This fails because the first write (which doesn’t match the condition) got returned… only the second write is expected.
> I ran the test with single node and multi node, and this looks to only fail when on multi node
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org