[
https://issues.apache.org/jira/browse/CASSANDRA-20338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17939084#comment-17939084
]
David Capwell commented on CASSANDRA-20338:
-------------------------------------------
https://github.com/apache/cassandra/pull/4006
SHA: 57755ffe8c7954dbfc0ef4a50a2182c5cbbcff99
JDK: 11
Test: org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest
{code}
accord.utils.Property$PropertyError: Property error detected:
Seed = -6614981692374717168
Examples = 1
Pure = true
Error: Unexpected results for query: SELECT * FROM ks1.tbl WHERE pk1 =
'2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' AND s1 = true AND v4 = true ALLOW
FILTERING
Steps: 400
Values:
State:
Setup:
CREATE KEYSPACE IF NOT EXISTS ks1 WITH replication = {'class':
'SimpleStrategy', 'replication_factor': 1};
CREATE TABLE ks1.tbl (
pk0 bigint,
pk1 inet,
ck0 timestamp,
ck1 float,
s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>>
static,
s1 boolean static,
v0 ascii,
v1 frozen<map<text, frozen<map<int, ascii>>>>,
v2 blob,
v3 frozen<tuple<frozen<map<boolean, ascii>>,
frozen<tuple<blob>>, 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>,
v4 boolean,
PRIMARY KEY ((pk0, pk1), ck0, ck1)
) WITH CLUSTERING ORDER BY (ck0 DESC, ck1 ASC)
AND additional_write_policy = '99p'
AND allow_auto_snapshot = true
AND bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'NONE', 'rows_per_partition':
'645858491'}
AND cdc = false
AND comment = ''
AND compaction = {'class':
'org.apache.cassandra.db.compaction.UnifiedCompactionStrategy',
'only_purge_repaired_tombstones': 'true', 'provide_overlapping_tombstones':
'NONE'}
AND compression = {'chunk_length_in_kb': '16', 'class':
'org.apache.cassandra.io.compress.LZ4Compressor'}
AND memtable = 'default'
AND crc_check_chance = 1.0
AND default_time_to_live = 0
AND extensions = {}
AND gc_grace_seconds = 864000
AND incremental_backups = true
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair = 'BLOCKING'
AND speculative_retry = '99p';
CREATE CUSTOM INDEX tbl_pk0 ON ks1.tbl(pk0) USING
'StorageAttachedIndex';
CREATE CUSTOM INDEX tbl_pk1 ON ks1.tbl(pk1) USING
'StorageAttachedIndex';
CREATE CUSTOM INDEX tbl_ck0 ON ks1.tbl(ck0) USING
'StorageAttachedIndex';
CREATE CUSTOM INDEX tbl_ck1 ON ks1.tbl(ck1) USING
'StorageAttachedIndex';
CREATE INDEX tbl_s0 ON ks1.tbl(FULL(s0)) USING 'SAI';
CREATE INDEX tbl_s1 ON ks1.tbl(s1) USING 'SAI';
CREATE INDEX tbl_v0 ON ks1.tbl(v0) USING 'SAI';
CREATE INDEX tbl_v1 ON ks1.tbl(FULL(v1)) USING 'SAI';
CREATE CUSTOM INDEX tbl_v3 ON ks1.tbl(v3) USING
'StorageAttachedIndex';
CREATE CUSTOM INDEX tbl_v4 ON ks1.tbl(v4) USING
'StorageAttachedIndex';:
org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.State
History:
1: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v3, v0, v2)
VALUES (-3861597867664806948, '174.128.216.143', '2034-03-09T18:20:56.930Z',
3.11811162E18, {{'J\u0016N`', 'X\u0016\u0003(X', '\u007F\u00098"1'}:
{00000000-0000-4200-9000-000000000000: 0xdef26622793c0919cc,
00000000-0000-4600-b600-000000000000: 0x5e54aa59f03063,
00000000-0000-4f00-9100-000000000000: 0x5ef6841d7f7e9fbe962c}}, ({false:
'\u000E![\u0016&=\u0006\u0001', true: '0M9\u0019\u001E\u0013'}, (0x9fe25c5e),
0x0000000000001a00bb00000000000000), '\u000A mf' + 'm/^G\u000CkEW7', 0x6c39)
USING TIMESTAMP 1 -- on node1
2: SELECT * FROM ks1.tbl WHERE ck0 > '2034-03-09T18:20:56.930Z'
LIMIT 89 -- ck0 timestamp (reversed), indexed with SAI, on node1, fetch size 10
3: DELETE FROM ks1.tbl USING TIMESTAMP 2 WHERE pk0 =
4531198082496131334 AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND
ck0 = '2026-12-02T10:50:38.028Z' AND ck1 = -491.0544 -- on node1
4: SELECT * FROM ks1.tbl WHERE v0 <= '\u000A mfm/^G\u000CkEW7'
LIMIT 57 ALLOW FILTERING -- v0 ascii, indexed with SAI, on node1, fetch size 10
5: SELECT * FROM ks1.tbl WHERE pk1 = '174.128.216.143' -- pk1
inet, indexed with SAI, on node1, fetch size 1000
6: UPDATE ks1.tbl USING TIMESTAMP 3 SET s0={{'''6qk\u00138gA'}:
{00000000-0000-4d00-bf00-000000000000: 0x627515a4d47d5a98}, {')Mb1S'}:
{00000000-0000-4000-9100-000000000000: 0x071317710ea3e5a403,
00000000-0000-4600-8400-000000000000: 0xe040e8908bf600}, {'2\u0015,c4\FFPZ',
':o"J^\u0010{'}: {00000000-0000-4500-9d00-000000000000: 0xb0c04c25f15721a658,
00000000-0000-4700-b200-000000000000: 0x2e58e3,
00000000-0000-4900-b200-000000000000: 0x20af911d}}, s1=false,
v0='\u0011\u001Etkk', v1={'㣤?匿': {-1879255062: '\u001F)<\u001C', 403598347:
'3=\u0012~]\u0008\u0003', 778810263: 'K'}}, v2=0x9393, v3=({false:
'\u0014%\u000CpC\u0008A\u0005', true:
'\u001AA\u001F0\u0008\u000E\u0010_\u0011'}, (0x7a64e54139),
0x0000000000001e009500000000000000), v4=false WHERE pk0 = 5666087756057021160
AND pk1 = 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' AND ck0 =
'1976-08-20T06:13:02.612Z' AND ck1 = 5.071078E30 * -6.1897097E37 -- on node1
7: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, s1, v0, v1, v2,
v3, v4) VALUES (-3861597867664806948, '174.128.216.143',
'2009-10-27T15:44:11.844Z', -6.483759E20, {{'6', 'a0'}:
{00000000-0000-4100-9400-000000000000: 0xee27,
00000000-0000-4900-a000-000000000000: 0xe00a2e,
00000000-0000-4a00-9c00-000000000000: 0xe5abb48aaaa6}, {'@T;egM+'}:
{00000000-0000-4500-b900-000000000000: 0xe9,
00000000-0000-4d00-bb00-000000000000: 0xc1be0fe3d69a373d8391}}, false,
'NA4\u0010K\u001B\u0016xv8', {'跠윇ꑃ郧驄': {-2091004447: '80\u0003,2u', -976706600:
'\u000F'}}, 0x5def, ({false: '/', true: '\u0012A\u001F\u0006j'}, (0x46b0779d),
0x0000000000001700ba00000000000000), true) USING TIMESTAMP 4 -- on node1
8: SELECT * FROM ks1.tbl WHERE pk0 = -3861597867664806948 AND
pk1 = '174.128.216.143' AND v1 < {'跠윇ꑃ郧驄': {-2091004447: '80\u0003,2u',
-976706600: '\u000F'}} LIMIT 84 ALLOW FILTERING -- v1 frozen<map<text,
frozen<map<int, ascii>>>>, indexed with SAI, on node1, fetch size 10
9: SELECT * FROM ks1.tbl WHERE pk0 = -3861597867664806948 AND
pk1 = '174.128.216.143' AND s1 = false LIMIT 540 ALLOW FILTERING -- s1 boolean,
indexed with SAI, on node1, fetch size 1
10: SELECT * FROM ks1.tbl WHERE s0 > {{'6', 'a0'}:
{00000000-0000-4100-9400-000000000000: 0xee27,
00000000-0000-4900-a000-000000000000: 0xe00a2e,
00000000-0000-4a00-9c00-000000000000: 0xe5abb48aaaa6}, {'@T;egM+'}:
{00000000-0000-4500-b900-000000000000: 0xe9,
00000000-0000-4d00-bb00-000000000000: 0xc1be0fe3d69a373d8391}} LIMIT 339 ALLOW
FILTERING -- s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>>,
indexed with SAI, on node1, fetch size 5000
11: nodetool flush ks1 tbl
12: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 154
-- by token, on node1, fetch size 1000
13: UPDATE ks1.tbl USING TIMESTAMP 5 SET v0='$Evy', v3=({false:
'\u0006\u000Cp.V?\u0005', true: '\u000B\u001A'}, (0x6d53eb),
0x00000000000042009500000000000000) WHERE pk0 = -7092676947467875356 AND pk1
= '37de:45bf:1239:7766:cbe2:e333:efab:d3c6' AND ck0 =
'2035-06-13T19:57:35.817Z' AND ck1 = 6.837532E28 -- on node1
14: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 354 -- by token, on node1,
fetch size 10
15: SELECT * FROM ks1.tbl WHERE s0 < {{'''6qk\u00138gA'}:
{00000000-0000-4d00-bf00-000000000000: 0x627515a4d47d5a98}, {')Mb1S'}:
{00000000-0000-4000-9100-000000000000: 0x071317710ea3e5a403,
00000000-0000-4600-8400-000000000000: 0xe040e8908bf600}, {'2\u0015,c4\FFPZ',
':o"J^\u0010{'}: {00000000-0000-4500-9d00-000000000000: 0xb0c04c25f15721a658,
00000000-0000-4700-b200-000000000000: 0x2e58e3,
00000000-0000-4900-b200-000000000000: 0x20af911d}} LIMIT 645 ALLOW FILTERING --
s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>>, indexed with SAI,
on node1, fetch size 1
16: SELECT * FROM ks1.tbl WHERE s0 = {{'6', 'a0'}:
{00000000-0000-4100-9400-000000000000: 0xee27,
00000000-0000-4900-a000-000000000000: 0xe00a2e,
00000000-0000-4a00-9c00-000000000000: 0xe5abb48aaaa6}, {'@T;egM+'}:
{00000000-0000-4500-b900-000000000000: 0xe9,
00000000-0000-4d00-bb00-000000000000: 0xc1be0fe3d69a373d8391}} ALLOW FILTERING
-- s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>>, indexed with
SAI, on node1, fetch size 10
17: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') -- by
token, on node1
18: SELECT * FROM ks1.tbl WHERE pk0 = -3861597867664806948 AND
pk1 = '174.128.216.143' AND v2 = 0x5def LIMIT 143 ALLOW FILTERING -- v2 blob,
on node1, fetch size 100
19: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 169 -- by token, on node1,
fetch size 10
20: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 78
-- by token, on node1, fetch size 1000
21: SELECT * FROM ks1.tbl WHERE v4 = true AND s0 = {{'6',
'a0'}: {00000000-0000-4100-9400-000000000000: 0xee27,
00000000-0000-4900-a000-000000000000: 0xe00a2e,
00000000-0000-4a00-9c00-000000000000: 0xe5abb48aaaa6}, {'@T;egM+'}:
{00000000-0000-4500-b900-000000000000: 0xe9,
00000000-0000-4d00-bb00-000000000000: 0xc1be0fe3d69a373d8391}} AND ck0 =
'2035-06-13T19:57:35.817Z' AND s1 = false AND pk1 =
'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' AND v1 = {'㣤?匿': {-1879255062:
'\u001F)<\u001C', 403598347: '3=\u0012~]\u0008\u0003', 778810263: 'K'}} LIMIT
169 ALLOW FILTERING -- v4 boolean (indexed with SAI), s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI),
ck0 timestamp (reversed) (indexed with SAI), s1 boolean (indexed with SAI), pk1
inet (indexed with SAI), v1 frozen<map<text, frozen<map<int, ascii>>>> (indexed
with SAI), on node1, fetch size 1000
22: SELECT * FROM ks1.tbl WHERE s0 > {{'''6qk\u00138gA'}:
{00000000-0000-4d00-bf00-000000000000: 0x627515a4d47d5a98}, {')Mb1S'}:
{00000000-0000-4000-9100-000000000000: 0x071317710ea3e5a403,
00000000-0000-4600-8400-000000000000: 0xe040e8908bf600}, {'2\u0015,c4\FFPZ',
':o"J^\u0010{'}: {00000000-0000-4500-9d00-000000000000: 0xb0c04c25f15721a658,
00000000-0000-4700-b200-000000000000: 0x2e58e3,
00000000-0000-4900-b200-000000000000: 0x20af911d}} LIMIT 125 ALLOW FILTERING --
s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>>, indexed with SAI,
on node1, fetch size 1000
23: SELECT * FROM ks1.tbl WHERE s1 < false ALLOW FILTERING --
s1 boolean, indexed with SAI, on node1
24: SELECT * FROM ks1.tbl WHERE s0 = {{'6', 'a0'}:
{00000000-0000-4100-9400-000000000000: 0xee27,
00000000-0000-4900-a000-000000000000: 0xe00a2e,
00000000-0000-4a00-9c00-000000000000: 0xe5abb48aaaa6}, {'@T;egM+'}:
{00000000-0000-4500-b900-000000000000: 0xe9,
00000000-0000-4d00-bb00-000000000000: 0xc1be0fe3d69a373d8391}} AND v2 = 0x9393
AND v0 = '\u0011\u001Etkk' AND s1 = false AND v4 = false AND v3 = ({false: '/',
true: '\u0012A\u001F\u0006j'}, (0x46b0779d),
0x0000000000001700ba00000000000000) AND ck1 = 3.11811162E18 AND pk0 =
-3861597867664806948 ALLOW FILTERING -- s0 frozen<map<frozen<set<ascii>>,
frozen<map<uuid, blob>>>> (indexed with SAI), v2 blob, v0 ascii (indexed with
SAI), s1 boolean (indexed with SAI), v4 boolean (indexed with SAI), v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>> (indexed with SAI), ck1
float (indexed with SAI), pk0 bigint (indexed with SAI), on node1, fetch size
5000
25: DELETE v3, v0, v1, s0, s1, s0 FROM ks1.tbl USING TIMESTAMP
6 WHERE pk0 = 4531198082496131334 AND pk1 =
'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 = '1978-07-02T19:37:47.939Z'
AND ck1 = 5.012437E10 -- on node1
26: SELECT * FROM ks1.tbl WHERE v4 = false AND v2 = 0x9393 AND
ck1 = -Infinity AND pk1 = '37de:45bf:1239:7766:cbe2:e333:efab:d3c6' AND v0 =
'$Evy' ALLOW FILTERING -- v4 boolean (indexed with SAI), v2 blob, ck1 float
(indexed with SAI), pk1 inet (indexed with SAI), v0 ascii (indexed with SAI),
on node1, fetch size 10
27: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') LIMIT
329 -- by token, on node1
28: SELECT * FROM ks1.tbl WHERE v1 <= {'跠윇ꑃ郧驄': {-2091004447:
'80\u0003,2u', -976706600: '\u000F'}} LIMIT 171 ALLOW FILTERING -- v1
frozen<map<text, frozen<map<int, ascii>>>>, indexed with SAI, on node1, fetch
size 100
29: SELECT * FROM ks1.tbl WHERE v1 > {'㣤?匿': {-1879255062:
'\u001F)<\u001C', 403598347: '3=\u0012~]\u0008\u0003', 778810263: 'K'}} LIMIT
53 ALLOW FILTERING -- v1 frozen<map<text, frozen<map<int, ascii>>>>, indexed
with SAI, on node1
30: SELECT * FROM ks1.tbl WHERE v2 = 0x5def LIMIT 674 ALLOW
FILTERING -- v2 blob, on node1, fetch size 100
31: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 21
-- by token, on node1, fetch size 1000
32: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 258
-- by token, on node1, fetch size 5000
33: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 4 --
by token, on node1, fetch size 1
34: SELECT * FROM ks1.tbl WHERE pk0 = 5666087756057021160 --
pk0 bigint, indexed with SAI, on node1, fetch size 10
35: DELETE s0, s1 FROM ks1.tbl USING TIMESTAMP 7 WHERE pk0 =
-7092676947467875356 AND pk1 = '37de:45bf:1239:7766:cbe2:e333:efab:d3c6' -- on
node1
36: SELECT * FROM ks1.tbl WHERE v4 = true AND s1 = false AND
ck1 = -6.483759E20 AND pk0 = -7092676947467875356 AND v0 =
'NA4\u0010K\u001B\u0016xv8' ALLOW FILTERING -- v4 boolean (indexed with SAI),
s1 boolean (indexed with SAI), ck1 float (indexed with SAI), pk0 bigint
(indexed with SAI), v0 ascii (indexed with SAI), on node1, fetch size 100
37: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') -- by
token, on node1, fetch size 1
38: SELECT * FROM ks1.tbl LIMIT 18 -- full table scan, on
node1, fetch size 10
39: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 7 --
by token, on node1, fetch size 100
40: SELECT * FROM ks1.tbl WHERE pk0 = -7092676947467875356 AND
pk1 = '37de:45bf:1239:7766:cbe2:e333:efab:d3c6' LIMIT 915 -- By Partition Key,
on node1, fetch size 1
41: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 58
-- by token, on node1, fetch size 5000
42: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') LIMIT
761 -- by token, on node1, fetch size 1000
43: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') -- by
token, on node1, fetch size 100
44: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') -- by
token, on node1, fetch size 100
45: SELECT * FROM ks1.tbl WHERE pk0 = -7092676947467875356 AND
pk1 = '174.128.216.143' AND v1 = {'㣤?匿': {-1879255062: '\u001F)<\u001C',
403598347: '3=\u0012~]\u0008\u0003', 778810263: 'K'}} AND s0 =
{{'''6qk\u00138gA'}: {00000000-0000-4d00-bf00-000000000000:
0x627515a4d47d5a98}, {')Mb1S'}: {00000000-0000-4000-9100-000000000000:
0x071317710ea3e5a403, 00000000-0000-4600-8400-000000000000: 0xe040e8908bf600},
{'2\u0015,c4\FFPZ', ':o"J^\u0010{'}: {00000000-0000-4500-9d00-000000000000:
0xb0c04c25f15721a658, 00000000-0000-4700-b200-000000000000: 0x2e58e3,
00000000-0000-4900-b200-000000000000: 0x20af911d}} AND s1 = false AND v2 =
0x9393 AND ck1 = -6.483759E20 AND v0 = '$Evy' AND v4 = true AND v3 = ({false:
'/', true: '\u0012A\u001F\u0006j'}, (0x46b0779d),
0x0000000000001700ba00000000000000) LIMIT 127 ALLOW FILTERING -- pk0 bigint
(indexed with SAI), pk1 inet (indexed with SAI), v1 frozen<map<text,
frozen<map<int, ascii>>>> (indexed with SAI), s0 frozen<map<frozen<set<ascii>>,
frozen<map<uuid, blob>>>> (indexed with SAI), s1 boolean (indexed with SAI), v2
blob, ck1 float (indexed with SAI), v0 ascii (indexed with SAI), v4 boolean
(indexed with SAI), v3 frozen<tuple<frozen<map<boolean, ascii>>,
frozen<tuple<blob>>, 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>
(indexed with SAI), on node1, fetch size 5000
46: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') -- by
token, on node1, fetch size 5000
47: SELECT * FROM ks1.tbl WHERE pk0 = -7092676947467875356 AND
pk1 = '37de:45bf:1239:7766:cbe2:e333:efab:d3c6' LIMIT 335 -- By Partition Key,
on node1, fetch size 10
48: SELECT * FROM ks1.tbl WHERE v2 = 0x9393 AND ck0 =
'2035-06-13T19:57:35.817Z' AND s0 = {{'''6qk\u00138gA'}:
{00000000-0000-4d00-bf00-000000000000: 0x627515a4d47d5a98}, {')Mb1S'}:
{00000000-0000-4000-9100-000000000000: 0x071317710ea3e5a403,
00000000-0000-4600-8400-000000000000: 0xe040e8908bf600}, {'2\u0015,c4\FFPZ',
':o"J^\u0010{'}: {00000000-0000-4500-9d00-000000000000: 0xb0c04c25f15721a658,
00000000-0000-4700-b200-000000000000: 0x2e58e3,
00000000-0000-4900-b200-000000000000: 0x20af911d}} LIMIT 327 ALLOW FILTERING --
v2 blob, ck0 timestamp (reversed) (indexed with SAI), s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI), on
node1, fetch size 5000
49: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') LIMIT
525 -- by token, on node1, fetch size 5000
50: SELECT * FROM ks1.tbl WHERE v4 = false AND s0 = {{'6',
'a0'}: {00000000-0000-4100-9400-000000000000: 0xee27,
00000000-0000-4900-a000-000000000000: 0xe00a2e,
00000000-0000-4a00-9c00-000000000000: 0xe5abb48aaaa6}, {'@T;egM+'}:
{00000000-0000-4500-b900-000000000000: 0xe9,
00000000-0000-4d00-bb00-000000000000: 0xc1be0fe3d69a373d8391}} AND pk1 =
'174.128.216.143' AND ck0 = '2034-03-09T18:20:56.930Z' AND v1 = {'跠윇ꑃ郧驄':
{-2091004447: '80\u0003,2u', -976706600: '\u000F'}} LIMIT 36 ALLOW FILTERING --
v4 boolean (indexed with SAI), s0 frozen<map<frozen<set<ascii>>,
frozen<map<uuid, blob>>>> (indexed with SAI), pk1 inet (indexed with SAI), ck0
timestamp (reversed) (indexed with SAI), v1 frozen<map<text, frozen<map<int,
ascii>>>> (indexed with SAI), on node1, fetch size 5000
51: UPDATE ks1.tbl USING TIMESTAMP 8 SET s0={{'\u001B\u001BZ\',
'=X\u0017O||\u000Cb,', 'gG\u0013y2'}: {00000000-0000-4500-a100-000000000000:
0xaa75, 00000000-0000-4a00-ac00-000000000000: 0x4cbb697395a05f16bd},
{'o@\u0006*'}: {00000000-0000-4300-b300-000000000000: 0xb73b,
00000000-0000-4400-a400-000000000000: 0x08cde3f39f5f7852,
00000000-0000-4900-9f00-000000000000: 0xafa2045ee1a197833b}}, s1=null,
v0='A\u0005hNRgPh', v1={'ጎ᥋驙': {-49362600: '7', 1418016338: '\u0007\u0008RX'}},
v2=0x90a381e009, v3=({false: '\u001E'}, (0xc5389fb0006d2ac6f0),
0x0000000000004c008500000000000000), v4=true WHERE pk0 = 5666087756057021160
AND pk1 = 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' AND ck0 =
'2041-06-21T07:34:27.143Z' AND ck1 = -1.5230537E-24 -- on node1
52: SELECT * FROM ks1.tbl WHERE pk1 = '174.128.216.143' LIMIT
402 -- pk1 inet, indexed with SAI, on node1, fetch size 100
53: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 408
-- by token, on node1, fetch size 5000
54: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 673
-- by token, on node1
55: nodetool flush ks1 tbl
56: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') -- by token, on node1, fetch
size 1000
57: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') AND
token(pk0, pk1) <= token(-7092676947467875356,
'37de:45bf:1239:7766:cbe2:e333:efab:d3c6') LIMIT 242 -- by token range, on
node1, fetch size 10
58: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s1) VALUES
(1268506666581209403, '132.255.72.44', '2004-02-12T15:52:46.675Z',
-1.0642519E-6, true) USING TIMESTAMP 9 -- on node1
59: SELECT * FROM ks1.tbl LIMIT 769 -- full table scan, on
node1, fetch size 10
60: SELECT * FROM ks1.tbl WHERE pk0 = 1268506666581209403 AND
pk1 = '132.255.72.44' AND s1 = true LIMIT 42 ALLOW FILTERING -- s1 boolean,
indexed with SAI, on node1, fetch size 10
61: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(1268506666581209403, '132.255.72.44') LIMIT 649 -- by token, on node1
62: DELETE s1 FROM ks1.tbl USING TIMESTAMP 10 WHERE pk0 =
133647749441392509 AND pk1 = '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' -- on
node1
63: SELECT * FROM ks1.tbl WHERE v0 < '\u0011\u001Etkk' LIMIT
519 ALLOW FILTERING -- v0 ascii, indexed with SAI, on node1, fetch size 1
64: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') AND
token(pk0, pk1) < token(-7092676947467875356,
'37de:45bf:1239:7766:cbe2:e333:efab:d3c6') -- by token range, on node1, fetch
size 5000
65: SELECT * FROM ks1.tbl WHERE pk0 = 1268506666581209403 AND
pk1 = '132.255.72.44' AND ck0 = '2004-02-12T15:52:46.675Z' AND ck1 =
-1.0642519E-6 LIMIT 37 -- By Primary Key, on node1, fetch size 1000
66: DELETE FROM ks1.tbl USING TIMESTAMP 11 WHERE pk0 =
-3861597867664806948 AND pk1 = '174.128.216.143' AND ck0 =
'2023-12-15T02:24:07.854Z' AND ck1 = -3.1851898E-25 + -1.2113419E-17 -- on
node1
67: SELECT * FROM ks1.tbl WHERE pk0 = 5666087756057021160 LIMIT
79 -- pk0 bigint, indexed with SAI, on node1, fetch size 100
68: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 371
-- by token, on node1, fetch size 10
69: SELECT * FROM ks1.tbl WHERE pk0 = 1268506666581209403 AND
v4 = true AND s1 = false AND pk1 = '174.128.216.143' AND v3 = ({false: '/',
true: '\u0012A\u001F\u0006j'}, (0x46b0779d),
0x0000000000001700ba00000000000000) AND v1 = {'ጎ᥋驙': {-49362600: '7',
1418016338: '\u0007\u0008RX'}} AND ck1 = -1.5230537E-24 AND v2 = 0x6c39 AND v0
= '\u000A mfm/^G\u000CkEW7' AND s0 = {{'6', 'a0'}:
{00000000-0000-4100-9400-000000000000: 0xee27,
00000000-0000-4900-a000-000000000000: 0xe00a2e,
00000000-0000-4a00-9c00-000000000000: 0xe5abb48aaaa6}, {'@T;egM+'}:
{00000000-0000-4500-b900-000000000000: 0xe9,
00000000-0000-4d00-bb00-000000000000: 0xc1be0fe3d69a373d8391}} AND ck0 =
'1976-08-20T06:13:02.612Z' LIMIT 39 ALLOW FILTERING -- pk0 bigint (indexed with
SAI), v4 boolean (indexed with SAI), s1 boolean (indexed with SAI), pk1 inet
(indexed with SAI), v3 frozen<tuple<frozen<map<boolean, ascii>>,
frozen<tuple<blob>>, 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>
(indexed with SAI), v1 frozen<map<text, frozen<map<int, ascii>>>> (indexed with
SAI), ck1 float (indexed with SAI), v2 blob, v0 ascii (indexed with SAI), s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI),
ck0 timestamp (reversed) (indexed with SAI), on node1, fetch size 1000
70: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 481 -- by token, on node1,
fetch size 1000
71: SELECT * FROM ks1.tbl LIMIT 127 -- full table scan, on
node1, fetch size 100
72: UPDATE ks1.tbl USING TIMESTAMP 12 SET
s0={{'\u0006l\u0011\u000D@U', '\u000Bu\u0011', '\u0015\u000EL3(Cn'}:
{00000000-0000-4900-9f00-000000000000: 0x2148e60eccc920e2,
00000000-0000-4e00-8b00-000000000000: 0xa1a7,
00000000-0000-4f00-bf00-000000000000: 0x6bdc73},
{'\u001EI4\u001E03N\u0007\u0010&', 'UKb\u0006', 'o\u001Dmnx\u001Fk'}:
{00000000-0000-4200-aa00-000000000000: 0x4d,
00000000-0000-4600-9600-000000000000: 0x32982c1d,
00000000-0000-4e00-9e00-000000000000: 0xd95149fc}}, s1=true, v0=null,
v1={'旰퐀늒㧩鮩鉓澴巏聽丰': {-1708634768: '^\u001AV\u0002', 782702699:
'\u0016\u001F"*$\u000E?_Y', 1643123268: '\u000D'}}, v2=0x2e65a8d5f0d8a2,
v3=({false: 'H4\u000E*', true: '\u001E@_}I9\u0018\u0011'}, (0x84718214),
0x0000000000004d009600000000000000), v4=true WHERE pk0 = 5778883423090972680
AND pk1 = '133.53.176.75' AND ck0 = '1978-06-20T12:37:22.513Z' AND ck1 =
-6.261731E13 + 1.12096546E15 -- on node1
73: SELECT * FROM ks1.tbl WHERE v1 = {'跠윇ꑃ郧驄': {-2091004447:
'80\u0003,2u', -976706600: '\u000F'}} AND pk0 = 5666087756057021160 LIMIT 689
ALLOW FILTERING -- v1 frozen<map<text, frozen<map<int, ascii>>>> (indexed with
SAI), pk0 bigint (indexed with SAI), on node1
74: SELECT * FROM ks1.tbl WHERE pk0 = 5778883423090972680 AND
pk1 = '133.53.176.75' AND s1 <= true LIMIT 80 ALLOW FILTERING -- s1 boolean,
indexed with SAI, on node1, fetch size 1000
75: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 277 -- by token, on node1,
fetch size 1
76: SELECT * FROM ks1.tbl WHERE pk0 = 5778883423090972680 LIMIT
428 -- pk0 bigint, indexed with SAI, on node1
77: DELETE v4, v0, v1, s1 FROM ks1.tbl USING TIMESTAMP 13 WHERE
pk0 = 4531198082496131334 AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220'
AND ck0 = '2003-01-14T15:28:19.835Z' AND ck1 = 1.8630459E-25 * 6.83225E-39 --
on node1
78: DELETE FROM ks1.tbl USING TIMESTAMP 14 WHERE pk0 =
4531198082496131334 AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND
ck0 = '2061-12-06T09:45:40.802Z' AND ck1 = -1.2671885E25 -- on node1
79: SELECT * FROM ks1.tbl WHERE ck1 = -1.0642519E-6 AND v0 =
'\u0011\u001Etkk' AND v1 = {'㣤?匿': {-1879255062: '\u001F)<\u001C', 403598347:
'3=\u0012~]\u0008\u0003', 778810263: 'K'}} AND v4 = true AND pk0 =
1268506666581209403 LIMIT 379 ALLOW FILTERING -- ck1 float (indexed with SAI),
v0 ascii (indexed with SAI), v1 frozen<map<text, frozen<map<int, ascii>>>>
(indexed with SAI), v4 boolean (indexed with SAI), pk0 bigint (indexed with
SAI), on node1, fetch size 10
80: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') -- by
token, on node1, fetch size 10
81: SELECT * FROM ks1.tbl WHERE v1 = {'跠윇ꑃ郧驄': {-2091004447:
'80\u0003,2u', -976706600: '\u000F'}} AND pk0 = -3861597867664806948 AND v2 =
0x2e65a8d5f0d8a2 AND pk1 = '132.255.72.44' AND v4 = true AND ck1 = -6.483759E20
AND v0 = 'NA4\u0010K\u001B\u0016xv8' AND s0 = {{'6', 'a0'}:
{00000000-0000-4100-9400-000000000000: 0xee27,
00000000-0000-4900-a000-000000000000: 0xe00a2e,
00000000-0000-4a00-9c00-000000000000: 0xe5abb48aaaa6}, {'@T;egM+'}:
{00000000-0000-4500-b900-000000000000: 0xe9,
00000000-0000-4d00-bb00-000000000000: 0xc1be0fe3d69a373d8391}} AND ck0 =
'1978-06-20T12:37:22.513Z' AND s1 = false ALLOW FILTERING -- v1
frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI), pk0 bigint
(indexed with SAI), v2 blob, pk1 inet (indexed with SAI), v4 boolean (indexed
with SAI), ck1 float (indexed with SAI), v0 ascii (indexed with SAI), s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI),
ck0 timestamp (reversed) (indexed with SAI), s1 boolean (indexed with SAI), on
node1
82: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(1268506666581209403, '132.255.72.44') -- by token, on node1, fetch size
1000
83: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(1268506666581209403, '132.255.72.44') LIMIT 172 -- by token, on node1,
fetch size 10
84: SELECT * FROM ks1.tbl WHERE v4 < false LIMIT 93 ALLOW
FILTERING -- v4 boolean, indexed with SAI, on node1, fetch size 1000
85: SELECT * FROM ks1.tbl WHERE pk1 =
'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' LIMIT 780 -- pk1 inet, indexed with
SAI, on node1
86: SELECT * FROM ks1.tbl WHERE v4 >= false ALLOW FILTERING --
v4 boolean, indexed with SAI, on node1, fetch size 100
87: nodetool flush ks1 tbl
88: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') LIMIT
404 -- by token, on node1, fetch size 10
89: UPDATE ks1.tbl USING TIMESTAMP 15 SET s0={{'\u001B.4'}:
{00000000-0000-4200-bc00-000000000000: 0xe922,
00000000-0000-4700-b100-000000000000: 0x9030976526d6deee5eff,
00000000-0000-4800-a800-000000000000: 0x9f8070c1c31599}, {'3y,', 't'}:
{00000000-0000-4500-a000-000000000000: 0x1cf70816,
00000000-0000-4600-9000-000000000000: 0x1b7d383d8473d6bb,
00000000-0000-4900-8b00-000000000000: 0x16083fc03d}, {'\G&U'}:
{00000000-0000-4100-9400-000000000000: 0x4a7dd0259070e883,
00000000-0000-4100-ad00-000000000000: 0xc3,
00000000-0000-4400-a700-000000000000: 0xfa4ba2}}, s1=true,
v0='i\u0001Z.3\u0019\u001C1\u001Ew' + '\u0015*w', v1={'İ헩퍚쫚ﱫꬑᅪ': {292265786:
'IpSN'}, 'ᆺ': {-2051805860: ',SJV\u001B'}}, v2=null, v3=({false: '9u', true:
'g+4+z)\u000C'}, (0x6e906eb80a), 0x00000000000048009200000000000000), v4=false
WHERE pk0 = 1268506666581209403 AND pk1 = '132.255.72.44' AND ck0 =
'2009-02-14T22:31:37.274Z' AND ck1 = 7.660905E14 -- on node1
90: DELETE FROM ks1.tbl USING TIMESTAMP 16 WHERE pk0 =
4531198082496131334 AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' -- on
node1
91: SELECT * FROM ks1.tbl WHERE v0 = '\u0011\u001Etkk' LIMIT
175 ALLOW FILTERING -- v0 ascii, indexed with SAI, on node1
92: SELECT * FROM ks1.tbl WHERE pk1 = '133.53.176.75' AND s0 =
{{'\u001B\u001BZ\', '=X\u0017O||\u000Cb,', 'gG\u0013y2'}:
{00000000-0000-4500-a100-000000000000: 0xaa75,
00000000-0000-4a00-ac00-000000000000: 0x4cbb697395a05f16bd}, {'o@\u0006*'}:
{00000000-0000-4300-b300-000000000000: 0xb73b,
00000000-0000-4400-a400-000000000000: 0x08cde3f39f5f7852,
00000000-0000-4900-9f00-000000000000: 0xafa2045ee1a197833b}} AND pk0 =
5666087756057021160 AND v0 = '\u000A mfm/^G\u000CkEW7' AND v1 = {'旰퐀늒㧩鮩鉓澴巏聽丰':
{-1708634768: '^\u001AV\u0002', 782702699: '\u0016\u001F"*$\u000E?_Y',
1643123268: '\u000D'}} AND ck0 = '1976-08-20T06:13:02.612Z' AND ck1 =
6.837532E28 AND v3 = ({false: '9u', true: 'g+4+z)\u000C'}, (0x6e906eb80a),
0x00000000000048009200000000000000) AND v4 = true AND s1 = false ALLOW
FILTERING -- pk1 inet (indexed with SAI), s0 frozen<map<frozen<set<ascii>>,
frozen<map<uuid, blob>>>> (indexed with SAI), pk0 bigint (indexed with SAI), v0
ascii (indexed with SAI), v1 frozen<map<text, frozen<map<int, ascii>>>>
(indexed with SAI), ck0 timestamp (reversed) (indexed with SAI), ck1 float
(indexed with SAI), v3 frozen<tuple<frozen<map<boolean, ascii>>,
frozen<tuple<blob>>, 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>
(indexed with SAI), v4 boolean (indexed with SAI), s1 boolean (indexed with
SAI), on node1, fetch size 10
93: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v4, s1, v3, v2)
VALUES (4531198082496131334, 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220',
'2033-05-10T20:01:39.737Z', 1238155.6 * -9.5942846E-17, false, false, ({false:
'>zS\u0014\u0010', true: '7\u001E\u0015\u0002|Z'}, (0xe8fafdf0d4ad0b28),
0x0000000000001e00a200000000000000), 0xac) USING TIMESTAMP 17 -- on node1
94: UPDATE ks1.tbl USING TIMESTAMP 18 SET v4=null, v3=({true:
'%3<^'}, (0xa9dc666b96), 0x0000000000004500ba00000000000000), v0='kLe)',
v1={'?ߥ鏌짐巠': {-1743013482: 'NK`!8\u00016\u000F', -1484993536: 'F\u0017B',
-659672689: 'ubv'}, '\u008Eቶ厗튼药丨猹譆嵺': {-2007678581: 'i\u0009ZqnH\u000F2',
-1973054692: ']\u0000M', 2071507780: '3]h%T\u0015\u0017&\u0001 '}}, v2=0x WHERE
pk0 = 4531198082496131334 AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220'
AND ck0 = '1972-10-01T13:42:14.783Z' AND ck1 = -3.2628846E7 -- on node1
95: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') -- by
token, on node1, fetch size 100
96: SELECT * FROM ks1.tbl WHERE v0 =
'NA4\u0010K\u001B\u0016xv8' ALLOW FILTERING -- v0 ascii, indexed with SAI, on
node1, fetch size 1000
97: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') -- by token, on node1, fetch
size 10
98: nodetool flush ks1 tbl
99: DELETE FROM ks1.tbl USING TIMESTAMP 19 WHERE pk0 =
1268506666581209403 AND pk1 = '132.255.72.44' -- on node1
100: SELECT * FROM ks1.tbl WHERE pk0 = 5666087756057021160 AND
pk1 = 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' LIMIT 804 -- By Partition Key,
on node1, fetch size 1
101: SELECT * FROM ks1.tbl WHERE v3 = ({false:
'\u0006\u000Cp.V?\u0005', true: '\u000B\u001A'}, (0x6d53eb),
0x00000000000042009500000000000000) AND v0 = '\u0011\u001Etkk' AND pk0 =
-3861597867664806948 AND s0 = {{'\u001B\u001BZ\', '=X\u0017O||\u000Cb,',
'gG\u0013y2'}: {00000000-0000-4500-a100-000000000000: 0xaa75,
00000000-0000-4a00-ac00-000000000000: 0x4cbb697395a05f16bd}, {'o@\u0006*'}:
{00000000-0000-4300-b300-000000000000: 0xb73b,
00000000-0000-4400-a400-000000000000: 0x08cde3f39f5f7852,
00000000-0000-4900-9f00-000000000000: 0xafa2045ee1a197833b}} AND ck0 =
'1976-08-20T06:13:02.612Z' AND v4 = true AND v1 = {'跠윇ꑃ郧驄': {-2091004447:
'80\u0003,2u', -976706600: '\u000F'}} AND s1 = true ALLOW FILTERING -- v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>> (indexed with SAI), v0
ascii (indexed with SAI), pk0 bigint (indexed with SAI), s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI),
ck0 timestamp (reversed) (indexed with SAI), v4 boolean (indexed with SAI), v1
frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI), s1 boolean
(indexed with SAI), on node1, fetch size 10
102: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334
LIMIT 416 -- pk0 bigint, indexed with SAI, on node1, fetch size 1
103: SELECT * FROM ks1.tbl WHERE ck1 = -1.1879217E-10 LIMIT 254
-- ck1 float, indexed with SAI, on node1, fetch size 5000
104: SELECT * FROM ks1.tbl WHERE pk0 = 5778883423090972680 AND
pk1 = '133.53.176.75' AND s1 < true LIMIT 36 ALLOW FILTERING -- s1 boolean,
indexed with SAI, on node1, fetch size 1000
105: SELECT * FROM ks1.tbl WHERE v1 = {'跠윇ꑃ郧驄': {-2091004447:
'80\u0003,2u', -976706600: '\u000F'}} LIMIT 162 ALLOW FILTERING -- v1
frozen<map<text, frozen<map<int, ascii>>>>, indexed with SAI, on node1, fetch
size 1000
106: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 509
-- by token, on node1, fetch size 10
107: SELECT * FROM ks1.tbl WHERE v2 = 0x2e65a8d5f0d8a2 LIMIT
117 ALLOW FILTERING -- v2 blob, on node1, fetch size 1
108: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 634 -- by token, on node1,
fetch size 1000
109: SELECT * FROM ks1.tbl WHERE ck0 =
'2041-06-21T07:34:27.143Z' LIMIT 199 -- ck0 timestamp (reversed), indexed with
SAI, on node1, fetch size 1000
110: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(4531198082496131334, 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220') LIMIT 407
-- by token, on node1, fetch size 1
111: UPDATE ks1.tbl USING TIMESTAMP 20 SET s0={{'\u0002Ex',
'\u0016v,GS+\u0009\u0002\u0000\u0004', 't8\u0015\]l'}:
{00000000-0000-4000-8a00-000000000000: 0x49b33549,
00000000-0000-4500-8400-000000000000: 0x83db41c35c,
00000000-0000-4500-bd00-000000000000: 0x4a68add06d8f0394}}, s1=null,
v0='\u001De[M90' + '\u0009"c@\u007F', v1=null, v2=0xa58471bc, v3=null, v4=true
WHERE pk0 = 4531198082496131334 AND pk1 =
'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 = '2064-04-27T14:15:45.444Z'
AND ck1 = -7.696585E27 -- on node1
112: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') LIMIT
287 -- by token, on node1, fetch size 10
113: SELECT * FROM ks1.tbl WHERE s1 = true ALLOW FILTERING --
s1 boolean, indexed with SAI, on node1, fetch size 100
114: SELECT * FROM ks1.tbl WHERE s1 = false LIMIT 555 ALLOW
FILTERING -- s1 boolean, indexed with SAI, on node1, fetch size 10
115: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 190
-- by token, on node1
116: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 =
'2064-04-27T14:15:45.444Z' AND ck1 = -7.696585E27 -- By Primary Key, on node1,
fetch size 100
117: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 108 -- by token, on node1,
fetch size 1
118: SELECT * FROM ks1.tbl WHERE s0 <
{{'\u0006l\u0011\u000D@U', '\u000Bu\u0011', '\u0015\u000EL3(Cn'}:
{00000000-0000-4900-9f00-000000000000: 0x2148e60eccc920e2,
00000000-0000-4e00-8b00-000000000000: 0xa1a7,
00000000-0000-4f00-bf00-000000000000: 0x6bdc73},
{'\u001EI4\u001E03N\u0007\u0010&', 'UKb\u0006', 'o\u001Dmnx\u001Fk'}:
{00000000-0000-4200-aa00-000000000000: 0x4d,
00000000-0000-4600-9600-000000000000: 0x32982c1d,
00000000-0000-4e00-9e00-000000000000: 0xd95149fc}} LIMIT 269 ALLOW FILTERING --
s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>>, indexed with SAI,
on node1, fetch size 1
119: SELECT * FROM ks1.tbl WHERE s1 >= false LIMIT 182 ALLOW
FILTERING -- s1 boolean, indexed with SAI, on node1
120: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 716 -- by token, on node1,
fetch size 1000
121: SELECT * FROM ks1.tbl LIMIT 558 -- full table scan, on
node1, fetch size 10
122: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 307
-- by token, on node1, fetch size 1
123: SELECT * FROM ks1.tbl WHERE v1 = {'跠윇ꑃ郧驄': {-2091004447:
'80\u0003,2u', -976706600: '\u000F'}} AND ck0 = '1978-06-20T12:37:22.513Z' AND
v2 = 0xac LIMIT 223 ALLOW FILTERING -- v1 frozen<map<text, frozen<map<int,
ascii>>>> (indexed with SAI), ck0 timestamp (reversed) (indexed with SAI), v2
blob, on node1, fetch size 1000
124: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(4531198082496131334, 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220') LIMIT 92
-- by token, on node1, fetch size 1
125: DELETE FROM ks1.tbl USING TIMESTAMP 21 WHERE pk0 =
4531198082496131334 AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND
ck0 = '2065-12-26T16:27:27.724Z' AND ck1 = 28.348366 + 5.236947E-14 -- on node1
126: UPDATE ks1.tbl USING TIMESTAMP 22 SET v3=({false: ','},
(0xa3502eea), 0x00000000000049008600000000000000), v4=false, v1={'忤':
{-1974487252: 'k', 9697318: 'G'}, '譬棏ࠫ禎ᗉ汮': {-847669374: 'n/YE\u0002[',
-494569534: '3'}, '鵩\u0018饲': {-586872166: 'd\u001A]0\u000B+''x[', 1103727538:
'G', 1348547291: '(k'}}, v2=0xcdf6 WHERE pk0 = 5778883423090972680 AND pk1 =
'133.53.176.75' AND ck0 = '2053-10-16T11:51:17.920Z' AND ck1 = 9.2208672E7 *
-2.8840122E33 -- on node1
127: SELECT * FROM ks1.tbl WHERE s1 = false ALLOW FILTERING --
s1 boolean, indexed with SAI, on node1, fetch size 1
128: SELECT * FROM ks1.tbl WHERE s1 = true LIMIT 605 ALLOW
FILTERING -- s1 boolean, indexed with SAI, on node1
129: SELECT * FROM ks1.tbl WHERE pk0 = 5666087756057021160 AND
pk1 = 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' LIMIT 55 -- By Partition Key, on
node1, fetch size 100
130: nodetool flush ks1 tbl
131: SELECT * FROM ks1.tbl WHERE v2 = 0xcdf6 LIMIT 469 ALLOW
FILTERING -- v2 blob, on node1, fetch size 100
132: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, s1, v0, v1,
v2, v3, v4) VALUES (4531198082496131334,
'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220', '2005-03-16T03:26:00.335Z',
5.8125115E-25 + -4.32925639E18, {{' D\u001E', 'K:)UQ ',
'b\\.>M:\u0007\u0010\u000A'}: {00000000-0000-4d00-ba00-000000000000: 0x8ce1b0},
{')8Ru,aBG', 'b|o\u000B', 'o/DD7'}: {00000000-0000-4c00-b000-000000000000:
0xa31f9cdf, 00000000-0000-4e00-9100-000000000000: 0x9811ce312e5351783d1a},
{'|^'}: {00000000-0000-4700-9a00-000000000000: 0x6d400be74dc5928467}}, true,
'q\u001Ak\u000D\u000EY-' + 'x', {'▗': {-1363764394: 'QC\u0016,^5"t]>',
-1069518714: 'C6QWc!', -890667829: '\u001F)\u0019'}}, 0x208595ff6237, ({true:
'og'}, (0x1ae39397e5b6d5), 0x0000000000004a009e00000000000000), false) USING
TIMESTAMP 23 -- on node1
133: SELECT * FROM ks1.tbl WHERE ck1 = 1.05834812E15 -- ck1
float, indexed with SAI, on node1, fetch size 5000
134: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5778883423090972680, '133.53.176.75') LIMIT 111 -- by token, on node1
135: UPDATE ks1.tbl USING TIMESTAMP 24 SET
v0='\u000Bn/g\u0007', s0={{'\u000D\u0010', '\ \u0000$*{3]\u0003t'}:
{00000000-0000-4300-8f00-000000000000: 0x85,
00000000-0000-4d00-9600-000000000000: 0x7fa5b219,
00000000-0000-4f00-a000-000000000000: 0x95915a225c}, {'V\u000DW;'}:
{00000000-0000-4400-af00-000000000000: 0xaafd475b104e2d2378,
00000000-0000-4900-a400-000000000000: 0x8e}}, s1=true WHERE pk0 =
4531198082496131334 AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND
ck0 = '2028-06-22T03:40:39.788Z' AND ck1 = -1.11391846E24 * 1.6543008E19 -- on
node1
136: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') -- by token, on node1
137: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 248 -- by token, on node1,
fetch size 5000
138: SELECT * FROM ks1.tbl WHERE ck0 =
'1972-10-01T13:42:14.783Z' AND v0 = '\u000A mfm/^G\u000CkEW7' AND s0 =
{{'\u001B\u001BZ\', '=X\u0017O||\u000Cb,', 'gG\u0013y2'}:
{00000000-0000-4500-a100-000000000000: 0xaa75,
00000000-0000-4a00-ac00-000000000000: 0x4cbb697395a05f16bd}, {'o@\u0006*'}:
{00000000-0000-4300-b300-000000000000: 0xb73b,
00000000-0000-4400-a400-000000000000: 0x08cde3f39f5f7852,
00000000-0000-4900-9f00-000000000000: 0xafa2045ee1a197833b}} AND pk0 =
-7092676947467875356 AND s1 = false LIMIT 60 ALLOW FILTERING -- ck0 timestamp
(reversed) (indexed with SAI), v0 ascii (indexed with SAI), s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI),
pk0 bigint (indexed with SAI), s1 boolean (indexed with SAI), on node1, fetch
size 1000
139: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s1, v2, s0)
VALUES (4531198082496131334, 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220',
'2029-11-22T07:25:47.281Z', -7.326477E24 * 3.3607407E-8, true, 0x5ece9a5c4c,
{{'\u0002PwQ\u001D-B', 'Nlp\u0011y^\u0007'}:
{00000000-0000-4700-9000-000000000000: 0x4288ee712c56aaca8b,
00000000-0000-4800-8f00-000000000000: 0x8681a4f3}, {'\u0004', ';Z\u0013~'}:
{00000000-0000-4400-bb00-000000000000: 0xb1}, {'\u001D%b\u0009f\u0008',
'AKQ}3&=', 'HRK\u0011'}: {00000000-0000-4400-bc00-000000000000:
0x3daf15237bd85fb0, 00000000-0000-4a00-b700-000000000000: 0x216323}}) USING
TIMESTAMP 25 -- on node1
140: UPDATE ks1.tbl USING TIMESTAMP 26 SET v4=true WHERE pk0 =
133647749441392509 AND pk1 = '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' AND
ck0 = '1995-01-24T00:52:42.129Z' AND ck1 = -0.05011857 + 3.6624246E31 -- on
node1
141: SELECT * FROM ks1.tbl WHERE pk0 = 5666087756057021160 AND
pk1 = 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' AND s0 <= {{'\u001B\u001BZ\',
'=X\u0017O||\u000Cb,', 'gG\u0013y2'}: {00000000-0000-4500-a100-000000000000:
0xaa75, 00000000-0000-4a00-ac00-000000000000: 0x4cbb697395a05f16bd},
{'o@\u0006*'}: {00000000-0000-4300-b300-000000000000: 0xb73b,
00000000-0000-4400-a400-000000000000: 0x08cde3f39f5f7852,
00000000-0000-4900-9f00-000000000000: 0xafa2045ee1a197833b}} ALLOW FILTERING --
s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>>, indexed with SAI,
on node1, fetch size 1000
142: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5778883423090972680, '133.53.176.75') -- by token, on node1, fetch size
1000
143: SELECT * FROM ks1.tbl WHERE s1 = false LIMIT 87 ALLOW
FILTERING -- s1 boolean, indexed with SAI, on node1, fetch size 1
144: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, s1, v0, v1,
v2, v3, v4) VALUES (4531198082496131334,
'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220', '2020-08-12T10:06:03.537Z',
1.0188728E19 + 2.5650294E-23, {{'\u0002`9d?+*4',
'{V\u0014|\u001Ac\u0017\u001A'''}: {00000000-0000-4500-8400-000000000000:
0xefd8b2, 00000000-0000-4600-8c00-000000000000: 0x888eb001740a}, {'+=\u0008',
'3F(y#E\u0006#\u007F~'}: {00000000-0000-4c00-a500-000000000000: 0x470a6e28}},
false, 'K43\u0010=];\u001B\u000E', {'ৣඖ䖑': {-1131019981: 'JwKl.X\\u000B'},
'ᣜዻ鯠䝒㹆?ꍰ': {151619062: 'WJH', 635182384: ','}, '㠵ᖽⓃ츂穼': {1906556991: 'w'}},
0xfab134fc44110bd3, ({false: '\u0009\u0009&J', true: 'PE\u0007m$&C'},
(0x5cf4087a775b45f19b), 0x0000000000004b00a100000000000000), true) USING
TIMESTAMP 27 -- on node1
145: SELECT * FROM ks1.tbl WHERE pk0 = -3861597867664806948
LIMIT 701 -- pk0 bigint, indexed with SAI, on node1, fetch size 1
146: nodetool flush ks1 tbl
147: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') AND
token(pk0, pk1) < token(5778883423090972680, '133.53.176.75') LIMIT 690 -- by
token range, on node1, fetch size 10
148: SELECT * FROM ks1.tbl WHERE s0 =
{{'\u0006l\u0011\u000D@U', '\u000Bu\u0011', '\u0015\u000EL3(Cn'}:
{00000000-0000-4900-9f00-000000000000: 0x2148e60eccc920e2,
00000000-0000-4e00-8b00-000000000000: 0xa1a7,
00000000-0000-4f00-bf00-000000000000: 0x6bdc73},
{'\u001EI4\u001E03N\u0007\u0010&', 'UKb\u0006', 'o\u001Dmnx\u001Fk'}:
{00000000-0000-4200-aa00-000000000000: 0x4d,
00000000-0000-4600-9600-000000000000: 0x32982c1d,
00000000-0000-4e00-9e00-000000000000: 0xd95149fc}} AND v2 = 0x90a381e009 AND
pk1 = '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' AND v0 = 'kLe)' AND s1 = false
AND v4 = false AND pk0 = 133647749441392509 AND v1 = {'ৣඖ䖑': {-1131019981:
'JwKl.X\\u000B'}, 'ᣜዻ鯠䝒㹆?ꍰ': {151619062: 'WJH', 635182384: ','}, '㠵ᖽⓃ츂穼':
{1906556991: 'w'}} AND v3 = ({false: '\u0006\u000Cp.V?\u0005', true:
'\u000B\u001A'}, (0x6d53eb), 0x00000000000042009500000000000000) LIMIT 74 ALLOW
FILTERING -- s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>>
(indexed with SAI), v2 blob, pk1 inet (indexed with SAI), v0 ascii (indexed
with SAI), s1 boolean (indexed with SAI), v4 boolean (indexed with SAI), pk0
bigint (indexed with SAI), v1 frozen<map<text, frozen<map<int, ascii>>>>
(indexed with SAI), v3 frozen<tuple<frozen<map<boolean, ascii>>,
frozen<tuple<blob>>, 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>
(indexed with SAI), on node1, fetch size 5000
149: SELECT * FROM ks1.tbl WHERE pk1 =
'2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' LIMIT 36 -- pk1 inet, indexed with
SAI, on node1, fetch size 5000
150: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') AND
token(pk0, pk1) < token(5778883423090972680, '133.53.176.75') LIMIT 933 -- by
token range, on node1, fetch size 100
151: SELECT * FROM ks1.tbl LIMIT 358 -- full table scan, on
node1, fetch size 100
152: SELECT * FROM ks1.tbl WHERE v4 < true ALLOW FILTERING --
v4 boolean, indexed with SAI, on node1, fetch size 5000
153: SELECT * FROM ks1.tbl WHERE v3 = ({false:
'>zS\u0014\u0010', true: '7\u001E\u0015\u0002|Z'}, (0xe8fafdf0d4ad0b28),
0x0000000000001e00a200000000000000) AND v1 = {'跠윇ꑃ郧驄': {-2091004447:
'80\u0003,2u', -976706600: '\u000F'}} LIMIT 127 ALLOW FILTERING -- v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>> (indexed with SAI), v1
frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI), on node1, fetch
size 1000
154: SELECT * FROM ks1.tbl WHERE s1 = false AND v0 =
'q\u001Ak\u000D\u000EY-x' AND pk0 = 133647749441392509 AND ck0 =
'2029-11-22T07:25:47.281Z' AND v1 = {'?ߥ鏌짐巠': {-1743013482:
'NK`!8\u00016\u000F', -1484993536: 'F\u0017B', -659672689: 'ubv'},
'\u008Eቶ厗튼药丨猹譆嵺': {-2007678581: 'i\u0009ZqnH\u000F2', -1973054692: ']\u0000M',
2071507780: '3]h%T\u0015\u0017&\u0001 '}} AND pk1 = '133.53.176.75' AND v4 =
true AND ck1 = -6.483759E20 AND s0 = {{'\u0002`9d?+*4',
'{V\u0014|\u001Ac\u0017\u001A'''}: {00000000-0000-4500-8400-000000000000:
0xefd8b2, 00000000-0000-4600-8c00-000000000000: 0x888eb001740a}, {'+=\u0008',
'3F(y#E\u0006#\u007F~'}: {00000000-0000-4c00-a500-000000000000: 0x470a6e28}}
LIMIT 34 ALLOW FILTERING -- s1 boolean (indexed with SAI), v0 ascii (indexed
with SAI), pk0 bigint (indexed with SAI), ck0 timestamp (reversed) (indexed
with SAI), v1 frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI),
pk1 inet (indexed with SAI), v4 boolean (indexed with SAI), ck1 float (indexed
with SAI), s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed
with SAI), on node1, fetch size 10
155: SELECT * FROM ks1.tbl WHERE v3 = ({true: 'og'},
(0x1ae39397e5b6d5), 0x0000000000004a009e00000000000000) LIMIT 73 ALLOW
FILTERING -- v3 frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>>, indexed with SAI, on
node1, fetch size 5000
156: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' -- By Partition Key, on node1,
fetch size 10
157: SELECT * FROM ks1.tbl WHERE v1 = {'旰퐀늒㧩鮩鉓澴巏聽丰':
{-1708634768: '^\u001AV\u0002', 782702699: '\u0016\u001F"*$\u000E?_Y',
1643123268: '\u000D'}} AND s0 = {{'\u0006l\u0011\u000D@U', '\u000Bu\u0011',
'\u0015\u000EL3(Cn'}: {00000000-0000-4900-9f00-000000000000:
0x2148e60eccc920e2, 00000000-0000-4e00-8b00-000000000000: 0xa1a7,
00000000-0000-4f00-bf00-000000000000: 0x6bdc73},
{'\u001EI4\u001E03N\u0007\u0010&', 'UKb\u0006', 'o\u001Dmnx\u001Fk'}:
{00000000-0000-4200-aa00-000000000000: 0x4d,
00000000-0000-4600-9600-000000000000: 0x32982c1d,
00000000-0000-4e00-9e00-000000000000: 0xd95149fc}} LIMIT 443 ALLOW FILTERING --
v1 frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI), s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI), on
node1, fetch size 5000
158: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 94 -- by token, on node1,
fetch size 1
159: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(4531198082496131334, 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220') -- by
token, on node1
160: SELECT * FROM ks1.tbl WHERE ck1 < -3.2628846E7 LIMIT 359
-- ck1 float, indexed with SAI, on node1
161: SELECT * FROM ks1.tbl WHERE s0 = {{'\u001B\u001BZ\',
'=X\u0017O||\u000Cb,', 'gG\u0013y2'}: {00000000-0000-4500-a100-000000000000:
0xaa75, 00000000-0000-4a00-ac00-000000000000: 0x4cbb697395a05f16bd},
{'o@\u0006*'}: {00000000-0000-4300-b300-000000000000: 0xb73b,
00000000-0000-4400-a400-000000000000: 0x08cde3f39f5f7852,
00000000-0000-4900-9f00-000000000000: 0xafa2045ee1a197833b}} ALLOW FILTERING --
s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>>, indexed with SAI,
on node1, fetch size 1
162: SELECT * FROM ks1.tbl WHERE v0 < 'kLe)' ALLOW FILTERING --
v0 ascii, indexed with SAI, on node1, fetch size 1000
163: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(4531198082496131334, 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220') LIMIT 533
-- by token, on node1, fetch size 5000
164: UPDATE ks1.tbl USING TIMESTAMP 28 SET s0={{'19',
'j7G\u0016'}: {00000000-0000-4900-bd00-000000000000: 0x4bab},
{'1;|\u000DY\u0009\u001E{w%', 'hL#'}: {00000000-0000-4800-ac00-000000000000:
0x72e2e7b946f2c0a2eb}, {'@\u0003', 'B', ']u:\u0015\u001E\u001E'}:
{00000000-0000-4200-9200-000000000000: 0xfae9,
00000000-0000-4900-9f00-000000000000: 0xc619f7df11,
00000000-0000-4d00-8000-000000000000: 0x762a47}}, s1=false, v0='\u0004\u00034'
+ 'q2k''\u0009h|\u0010', v1={'㐨涗剠㢕迅寏䅖ﮒ벶': {-977895264: '.u'}, '䃏죉箓덁ৠ':
{-1259423621: '*\u0004vgy\u000F\u0016i', 610952270: 'Q\u000BX', 1419734583:
'\u0001'}, '咤ゟ饰䌹몹ꗦ᭞棻': {1556327352: 'I\u0017\u001B($G'}}, v2=0xa570c38b,
v3=({false: ''''}, (0xbfd0), 0x00000000000041008000000000000000), v4=false
WHERE pk0 = 5666087756057021160 AND pk1 =
'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' AND ck0 = '2067-09-15T09:13:51.221Z'
AND ck1 = -7.24286E19 - 6.2453034E-18 -- on node1
165: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') AND
token(pk0, pk1) <= token(5778883423090972680, '133.53.176.75') -- by token
range, on node1, fetch size 10
166: SELECT * FROM ks1.tbl WHERE s1 <= false ALLOW FILTERING --
s1 boolean, indexed with SAI, on node1, fetch size 100
167: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(4531198082496131334, 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220') LIMIT 42
-- by token, on node1, fetch size 10
168: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(4531198082496131334, 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220') -- by
token, on node1, fetch size 1
169: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' LIMIT 606 -- By Partition Key,
on node1, fetch size 1
170: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') LIMIT
324 -- by token, on node1, fetch size 1000
171: SELECT * FROM ks1.tbl WHERE v1 = {'跠윇ꑃ郧驄': {-2091004447:
'80\u0003,2u', -976706600: '\u000F'}} AND ck1 = -2.46223895E17 AND pk0 =
-3861597867664806948 AND v0 = '\u000A mfm/^G\u000CkEW7' AND v2 = 0xa58471bc AND
pk1 = '133.53.176.75' AND s0 = {{'19', 'j7G\u0016'}:
{00000000-0000-4900-bd00-000000000000: 0x4bab}, {'1;|\u000DY\u0009\u001E{w%',
'hL#'}: {00000000-0000-4800-ac00-000000000000: 0x72e2e7b946f2c0a2eb},
{'@\u0003', 'B', ']u:\u0015\u001E\u001E'}:
{00000000-0000-4200-9200-000000000000: 0xfae9,
00000000-0000-4900-9f00-000000000000: 0xc619f7df11,
00000000-0000-4d00-8000-000000000000: 0x762a47}} AND v3 = ({false: '/', true:
'\u0012A\u001F\u0006j'}, (0x46b0779d), 0x0000000000001700ba00000000000000) AND
s1 = false AND ck0 = '2005-03-16T03:26:00.335Z' AND v4 = true LIMIT 750 ALLOW
FILTERING -- v1 frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI),
ck1 float (indexed with SAI), pk0 bigint (indexed with SAI), v0 ascii (indexed
with SAI), v2 blob, pk1 inet (indexed with SAI), s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI), v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>> (indexed with SAI), s1
boolean (indexed with SAI), ck0 timestamp (reversed) (indexed with SAI), v4
boolean (indexed with SAI), on node1, fetch size 1
172: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 =
'2029-11-22T07:25:47.281Z' AND ck1 = -2.46223895E17 LIMIT 559 -- By Primary
Key, on node1, fetch size 5000
173: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' LIMIT 177 -- By Partition Key,
on node1, fetch size 1
174: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') -- by
token, on node1
175: SELECT * FROM ks1.tbl WHERE ck1 = -4.32925639E18 AND s0 =
{{'\u0002`9d?+*4', '{V\u0014|\u001Ac\u0017\u001A'''}:
{00000000-0000-4500-8400-000000000000: 0xefd8b2,
00000000-0000-4600-8c00-000000000000: 0x888eb001740a}, {'+=\u0008',
'3F(y#E\u0006#\u007F~'}: {00000000-0000-4c00-a500-000000000000: 0x470a6e28}}
AND v2 = 0x5ece9a5c4c AND v4 = false AND pk1 =
'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' LIMIT 878 ALLOW FILTERING -- ck1
float (indexed with SAI), s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid,
blob>>>> (indexed with SAI), v2 blob, v4 boolean (indexed with SAI), pk1 inet
(indexed with SAI), on node1, fetch size 1000
176: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 743 -- by token, on node1,
fetch size 5000
177: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' -- By Partition Key, on node1,
fetch size 10
178: SELECT * FROM ks1.tbl WHERE v2 = 0x5def AND v1 = {'跠윇ꑃ郧驄':
{-2091004447: '80\u0003,2u', -976706600: '\u000F'}} AND v0 =
'\u001De[M90\u0009"c@\u007F' AND v3 = ({true: '%3<^'}, (0xa9dc666b96),
0x0000000000004500ba00000000000000) AND s0 = {{'6', 'a0'}:
{00000000-0000-4100-9400-000000000000: 0xee27,
00000000-0000-4900-a000-000000000000: 0xe00a2e,
00000000-0000-4a00-9c00-000000000000: 0xe5abb48aaaa6}, {'@T;egM+'}:
{00000000-0000-4500-b900-000000000000: 0xe9,
00000000-0000-4d00-bb00-000000000000: 0xc1be0fe3d69a373d8391}} LIMIT 290 ALLOW
FILTERING -- v2 blob, v1 frozen<map<text, frozen<map<int, ascii>>>> (indexed
with SAI), v0 ascii (indexed with SAI), v3 frozen<tuple<frozen<map<boolean,
ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>> (indexed with SAI), s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI), on
node1, fetch size 5000
179: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 --
pk0 bigint, indexed with SAI, on node1, fetch size 1
180: SELECT * FROM ks1.tbl WHERE pk0 = 5666087756057021160 AND
pk1 = 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' AND ck0 =
'2041-06-21T07:34:27.143Z' AND ck1 = -1.5230537E-24 LIMIT 693 -- By Primary
Key, on node1, fetch size 5000
181: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf') -- by
token, on node1, fetch size 1000
182: SELECT * FROM ks1.tbl WHERE s0 = {{'19', 'j7G\u0016'}:
{00000000-0000-4900-bd00-000000000000: 0x4bab}, {'1;|\u000DY\u0009\u001E{w%',
'hL#'}: {00000000-0000-4800-ac00-000000000000: 0x72e2e7b946f2c0a2eb},
{'@\u0003', 'B', ']u:\u0015\u001E\u001E'}:
{00000000-0000-4200-9200-000000000000: 0xfae9,
00000000-0000-4900-9f00-000000000000: 0xc619f7df11,
00000000-0000-4d00-8000-000000000000: 0x762a47}} LIMIT 213 ALLOW FILTERING --
s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>>, indexed with SAI,
on node1, fetch size 10
183: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf') LIMIT 587
-- by token, on node1, fetch size 10
184: SELECT * FROM ks1.tbl WHERE pk0 = -7092676947467875356 AND
pk1 = '37de:45bf:1239:7766:cbe2:e333:efab:d3c6' AND ck0 =
'2035-06-13T19:57:35.817Z' AND ck1 = 6.837532E28 -- By Primary Key, on node1,
fetch size 10
185: SELECT * FROM ks1.tbl WHERE v4 > false LIMIT 421 ALLOW
FILTERING -- v4 boolean, indexed with SAI, on node1, fetch size 10
186: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 =
'2033-05-10T20:01:39.737Z' AND ck1 = -1.1879217E-10 LIMIT 12 -- By Primary Key,
on node1, fetch size 1
187: SELECT * FROM ks1.tbl WHERE s0 =
{{'\u0006l\u0011\u000D@U', '\u000Bu\u0011', '\u0015\u000EL3(Cn'}:
{00000000-0000-4900-9f00-000000000000: 0x2148e60eccc920e2,
00000000-0000-4e00-8b00-000000000000: 0xa1a7,
00000000-0000-4f00-bf00-000000000000: 0x6bdc73},
{'\u001EI4\u001E03N\u0007\u0010&', 'UKb\u0006', 'o\u001Dmnx\u001Fk'}:
{00000000-0000-4200-aa00-000000000000: 0x4d,
00000000-0000-4600-9600-000000000000: 0x32982c1d,
00000000-0000-4e00-9e00-000000000000: 0xd95149fc}} LIMIT 14 ALLOW FILTERING --
s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>>, indexed with SAI,
on node1, fetch size 1
188: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf') -- by
token, on node1, fetch size 100
189: SELECT * FROM ks1.tbl WHERE ck0 >
'2041-06-21T07:34:27.143Z' LIMIT 18 -- ck0 timestamp (reversed), indexed with
SAI, on node1, fetch size 1000
190: SELECT * FROM ks1.tbl WHERE pk1 = '174.128.216.143' LIMIT
300 -- pk1 inet, indexed with SAI, on node1, fetch size 10
191: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 126 -- by token, on node1,
fetch size 100
192: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5778883423090972680, '133.53.176.75') LIMIT 591 -- by token, on node1,
fetch size 1
193: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 399 -- by token, on node1,
fetch size 100
194: SELECT * FROM ks1.tbl WHERE v0 >= 'kLe)' ALLOW FILTERING
-- v0 ascii, indexed with SAI, on node1, fetch size 1000
195: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') -- by token, on node1, fetch
size 5000
196: SELECT * FROM ks1.tbl WHERE pk0 = 5666087756057021160 AND
pk1 = 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' AND ck0 =
'2041-06-21T07:34:27.143Z' AND ck1 = -1.5230537E-24 LIMIT 283 -- By Primary
Key, on node1, fetch size 5000
197: SELECT * FROM ks1.tbl WHERE pk0 = -3861597867664806948 AND
pk1 = '174.128.216.143' AND ck0 = '2034-03-09T18:20:56.930Z' AND ck1 =
3.11811162E18 LIMIT 166 -- By Primary Key, on node1, fetch size 5000
198: SELECT * FROM ks1.tbl WHERE s0 = {{'\u0002`9d?+*4',
'{V\u0014|\u001Ac\u0017\u001A'''}: {00000000-0000-4500-8400-000000000000:
0xefd8b2, 00000000-0000-4600-8c00-000000000000: 0x888eb001740a}, {'+=\u0008',
'3F(y#E\u0006#\u007F~'}: {00000000-0000-4c00-a500-000000000000: 0x470a6e28}}
LIMIT 32 ALLOW FILTERING -- s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid,
blob>>>>, indexed with SAI, on node1, fetch size 100
199: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf') LIMIT 48
-- by token, on node1, fetch size 10
200: SELECT * FROM ks1.tbl WHERE s0 =
{{'\u0006l\u0011\u000D@U', '\u000Bu\u0011', '\u0015\u000EL3(Cn'}:
{00000000-0000-4900-9f00-000000000000: 0x2148e60eccc920e2,
00000000-0000-4e00-8b00-000000000000: 0xa1a7,
00000000-0000-4f00-bf00-000000000000: 0x6bdc73},
{'\u001EI4\u001E03N\u0007\u0010&', 'UKb\u0006', 'o\u001Dmnx\u001Fk'}:
{00000000-0000-4200-aa00-000000000000: 0x4d,
00000000-0000-4600-9600-000000000000: 0x32982c1d,
00000000-0000-4e00-9e00-000000000000: 0xd95149fc}} AND ck0 =
'2005-03-16T03:26:00.335Z' AND v3 = ({false: ','}, (0xa3502eea),
0x00000000000049008600000000000000) AND v4 = true AND pk1 =
'37de:45bf:1239:7766:cbe2:e333:efab:d3c6' AND v1 = {'?ߥ鏌짐巠': {-1743013482:
'NK`!8\u00016\u000F', -1484993536: 'F\u0017B', -659672689: 'ubv'},
'\u008Eቶ厗튼药丨猹譆嵺': {-2007678581: 'i\u0009ZqnH\u000F2', -1973054692: ']\u0000M',
2071507780: '3]h%T\u0015\u0017&\u0001 '}} AND pk0 = -3861597867664806948 LIMIT
351 ALLOW FILTERING -- s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid,
blob>>>> (indexed with SAI), ck0 timestamp (reversed) (indexed with SAI), v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>> (indexed with SAI), v4
boolean (indexed with SAI), pk1 inet (indexed with SAI), v1 frozen<map<text,
frozen<map<int, ascii>>>> (indexed with SAI), pk0 bigint (indexed with SAI), on
node1, fetch size 5000
201: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') LIMIT
245 -- by token, on node1, fetch size 10
202: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, s1, v0, v1,
v2, v3, v4) VALUES (4531198082496131334,
'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220', '2032-05-23T05:29:16.126Z',
8.080199E-29 * -1.21045451E12, {{'\u0005\u0005VZ0)', 'M^OT:w'}:
{00000000-0000-4800-a400-000000000000: 0x7ea88d5de7d6e26fce,
00000000-0000-4c00-a300-000000000000: 0xed80669386fe810b69b6}, {'\u001Fm@',
']\u0012=pW_Qtg'}: {00000000-0000-4800-9d00-000000000000: 0x4d3808,
00000000-0000-4a00-8200-000000000000: 0xca,
00000000-0000-4e00-8000-000000000000: 0x2410fed1},
{'\u007F\u0017\u0004?:$\u00068~'}: {00000000-0000-4000-bd00-000000000000:
0x1ec864}}, null, 'G\u000D\u0011Dt!u' + '^\u000A\u000E', {'ᳵᬯ汓旜㬪骰':
{1023891875: '+\S\u0007r>"LW\u0014'}}, 0x04df67664a, ({false:
'\u0003\u0015@\u0005\u000F\u0006L', true: '\u00148:'}, (0x3c),
0x0000000000004d00b500000000000000), true) USING TIMESTAMP 29 -- on node1
203: SELECT * FROM ks1.tbl WHERE v2 = 0xfab134fc44110bd3 ALLOW
FILTERING -- v2 blob, on node1, fetch size 1
204: SELECT * FROM ks1.tbl WHERE pk0 = -7092676947467875356 AND
pk1 = '37de:45bf:1239:7766:cbe2:e333:efab:d3c6' AND ck0 =
'2035-06-13T19:57:35.817Z' AND ck1 = 6.837532E28 -- By Primary Key, on node1,
fetch size 100
205: SELECT * FROM ks1.tbl WHERE v0 = 'q\u001Ak\u000D\u000EY-x'
AND s0 = {{'\u0006l\u0011\u000D@U', '\u000Bu\u0011', '\u0015\u000EL3(Cn'}:
{00000000-0000-4900-9f00-000000000000: 0x2148e60eccc920e2,
00000000-0000-4e00-8b00-000000000000: 0xa1a7,
00000000-0000-4f00-bf00-000000000000: 0x6bdc73},
{'\u001EI4\u001E03N\u0007\u0010&', 'UKb\u0006', 'o\u001Dmnx\u001Fk'}:
{00000000-0000-4200-aa00-000000000000: 0x4d,
00000000-0000-4600-9600-000000000000: 0x32982c1d,
00000000-0000-4e00-9e00-000000000000: 0xd95149fc}} AND ck1 = -7.696585E27 AND
v4 = false AND s1 = false ALLOW FILTERING -- v0 ascii (indexed with SAI), s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI),
ck1 float (indexed with SAI), v4 boolean (indexed with SAI), s1 boolean
(indexed with SAI), on node1, fetch size 10
206: UPDATE ks1.tbl USING TIMESTAMP 30 SET s0={{'Ce',
'J\u0014', 'q!UX\u001F\u0005D%>'}: {00000000-0000-4700-8500-000000000000:
0x142653c7942fa5c3, 00000000-0000-4b00-bb00-000000000000: 0xcd51,
00000000-0000-4e00-8400-000000000000: 0x0c9c}}, s1=false, v0='Ys1HHo' +
'^1\Hh''N\u0016', v1={'ὒ跐젖쁽鍠?⏮簽儡ⳋ': {1353189556:
')c\u001C\u000Fpc\u0004=\u0003+', 1970720377: '*[\u001E8\u0000'}, '餍䆒뭈ꔖ':
{-1340056081: '?\u0012', 1219068397: 'h"\u0014im\\u0011/', 1368489137:
'h@)\u000DOz\u0002#'}}, v2=0x94ed11faa7b7ef87, v3=null, v4=false WHERE pk0 =
4531198082496131334 AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND
ck0 = '2060-08-19T15:48:19.714Z' AND ck1 = -6.419676E-29 -- on node1
207: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
s0 = {{'6', 'a0'}: {00000000-0000-4100-9400-000000000000: 0xee27,
00000000-0000-4900-a000-000000000000: 0xe00a2e,
00000000-0000-4a00-9c00-000000000000: 0xe5abb48aaaa6}, {'@T;egM+'}:
{00000000-0000-4500-b900-000000000000: 0xe9,
00000000-0000-4d00-bb00-000000000000: 0xc1be0fe3d69a373d8391}} AND v2 =
0x04df67664a AND v1 = {'跠윇ꑃ郧驄': {-2091004447: '80\u0003,2u', -976706600:
'\u000F'}} AND v0 = '\u0011\u001Etkk' AND ck1 = -7.696585E27 AND ck0 =
'2005-03-16T03:26:00.335Z' AND v3 = ({false: ''''}, (0xbfd0),
0x00000000000041008000000000000000) AND v4 = false AND s1 = false AND pk1 =
'174.128.216.143' LIMIT 232 ALLOW FILTERING -- pk0 bigint (indexed with SAI),
s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI),
v2 blob, v1 frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI), v0
ascii (indexed with SAI), ck1 float (indexed with SAI), ck0 timestamp
(reversed) (indexed with SAI), v3 frozen<tuple<frozen<map<boolean, ascii>>,
frozen<tuple<blob>>, 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>
(indexed with SAI), v4 boolean (indexed with SAI), s1 boolean (indexed with
SAI), pk1 inet (indexed with SAI), on node1
208: SELECT * FROM ks1.tbl WHERE pk1 =
'2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' AND v2 = 0x94ed11faa7b7ef87 AND v4 =
false AND s1 = false AND ck0 = '2041-06-21T07:34:27.143Z' AND v1 = {'ጎ᥋驙':
{-49362600: '7', 1418016338: '\u0007\u0008RX'}} ALLOW FILTERING -- pk1 inet
(indexed with SAI), v2 blob, v4 boolean (indexed with SAI), s1 boolean (indexed
with SAI), ck0 timestamp (reversed) (indexed with SAI), v1 frozen<map<text,
frozen<map<int, ascii>>>> (indexed with SAI), on node1, fetch size 1000
209: UPDATE ks1.tbl USING TIMESTAMP 31 SET
v2=0x449a1a7e9e44bda70fd5, v1={'➌?灎': {-1135526302: '67', 134056764:
',\u000Bgh', 538196543: 'd\u000C'}, '蜖೨': {-1935074078: '-)\u000D',
-1704803058: '\u000F\u0003\u000E+\u000FQ', 204708439:
'P\u0009/\u000DX>\u0000\u0006\u0014\u000B'}} WHERE pk0 = -3861597867664806948
AND pk1 = '174.128.216.143' AND ck0 = '1985-03-03T02:33:37.458Z' AND ck1 =
-2.014844E-37 * 3.60529E34 -- on node1
210: SELECT * FROM ks1.tbl WHERE v0 >=
'NA4\u0010K\u001B\u0016xv8' LIMIT 695 ALLOW FILTERING -- v0 ascii, indexed with
SAI, on node1, fetch size 5000
211: DELETE FROM ks1.tbl USING TIMESTAMP 32 WHERE pk0 =
133647749441392509 AND pk1 = '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' AND
ck0 = '1988-01-18T06:00:36.167Z' AND ck1 = -1.3840727E-37 - 1.68488475E16 --
on node1
212: SELECT * FROM ks1.tbl WHERE pk0 = 5666087756057021160 AND
pk1 = 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' AND s1 >= false LIMIT 592 ALLOW
FILTERING -- s1 boolean, indexed with SAI, on node1, fetch size 1000
213: SELECT * FROM ks1.tbl WHERE v3 = ({false: '\u001E'},
(0xc5389fb0006d2ac6f0), 0x0000000000004c008500000000000000) AND v1 =
{'旰퐀늒㧩鮩鉓澴巏聽丰': {-1708634768: '^\u001AV\u0002', 782702699:
'\u0016\u001F"*$\u000E?_Y', 1643123268: '\u000D'}} AND v2 = 0x04df67664a AND
pk1 = '174.128.216.143' AND s0 = {{'19', 'j7G\u0016'}:
{00000000-0000-4900-bd00-000000000000: 0x4bab}, {'1;|\u000DY\u0009\u001E{w%',
'hL#'}: {00000000-0000-4800-ac00-000000000000: 0x72e2e7b946f2c0a2eb},
{'@\u0003', 'B', ']u:\u0015\u001E\u001E'}:
{00000000-0000-4200-9200-000000000000: 0xfae9,
00000000-0000-4900-9f00-000000000000: 0xc619f7df11,
00000000-0000-4d00-8000-000000000000: 0x762a47}} ALLOW FILTERING -- v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>> (indexed with SAI), v1
frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI), v2 blob, pk1
inet (indexed with SAI), s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid,
blob>>>> (indexed with SAI), on node1, fetch size 1
214: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(4531198082496131334, 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220') LIMIT 4
-- by token, on node1, fetch size 5000
215: SELECT * FROM ks1.tbl WHERE pk0 = -3861597867664806948 AND
pk1 = '174.128.216.143' -- By Partition Key, on node1, fetch size 1
216: SELECT * FROM ks1.tbl WHERE v3 = ({false:
'\u0014%\u000CpC\u0008A\u0005', true:
'\u001AA\u001F0\u0008\u000E\u0010_\u0011'}, (0x7a64e54139),
0x0000000000001e009500000000000000) LIMIT 196 ALLOW FILTERING -- v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>>, indexed with SAI, on
node1, fetch size 1000
217: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 852 -- by token, on node1,
fetch size 10
218: nodetool flush ks1 tbl
219: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 =
'2028-06-22T03:40:39.788Z' AND ck1 = -Infinity LIMIT 38 -- By Primary Key, on
node1, fetch size 5000
220: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' LIMIT 120 -- By Partition Key,
on node1
221: SELECT * FROM ks1.tbl WHERE v4 < false ALLOW FILTERING --
v4 boolean, indexed with SAI, on node1, fetch size 1000
222: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') LIMIT
171 -- by token, on node1, fetch size 100
223: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') LIMIT 51
-- by token, on node1, fetch size 1000
224: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5778883423090972680, '133.53.176.75') -- by token, on node1, fetch size
100
225: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(4531198082496131334, 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220') LIMIT 66
-- by token, on node1, fetch size 1
226: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5778883423090972680, '133.53.176.75') -- by token, on node1, fetch size 10
227: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 456 -- by token, on node1,
fetch size 5000
228: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf') LIMIT 221
-- by token, on node1, fetch size 100
229: UPDATE ks1.tbl USING TIMESTAMP 33 SET
s0={{'\u000B\u0006V\u000C\u0016'}: {00000000-0000-4600-9700-000000000000:
0x85ad0286, 00000000-0000-4d00-9700-000000000000: 0x4c325776}}, s1=true,
v0=null, v1={'됗': {-747484893: 'S1\u0000T-', -119735017: '/As)mL'}, 'ﺔ髖':
{255259436: '!;', 1378995470: 'bZc>QAJ'}}, v2=0x8e53a2, v3=({false: '1\u000C'},
(0x4b4f2d), 0x00000000000016009200000000000000), v4=true WHERE pk0 =
5666087756057021160 AND pk1 = 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' AND
ck0 = '1976-09-03T01:30:19.739Z' AND ck1 = 6.3902622E10 + -2.7893961E-8 -- on
node1
230: SELECT * FROM ks1.tbl LIMIT 440 -- full table scan, on
node1, fetch size 1
231: SELECT * FROM ks1.tbl WHERE pk0 = -3861597867664806948 AND
pk1 = '174.128.216.143' -- By Partition Key, on node1, fetch size 1000
232: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
ck0 = '2053-10-16T11:51:17.920Z' AND v4 = false AND v1 = {'旰퐀늒㧩鮩鉓澴巏聽丰':
{-1708634768: '^\u001AV\u0002', 782702699: '\u0016\u001F"*$\u000E?_Y',
1643123268: '\u000D'}} AND pk1 = '133.53.176.75' AND ck1 = 3.6624246E31 AND s0
= {{'\u000B\u0006V\u000C\u0016'}: {00000000-0000-4600-9700-000000000000:
0x85ad0286, 00000000-0000-4d00-9700-000000000000: 0x4c325776}} AND v0 =
'\u001De[M90\u0009"c@\u007F' AND v3 = ({false:
'\u0003\u0015@\u0005\u000F\u0006L', true: '\u00148:'}, (0x3c),
0x0000000000004d00b500000000000000) AND v2 = 0x449a1a7e9e44bda70fd5 AND s1 =
false LIMIT 866 ALLOW FILTERING -- pk0 bigint (indexed with SAI), ck0 timestamp
(reversed) (indexed with SAI), v4 boolean (indexed with SAI), v1
frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI), pk1 inet
(indexed with SAI), ck1 float (indexed with SAI), s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI), v0
ascii (indexed with SAI), v3 frozen<tuple<frozen<map<boolean, ascii>>,
frozen<tuple<blob>>, 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>
(indexed with SAI), v2 blob, s1 boolean (indexed with SAI), on node1
233: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 92
-- by token, on node1, fetch size 1
234: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s1, v3, v2, s0,
v4, v0, v1) VALUES (4531198082496131334,
'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220', '2041-03-30T22:31:49.043Z',
1227.6963 + -2.4018856E-5, false, null, 0xdd, {{'\u0019[*', '5!\u0007#\u0005',
'M.H'}: {00000000-0000-4100-a500-000000000000: 0x710825aa87,
00000000-0000-4700-9100-000000000000: 0x2dbde205d2,
00000000-0000-4d00-bc00-000000000000: 0xa28a}, {'$7Q\u0000\u0011*\u007F\u000D',
'q$\u000A\u0016="$'}: {00000000-0000-4700-b000-000000000000:
0x5709b55a758d17833b21, 00000000-0000-4a00-a700-000000000000: 0x6229dece,
00000000-0000-4f00-8100-000000000000: 0x5f992cc4}, {'J`k@\u001BpS!T%'}:
{00000000-0000-4600-8400-000000000000: 0x8274a6a01f7a3e,
00000000-0000-4800-ac00-000000000000: 0x003f6923d30760f48d40}}, null, null,
{'ᮾ謘䜩呦ꎮ①': {869972408: 'X\u0009xdO#'}}) USING TIMESTAMP 34 -- on node1
235: SELECT * FROM ks1.tbl WHERE pk0 = -3861597867664806948 AND
pk1 = '174.128.216.143' AND ck0 = '2009-10-27T15:44:11.844Z' AND ck1 =
-6.483759E20 LIMIT 8 -- By Primary Key, on node1, fetch size 5000
236: SELECT * FROM ks1.tbl WHERE ck0 =
'1995-01-24T00:52:42.129Z' -- ck0 timestamp (reversed), indexed with SAI, on
node1, fetch size 1
237: UPDATE ks1.tbl USING TIMESTAMP 35 SET s0={{'jOjs\u0006V'}:
{00000000-0000-4900-b000-000000000000: 0x97c4605107b0af34ae}}, s1=false,
v0='Vp)B', v1={'⠝': {296544631: 's4i@AAh|', 497636181: '5R\u00083M>',
1599833683: 'C\u0000K\u000D\u000Fe'}, '멒䩵褓?': {-208624288: 'Y', 232213381:
'VW', 818658382: '0'}}, v2=0x, v3=({false: 'K ', true: '"'},
(0x59f9fd1d7e3a9c06), 0x00000000000012009100000000000000), v4=null WHERE pk0 =
4531198082496131334 AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND
ck0 = '1990-08-14T02:25:35.892Z' AND ck1 = -2.997845E-25 * -3.225365E-31 -- on
node1
238: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') -- by token, on node1, fetch
size 1000
239: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf') LIMIT 764
-- by token, on node1, fetch size 1000
240: SELECT * FROM ks1.tbl WHERE v4 = true LIMIT 324 ALLOW
FILTERING -- v4 boolean, indexed with SAI, on node1, fetch size 1000
241: SELECT * FROM ks1.tbl WHERE s0 <
{{'\u0006l\u0011\u000D@U', '\u000Bu\u0011', '\u0015\u000EL3(Cn'}:
{00000000-0000-4900-9f00-000000000000: 0x2148e60eccc920e2,
00000000-0000-4e00-8b00-000000000000: 0xa1a7,
00000000-0000-4f00-bf00-000000000000: 0x6bdc73},
{'\u001EI4\u001E03N\u0007\u0010&', 'UKb\u0006', 'o\u001Dmnx\u001Fk'}:
{00000000-0000-4200-aa00-000000000000: 0x4d,
00000000-0000-4600-9600-000000000000: 0x32982c1d,
00000000-0000-4e00-9e00-000000000000: 0xd95149fc}} LIMIT 22 ALLOW FILTERING --
s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>>, indexed with SAI,
on node1, fetch size 100
242: SELECT * FROM ks1.tbl WHERE v0 =
'G\u000D\u0011Dt!u^\u000A\u000E' LIMIT 237 ALLOW FILTERING -- v0 ascii, indexed
with SAI, on node1, fetch size 5000
243: SELECT * FROM ks1.tbl WHERE v2 = 0xcdf6 AND ck1 =
1.0188728E19 LIMIT 171 ALLOW FILTERING -- v2 blob, ck1 float (indexed with
SAI), on node1
244: SELECT * FROM ks1.tbl WHERE pk0 = -7092676947467875356 AND
s1 = false AND v1 = {'됗': {-747484893: 'S1\u0000T-', -119735017: '/As)mL'},
'ﺔ髖': {255259436: '!;', 1378995470: 'bZc>QAJ'}} AND v3 = ({false: ''''},
(0xbfd0), 0x00000000000041008000000000000000) AND v4 = true AND s0 =
{{'jOjs\u0006V'}: {00000000-0000-4900-b000-000000000000: 0x97c4605107b0af34ae}}
AND v0 = 'NA4\u0010K\u001B\u0016xv8' AND pk1 =
'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 = '1976-09-03T01:30:19.739Z'
LIMIT 35 ALLOW FILTERING -- pk0 bigint (indexed with SAI), s1 boolean (indexed
with SAI), v1 frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI), v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>> (indexed with SAI), v4
boolean (indexed with SAI), s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid,
blob>>>> (indexed with SAI), v0 ascii (indexed with SAI), pk1 inet (indexed
with SAI), ck0 timestamp (reversed) (indexed with SAI), on node1, fetch size
1000
245: SELECT * FROM ks1.tbl WHERE s1 > false ALLOW FILTERING --
s1 boolean, indexed with SAI, on node1, fetch size 1
246: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf') -- by
token, on node1, fetch size 1
247: SELECT * FROM ks1.tbl WHERE ck0 >
'1990-08-14T02:25:35.892Z' -- ck0 timestamp (reversed), indexed with SAI, on
node1, fetch size 5000
248: SELECT * FROM ks1.tbl WHERE v3 = ({false: '/', true:
'\u0012A\u001F\u0006j'}, (0x46b0779d), 0x0000000000001700ba00000000000000)
ALLOW FILTERING -- v3 frozen<tuple<frozen<map<boolean, ascii>>,
frozen<tuple<blob>>, 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>,
indexed with SAI, on node1, fetch size 100
249: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(4531198082496131334, 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220') -- by
token, on node1
250: SELECT * FROM ks1.tbl WHERE s1 = false ALLOW FILTERING --
s1 boolean, indexed with SAI, on node1, fetch size 1
251: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 =
'2033-05-10T20:01:39.737Z' AND ck1 = -1.1879217E-10 LIMIT 461 -- By Primary
Key, on node1, fetch size 5000
252: SELECT * FROM ks1.tbl WHERE ck0 <=
'2041-06-21T07:34:27.143Z' LIMIT 418 -- ck0 timestamp (reversed), indexed with
SAI, on node1, fetch size 10
253: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v2, s1, v1)
VALUES (5778883423090972680, '133.53.176.75', '2003-12-15T23:36:07.726Z',
-2.7198392E37, 0xb31d3f60755e220c958b, true, {'㼋뚢䀅Ắ얎ἴꆋ': {-666399047:
'>qF+\u00169^P19', -115322575: '\u0009+ '}, '䤅므좗': {-178519468: 'N'},
'튁雞㥿?롂搠芭': {-1653897345: '%', 1449972426: '\u0007n'}}) USING TIMESTAMP 36 --
on node1
254: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND v4 = false LIMIT 99 ALLOW
FILTERING -- v4 boolean, indexed with SAI, on node1, fetch size 5000
255: UPDATE ks1.tbl USING TIMESTAMP 37 SET
s0={{'\u00198}t\u001C', 'F;\u000D', '\u007F{g\u000F&J*'}:
{00000000-0000-4000-a300-000000000000: 0x8089978fe25b48a571,
00000000-0000-4200-8400-000000000000: 0xc33110638ae77c,
00000000-0000-4c00-a800-000000000000: 0x80082a5e74}, {'"f@F\u001FTD',
'G\u0010&-V'}: {00000000-0000-4200-a800-000000000000: 0xf18f,
00000000-0000-4500-bc00-000000000000: 0x88,
00000000-0000-4e00-9000-000000000000: 0x72f4c57baa308ab2c9}, {'s\u0016mP},',
'v\u0012q$fp22\u0010\u000B'}: {00000000-0000-4d00-8100-000000000000:
0xad8f3325936b52}}, s1=false, v0='''z' + 't)}n\u00010|', v1={'䵿뫿鷡':
{1294499753: 'i^', 1356951858: '\u001F5cyB{B'}}, v2=0x49fa668aad77324549cd,
v3=({false: 'P^\u000F_[--', true: '{G\u0009''v3\u00054'}, (0x415d),
0x0000000000001a00a100000000000000), v4=false WHERE pk0 = 4531198082496131334
AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 =
'2069-02-10T14:27:00.202Z' AND ck1 = 4.41884E27 + 6.899159E25 -- on node1
256: SELECT * FROM ks1.tbl WHERE pk1 =
'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' LIMIT 43 -- pk1 inet, indexed with
SAI, on node1, fetch size 10
257: SELECT * FROM ks1.tbl WHERE s0 >= {{'6', 'a0'}:
{00000000-0000-4100-9400-000000000000: 0xee27,
00000000-0000-4900-a000-000000000000: 0xe00a2e,
00000000-0000-4a00-9c00-000000000000: 0xe5abb48aaaa6}, {'@T;egM+'}:
{00000000-0000-4500-b900-000000000000: 0xe9,
00000000-0000-4d00-bb00-000000000000: 0xc1be0fe3d69a373d8391}} LIMIT 903 ALLOW
FILTERING -- s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>>,
indexed with SAI, on node1, fetch size 10
258: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf') -- by
token, on node1, fetch size 100
259: SELECT * FROM ks1.tbl WHERE v1 = {'됗': {-747484893:
'S1\u0000T-', -119735017: '/As)mL'}, 'ﺔ髖': {255259436: '!;', 1378995470:
'bZc>QAJ'}} AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND v0 = 'kLe)'
AND v3 = ({false: '\u000E![\u0016&=\u0006\u0001', true:
'0M9\u0019\u001E\u0013'}, (0x9fe25c5e), 0x0000000000001a00bb00000000000000) AND
v2 = 0xac AND s0 = {{'\u000B\u0006V\u000C\u0016'}:
{00000000-0000-4600-9700-000000000000: 0x85ad0286,
00000000-0000-4d00-9700-000000000000: 0x4c325776}} AND ck0 =
'2060-08-19T15:48:19.714Z' AND ck1 = 6.837532E28 LIMIT 122 ALLOW FILTERING --
v1 frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI), pk1 inet
(indexed with SAI), v0 ascii (indexed with SAI), v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>> (indexed with SAI), v2
blob, s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with
SAI), ck0 timestamp (reversed) (indexed with SAI), ck1 float (indexed with
SAI), on node1, fetch size 10
260: SELECT * FROM ks1.tbl WHERE v0 = 'Vp)B' LIMIT 423 ALLOW
FILTERING -- v0 ascii, indexed with SAI, on node1, fetch size 1000
261: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 254 -- by token, on node1,
fetch size 1
262: nodetool flush ks1 tbl
263: SELECT * FROM ks1.tbl WHERE v2 = 0x90a381e009 ALLOW
FILTERING -- v2 blob, on node1, fetch size 1000
264: DELETE FROM ks1.tbl USING TIMESTAMP 38 WHERE pk0 =
4531198082496131334 AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' -- on
node1
265: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 536 -- by token, on node1
266: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') LIMIT 156
-- by token, on node1, fetch size 1
267: SELECT * FROM ks1.tbl WHERE pk0 = -3861597867664806948 AND
pk1 = '174.128.216.143' -- By Partition Key, on node1, fetch size 5000
268: SELECT * FROM ks1.tbl WHERE pk0 > -3861597867664806948
LIMIT 541 -- pk0 bigint, indexed with SAI, on node1, fetch size 10
269: SELECT * FROM ks1.tbl WHERE pk0 = 133647749441392509 AND
pk1 = '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' AND ck1 = 3.6624246E31 LIMIT
190 -- ck1 float, indexed with SAI, on node1, fetch size 100
270: DELETE FROM ks1.tbl USING TIMESTAMP 39 WHERE pk0 =
4531198082496131334 AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND
ck0 = '1993-12-19T17:31:28.783Z' AND ck1 = -3.8510577E-31 + 7.1267402E16 -- on
node1
271: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf') LIMIT 162
-- by token, on node1, fetch size 5000
272: UPDATE ks1.tbl USING TIMESTAMP 40 SET v2=0x6213601a76e7,
s0={{'\u0005'}: {00000000-0000-4e00-8900-000000000000: 0x0f419a50},
{'\u0010(\u0013p9\u000C', 'DD\u001D\u0011yD)', 'tgm{Vp'}:
{00000000-0000-4000-9600-000000000000: 0x47,
00000000-0000-4900-b800-000000000000: 0x2f3e7f09}, {'&C', '37-t',
'q,Nk\u000A1M:\u0001'}: {00000000-0000-4300-a100-000000000000: 0xa11eeacd0b0c}}
WHERE pk0 = 5778883423090972680 AND pk1 = '133.53.176.75' AND ck0 =
'2048-12-02T03:21:06.544Z' AND ck1 = 2.89648622E16 -- on node1
273: SELECT * FROM ks1.tbl WHERE v2 = 0x449a1a7e9e44bda70fd5
LIMIT 47 ALLOW FILTERING -- v2 blob, on node1, fetch size 1000
274: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5778883423090972680, '133.53.176.75') LIMIT 9 -- by token, on node1,
fetch size 5000
275: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, s1, v0, v1,
v2, v3, v4) VALUES (4531198082496131334,
'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220', '2030-05-31T10:23:08.601Z',
-5.014118E27 + -6.5086827, {{'\u0015E\u0019', '#IB\u0003L'}:
{00000000-0000-4d00-ac00-000000000000: 0x79080b8a54432a}}, true, '\u0019',
{'൸忪䌎ﺃ': {-143792787: '\u0000iv', 292993448: 'E', 1107438888: 'MSJBI-'}},
0x3a5b57f32ea7, ({false: '\u001F'}, (0xbb02),
0x0000000000004400b900000000000000), false) USING TIMESTAMP 41 -- on node1
276: SELECT * FROM ks1.tbl WHERE pk0 = 133647749441392509 AND
pk1 = '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' AND ck0 =
'1995-01-24T00:52:42.129Z' AND ck1 = 3.6624246E31 LIMIT 297 -- By Primary Key,
on node1, fetch size 5000
277: SELECT * FROM ks1.tbl WHERE pk0 = 5778883423090972680 AND
pk1 = '133.53.176.75' AND ck0 = '1978-06-20T12:37:22.513Z' AND ck1 =
1.05834812E15 LIMIT 93 -- By Primary Key, on node1, fetch size 100
278: nodetool flush ks1 tbl
279: SELECT * FROM ks1.tbl WHERE pk0 = -3861597867664806948 AND
pk1 = '174.128.216.143' LIMIT 59 -- By Partition Key, on node1, fetch size 100
280: SELECT * FROM ks1.tbl WHERE pk0 = 5666087756057021160 AND
pk1 = 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' AND v3 >= ({false: '\u001E'},
(0xc5389fb0006d2ac6f0), 0x0000000000004c008500000000000000) LIMIT 177 ALLOW
FILTERING -- v3 frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>>, indexed with SAI, on
node1, fetch size 1000
281: SELECT * FROM ks1.tbl WHERE pk0 = -7092676947467875356 AND
pk1 = '37de:45bf:1239:7766:cbe2:e333:efab:d3c6' LIMIT 161 -- By Partition Key,
on node1
282: SELECT * FROM ks1.tbl WHERE v4 <= true ALLOW FILTERING --
v4 boolean, indexed with SAI, on node1, fetch size 1000
283: SELECT * FROM ks1.tbl WHERE v0 = '\u000A mfm/^G\u000CkEW7'
AND s1 = true AND ck0 = '1985-03-03T02:33:37.458Z' AND s0 = {{'\u0015E\u0019',
'#IB\u0003L'}: {00000000-0000-4d00-ac00-000000000000: 0x79080b8a54432a}} AND
pk0 = -7092676947467875356 AND ck1 = 6.837532E28 AND v3 = ({false:
'\u0006\u000Cp.V?\u0005', true: '\u000B\u001A'}, (0x6d53eb),
0x00000000000042009500000000000000) AND v1 = {'㼋뚢䀅Ắ얎ἴꆋ': {-666399047:
'>qF+\u00169^P19', -115322575: '\u0009+ '}, '䤅므좗': {-178519468: 'N'},
'튁雞㥿?롂搠芭': {-1653897345: '%', 1449972426: '\u0007n'}} LIMIT 274 ALLOW
FILTERING -- v0 ascii (indexed with SAI), s1 boolean (indexed with SAI), ck0
timestamp (reversed) (indexed with SAI), s0 frozen<map<frozen<set<ascii>>,
frozen<map<uuid, blob>>>> (indexed with SAI), pk0 bigint (indexed with SAI),
ck1 float (indexed with SAI), v3 frozen<tuple<frozen<map<boolean, ascii>>,
frozen<tuple<blob>>, 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>
(indexed with SAI), v1 frozen<map<text, frozen<map<int, ascii>>>> (indexed with
SAI), on node1, fetch size 5000
284: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') LIMIT
399 -- by token, on node1, fetch size 100
285: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf') LIMIT 362
-- by token, on node1, fetch size 1
286: SELECT * FROM ks1.tbl WHERE s0 = {{'\u0005'}:
{00000000-0000-4e00-8900-000000000000: 0x0f419a50}, {'\u0010(\u0013p9\u000C',
'DD\u001D\u0011yD)', 'tgm{Vp'}: {00000000-0000-4000-9600-000000000000: 0x47,
00000000-0000-4900-b800-000000000000: 0x2f3e7f09}, {'&C', '37-t',
'q,Nk\u000A1M:\u0001'}: {00000000-0000-4300-a100-000000000000: 0xa11eeacd0b0c}}
LIMIT 940 ALLOW FILTERING -- s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid,
blob>>>>, indexed with SAI, on node1, fetch size 10
287: SELECT * FROM ks1.tbl WHERE v3 < ({false: '/', true:
'\u0012A\u001F\u0006j'}, (0x46b0779d), 0x0000000000001700ba00000000000000)
ALLOW FILTERING -- v3 frozen<tuple<frozen<map<boolean, ascii>>,
frozen<tuple<blob>>, 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>,
indexed with SAI, on node1
288: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5778883423090972680, '133.53.176.75') LIMIT 73 -- by token, on node1,
fetch size 5000
289: SELECT * FROM ks1.tbl WHERE pk1 =
'37de:45bf:1239:7766:cbe2:e333:efab:d3c6' AND v0 = 'NA4\u0010K\u001B\u0016xv8'
LIMIT 49 ALLOW FILTERING -- pk1 inet (indexed with SAI), v0 ascii (indexed with
SAI), on node1, fetch size 5000
290: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5778883423090972680, '133.53.176.75') LIMIT 467 -- by token, on node1
291: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, s1, v0, v1,
v2, v3, v4) VALUES (4531198082496131334,
'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220', '1974-06-27T16:34:57.828Z',
-4.1116237E-15 + -1.8409844E-36, {{'4ZzI\u0017', 'DJz\u0016\Ot\u000F!9',
'Nj~\u000D\u0002'}: {00000000-0000-4800-a800-000000000000:
0xd71d1827ef9cfe9833f9, 00000000-0000-4900-8600-000000000000: 0x39ff08,
00000000-0000-4a00-8600-000000000000: 0x4f157f6d96d9}}, true, '\u001BVwJ@^f' +
'`o', {'沼咄뭜馅ꏧ?⮌': {-1749932895: '8_\u0017', -1591069608:
'\u00079a\u0012@fVP\u0019', 1485402136: 'b\u0007.\u00062.\u0016\u0015\u007F'},
'现鷔긚': {-1627124827: '/\u0019\u0003K={\u0009\u0004T', 208446805: '\u0007n1'},
'봿Ճ徭퐾윖᪵ਫ㛁': {-7186790: '"'}}, 0xbeb6160fd5, ({false: '5[\u001F>|', true:
''':\u000D\u001D'}, (0xc6e7a9), 0x0000000000004800bf00000000000000), true)
USING TIMESTAMP 42 -- on node1
292: UPDATE ks1.tbl USING TIMESTAMP 43 SET s0={{'q\u0012n'}:
{00000000-0000-4100-b900-000000000000: 0xe28b22942d61338b91}}, s1=true,
v0='\u000AMhrFT\]', v1={'껭覌': {-869180147: '1\u000C*XP)', -645141482:
'\u000DV\u001E[pXlQ\u0000', 1252682440: '),asY1W'}}, v2=0xf3699e053afc9fce0271,
v3=({true: 'X\u0002\QE{,'}, (0x18fc3fe2987dc6),
0x0000000000004a008300000000000000), v4=true WHERE pk0 = 4531198082496131334
AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 =
'2070-06-16T22:53:02.076Z' AND ck1 = 3.568358E-29 -- on node1
293: SELECT * FROM ks1.tbl WHERE ck1 > -6.483759E20 LIMIT 668
-- ck1 float, indexed with SAI, on node1, fetch size 5000
294: SELECT * FROM ks1.tbl WHERE v2 < 0x6c39 LIMIT 16 ALLOW
FILTERING -- v2 blob, on node1, fetch size 100
295: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 36 -- by token, on node1,
fetch size 10
296: SELECT * FROM ks1.tbl WHERE pk0 = 5778883423090972680 AND
pk1 = '133.53.176.75' LIMIT 635 -- By Partition Key, on node1, fetch size 1000
297: UPDATE ks1.tbl USING TIMESTAMP 44 SET s0={{'+\u0007'}:
{00000000-0000-4300-ab00-000000000000: 0x7d73709dc25c57}, {'X\u0014>'}:
{00000000-0000-4a00-a300-000000000000: 0x428285d75187212b8431}}, s1=false,
v0='\u001E\u000DmH=sA X\u000C', v1={'唟鳙崌諼탪': {-2085359588: '{sj''',
-1797268160: 'V', -628914991: 'vWq\u001C*^Vl'}, '뤞': {-1007005130: 'J[\u0005}',
20462633: 'yAB~\u001E\u0013wmJ', 1814551038: '\u0019pLR?2I\u001F'},
'컳눟罡䌲崴쿞?菸⏚猄': {-1215153173: '\u0018GC}/\u0014xG\u000E'}}, v2=0x80ba59d39a0c,
v3=({false: 'T*%\u0003\u0007|7\u007F\u0009', true: '2Jo'}, (0xd621c8a7cb),
0x00000000000046008100000000000000), v4=false WHERE pk0 = 4531198082496131334
AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 =
'1972-10-03T16:40:31.918Z' AND ck1 = -1.40556385E18 -- on node1
298: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf') -- by
token, on node1, fetch size 1000
299: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') LIMIT 40
-- by token, on node1, fetch size 1000
300: SELECT * FROM ks1.tbl WHERE v1 = {'旰퐀늒㧩鮩鉓澴巏聽丰':
{-1708634768: '^\u001AV\u0002', 782702699: '\u0016\u001F"*$\u000E?_Y',
1643123268: '\u000D'}} AND pk0 = -3861597867664806948 AND v3 = ({true:
'X\u0002\QE{,'}, (0x18fc3fe2987dc6), 0x0000000000004a008300000000000000) AND s1
= false AND v4 = false AND s0 = {{'+\u0007'}:
{00000000-0000-4300-ab00-000000000000: 0x7d73709dc25c57}, {'X\u0014>'}:
{00000000-0000-4a00-a300-000000000000: 0x428285d75187212b8431}} AND pk1 =
'2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' AND v0 = '\u000A mfm/^G\u000CkEW7'
AND v2 = 0x449a1a7e9e44bda70fd5 AND ck1 = -Infinity AND ck0 =
'2009-10-27T15:44:11.844Z' LIMIT 240 ALLOW FILTERING -- v1 frozen<map<text,
frozen<map<int, ascii>>>> (indexed with SAI), pk0 bigint (indexed with SAI), v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>> (indexed with SAI), s1
boolean (indexed with SAI), v4 boolean (indexed with SAI), s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI),
pk1 inet (indexed with SAI), v0 ascii (indexed with SAI), v2 blob, ck1 float
(indexed with SAI), ck0 timestamp (reversed) (indexed with SAI), on node1,
fetch size 1
301: SELECT * FROM ks1.tbl WHERE v1 = {'൸忪䌎ﺃ': {-143792787:
'\u0000iv', 292993448: 'E', 1107438888: 'MSJBI-'}} AND ck0 =
'2035-06-13T19:57:35.817Z' AND s1 = false AND ck1 = -2.7198392E37 AND s0 =
{{'6', 'a0'}: {00000000-0000-4100-9400-000000000000: 0xee27,
00000000-0000-4900-a000-000000000000: 0xe00a2e,
00000000-0000-4a00-9c00-000000000000: 0xe5abb48aaaa6}, {'@T;egM+'}:
{00000000-0000-4500-b900-000000000000: 0xe9,
00000000-0000-4d00-bb00-000000000000: 0xc1be0fe3d69a373d8391}} AND v3 =
({false: 'T*%\u0003\u0007|7\u007F\u0009', true: '2Jo'}, (0xd621c8a7cb),
0x00000000000046008100000000000000) AND v0 = '\u000A mfm/^G\u000CkEW7' ALLOW
FILTERING -- v1 frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI),
ck0 timestamp (reversed) (indexed with SAI), s1 boolean (indexed with SAI), ck1
float (indexed with SAI), s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid,
blob>>>> (indexed with SAI), v3 frozen<tuple<frozen<map<boolean, ascii>>,
frozen<tuple<blob>>, 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>
(indexed with SAI), v0 ascii (indexed with SAI), on node1
302: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf') LIMIT 106
-- by token, on node1
303: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 613 -- by token, on node1,
fetch size 5000
304: SELECT * FROM ks1.tbl WHERE ck1 = 3.568358E-29 AND s0 =
{{'\u000B\u0006V\u000C\u0016'}: {00000000-0000-4600-9700-000000000000:
0x85ad0286, 00000000-0000-4d00-9700-000000000000: 0x4c325776}} LIMIT 237 ALLOW
FILTERING -- ck1 float (indexed with SAI), s0 frozen<map<frozen<set<ascii>>,
frozen<map<uuid, blob>>>> (indexed with SAI), on node1, fetch size 1000
305: SELECT * FROM ks1.tbl WHERE ck0 <=
'1985-03-03T02:33:37.458Z' LIMIT 780 -- ck0 timestamp (reversed), indexed with
SAI, on node1
306: SELECT * FROM ks1.tbl WHERE s0 =
{{'\u000B\u0006V\u000C\u0016'}: {00000000-0000-4600-9700-000000000000:
0x85ad0286, 00000000-0000-4d00-9700-000000000000: 0x4c325776}} AND ck1 =
-1.40556385E18 AND s1 = true AND ck0 = '2070-06-16T22:53:02.076Z' AND v1 =
{'㣤?匿': {-1879255062: '\u001F)<\u001C', 403598347: '3=\u0012~]\u0008\u0003',
778810263: 'K'}} AND v2 = 0x6213601a76e7 ALLOW FILTERING -- s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI),
ck1 float (indexed with SAI), s1 boolean (indexed with SAI), ck0 timestamp
(reversed) (indexed with SAI), v1 frozen<map<text, frozen<map<int, ascii>>>>
(indexed with SAI), v2 blob, on node1, fetch size 100
307: SELECT * FROM ks1.tbl WHERE pk0 = 5778883423090972680 AND
pk1 = '133.53.176.75' AND ck0 = '2048-12-02T03:21:06.544Z' AND ck1 =
2.89648622E16 -- By Primary Key, on node1, fetch size 10
308: UPDATE ks1.tbl USING TIMESTAMP 45 SET s0=null, s1=true,
v0='U43\u0005>W\u001D[9' + 'k', v1={'ሁ⁕嫐뻧拼䵪': {-1169885471: 'Q\u000E',
1117608355: 'J_\u000Da@ 4up@'}, '蘆⃧㒳⊣': {683388463:
'\u0009&\u0013R\u000DY\u0013', 2113137280: 'S]#&$y-\u000DQ\u0014'}},
v2=0xbdf648befde5d38adf, v3=({false: 'WW\u000CPa\u0014', true: 'm\u0000 '},
(0x67), 0x00000000000010009e00000000000000), v4=null WHERE pk0 =
4531198082496131334 AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND
ck0 = '1979-06-02T01:29:54.402Z' AND ck1 = 1.1004538E23 - -6.6955756E-35 -- on
node1
309: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, s1, v0, v1,
v2, v3, v4) VALUES (133647749441392509,
'2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf', '2018-07-01T10:12:06.548Z',
-4.8821006E-4, null, true, null, {'攎ڕ볚裞觶濌骭靰': {-832273966: '+D\u0018',
718663405: '\u0019G0\u00134K&'}}, 0x99100efbd7879958, ({false:
'}wRgRibB\u0010'}, (0x91), 0x0000000000001400a900000000000000), true) USING
TIMESTAMP 46 -- on node1
310: UPDATE ks1.tbl USING TIMESTAMP 47 SET s0=null, s1=true,
v0='7@}\u0014 y' + 'E{f\u001D7.r\u0019', v1={'ટᡒ攨ꑅ䃙': {-1830617307:
'"O=lN\u0006N', -126346151: '8YD0Zt', 2062351769: '\u0012'}, 'ᤠ旘祣ꬑ':
{862872725: '\u00038*V\u0018', 1597611063: '\u0017.9X\u001B8j', 1649580921:
'~krx\u001C'}, '넉䷠ጵ': {-1052328401: '6\u0017E\u0019\u0000M', 16961037:
'%xq?0~', 60164399: '\u000F'}}, v2=0xce, v3=({false: '\u0008\u0004y\u0019R$'},
(0xe8365d), 0x0000000000004100a800000000000000), v4=true WHERE pk0 =
5778883423090972680 AND pk1 = '133.53.176.75' AND ck0 =
'2037-06-11T03:43:25.302Z' AND ck1 = -5.7324684E7 -- on node1
311: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5666087756057021160, 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e') -- by
token, on node1, fetch size 1000
312: DELETE s0 FROM ks1.tbl USING TIMESTAMP 48 WHERE pk0 =
-9123548823949921683 AND pk1 = '39f6:e7f6:7a60:6de:4664:768b:6d00:647e' -- on
node1
313: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v1, s0) VALUES
(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf',
'2000-06-05T14:43:29.408Z', 268.07504, {'合ౘὮʦȿ䠲㧻溹鹯': {1226325569:
'U=\u0001`C{'}}, {{'\u001C'}: {00000000-0000-4d00-b600-000000000000: 0x14a230},
{'/', 'DK\u0009', 'c\u0012C3P'}: {00000000-0000-4300-8100-000000000000: 0x5a12,
00000000-0000-4a00-a600-000000000000: 0xc60e7f8f4ca94839c85e}}) USING TIMESTAMP
49 -- on node1
314: SELECT * FROM ks1.tbl WHERE ck1 >= 3.568358E-29 LIMIT 136
-- ck1 float, indexed with SAI, on node1, fetch size 100
315: SELECT * FROM ks1.tbl WHERE v2 <= 0xcdf6 LIMIT 807 ALLOW
FILTERING -- v2 blob, on node1, fetch size 5000
316: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0, v3, s0)
VALUES (4531198082496131334, 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220',
'2048-01-04T21:49:02.254Z', -4.492089E29, 'C3d4$f\u0007i' + 'P\u000E4C\u0014',
({false: 'f{4F', true: '\u000A`O\u0008\u0007'}, (0x0f),
0x0000000000004d009e00000000000000), {{'\u0015M\u0017', '#\u000AyyTaK',
';\u001A+\u000ADN'}: {00000000-0000-4200-8200-000000000000: 0x2bb32759f2,
00000000-0000-4800-ba00-000000000000: 0x1d9b2c60afc1927b4741,
00000000-0000-4900-a300-000000000000: 0xd823423ab6ec},
{'\u001C\u000FxO\u000Ac', 'NWV\u000Dz', 'O\u000DPSr'}:
{00000000-0000-4500-ae00-000000000000: 0x6fe89521ae2c2f}}) USING TIMESTAMP 50
-- on node1
317: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') -- by token, on node1, fetch
size 10
318: SELECT * FROM ks1.tbl WHERE v2 = 0xb31d3f60755e220c958b
AND s1 = true AND pk0 = -7092676947467875356 AND ck0 =
'1976-08-20T06:13:02.612Z' AND s0 = {{'\u000B\u0006V\u000C\u0016'}:
{00000000-0000-4600-9700-000000000000: 0x85ad0286,
00000000-0000-4d00-9700-000000000000: 0x4c325776}} AND v1 = {'㼋뚢䀅Ắ얎ἴꆋ':
{-666399047: '>qF+\u00169^P19', -115322575: '\u0009+ '}, '䤅므좗': {-178519468:
'N'}, '튁雞㥿?롂搠芭': {-1653897345: '%', 1449972426: '\u0007n'}} AND v3 =
({false: 'H4\u000E*', true: '\u001E@_}I9\u0018\u0011'}, (0x84718214),
0x0000000000004d009600000000000000) AND ck1 = -5.014118E27 LIMIT 22 ALLOW
FILTERING -- v2 blob, s1 boolean (indexed with SAI), pk0 bigint (indexed with
SAI), ck0 timestamp (reversed) (indexed with SAI), s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI), v1
frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI), v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>> (indexed with SAI), ck1
float (indexed with SAI), on node1, fetch size 1000
319: nodetool flush ks1 tbl
320: SELECT * FROM ks1.tbl WHERE v2 = 0x6c39 AND s0 =
{{'\u000B\u0006V\u000C\u0016'}: {00000000-0000-4600-9700-000000000000:
0x85ad0286, 00000000-0000-4d00-9700-000000000000: 0x4c325776}} AND pk1 =
'133.53.176.75' AND v0 = '\u000AMhrFT\]' AND v1 = {'唟鳙崌諼탪': {-2085359588:
'{sj''', -1797268160: 'V', -628914991: 'vWq\u001C*^Vl'}, '뤞': {-1007005130:
'J[\u0005}', 20462633: 'yAB~\u001E\u0013wmJ', 1814551038:
'\u0019pLR?2I\u001F'}, '컳눟罡䌲崴쿞?菸⏚猄': {-1215153173: '\u0018GC}/\u0014xG\u000E'}}
LIMIT 334 ALLOW FILTERING -- v2 blob, s0 frozen<map<frozen<set<ascii>>,
frozen<map<uuid, blob>>>> (indexed with SAI), pk1 inet (indexed with SAI), v0
ascii (indexed with SAI), v1 frozen<map<text, frozen<map<int, ascii>>>>
(indexed with SAI), on node1, fetch size 5000
321: SELECT * FROM ks1.tbl WHERE v2 = 0x99100efbd7879958 LIMIT
10 ALLOW FILTERING -- v2 blob, on node1
322: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5778883423090972680, '133.53.176.75') LIMIT 35 -- by token, on node1,
fetch size 5000
323: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(4531198082496131334, 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220') AND
token(pk0, pk1) <= token(-7092676947467875356,
'37de:45bf:1239:7766:cbe2:e333:efab:d3c6') LIMIT 56 -- by token range, on
node1, fetch size 100
324: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 =
'1974-06-27T16:34:57.828Z' AND ck1 = -4.1116237E-15 LIMIT 65 -- By Primary Key,
on node1, fetch size 1000
325: UPDATE ks1.tbl USING TIMESTAMP 51 SET s0={{'6%'}:
{00000000-0000-4800-9700-000000000000: 0x4a54,
00000000-0000-4a00-b400-000000000000: 0xb62821f9367ab453dd,
00000000-0000-4b00-9200-000000000000: 0x11}, {'^', 'kt\u0016',
'p\u0006\u001E'}: {00000000-0000-4f00-a200-000000000000: 0x7fb32535}}, s1=true,
v0='93+\u0003qSt\u000FH' + '\u0017^Qe]|\u0000F=', v1={'ᒔ⥎뉿': {-764131561:
'\u0017\u001E'}}, v2=0xb1, v3=({false: '7\u001DcNM\u000C<"d'}, (0xcece75),
0x0000000000001d009b00000000000000), v4=true WHERE pk0 = 4531198082496131334
AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 =
'2016-01-03T03:26:46.387Z' AND ck1 = 946.1549 * 3.2914427E32 -- on node1
326: SELECT * FROM ks1.tbl WHERE v3 = ({true: 'X\u0002\QE{,'},
(0x18fc3fe2987dc6), 0x0000000000004a008300000000000000) ALLOW FILTERING -- v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>>, indexed with SAI, on node1
327: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 =
'2070-06-16T22:53:02.076Z' AND ck1 = 3.568358E-29 LIMIT 495 -- By Primary Key,
on node1, fetch size 1000
328: SELECT * FROM ks1.tbl WHERE ck1 < -Infinity LIMIT 255 --
ck1 float, indexed with SAI, on node1, fetch size 1
329: SELECT * FROM ks1.tbl WHERE v1 = {'旰퐀늒㧩鮩鉓澴巏聽丰':
{-1708634768: '^\u001AV\u0002', 782702699: '\u0016\u001F"*$\u000E?_Y',
1643123268: '\u000D'}} AND v4 = true AND s1 = false AND s0 = {{'6%'}:
{00000000-0000-4800-9700-000000000000: 0x4a54,
00000000-0000-4a00-b400-000000000000: 0xb62821f9367ab453dd,
00000000-0000-4b00-9200-000000000000: 0x11}, {'^', 'kt\u0016',
'p\u0006\u001E'}: {00000000-0000-4f00-a200-000000000000: 0x7fb32535}} AND ck1 =
-6.483759E20 AND pk0 = 5666087756057021160 LIMIT 124 ALLOW FILTERING -- v1
frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI), v4 boolean
(indexed with SAI), s1 boolean (indexed with SAI), s0
frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>> (indexed with SAI),
ck1 float (indexed with SAI), pk0 bigint (indexed with SAI), on node1, fetch
size 10
330: SELECT * FROM ks1.tbl WHERE v0 = '\u000A mfm/^G\u000CkEW7'
AND v2 = 0x5def LIMIT 65 ALLOW FILTERING -- v0 ascii (indexed with SAI), v2
blob, on node1, fetch size 1000
331: SELECT * FROM ks1.tbl WHERE pk0 = 4531198082496131334 AND
pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND ck0 =
'1972-10-03T16:40:31.918Z' AND ck1 = -1.40556385E18 LIMIT 964 -- By Primary
Key, on node1, fetch size 10
332: SELECT * FROM ks1.tbl WHERE pk0 = 133647749441392509 LIMIT
137 -- pk0 bigint, indexed with SAI, on node1, fetch size 1
333: SELECT * FROM ks1.tbl WHERE v1 = {'൸忪䌎ﺃ': {-143792787:
'\u0000iv', 292993448: 'E', 1107438888: 'MSJBI-'}} AND pk1 = '174.128.216.143'
AND v0 = '\u001BVwJ@^f`o' AND v3 = ({false: '\u0006\u000Cp.V?\u0005', true:
'\u000B\u001A'}, (0x6d53eb), 0x00000000000042009500000000000000) AND ck0 =
'1979-06-02T01:29:54.402Z' AND pk0 = 4531198082496131334 AND s1 = true AND s0 =
{{'\u001C'}: {00000000-0000-4d00-b600-000000000000: 0x14a230}, {'/',
'DK\u0009', 'c\u0012C3P'}: {00000000-0000-4300-8100-000000000000: 0x5a12,
00000000-0000-4a00-a600-000000000000: 0xc60e7f8f4ca94839c85e}} LIMIT 404 ALLOW
FILTERING -- v1 frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI),
pk1 inet (indexed with SAI), v0 ascii (indexed with SAI), v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>> (indexed with SAI), ck0
timestamp (reversed) (indexed with SAI), pk0 bigint (indexed with SAI), s1
boolean (indexed with SAI), s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid,
blob>>>> (indexed with SAI), on node1, fetch size 5000
334: SELECT * FROM ks1.tbl WHERE s0 = {{'\u001C'}:
{00000000-0000-4d00-b600-000000000000: 0x14a230}, {'/', 'DK\u0009',
'c\u0012C3P'}: {00000000-0000-4300-8100-000000000000: 0x5a12,
00000000-0000-4a00-a600-000000000000: 0xc60e7f8f4ca94839c85e}} AND v0 =
'C3d4$f\u0007iP\u000E4C\u0014' AND s1 = false AND ck0 =
'2018-07-01T10:12:06.548Z' AND v4 = false AND v1 = {'됗': {-747484893:
'S1\u0000T-', -119735017: '/As)mL'}, 'ﺔ髖': {255259436: '!;', 1378995470:
'bZc>QAJ'}} AND v2 = 0x99100efbd7879958 AND pk0 = 5778883423090972680 AND v3 =
({false: '\u001F'}, (0xbb02), 0x0000000000004400b900000000000000) LIMIT 59
ALLOW FILTERING -- s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid, blob>>>>
(indexed with SAI), v0 ascii (indexed with SAI), s1 boolean (indexed with SAI),
ck0 timestamp (reversed) (indexed with SAI), v4 boolean (indexed with SAI), v1
frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI), v2 blob, pk0
bigint (indexed with SAI), v3 frozen<tuple<frozen<map<boolean, ascii>>,
frozen<tuple<blob>>, 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>
(indexed with SAI), on node1
335: SELECT * FROM ks1.tbl WHERE v1 = {'ટᡒ攨ꑅ䃙': {-1830617307:
'"O=lN\u0006N', -126346151: '8YD0Zt', 2062351769: '\u0012'}, 'ᤠ旘祣ꬑ':
{862872725: '\u00038*V\u0018', 1597611063: '\u0017.9X\u001B8j', 1649580921:
'~krx\u001C'}, '넉䷠ጵ': {-1052328401: '6\u0017E\u0019\u0000M', 16961037:
'%xq?0~', 60164399: '\u000F'}} LIMIT 219 ALLOW FILTERING -- v1 frozen<map<text,
frozen<map<int, ascii>>>>, indexed with SAI, on node1, fetch size 10
336: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(5778883423090972680, '133.53.176.75') LIMIT 25 -- by token, on node1,
fetch size 1000
337: SELECT * FROM ks1.tbl WHERE v4 >= false LIMIT 270 ALLOW
FILTERING -- v4 boolean, indexed with SAI, on node1, fetch size 1
338: DELETE FROM ks1.tbl USING TIMESTAMP 52 WHERE pk0 =
5778883423090972680 AND pk1 = '133.53.176.75' -- on node1
339: SELECT * FROM ks1.tbl WHERE pk1 =
'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' LIMIT 515 -- pk1 inet, indexed with
SAI, on node1, fetch size 1000
340: SELECT * FROM ks1.tbl WHERE pk0 = 5666087756057021160 AND
pk1 = 'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e' AND v3 = ({false: '1\u000C'},
(0x4b4f2d), 0x00000000000016009200000000000000) ALLOW FILTERING -- v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>>, indexed with SAI, on
node1, fetch size 5000
341: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v1, v0, v4,
v3, s1) VALUES (-3861597867664806948, '174.128.216.143',
'1975-01-12T20:49:17.984Z', -5.5057644E31, {{'/aAK', '@h\u0018\e\u000E'}:
{00000000-0000-4a00-b800-000000000000: 0x97}, {':S'}:
{00000000-0000-4900-9d00-000000000000: 0x2c80a2c01049,
00000000-0000-4a00-af00-000000000000: 0x70ed896b53543b9517},
{'EuH\Q7\u000FkqM', 'W', 'c'}: {00000000-0000-4800-a100-000000000000: 0x9a,
00000000-0000-4b00-9500-000000000000: 0xc6d431,
00000000-0000-4c00-a800-000000000000: 0xba}}, {'숹甅륞壣ȱ쭟㿬┢峺': {1528489141:
'i98B~'}}, '"''\u0011+CD', true, ({false: 'AR3_', true: 'w9\u0006t\u000A'},
(0xb267acce), 0x0000000000004400aa00000000000000), true) USING TIMESTAMP 53 --
on node1
342: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 48 -- by token, on node1
343: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf') LIMIT 253
-- by token, on node1, fetch size 10
344: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(-3861597867664806948, '174.128.216.143') LIMIT 1000 -- by token, on
node1, fetch size 10
345: SELECT * FROM ks1.tbl WHERE pk0 = -7092676947467875356 AND
pk1 = '37de:45bf:1239:7766:cbe2:e333:efab:d3c6' -- By Partition Key, on node1,
fetch size 1
346: SELECT * FROM ks1.tbl LIMIT 126 -- full table scan, on
node1, fetch size 100
347: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v2, s1, v1, s0,
v3) VALUES (1268506666581209403, '132.255.72.44', '2045-12-20T14:37:33.741Z',
-4.22257294E14, 0xe3f80a2c48a710915b, false, {'᎗唞㽙': {-1325658629: '&',
678406237: ' ?~x4', 853734333: '\u0007rq\u0018'}, '⨐뼀꒭䝻⳿筶酇栾': {-1558897765:
'7b)\u0015r\u0011.^', -236653648: 'k{\u0013\u001E\u0003}'}, '珀': {-1063623114:
'&"v\-N', -277436422: '\u000BK\u000A\u000A\u0012', -263418590:
'\u001Bm6\u000E\u000C'}}, {{'\u0005"}K\u000CdNJ{N', '\u0014<=ZH<5\u000Ek',
'[%dByF\u0000'}: {00000000-0000-4c00-8a00-000000000000: 0x8a10}, {'Er', 'cz@'}:
{00000000-0000-4600-be00-000000000000: 0x90f1c1f82a44ed,
00000000-0000-4c00-9800-000000000000: 0x73dd3fe75bc09e95b0,
00000000-0000-4d00-9100-000000000000: 0xf7bb29a163fe18d1}, {'Z',
'ry\u0008\u0018C%U'}: {00000000-0000-4200-b600-000000000000: 0x2a439bf1fa5b,
00000000-0000-4700-be00-000000000000: 0x4efb8cf3b2bde5f254c5,
00000000-0000-4d00-8800-000000000000: 0x5f}}, ({true: '\\u000D\u000AC\u0006r'},
(0xe0bc74f0), 0x0000000000001200b400000000000000)) USING TIMESTAMP 54 -- on
node1
348: SELECT * FROM ks1.tbl WHERE s1 = false AND pk1 =
'174.128.216.143' AND s0 = {{'6%'}: {00000000-0000-4800-9700-000000000000:
0x4a54, 00000000-0000-4a00-b400-000000000000: 0xb62821f9367ab453dd,
00000000-0000-4b00-9200-000000000000: 0x11}, {'^', 'kt\u0016',
'p\u0006\u001E'}: {00000000-0000-4f00-a200-000000000000: 0x7fb32535}} AND ck1 =
-0.007264097 LIMIT 47 ALLOW FILTERING -- s1 boolean (indexed with SAI), pk1
inet (indexed with SAI), s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid,
blob>>>> (indexed with SAI), ck1 float (indexed with SAI), on node1, fetch size
100
349: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v3) VALUES
(4531198082496131334, 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220',
'2060-08-27T04:28:41.821Z', 6.2783723E29, ({false: '\u001B?2', true:
'pow\u0006\'}, (0xcdcb78f828d57f2895), 0x0000000000001b00a000000000000000))
USING TIMESTAMP 55 -- on node1
350: SELECT * FROM ks1.tbl WHERE pk0 = -3861597867664806948 AND
pk1 = '174.128.216.143' AND ck0 = '2009-10-27T15:44:11.844Z' AND ck1 =
-6.483759E20 -- By Primary Key, on node1, fetch size 10
351: SELECT * FROM ks1.tbl WHERE s1 > true LIMIT 39 ALLOW
FILTERING -- s1 boolean, indexed with SAI, on node1, fetch size 1
352: UPDATE ks1.tbl USING TIMESTAMP 56 SET s0=null, s1=false,
v0='XwX', v1={'ᙺ砽涐鲧ꔶ駛쪦ɇ': {-340328726: '\u001D@\u000Fe\u0010\u0018cODN',
735010123: '['}, '즨㽦ᖻ䷶撏': {-771566623: 'O%*)` \u0008"', 278612268:
'@\u0000^\u0015{'}}, v2=0x54673422d308af56, v3=({false: '!\u0013j'},
(0x3bb4af), 0x00000000000018008100000000000000), v4=false WHERE pk0 =
4531198082496131334 AND pk1 = 'ba3c:4470:8cbc:2c81:5e2b:590f:f1e3:8220' AND
ck0 = '1996-12-23T21:32:03.829Z' AND ck1 = -6.3866997E-22 - 5.0440876E7 -- on
node1
353: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, s1, v0, v1,
v2, v3, v4) VALUES (5666087756057021160,
'f82d:55e9:af2a:21f0:fe83:bac8:825:2a1e', '2066-10-31T12:23:58.162Z',
-6.1614457E27 + -4.2272378E-32, {{'\u0005u/!rSi\u0004:', '//', 'G?\u000E
z\u0014'}: {00000000-0000-4800-8600-000000000000: 0xc27c3469be,
00000000-0000-4e00-8200-000000000000: 0x95}, {'\u0008*\u0003@J', '($<\u0010'}:
{00000000-0000-4100-ad00-000000000000: 0xb8d2653ef6,
00000000-0000-4d00-b900-000000000000: 0x3e46258aa265642abc8b},
{'\u0010qw\u0014\u000Ee\u0004Cr\u000D'}: {00000000-0000-4600-ac00-000000000000:
0x7942ba3b, 00000000-0000-4b00-8200-000000000000: 0x8ded226b834c9b1e,
00000000-0000-4f00-a700-000000000000: 0xaaf2eae5cc83b419a1}}, true, '\u0014',
{'Ӥ跣龃숱摺䣜ബ鏙䥤㊖': {767943604: '\u0001%4\7Mv+\u000E', 964913708:
'\u001F8BYU\u001Bjg\u007F'}, 'ိ䷛': {452912174: 'tX.\u001C\u0017P\u000B',
742420226: 'I/', 1101396890: 'Z85Z-'}, '䜷貿籎븨왶玹蓎': {-1442904666:
'\u0000`\u0015'}}, 0xabb5ac3558, ({false: ':|Sk \u0006?7}M'},
(0x61c6efdb9a7adfb4c5), 0x00000000000010008400000000000000), null) USING
TIMESTAMP 57 -- on node1
354: SELECT * FROM ks1.tbl WHERE s0 = {{'/aAK',
'@h\u0018\e\u000E'}: {00000000-0000-4a00-b800-000000000000: 0x97}, {':S'}:
{00000000-0000-4900-9d00-000000000000: 0x2c80a2c01049,
00000000-0000-4a00-af00-000000000000: 0x70ed896b53543b9517},
{'EuH\Q7\u000FkqM', 'W', 'c'}: {00000000-0000-4800-a100-000000000000: 0x9a,
00000000-0000-4b00-9500-000000000000: 0xc6d431,
00000000-0000-4c00-a800-000000000000: 0xba}} AND pk1 =
'37de:45bf:1239:7766:cbe2:e333:efab:d3c6' AND v0 = '\u001E\u000DmH=sA X\u000C'
AND pk0 = -3861597867664806948 AND ck0 = '2045-12-20T14:37:33.741Z' AND v1 =
{'숹甅륞壣ȱ쭟㿬┢峺': {1528489141: 'i98B~'}} AND v4 = true AND ck1 = 6.837532E28 LIMIT
98 ALLOW FILTERING -- s0 frozen<map<frozen<set<ascii>>, frozen<map<uuid,
blob>>>> (indexed with SAI), pk1 inet (indexed with SAI), v0 ascii (indexed
with SAI), pk0 bigint (indexed with SAI), ck0 timestamp (reversed) (indexed
with SAI), v1 frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI), v4
boolean (indexed with SAI), ck1 float (indexed with SAI), on node1, fetch size
1000
355: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(1268506666581209403, '132.255.72.44') LIMIT 936 -- by token, on node1,
fetch size 100
356: nodetool flush ks1 tbl
357: SELECT * FROM ks1.tbl WHERE pk1 = '174.128.216.143' AND v3
= ({false: '\u000E![\u0016&=\u0006\u0001', true: '0M9\u0019\u001E\u0013'},
(0x9fe25c5e), 0x0000000000001a00bb00000000000000) AND v1 = {'攎ڕ볚裞觶濌骭靰':
{-832273966: '+D\u0018', 718663405: '\u0019G0\u00134K&'}} AND s1 = true AND v4
= true ALLOW FILTERING -- pk1 inet (indexed with SAI), v3
frozen<tuple<frozen<map<boolean, ascii>>, frozen<tuple<blob>>,
'org.apache.cassandra.db.marshal.LexicalUUIDType'>> (indexed with SAI), v1
frozen<map<text, frozen<map<int, ascii>>>> (indexed with SAI), s1 boolean
(indexed with SAI), v4 boolean (indexed with SAI), on node1, fetch size 10
358: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(133647749441392509, '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf') LIMIT 597
-- by token, on node1
359: UPDATE ks1.tbl USING TIMESTAMP 58 SET s0={{'rT'}:
{00000000-0000-4500-9900-000000000000: 0x5d1b5c,
00000000-0000-4a00-a800-000000000000: 0x736227e8cc83c7ca3d93}}, s1=false,
v0='\u001F?\u001DH', v1={'砎Ṁ': {1872328433: 'b~\u001A2', 2054030647:
'9}x\u0002'}, '죆딽욪៴⮶⦦웳⳺?': {-749831150: 'bDyt\u000C''\u0016\u0006', 221289580:
'\u000Ei?WVnV'}}, v2=0xe1b0d2bdfe404d51, v3=({true: 'V3)n\u001DLA@'},
(0x15c050bf774734), 0x0000000000004200af00000000000000), v4=false WHERE pk0 =
-3861597867664806948 AND pk1 = '174.128.216.143' AND ck0 =
'2003-12-26T14:51:29.201Z' AND ck1 = -4.818851E-17 -- on node1
360: UPDATE ks1.tbl USING TIMESTAMP 59 SET v3=({false:
'9Jx\u0017\u0012\:', true: '\u0005'}, (0x0d8061a83a),
0x0000000000001f00aa00000000000000), v2=0xcae4d88effdd311d4e53, v1={',⋼㙈텷':
{-1471545175: 'sQn\u000B\u0016\u0014W+P\u0000', -1382962855: 'Gdn|go',
1159517202: '^4G#'}, '炆뷝忬': {-1309419211: 'b$\u000D\u0011'}}, s0={{'\\u0008s',
't33i)\u0006vo'}: {00000000-0000-4400-aa00-000000000000: 0x14fca66fb9030048,
00000000-0000-4600-8300-000000000000: 0x4c32fc3542f769,
00000000-0000-4c00-bf00-000000000000: 0xa3ed696e6112f605}, {'^'}:
{00000000-0000-4900-b900-000000000000: 0xcc3939d24ec27a}, {'c\u0019p+',
'j:\u0001J$!', 'j{];hf\u000B,\u0003 '}: {00000000-0000-4400-9400-000000000000:
0x71d3a7, 00000000-0000-4f00-a200-000000000000: 0xc290bea7db9fa8}} WHERE pk0 =
-7092676947467875356 AND pk1 = '37de:45bf:1239:7766:cbe2:e333:efab:d3c6' AND
ck0 = '2029-01-05T09:06:05.995Z' AND ck1 = -6.473332E7 * 3.362848E-32 -- on
node1
361: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(-7092676947467875356, '37de:45bf:1239:7766:cbe2:e333:efab:d3c6') AND
token(pk0, pk1) < token(1268506666581209403, '132.255.72.44') LIMIT 17 -- by
token range, on node1, fetch size 10
362: SELECT * FROM ks1.tbl WHERE pk1 =
'2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' AND s1 = true AND v4 = true ALLOW
FILTERING -- pk1 inet (indexed with SAI), s1 boolean (indexed with SAI), v4
boolean (indexed with SAI), on node1, fetch size 1000
at accord.utils.Property$StatefulBuilder.check(Property.java:504)
at
org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.test(SingleNodeTableWalkTest.java:369)
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 pk1 = '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' AND s1 =
true AND v4 = true ALLOW FILTERING
Caused by: java.lang.AssertionError: Missing rows:
pk0 | pk1 | ck0
| ck1 | s0
| s1
| v0 | v1 | v2 | v3 | v4
133647749441392509 | '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' |
'1995-01-24T00:52:42.129Z' | 3.6624246E31 | {{'\u001C'}:
{00000000-0000-4d00-b600-000000000000: 0x14a230}, {'/', 'DK\u0009',
'c\u0012C3P'}: {00000000-0000-4300-8100-000000000000: 0x5a12,
00000000-0000-4a00-a600-000000000000: 0xc60e7f8f4ca94839c85e}} | true | null |
null | null | null | true
Expected:
pk0 | pk1 | ck0
| ck1 | s0
|
s1 | v0 | v1
| v2 | v3
| v4
133647749441392509 | '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' |
'1995-01-24T00:52:42.129Z' | 3.6624246E31 | {{'\u001C'}:
{00000000-0000-4d00-b600-000000000000: 0x14a230}, {'/', 'DK\u0009',
'c\u0012C3P'}: {00000000-0000-4300-8100-000000000000: 0x5a12,
00000000-0000-4a00-a600-000000000000: 0xc60e7f8f4ca94839c85e}} | true | null |
null | null
| null
| true
133647749441392509 | '2370:9d7d:1654:7694:42de:6a3c:30fe:e8bf' |
'2018-07-01T10:12:06.548Z' | -4.8821006E-4 | {{'\u001C'}:
{00000000-0000-4d00-b600-000000000000: 0x14a230}, {'/', 'DK\u0009',
'c\u0012C3P'}: {00000000-0000-4300-8100-000000000000: 0x5a12,
00000000-0000-4a00-a600-000000000000: 0xc60e7f8f4ca94839c85e}} | true | null |
{'攎ڕ볚裞觶濌骭靰': {-832273966: '+D\u0018', 718663405: '\u0019G0\u00134K&'}} |
0x99100efbd7879958 | ({false: '}wRgRibB\u0010'}, (0x91),
0x0000000000001400a900000000000000) | true
{code}
> Another single-node possibly static column-related SAI missing row issue
> (will update title when root cause is clear)
> ---------------------------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-20338
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20338
> Project: Apache Cassandra
> Issue Type: Bug
> Components: Feature/SAI
> Reporter: Caleb Rackliffe
> Assignee: Caleb Rackliffe
> Priority: Normal
> Fix For: 5.0.x, 5.x
>
>
> Running {{SingleNodeTableWalkTest}}...
> {noformat}
> accord.utils.Property$PropertyError: Property error detected:
> Seed = -4570870071359163365
> Examples = 2147483647
> Pure = true
> Error: Unexpected results for query: SELECT * FROM ks1.tbl WHERE s1 = true
> AND v2 = 0x0000000000001d008e00000000000000 AND pk0 = 1.0844396412062203E195
> ALLOW FILTERING
> {noformat}
> {noformat}
> Steps: 400
> Values:
> State:
> Setup:
> CREATE KEYSPACE IF NOT EXISTS ks1 WITH replication = {'class':
> 'SimpleStrategy', 'replication_factor': 1};
> CREATE TABLE ks1.tbl (
> pk0 double,
> pk1 text,
> ck0 ascii,
> s0 time static,
> s1 boolean static,
> v0 varint,
> v1 bigint,
> v2 'org.apache.cassandra.db.marshal.LexicalUUIDType',
> v3 double,
> v4 ascii,
> PRIMARY KEY ((pk0, pk1), ck0)
> ) WITH CLUSTERING ORDER BY (ck0 ASC);
> CREATE INDEX tbl_pk0 ON ks1.tbl(pk0) USING 'SAI';
> CREATE CUSTOM INDEX tbl_pk1 ON ks1.tbl(pk1) USING
> 'StorageAttachedIndex';
> CREATE CUSTOM INDEX tbl_ck0 ON ks1.tbl(ck0) USING
> 'StorageAttachedIndex';
> CREATE CUSTOM INDEX tbl_s0 ON ks1.tbl(s0) USING
> 'StorageAttachedIndex';
> CREATE CUSTOM INDEX tbl_s1 ON ks1.tbl(s1) USING
> 'StorageAttachedIndex';
> CREATE INDEX tbl_v0 ON ks1.tbl(v0) USING 'SAI';
> CREATE INDEX tbl_v1 ON ks1.tbl(v1) USING 'SAI';
> CREATE CUSTOM INDEX tbl_v3 ON ks1.tbl(v3) USING
> 'StorageAttachedIndex';
> CREATE INDEX tbl_v4 ON ks1.tbl(v4) USING 'SAI';:
> org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.State
>
> History:
> 6: DELETE FROM ks1.tbl USING TIMESTAMP 1 WHERE pk0 =
> 1.0844396412062203E195 AND pk1 = '蚨㡦Ɱ擳麗㾢鉦鵅' AND ck0 =
> 'EkOjIqy\u000F4\u007F' -- on node1
> 9: INSERT INTO ks1.tbl (pk0, pk1, ck0, v3, v4) VALUES
> (-5.332164051882835E-118, 'ﷻṮ', '\u000DT\u007F}P', 2.1518964658843966E-154,
> '#)') USING TIMESTAMP 2 -- on node1
> 91: DELETE FROM ks1.tbl USING TIMESTAMP 3 WHERE pk0 =
> -5.332164051882835E-118 AND pk1 = 'ﷻṮ' AND ck0 = 'Z' + 'Zl' -- on node1
> 129: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, s1, v0, v1, v2,
> v3, v4) VALUES (1.0844396412062203E195, '蚨㡦Ɱ擳麗㾢鉦鵅', 'Q',
> '14:59:24.557825178', false, 21 * -126, -3909575580531410414,
> 0x0000000000001d008e00000000000000, 1.3611534850564156E135 -
> -1.3619298083760226E-178, '0c\u0011?\u007Fm[' + 'on]50h') USING TIMESTAMP 4
> -- on node1
> 137: DELETE FROM ks1.tbl USING TIMESTAMP 5 WHERE pk0 =
> 1.0844396412062203E195 AND pk1 = '蚨㡦Ɱ擳麗㾢鉦鵅' AND ck0 = '\u0006yhs!byx5]' --
> on node1
> 146: DELETE FROM ks1.tbl USING TIMESTAMP 6 WHERE pk0 =
> 1.0844396412062203E195 AND pk1 = '蚨㡦Ɱ擳麗㾢鉦鵅' AND ck0 = 'g3(X' +
> '\u0014\u000F' -- on node1
> 152: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, s1, v0, v1, v3,
> v4) VALUES (-5.332164051882835E-118, 'ﷻṮ', '\u0010]/d]Qa!w' +
> 'f\u0013_\u000Bt', '14:48:17.526579773', true, -1590897135,
> -2573745997185251720 - 960275326299953638, 8.598387157543732E36 -
> 0.009913671650062445, '@{$\u0011\u007Fv9' + 'YMS') USING TIMESTAMP 7 -- on
> node1
> 153: INSERT INTO ks1.tbl (pk0, pk1, ck0, s1) VALUES
> (1.0844396412062203E195, '蚨㡦Ɱ擳麗㾢鉦鵅', '\u0002`\u0006' + '_7Us\u0016H5\u0005',
> true) USING TIMESTAMP 8 -- on node1
> 163: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v3, v4) VALUES
> (-5.332164051882835E-118, 'ﷻṮ', '\u0002U)e' + 'k{\u0007',
> '19:22:01.238358528', 13461.787488896407 - -8.477600108610068E-237,
> 'b\u0010^6' + 'n') USING TIMESTAMP 9 -- on node1
> 178: DELETE FROM ks1.tbl USING TIMESTAMP 10 WHERE pk0 =
> -5.332164051882835E-118 AND pk1 = 'ﷻṮ' AND ck0 =
> '(J\u000A$\u001A\u007F\u000D\u001EI' + '\u0016%r}Vn\u001EmQ\u000B' -- on node1
> 197: DELETE s0 FROM ks1.tbl USING TIMESTAMP 11 WHERE pk0 =
> -5.332164051882835E-118 AND pk1 = 'ﷻṮ' -- on node1
> 198: nodetool flush ks1 tbl
> 247: UPDATE ks1.tbl USING TIMESTAMP 12 SET v0=0,
> v1=6538215846805966033 * -1292336222967630169, s0='16:30:52.410070437',
> s1=false WHERE pk0 = -5.332164051882835E-118 AND pk1 = 'ﷻṮ' AND ck0 =
> 'HkA' + 'V\u0008ig\u0003A\u000Et' -- on node1
> 268: SELECT * FROM ks1.tbl WHERE s1 = true AND v2 =
> 0x0000000000001d008e00000000000000 AND pk0 = 1.0844396412062203E195 ALLOW
> FILTERING -- s1 boolean (indexed with SAI), v2
> 'org.apache.cassandra.db.marshal.LexicalUUIDType', pk0 double (indexed with
> SAI), on node1, fetch size 100
> {noformat}
> {noformat}
> Caused by: java.lang.AssertionError: Unexpected results for query: SELECT *
> FROM ks1.tbl WHERE s1 = true AND v2 = 0x0000000000001d008e00000000000000 AND
> pk0 = 1.0844396412062203E195 ALLOW FILTERING
> Caused by: java.lang.AssertionError: No rows returned
> Expected:
> pk0 | pk1 | ck0 | s0 | s1 | v0
> | v1 | v2 | v3
> | v4
> 1.0844396412062203E195 | '蚨㡦Ɱ擳麗㾢鉦鵅' | 'Q' | '14:59:24.557825178' | true |
> -2646 | -3909575580531410414 | 0x0000000000001d008e00000000000000 |
> 1.3611534850564156E135 | '0c\u0011?\u007Fm[on]50h'
> {noformat}
> I've gone through almost 1000 other seeds trying to reproduce this in a
> couple hours of local testing w/ no luck, but we'll see if the history above
> repros in a {{CQLTester}} test...
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
