[
https://issues.apache.org/jira/browse/CASSANDRA-20338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17939082#comment-17939082
]
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 = -6259023164406676438
Examples = 1
Pure = true
Error: Unexpected results for query: SELECT * FROM ks1.tbl WHERE ck0 =
0x4a2b5f8a0077fd7923 AND s0 = false AND pk0 =
00000000-0000-1c00-a300-000000000000 PER PARTITION LIMIT 567 LIMIT 481 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 timeuuid,
pk1 inet,
ck0 blob,
ck1 bigint,
s0 boolean static,
v0 vector<boolean, 3>,
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.1
AND caching = {'keys': 'NONE', 'rows_per_partition': 'ALL'}
AND cdc = false
AND comment = ''
AND compaction = {'class':
'org.apache.cassandra.db.compaction.LeveledCompactionStrategy',
'max_threshold': '32', 'min_threshold': '4', 'only_purge_repaired_tombstones':
'false', 'provide_overlapping_tombstones': 'NONE'}
AND compression = {'enabled': 'false'}
AND memtable = 'default'
AND crc_check_chance = 1.0
AND default_time_to_live = 0
AND extensions = {}
AND gc_grace_seconds = 864000
AND incremental_backups = true
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair = 'BLOCKING'
AND speculative_retry = '99p';
CREATE INDEX tbl_pk0 ON ks1.tbl(pk0) USING 'SAI';
CREATE INDEX tbl_pk1 ON ks1.tbl(pk1) USING 'SAI';
CREATE INDEX tbl_ck1 ON ks1.tbl(ck1) USING 'SAI';
CREATE INDEX tbl_s0 ON ks1.tbl(s0) USING 'SAI';:
org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.State
History:
1: SELECT * FROM ks1.tbl PER PARTITION LIMIT 528 LIMIT 885 --
full table scan, on node1
2: UPDATE ks1.tbl USING TIMESTAMP 1 SET v0=[true, false, true],
s0=false WHERE pk0 = 00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x679148 AND ck1 =
-8253442852081950234 * -2788754345412203042 -- on node1
3: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0) VALUES
(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f', 0xb72fed9be33e2d,
-5340853930064683942 - 824120610818976526, false, null) USING TIMESTAMP 2 -- on
node1
4: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 949 LIMIT 816 --
by token, on node1, fetch size 1
5: SELECT * FROM ks1.tbl WHERE s0 = false PER PARTITION LIMIT
311 LIMIT 419 ALLOW FILTERING -- s0 boolean, indexed with SAI, on node1
6: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 385 LIMIT 280 --
by token range, on node1
7: DELETE FROM ks1.tbl USING TIMESTAMP 3 WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' -- on node1
8: UPDATE ks1.tbl USING TIMESTAMP 4 SET v0=[false, true, true],
s0=false WHERE pk0 = 00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0xd5d84a7e3c37 AND ck1 =
-3575589473789585038 - 7099165944229555064 -- on node1
9: SELECT * FROM ks1.tbl WHERE ck1 = 7771988655690411514 PER
PARTITION LIMIT 907 LIMIT 284 -- ck1 bigint, indexed with SAI, on node1, fetch
size 10
10: SELECT * FROM ks1.tbl WHERE s0 <= false PER PARTITION LIMIT
822 LIMIT 882 ALLOW FILTERING -- s0 boolean, indexed with SAI, on node1
11: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 996 -- by token,
on node1, fetch size 1
12: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 117 LIMIT 962 --
by token, on node1, fetch size 1
13: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 916 LIMIT 699 --
by token range, on node1, fetch size 1000
14: nodetool flush ks1 tbl
15: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 816 LIMIT 882 --
by token, on node1, fetch size 1
16: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 506 LIMIT 789 --
by token range, on node1
17: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 959 LIMIT 915 --
by token range, on node1
18: SELECT * FROM ks1.tbl WHERE v0 <= [false, true, true] PER
PARTITION LIMIT 982 LIMIT 911 ALLOW FILTERING -- v0 vector<boolean, 3>, on node1
19: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') LIMIT 882 -- by token range, on node1
20: DELETE FROM ks1.tbl USING TIMESTAMP 5 WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' AND ck0 = 0xfe5827bf31b4b3ac9cec AND
ck1 = -3750097418188163741 * 547957448541729892 -- on node1
21: SELECT * FROM ks1.tbl WHERE pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' PER PARTITION LIMIT 911 -- pk1 inet,
indexed with SAI, on node1, fetch size 1
22: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' PER PARTITION LIMIT 961 LIMIT 824 --
By Partition Key, on node1, fetch size 5000
23: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 992 -- by token
range, on node1, fetch size 100
24: SELECT * FROM ks1.tbl WHERE pk0 <
00000000-0000-1c00-a300-000000000000 PER PARTITION LIMIT 876 -- pk0 timeuuid,
indexed with SAI, on node1, fetch size 5000
25: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 437 LIMIT 995 --
by token range, on node1, fetch size 1
26: DELETE FROM ks1.tbl USING TIMESTAMP 6 WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' AND ck0 = 0xab9c AND ck1 =
-4407617234257571599 -- on node1
27: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0) VALUES
(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f', 0xa17377e1faa31353,
2960535745956850733 + 5979305971262522473, [true, true, true]) USING TIMESTAMP
7 -- on node1
28: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') AND
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 430 LIMIT 948 --
by token range, on node1, fetch size 1
29: SELECT * FROM ks1.tbl WHERE pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' -- pk1 inet, indexed with SAI, on
node1, fetch size 1000
30: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0xd5d84a7e3c37 AND ck1 =
7771988655690411514 PER PARTITION LIMIT 813 -- By Primary Key, on node1, fetch
size 100
31: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 306 -- by token,
on node1, fetch size 1
32: UPDATE ks1.tbl USING TIMESTAMP 8 SET v0=[false, true, true]
WHERE pk0 = 00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' AND ck0 = 0x1f8031 AND ck1 =
3818164591652808899 * 2826287994791868806 -- on node1
33: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 932 -- by token,
on node1, fetch size 100
34: UPDATE ks1.tbl USING TIMESTAMP 9 SET v0=[true, false, true]
WHERE pk0 = 00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x42357d3029b5c669 AND ck1
= 2906668262778988364 -- on node1
35: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x42357d3029b5c669 AND ck1 =
2906668262778988364 LIMIT 992 -- By Primary Key, on node1, fetch size 1000
36: SELECT * FROM ks1.tbl WHERE s0 = false AND pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' PER PARTITION LIMIT 750 LIMIT 16 ALLOW
FILTERING -- s0 boolean (indexed with SAI), pk0 timeuuid (indexed with SAI),
pk1 inet (indexed with SAI), on node1, fetch size 10
37: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND s0 = false AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' PER PARTITION LIMIT 974 LIMIT 267
ALLOW FILTERING -- pk0 timeuuid (indexed with SAI), s0 boolean (indexed with
SAI), pk1 inet (indexed with SAI), on node1, fetch size 1000
38: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 861 -- by token,
on node1, fetch size 1
39: SELECT * FROM ks1.tbl WHERE ck1 <= 7771988655690411514 PER
PARTITION LIMIT 634 LIMIT 793 -- ck1 bigint, indexed with SAI, on node1, fetch
size 100
40: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 213 -- by token,
on node1, fetch size 10
41: SELECT * FROM ks1.tbl WHERE v0 < [false, true, true] PER
PARTITION LIMIT 111 ALLOW FILTERING -- v0 vector<boolean, 3>, on node1, fetch
size 1000
42: UPDATE ks1.tbl USING TIMESTAMP 10 SET v0=[true, true,
false], s0=false WHERE pk0 = 00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' AND ck0 = 0x314e0e37 AND ck1 =
4436196205588616045 - 8460238003399872377 -- on node1
43: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') LIMIT 902 -- by token, on node1,
fetch size 1
44: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND s0 < false PER PARTITION LIMIT 943
ALLOW FILTERING -- s0 boolean, indexed with SAI, on node1, fetch size 100
45: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 722 LIMIT 305 --
by token range, on node1, fetch size 5000
46: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND ck1 = 7771988655690411514 AND ck0 =
0xd5d84a7e3c37 AND pk1 = 'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' AND s0 =
false PER PARTITION LIMIT 950 LIMIT 876 ALLOW FILTERING -- pk0 timeuuid
(indexed with SAI), ck1 bigint (indexed with SAI), ck0 blob (reversed), pk1
inet (indexed with SAI), s0 boolean (indexed with SAI), on node1, fetch size 1
47: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 567 LIMIT 84 --
by token range, on node1, fetch size 1
48: SELECT * FROM ks1.tbl WHERE pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0xd5d84a7e3c37 AND s0 =
false AND pk0 = 00000000-0000-1c00-a300-000000000000 AND ck1 =
-4024041797811256332 PER PARTITION LIMIT 378 LIMIT 530 ALLOW FILTERING -- pk1
inet (indexed with SAI), ck0 blob (reversed), s0 boolean (indexed with SAI),
pk0 timeuuid (indexed with SAI), ck1 bigint (indexed with SAI), on node1, fetch
size 1
49: nodetool flush ks1 tbl
50: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 155 -- by token,
on node1, fetch size 1
51: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 975 LIMIT 129 --
by token range, on node1, fetch size 1
52: UPDATE ks1.tbl USING TIMESTAMP 11 SET v0=[true, false,
true] WHERE pk0 = 00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0xefca7597 AND ck1 =
-4169112474331167077 -- on node1
53: SELECT * FROM ks1.tbl WHERE pk0 <=
00000000-0000-1100-9500-000000000000 PER PARTITION LIMIT 11 LIMIT 404 -- pk0
timeuuid, indexed with SAI, on node1, fetch size 10
54: SELECT * FROM ks1.tbl WHERE v0 <= [true, false, true] ALLOW
FILTERING -- v0 vector<boolean, 3>, on node1
55: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 860 -- by token
range, on node1
56: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') LIMIT 641 -- by token range, on node1
57: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 834 -- by token,
on node1
58: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 905 LIMIT 625 --
by token range, on node1
59: SELECT * FROM ks1.tbl PER PARTITION LIMIT 647 -- full table
scan, on node1
60: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 939 -- by token,
on node1
61: SELECT * FROM ks1.tbl WHERE s0 < false PER PARTITION LIMIT
979 ALLOW FILTERING -- s0 boolean, indexed with SAI, on node1
62: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 854 LIMIT 156 --
by token range, on node1
63: SELECT * FROM ks1.tbl WHERE s0 = false AND pk0 =
00000000-0000-1100-9500-000000000000 PER PARTITION LIMIT 653 ALLOW FILTERING --
s0 boolean (indexed with SAI), pk0 timeuuid (indexed with SAI), on node1
64: SELECT * FROM ks1.tbl WHERE ck1 = 8939841717219373206 AND
pk0 = 00000000-0000-1100-9500-000000000000 ALLOW FILTERING -- ck1 bigint
(indexed with SAI), pk0 timeuuid (indexed with SAI), on node1
65: SELECT * FROM ks1.tbl WHERE ck0 < 0x314e0e37 PER PARTITION
LIMIT 320 LIMIT 24 ALLOW FILTERING -- ck0 blob (reversed), on node1
66: SELECT * FROM ks1.tbl WHERE ck0 = 0xefca7597 PER PARTITION
LIMIT 815 ALLOW FILTERING -- ck0 blob (reversed), on node1
67: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 859 -- by token,
on node1
68: DELETE FROM ks1.tbl USING TIMESTAMP 12 WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x467633be45 AND ck1 =
178711623194133448 - -1475639234145672168 -- on node1
69: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 849 LIMIT 913 --
by token, on node1
70: SELECT * FROM ks1.tbl PER PARTITION LIMIT 9 -- full table
scan, on node1
71: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' AND s0 < false PER PARTITION LIMIT 929
ALLOW FILTERING -- s0 boolean, indexed with SAI, on node1
72: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 52 -- by token,
on node1
73: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 628 LIMIT 895 --
by token range, on node1
74: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 873 -- by token,
on node1
75: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 929 LIMIT 736 --
by token range, on node1
76: SELECT * FROM ks1.tbl PER PARTITION LIMIT 403 -- full table
scan, on node1
77: SELECT * FROM ks1.tbl WHERE s0 <= false ALLOW FILTERING --
s0 boolean, indexed with SAI, on node1
78: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 513 LIMIT 978 --
by token, on node1
79: UPDATE ks1.tbl USING TIMESTAMP 13 SET v0=[false, true,
true] WHERE pk0 = 00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x30afa7466d2d27a56ddb AND
ck1 = 1728846322096973440 - -5807482556993624227 -- on node1
80: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 765 -- by token
range, on node1
81: DELETE s0, s0 FROM ks1.tbl USING TIMESTAMP 14 WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' -- on node1
82: DELETE FROM ks1.tbl USING TIMESTAMP 15 WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' -- on node1
83: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 639 -- by token,
on node1
84: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 993 LIMIT 985 --
by token range, on node1
85: SELECT * FROM ks1.tbl -- full table scan, on node1
86: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 996 LIMIT 983 --
by token, on node1
87: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 71 -- by token,
on node1
88: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 991 -- by token
range, on node1
89: SELECT * FROM ks1.tbl -- full table scan, on node1
90: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 11 LIMIT 351 --
by token range, on node1
91: nodetool flush ks1 tbl
92: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x30afa7466d2d27a56ddb AND
ck1 = 7536328879090597667 -- By Primary Key, on node1
93: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 817 -- by token,
on node1, fetch size 1000
94: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 541 LIMIT 816 --
by token range, on node1, fetch size 1
95: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') LIMIT 959 -- by token, on node1,
fetch size 1
96: DELETE FROM ks1.tbl USING TIMESTAMP 16 WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' -- on node1
97: DELETE FROM ks1.tbl USING TIMESTAMP 17 WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' AND ck0 = 0xbd AND ck1 =
-4154379476321768271 * -4463677325442284761 -- on node1
98: SELECT * FROM ks1.tbl PER PARTITION LIMIT 252 LIMIT 692 --
full table scan, on node1, fetch size 10
99: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0) VALUES
(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5', 0x9f7a42d471, 8485007411746772622 +
-2353894219731679747, null, [true, false, true]) USING TIMESTAMP 18 -- on node1
100: SELECT * FROM ks1.tbl WHERE pk0 <
00000000-0000-1100-9500-000000000000 PER PARTITION LIMIT 677 -- pk0 timeuuid,
indexed with SAI, on node1, fetch size 1
101: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 893 -- by token,
on node1, fetch size 1
102: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0) VALUES
(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f', 0x2df16a651cfe, -608649733441514029,
true) USING TIMESTAMP 19 -- on node1
103: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0) VALUES
(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5', 0x2bba04eb9efb0de7833f,
3817861772931751013 * -6383379172629118431, true, [true, false, false]) USING
TIMESTAMP 20 -- on node1
104: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' -- By Partition Key, on node1, fetch
size 1
105: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 446 -- by token,
on node1, fetch size 1
106: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') -- by token, on node1, fetch size 10
107: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' -- By Partition Key, on node1, fetch
size 1
108: SELECT * FROM ks1.tbl WHERE ck0 = 0x2df16a651cfe PER
PARTITION LIMIT 873 LIMIT 938 ALLOW FILTERING -- ck0 blob (reversed), on node1,
fetch size 100
109: SELECT * FROM ks1.tbl WHERE v0 <= [true, false, false] PER
PARTITION LIMIT 246 LIMIT 415 ALLOW FILTERING -- v0 vector<boolean, 3>, on
node1, fetch size 100
110: SELECT * FROM ks1.tbl WHERE pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x2bba04eb9efb0de7833f AND
ck1 = 6131113192015092875 AND s0 = true AND pk0 =
00000000-0000-1c00-a300-000000000000 PER PARTITION LIMIT 902 LIMIT 445 ALLOW
FILTERING -- pk1 inet (indexed with SAI), ck0 blob (reversed), ck1 bigint
(indexed with SAI), s0 boolean (indexed with SAI), pk0 timeuuid (indexed with
SAI), on node1, fetch size 1
111: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 932 -- by token,
on node1, fetch size 1000
112: SELECT * FROM ks1.tbl WHERE ck1 < -608649733441514029 PER
PARTITION LIMIT 779 LIMIT 984 -- ck1 bigint, indexed with SAI, on node1, fetch
size 100
113: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 918 LIMIT 831 --
by token range, on node1, fetch size 100
114: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 494 LIMIT 982 --
by token, on node1, fetch size 1
115: SELECT * FROM ks1.tbl WHERE ck1 > -608649733441514029 PER
PARTITION LIMIT 874 -- ck1 bigint, indexed with SAI, on node1, fetch size 1
116: SELECT * FROM ks1.tbl WHERE pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' PER PARTITION LIMIT 923 LIMIT 955 --
pk1 inet, indexed with SAI, on node1, fetch size 1000
117: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 935 -- by token
range, on node1, fetch size 1
118: SELECT * FROM ks1.tbl WHERE ck1 <= -1377884291062910203
PER PARTITION LIMIT 533 -- ck1 bigint, indexed with SAI, on node1, fetch size
100
119: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') -- by token range, on node1, fetch
size 100
120: SELECT * FROM ks1.tbl WHERE ck0 < 0x2bba04eb9efb0de7833f
ALLOW FILTERING -- ck0 blob (reversed), on node1, fetch size 1
121: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 384 LIMIT 345 --
by token, on node1, fetch size 1
122: DELETE FROM ks1.tbl USING TIMESTAMP 21 WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x90909e9dc36392b5e5 AND
ck1 = 4020774783760239006 -- on node1
123: SELECT * FROM ks1.tbl WHERE s0 = true AND ck0 =
0x9f7a42d471 AND pk1 = 'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' LIMIT 205 ALLOW
FILTERING -- s0 boolean (indexed with SAI), ck0 blob (reversed), pk1 inet
(indexed with SAI), on node1, fetch size 1000
124: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 994 -- by token
range, on node1, fetch size 10
125: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 925 -- by token
range, on node1, fetch size 1000
126: SELECT * FROM ks1.tbl PER PARTITION LIMIT 592 -- full
table scan, on node1, fetch size 1
127: nodetool flush ks1 tbl
128: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' AND ck0 < 0x2bba04eb9efb0de7833f PER
PARTITION LIMIT 752 ALLOW FILTERING -- ck0 blob (reversed), on node1, fetch
size 1
129: SELECT * FROM ks1.tbl WHERE ck0 < 0x2bba04eb9efb0de7833f
PER PARTITION LIMIT 993 LIMIT 32 ALLOW FILTERING -- ck0 blob (reversed), on
node1, fetch size 1
130: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 798 -- by token,
on node1, fetch size 5000
131: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' PER PARTITION LIMIT 958 -- By
Partition Key, on node1, fetch size 1
132: SELECT * FROM ks1.tbl WHERE pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' PER PARTITION LIMIT 823 -- pk1 inet,
indexed with SAI, on node1, fetch size 1
133: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' AND ck0 = 0x9f7a42d471 AND ck1 =
6131113192015092875 PER PARTITION LIMIT 788 -- By Primary Key, on node1, fetch
size 1
134: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1100-9500-000000000000 PER PARTITION LIMIT 32 -- pk0 timeuuid,
indexed with SAI, on node1, fetch size 1
135: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 927 LIMIT 569 --
by token range, on node1, fetch size 5000
136: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 893 LIMIT 946 --
by token range, on node1, fetch size 1
137: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 985 -- by token
range, on node1, fetch size 10
138: SELECT * FROM ks1.tbl PER PARTITION LIMIT 578 LIMIT 82 --
full table scan, on node1, fetch size 1000
139: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 914 LIMIT 550 --
by token range, on node1, fetch size 1
140: SELECT * FROM ks1.tbl WHERE ck1 <= -1377884291062910203
PER PARTITION LIMIT 409 -- ck1 bigint, indexed with SAI, on node1, fetch size 1
141: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 472 -- by token,
on node1
142: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0) VALUES
(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f', 0x37, 8708403838942747703 -
4280743287998780010, true, [true, false, true]) USING TIMESTAMP 22 -- on node1
143: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') -- by token, on node1
144: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 795 LIMIT 628 --
by token, on node1
145: DELETE FROM ks1.tbl USING TIMESTAMP 23 WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' -- on node1
146: DELETE FROM ks1.tbl USING TIMESTAMP 24 WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' AND ck0 = 0xcfc69d29e5331c1a AND ck1
= -6584113894706719998 - 6431450093280942854 -- on node1
147: SELECT * FROM ks1.tbl WHERE s0 <= true PER PARTITION LIMIT
602 ALLOW FILTERING -- s0 boolean, indexed with SAI, on node1
148: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0) VALUES
(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f', 0x871c9e, -8191022631481718458 +
3112026868598176972, true) USING TIMESTAMP 25 -- on node1
149: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 615 LIMIT 961 --
by token, on node1
150: DELETE FROM ks1.tbl USING TIMESTAMP 26 WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x0fa1833922549121cc8f AND
ck1 = 5751880254111238950 -- on node1
151: DELETE FROM ks1.tbl USING TIMESTAMP 27 WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' AND ck0 = 0x36d34f39f960 AND ck1 =
-9216996326177350483 -- on node1
152: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 998 LIMIT 944 --
by token, on node1
153: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 928 LIMIT 554 --
by token, on node1
154: SELECT * FROM ks1.tbl WHERE pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' PER PARTITION LIMIT 743 LIMIT 741 --
pk1 inet, indexed with SAI, on node1
155: SELECT * FROM ks1.tbl WHERE ck1 = 6131113192015092875 PER
PARTITION LIMIT 321 LIMIT 828 -- ck1 bigint, indexed with SAI, on node1
156: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 813 LIMIT 709 --
by token range, on node1
157: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 438 LIMIT 772 --
by token range, on node1
158: SELECT * FROM ks1.tbl WHERE v0 = [true, false, true] PER
PARTITION LIMIT 271 LIMIT 507 ALLOW FILTERING -- v0 vector<boolean, 3>, on node1
159: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 906 LIMIT 846 --
by token range, on node1
160: nodetool flush ks1 tbl
161: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1100-9500-000000000000 PER PARTITION LIMIT 690 LIMIT 602 -- pk0
timeuuid, indexed with SAI, on node1
162: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 329 -- by token,
on node1
163: SELECT * FROM ks1.tbl PER PARTITION LIMIT 791 -- full
table scan, on node1
164: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 476 LIMIT 905 --
by token, on node1
165: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') -- by token, on node1
166: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 953 LIMIT 945 --
by token range, on node1
167: SELECT * FROM ks1.tbl PER PARTITION LIMIT 556 -- full
table scan, on node1
168: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') -- by token, on node1
169: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') LIMIT 865 -- by token range, on node1
170: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 942 -- by token
range, on node1
171: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 743 -- by token,
on node1
172: SELECT * FROM ks1.tbl -- full table scan, on node1
173: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 711 -- by token,
on node1
174: SELECT * FROM ks1.tbl WHERE ck1 <= -5078995762883541486
LIMIT 967 -- ck1 bigint, indexed with SAI, on node1
175: SELECT * FROM ks1.tbl WHERE s0 <= true PER PARTITION LIMIT
970 LIMIT 736 ALLOW FILTERING -- s0 boolean, indexed with SAI, on node1
176: SELECT * FROM ks1.tbl PER PARTITION LIMIT 944 LIMIT 688 --
full table scan, on node1
177: SELECT * FROM ks1.tbl WHERE ck0 <= 0x9f7a42d471 ALLOW
FILTERING -- ck0 blob (reversed), on node1
178: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') -- by token range, on node1
179: DELETE s0 FROM ks1.tbl USING TIMESTAMP 28 WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' -- on node1
180: SELECT * FROM ks1.tbl WHERE ck1 = 6131113192015092875 PER
PARTITION LIMIT 971 -- ck1 bigint, indexed with SAI, on node1
181: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 959 LIMIT 49 --
by token range, on node1
182: SELECT * FROM ks1.tbl WHERE ck0 < 0x871c9e PER PARTITION
LIMIT 130 LIMIT 983 ALLOW FILTERING -- ck0 blob (reversed), on node1
183: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' PER PARTITION LIMIT 926 LIMIT 902 --
By Partition Key, on node1
184: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 140 LIMIT 871 --
by token, on node1
185: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 826 LIMIT 591 --
by token, on node1
186: SELECT * FROM ks1.tbl WHERE pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' PER PARTITION LIMIT 524 -- pk1 inet,
indexed with SAI, on node1
187: SELECT * FROM ks1.tbl WHERE pk0 <=
00000000-0000-1c00-a300-000000000000 PER PARTITION LIMIT 920 LIMIT 367 -- pk0
timeuuid, indexed with SAI, on node1
188: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x871c9e AND ck1 =
-5078995762883541486 PER PARTITION LIMIT 979 -- By Primary Key, on node1
189: SELECT * FROM ks1.tbl -- full table scan, on node1
190: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 989 LIMIT 655 --
by token range, on node1
191: SELECT * FROM ks1.tbl WHERE ck1 = -1377884291062910203 AND
pk1 = '6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND s0 = true AND pk0 =
00000000-0000-1100-9500-000000000000 AND ck0 = 0x9f7a42d471 PER PARTITION LIMIT
187 LIMIT 919 ALLOW FILTERING -- ck1 bigint (indexed with SAI), pk1 inet
(indexed with SAI), s0 boolean (indexed with SAI), pk0 timeuuid (indexed with
SAI), ck0 blob (reversed), on node1
192: SELECT * FROM ks1.tbl WHERE ck1 = -1377884291062910203 AND
s0 = true AND ck0 = 0x9f7a42d471 PER PARTITION LIMIT 965 ALLOW FILTERING -- ck1
bigint (indexed with SAI), s0 boolean (indexed with SAI), ck0 blob (reversed),
on node1
193: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1100-9500-000000000000 PER PARTITION LIMIT 591 LIMIT 846 -- pk0
timeuuid, indexed with SAI, on node1
194: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck1 = -5078995762883541486 PER
PARTITION LIMIT 732 LIMIT 854 -- ck1 bigint, indexed with SAI, on node1
195: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 456 -- by token,
on node1
196: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 801 -- by token,
on node1
197: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0) VALUES
(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f', 0x4a2b5f8a0077fd7923,
4327029664600471377 - 2832976571794927079, [true, false, true]) USING TIMESTAMP
29 -- on node1
198: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 706 -- by token
range, on node1
199: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 724 -- by token
range, on node1
200: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 441 -- by token
range, on node1
201: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 948 LIMIT 622 --
by token, on node1
202: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <=
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 650 LIMIT 949 --
by token range, on node1
203: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 348 -- by token
range, on node1, fetch size 1
204: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' AND ck0 = 0x9f7a42d471 AND ck1 =
6131113192015092875 PER PARTITION LIMIT 977 -- By Primary Key, on node1, fetch
size 5000
205: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') LIMIT 556 -- by token, on node1,
fetch size 1000
206: SELECT * FROM ks1.tbl PER PARTITION LIMIT 127 LIMIT 988 --
full table scan, on node1, fetch size 1
207: SELECT * FROM ks1.tbl WHERE ck1 = 6131113192015092875 --
ck1 bigint, indexed with SAI, on node1, fetch size 10
208: DELETE s0, s0 FROM ks1.tbl USING TIMESTAMP 30 WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' -- on node1
209: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 995 LIMIT 684 --
by token, on node1, fetch size 1
210: UPDATE ks1.tbl USING TIMESTAMP 31 SET v0=[true, false,
true] WHERE pk0 = 00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x289f409d8fc3e50d AND ck1
= -8152699266362088441 * -3771931745441430309 -- on node1
211: nodetool flush ks1 tbl
212: UPDATE ks1.tbl USING TIMESTAMP 32 SET s0=false, v0=[true,
true, true] WHERE pk0 = 00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x6e3e41 AND ck1 =
-2005065174760223600 - 2254457082278611511 -- on node1
213: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' PER PARTITION LIMIT 978 LIMIT 906 --
By Partition Key, on node1, fetch size 1
214: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') PER PARTITION LIMIT 910 -- by token,
on node1, fetch size 1
215: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' PER PARTITION LIMIT 737 LIMIT 656 --
By Partition Key, on node1, fetch size 5000
216: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 888 LIMIT 772 --
by token, on node1, fetch size 5000
217: SELECT * FROM ks1.tbl WHERE v0 <= [true, false, false]
LIMIT 982 ALLOW FILTERING -- v0 vector<boolean, 3>, on node1, fetch size 1
218: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 359 -- by token
range, on node1, fetch size 5000
219: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0) VALUES
(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5', 0x6fb5dafaaa04b17f,
5035289413010743934 - -2618107762399071475, false, null) USING TIMESTAMP 33 --
on node1
220: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v0) VALUES
(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f', 0x28bc61e7e045a054,
3603493221173859972 - 7061910631581125536, [false, true, false]) USING
TIMESTAMP 34 -- on node1
221: UPDATE ks1.tbl USING TIMESTAMP 35 SET v0=[false, false,
true] WHERE pk0 = 00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0xcd AND ck1 =
-6796314921488215915 - -7929118281220612316 -- on node1
222: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 922 -- by token
range, on node1, fetch size 5000
223: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1100-9500-000000000000 PER PARTITION LIMIT 934 LIMIT 917 -- pk0
timeuuid, indexed with SAI, on node1, fetch size 1
224: SELECT * FROM ks1.tbl WHERE v0 = [false, false, true]
ALLOW FILTERING -- v0 vector<boolean, 3>, on node1, fetch size 1
225: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') LIMIT 965 -- by token, on node1,
fetch size 1
226: SELECT * FROM ks1.tbl -- full table scan, on node1, fetch
size 1
227: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 5 -- by token, on
node1, fetch size 1
228: nodetool flush ks1 tbl
229: SELECT * FROM ks1.tbl WHERE v0 = [true, true, true] PER
PARTITION LIMIT 935 ALLOW FILTERING -- v0 vector<boolean, 3>, on node1, fetch
size 10
230: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 908 -- by token,
on node1, fetch size 1
231: DELETE FROM ks1.tbl USING TIMESTAMP 36 WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' -- on node1
232: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0) VALUES
(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5', 0xc807, -33882618325261352, true,
[true, true, false]) USING TIMESTAMP 37 -- on node1
233: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 188 LIMIT 456 --
by token range, on node1, fetch size 1000
234: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' PER PARTITION LIMIT 738 -- By
Partition Key, on node1, fetch size 100
235: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0) VALUES
(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5', 0x25cfbc44a1bb4ecca2,
2078230415807953077 + -2292536501841634629, true, [false, false, false]) USING
TIMESTAMP 38 -- on node1
236: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 657 -- by token,
on node1, fetch size 1
237: SELECT * FROM ks1.tbl WHERE s0 <= true PER PARTITION LIMIT
812 ALLOW FILTERING -- s0 boolean, indexed with SAI, on node1, fetch size 100
238: DELETE FROM ks1.tbl USING TIMESTAMP 39 WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x7fb1 AND ck1 =
-2267055789732356616 -- on node1
239: UPDATE ks1.tbl USING TIMESTAMP 40 SET v0=null, s0=true
WHERE pk0 = 00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' AND ck0 = 0x9d362da31b06f5 AND ck1 =
-4868076929742240820 - 6245994368633650508 -- on node1
240: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 824 LIMIT 927 --
by token, on node1, fetch size 1
241: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1100-9500-000000000000 AND pk1 =
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5' AND ck0 = 0xc807 AND ck1 =
-33882618325261352 PER PARTITION LIMIT 963 -- By Primary Key, on node1, fetch
size 1
242: DELETE FROM ks1.tbl USING TIMESTAMP 41 WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x4c459765a96a2e35 AND ck1
= 1961509403452952175 * -4954782103841129206 -- on node1
243: SELECT * FROM ks1.tbl WHERE v0 <= [false, false, true] PER
PARTITION LIMIT 319 LIMIT 121 ALLOW FILTERING -- v0 vector<boolean, 3>, on
node1, fetch size 100
244: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token(00000000-0000-1100-9500-000000000000,
'f74d:12c6:c06a:c1a:e31b:cc19:fadb:d2d5') AND token(pk0, pk1) <
token(00000000-0000-1c00-a300-000000000000,
'6c47:2232:6a51:971:8905:e592:eddc:7d3f') PER PARTITION LIMIT 899 -- by token
range, on node1, fetch size 10
245: SELECT * FROM ks1.tbl WHERE pk0 =
00000000-0000-1c00-a300-000000000000 AND pk1 =
'6c47:2232:6a51:971:8905:e592:eddc:7d3f' AND ck0 = 0x4a2b5f8a0077fd7923 PER
PARTITION LIMIT 681 ALLOW FILTERING -- ck0 blob (reversed), on node1, fetch
size 1
246: SELECT * FROM ks1.tbl WHERE ck0 = 0x4a2b5f8a0077fd7923 AND
s0 = false AND pk0 = 00000000-0000-1c00-a300-000000000000 PER PARTITION LIMIT
567 LIMIT 481 ALLOW FILTERING -- ck0 blob (reversed), s0 boolean (indexed with
SAI), pk0 timeuuid (indexed with SAI), on node1, fetch size 1
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 ck0 = 0x4a2b5f8a0077fd7923 AND s0 = false AND pk0 =
00000000-0000-1c00-a300-000000000000 PER PARTITION LIMIT 567 LIMIT 481 ALLOW
FILTERING
Caused by: java.lang.AssertionError: No rows returned
Expected:
pk0 | pk1
| ck0 | ck1 | s0 | v0
00000000-0000-1c00-a300-000000000000 | '6c47:2232:6a51:971:8905:e592:eddc:7d3f'
| 0x4a2b5f8a0077fd7923 | 1494053092805544298 | false | [true, false, 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
