[
https://issues.apache.org/jira/browse/CASSANDRA-20338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17938703#comment-17938703
]
David Capwell edited comment on CASSANDRA-20338 at 3/26/25 6:42 PM:
--------------------------------------------------------------------
Here is another possible seed
https://github.com/apache/cassandra/pull/4006
SHA: 6aaf39a6563314bc110c8ef217d09dd66ca6ced0
{code}
accord.utils.Property$PropertyError: Property error detected:
Seed = -464866883761188308
Examples = 1
Pure = true
Error: Unexpected results for query: SELECT * FROM ks1.tbl WHERE s0 = (28387,
{-1.18764904E-20}) AND pk1 = 00000000-0000-4000-ad00-000000000000 AND ck1 =
0xa06bb301 PER PARTITION LIMIT 25 LIMIT 307 ALLOW FILTERING
Steps: 400
Values:
State:
Setup:
CREATE KEYSPACE IF NOT EXISTS ks1 WITH replication = {'class':
'SimpleStrategy', 'replication_factor': 1};
CREATE TYPE IF NOT EXISTS ks1."0" (
f0 blob
);;
CREATE TYPE IF NOT EXISTS
ks1."g8BJ1wxrLatl5q3OkJhLsD1FaKwFx8qu2Tjyqk1BOt" (
f0 boolean,
f1 tinyint,
f2 text
);;
CREATE TABLE ks1.tbl (
pk0 time,
pk1 uuid,
ck0 uuid,
ck1 blob,
s0 frozen<tuple<smallint, frozen<set<float>>>> static,
v0 vector<vector<int, 2>, 3>,
v1 frozen<map<frozen<"0">, vector<bigint, 2>>>,
v2
vector<frozen<"g8BJ1wxrLatl5q3OkJhLsD1FaKwFx8qu2Tjyqk1BOt">, 2>,
v3 bigint,
PRIMARY KEY ((pk0, pk1), ck0, ck1)
) WITH CLUSTERING ORDER BY (ck0 DESC, ck1 DESC)
AND additional_write_policy = '99p'
AND allow_auto_snapshot = true
AND bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND cdc = false
AND comment = ''
AND compaction = {'bucket_high': '1.5692993708987346',
'bucket_low': '0.21912280187999553', 'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32', 'min_sstable_size': '15728640', 'min_threshold': '4',
'only_purge_repaired_tombstones': 'false', 'provide_overlapping_tombstones':
'CELL', 'tombstone_threshold': '0.26826942'}
AND compression = {'enabled': 'false'}
AND memtable = 'default'
AND crc_check_chance = 1.0
AND default_time_to_live = 0
AND extensions = {}
AND gc_grace_seconds = 864000
AND incremental_backups = true
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair = 'BLOCKING'
AND speculative_retry = '99p';
CREATE CUSTOM INDEX tbl_pk0 ON ks1.tbl(pk0) USING
'StorageAttachedIndex';
CREATE CUSTOM INDEX tbl_pk1 ON ks1.tbl(pk1) USING
'StorageAttachedIndex';
CREATE CUSTOM INDEX tbl_ck0 ON ks1.tbl(ck0) USING
'StorageAttachedIndex';
CREATE INDEX tbl_s0 ON ks1.tbl(s0) USING 'SAI';
CREATE INDEX tbl_v1 ON ks1.tbl(FULL(v1)) USING 'SAI';
CREATE INDEX tbl_v3 ON ks1.tbl(v3) USING 'SAI';:
org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.State
History:
1: DELETE s0 FROM ks1.tbl USING TIMESTAMP 1 WHERE pk0 =
'05:05:39.676771737' AND pk1 = 00000000-0000-4500-9e00-000000000000 -- on node1
2: DELETE FROM ks1.tbl USING TIMESTAMP 2 WHERE pk0 =
'07:08:47.775161332' AND pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 =
00000000-0000-4a00-a600-000000000000 AND ck1 = 0x65bb -- on node1
3: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3)
VALUES ('02:43:47.716011275', 00000000-0000-4200-b200-000000000000,
00000000-0000-4e00-8400-000000000000, 0xf2791941aea8e469, (12129,
{-2.58545975E14}), [[-1781797567, 330686172], [103364202, 2031130152],
[-550709009, 492544493]], {{f0: 0x34839b8bae653b2bdee8}: [-8431172225521461427,
8894719445990427242]}, [{f0: false, f1: 53, f2: '嵆왛孷쏆䊖恣'}, {f0: true, f1: 21,
f2: 'ᨚ?榥쯢?ɚ챛ퟡ'}], 9167463065336786821) USING TIMESTAMP 3 -- on node1
4: SELECT * FROM ks1.tbl PER PARTITION LIMIT 238 LIMIT 253 --
full table scan, on node1
5: SELECT * FROM ks1.tbl WHERE ck0 =
00000000-0000-4e00-8400-000000000000 AND ck1 = 0xf2791941aea8e469 AND pk0 =
'02:43:47.716011275' AND s0 = (12129, {-2.58545975E14}) AND v1 = {{f0:
0x34839b8bae653b2bdee8}: [-8431172225521461427, 8894719445990427242]} AND pk1 =
00000000-0000-4200-b200-000000000000 AND v3 = 9167463065336786821 PER PARTITION
LIMIT 728 ALLOW FILTERING -- ck0 uuid (reversed) (indexed with SAI), ck1 blob
(reversed), pk0 time (indexed with SAI), s0 frozen<tuple<smallint,
frozen<set<float>>>> (indexed with SAI), v1 frozen<map<frozen<"0">,
vector<bigint, 2>>> (indexed with SAI), pk1 uuid (indexed with SAI), v3 bigint
(indexed with SAI), on node1, fetch size 1000
6: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('02:43:47.716011275', 00000000-0000-4200-b200-000000000000) AND
token(pk0, pk1) <= token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) -- by token range, on node1
7: UPDATE ks1.tbl USING TIMESTAMP 4 SET s0=(23307,
{-8.214548E-18}), v0=[[672139924, -1253475201], [353181149, -1829076723],
[179355765, 379303855]], v1={{f0: 0x64850696464d}: [-7485547085069825418,
7795885370802556756], {f0: 0x67633db6f091}: [-8484578637223040646,
8216210044102487771]}, v2=[{f0: true, f1: 68, f2: '䝿ᝧ䶨푥펟겭매郂쀌'}, {f0: true, f1:
98, f2: '髃爫삿챥卛☓읂ີ?'}], v3=-4626482462417652499 * -7377486305688263453 WHERE
pk0 = '03:36:30.876439626' AND pk1 = 00000000-0000-4000-ad00-000000000000 AND
ck0 = 00000000-0000-4000-9f00-000000000000 AND ck1 = 0xa06bb301 -- on node1
8: SELECT * FROM ks1.tbl WHERE ck1 = 0xa06bb301 AND pk0 =
'02:43:47.716011275' AND v1 = {{f0: 0x34839b8bae653b2bdee8}:
[-8431172225521461427, 8894719445990427242]} AND s0 = (12129, {-2.58545975E14})
AND pk1 = 00000000-0000-4000-ad00-000000000000 AND ck0 =
00000000-0000-4e00-8400-000000000000 PER PARTITION LIMIT 150 LIMIT 329 ALLOW
FILTERING -- ck1 blob (reversed), pk0 time (indexed with SAI), v1
frozen<map<frozen<"0">, vector<bigint, 2>>> (indexed with SAI), s0
frozen<tuple<smallint, frozen<set<float>>>> (indexed with SAI), pk1 uuid
(indexed with SAI), ck0 uuid (reversed) (indexed with SAI), on node1
9: SELECT * FROM ks1.tbl WHERE pk0 = '02:43:47.716011275' AND
pk1 = 00000000-0000-4200-b200-000000000000 AND ck0 =
00000000-0000-4e00-8400-000000000000 AND ck1 = 0xf2791941aea8e469 PER PARTITION
LIMIT 245 LIMIT 338 -- By Primary Key, on node1
10: SELECT * FROM ks1.tbl WHERE pk1 =
00000000-0000-4000-ad00-000000000000 AND s0 = (12129, {-2.58545975E14}) AND ck1
= 0xa06bb301 AND v3 = 9206814797433618983 PER PARTITION LIMIT 812 ALLOW
FILTERING -- pk1 uuid (indexed with SAI), s0 frozen<tuple<smallint,
frozen<set<float>>>> (indexed with SAI), ck1 blob (reversed), v3 bigint
(indexed with SAI), on node1, fetch size 1000
11: SELECT * FROM ks1.tbl WHERE s0 = (23307, {-8.214548E-18})
AND ck0 = 00000000-0000-4000-9f00-000000000000 AND ck1 = 0xa06bb301 AND pk0 =
'02:43:47.716011275' AND v1 = {{f0: 0x34839b8bae653b2bdee8}:
[-8431172225521461427, 8894719445990427242]} AND pk1 =
00000000-0000-4000-ad00-000000000000 ALLOW FILTERING -- s0
frozen<tuple<smallint, frozen<set<float>>>> (indexed with SAI), ck0 uuid
(reversed) (indexed with SAI), ck1 blob (reversed), pk0 time (indexed with
SAI), v1 frozen<map<frozen<"0">, vector<bigint, 2>>> (indexed with SAI), pk1
uuid (indexed with SAI), on node1
12: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) -- by token range, on node1
13: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) -- by token range, on node1
14: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) LIMIT 845 -- by token range, on node1,
fetch size 1000
15: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) <= token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) LIMIT 680 -- by token range, on node1
16: SELECT * FROM ks1.tbl WHERE ck1 = 0xa06bb301 AND v1 = {{f0:
0x64850696464d}: [-7485547085069825418, 7795885370802556756], {f0:
0x67633db6f091}: [-8484578637223040646, 8216210044102487771]} AND ck0 =
00000000-0000-4e00-8400-000000000000 PER PARTITION LIMIT 462 ALLOW FILTERING --
ck1 blob (reversed), v1 frozen<map<frozen<"0">, vector<bigint, 2>>> (indexed
with SAI), ck0 uuid (reversed) (indexed with SAI), on node1
17: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
v3) VALUES ('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000,
00000000-0000-4a00-a500-000000000000, 0xfef0d63ff7, (-15283, {-1.132058E24,
2.9319742E-31}), [[-335960956, 678086816], [-2139882146, 1011627708],
[-55338955, -2094185756]], {{f0: 0xd9c3ab}: [-9002034104664383537,
-8074261670215737032]}, [{f0: true, f1: -79, f2: '霠♘칳⦵ঋ幗䶐'}, {f0: true, f1: 7,
f2: '䉻ݹ鞞텔㙠'}], 1885613374025825905) USING TIMESTAMP 5 -- on node1
18: DELETE FROM ks1.tbl USING TIMESTAMP 6 WHERE pk0 =
'14:02:14.975449434' AND pk1 = 00000000-0000-4900-9900-000000000000 -- on node1
19: DELETE FROM ks1.tbl USING TIMESTAMP 7 WHERE pk0 =
'12:15:35.151327231' AND pk1 = 00000000-0000-4500-ac00-000000000000 -- on node1
20: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
v1 = {{f0: 0x34839b8bae653b2bdee8}: [-8431172225521461427,
8894719445990427242]} AND v3 = 9206814797433618983 AND ck1 = 0xfef0d63ff7 AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND s0 = (23307, {-8.214548E-18})
AND ck0 = 00000000-0000-4e00-8400-000000000000 PER PARTITION LIMIT 78 ALLOW
FILTERING -- pk0 time (indexed with SAI), v1 frozen<map<frozen<"0">,
vector<bigint, 2>>> (indexed with SAI), v3 bigint (indexed with SAI), ck1 blob
(reversed), pk1 uuid (indexed with SAI), s0 frozen<tuple<smallint,
frozen<set<float>>>> (indexed with SAI), ck0 uuid (reversed) (indexed with
SAI), on node1, fetch size 10
21: DELETE FROM ks1.tbl USING TIMESTAMP 8 WHERE pk0 =
'07:08:47.775161332' AND pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 =
00000000-0000-4b00-b000-000000000000 AND ck1 = 0xa4121adb08 -- on node1
22: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 PER PARTITION LIMIT 101 LIMIT 260 --
By Partition Key, on node1, fetch size 100
23: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
v3) VALUES ('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000,
00000000-0000-4600-b400-000000000000, 0x63f5, (28387, {-1.18764904E-20}),
[[-441895935, 313114446], [-740629531, -678512740], [1429899934, -1259907921]],
{{f0: 0x5df1}: [414225888834712632, -5730196176171247108], {f0:
0x92c1497d7072b81c91}: [-7587541014989351350, -2813091340484612608]}, [{f0:
true, f1: 41, f2: '쎺╇⒀왶'}, {f0: true, f1: -84, f2: '턺䋏篷'}],
-1473884563651667176 + 128345915915881356) USING TIMESTAMP 9 -- on node1
24: SELECT * FROM ks1.tbl PER PARTITION LIMIT 765 LIMIT 966 --
full table scan, on node1, fetch size 10
25: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) LIMIT 930 -- by token range, on node1,
fetch size 1
26: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) PER PARTITION LIMIT 390 LIMIT 371 -- by
token range, on node1, fetch size 10
27: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('02:43:47.716011275', 00000000-0000-4200-b200-000000000000) -- by token,
on node1, fetch size 10
28: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) LIMIT 674 -- by token range, on node1
29: DELETE FROM ks1.tbl USING TIMESTAMP 10 WHERE pk0 =
'02:43:47.716011275' AND pk1 = 00000000-0000-4200-b200-000000000000 -- on node1
30: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 -- By Partition Key, on node1
31: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token(pk0, pk1) <= token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) -- by token range, on node1
32: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND ck1 = 0x63f5 PER PARTITION LIMIT
121 LIMIT 268 ALLOW FILTERING -- ck1 blob (reversed), on node1
33: DELETE s0, s0 FROM ks1.tbl USING TIMESTAMP 11 WHERE pk0 =
'07:08:47.775161332' AND pk1 = 00000000-0000-4800-ad00-000000000000 -- on node1
34: DELETE FROM ks1.tbl USING TIMESTAMP 12 WHERE pk0 =
'14:02:14.975449434' AND pk1 = 00000000-0000-4900-9900-000000000000 -- on node1
35: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) PER PARTITION LIMIT 77 LIMIT 406 -- by
token range, on node1
36: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) LIMIT 878 --
by token, on node1
37: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 -- By Partition Key, on node1
38: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 LIMIT 336 -- By Partition Key, on
node1
39: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 AND v2 = [{f0: true, f1: -79, f2:
'霠♘칳⦵ঋ幗䶐'}, {f0: true, f1: 7, f2: '䉻ݹ鞞텔㙠'}] PER PARTITION LIMIT 448 LIMIT 827
ALLOW FILTERING -- v2
vector<frozen<"g8BJ1wxrLatl5q3OkJhLsD1FaKwFx8qu2Tjyqk1BOt">, 2>, on node1
40: nodetool flush ks1 tbl
41: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) PER PARTITION
LIMIT 200 LIMIT 16 -- by token, on node1, fetch size 10
42: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) PER PARTITION LIMIT 499 -- by token
range, on node1, fetch size 1000
43: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) LIMIT 521 --
by token, on node1, fetch size 10
44: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
v3) VALUES ('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000,
00000000-0000-4b00-8a00-000000000000, 0x796832dd393ed9, (-5067, {1.6430526E-26,
9.1520835E-9}), [[282190412, -1332742488], [-1326870972, -1507032445],
[2130920808, -507072905]], {{f0: 0x487ddc7830}: [7904404607542179003,
-457828847990759307], {f0: 0xe5216b5d7d0e0381787b}: [-8132031026799433302,
-7693009312950744208]}, [{f0: false, f1: -23, f2: '뷛熬羚?㵩䒪䰀鳷'}, {f0: true, f1:
10, f2: '滠?겨䍝쌢⟚㩊'}], -2173067216381309339 * 8003217163647839791) USING
TIMESTAMP 13 -- on node1
45: DELETE FROM ks1.tbl USING TIMESTAMP 14 WHERE pk0 =
'09:30:17.241628150' AND pk1 = 00000000-0000-4b00-b100-000000000000 AND ck0 =
00000000-0000-4000-9100-000000000000 AND ck1 = 0x3cafa20e28bf -- on node1
46: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 =
00000000-0000-4a00-a500-000000000000 AND ck1 = 0xfef0d63ff7 LIMIT 126 -- By
Primary Key, on node1, fetch size 10
47: SELECT * FROM ks1.tbl WHERE v1 = {{f0: 0x64850696464d}:
[-7485547085069825418, 7795885370802556756], {f0: 0x67633db6f091}:
[-8484578637223040646, 8216210044102487771]} AND ck0 =
00000000-0000-4000-9f00-000000000000 AND pk1 =
00000000-0000-4800-ad00-000000000000 AND s0 = (28387, {-1.18764904E-20}) AND v3
= 9206814797433618983 AND ck1 = 0xfef0d63ff7 AND pk0 = '03:36:30.876439626'
LIMIT 579 ALLOW FILTERING -- v1 frozen<map<frozen<"0">, vector<bigint, 2>>>
(indexed with SAI), ck0 uuid (reversed) (indexed with SAI), pk1 uuid (indexed
with SAI), s0 frozen<tuple<smallint, frozen<set<float>>>> (indexed with SAI),
v3 bigint (indexed with SAI), ck1 blob (reversed), pk0 time (indexed with SAI),
on node1, fetch size 100
48: DELETE FROM ks1.tbl USING TIMESTAMP 15 WHERE pk0 =
'07:08:47.775161332' AND pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 =
00000000-0000-4a00-9f00-000000000000 AND ck1 = 0x96 -- on node1
49: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) LIMIT 963 --
by token range, on node1, fetch size 10
50: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 =
00000000-0000-4a00-a500-000000000000 AND ck1 = 0xfef0d63ff7 LIMIT 16 -- By
Primary Key, on node1, fetch size 10
51: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) LIMIT 341 -- by token range, on node1
52: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) -- by token range, on node1
53: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v3, v1, v0) VALUES
('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000,
00000000-0000-4500-8500-000000000000, 0x6d698f, 4193636848147638568 -
5038104430806020365, {{f0: 0x73e1}: [-6348065865830433534,
-6759265680224526862], {f0: 0x812d}: [8558329330827688068,
7430601506500167401]}, null) USING TIMESTAMP 16 -- on node1
54: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) LIMIT 921 --
by token, on node1
55: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) LIMIT 679 -- by token range, on node1
56: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v3,
v2) VALUES ('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000,
00000000-0000-4a00-8c00-000000000000, 0x3cfba69ba50245, (-16323,
{3.633346E-25}), [[1151922109, 1690784253], [1784763947, -143592121],
[-1530655107, 1326912056]], {{f0: 0x19d176c92cb8}: [-7441098625465562907,
6685037052700030619], {f0: 0x883bcf7bed789c}: [-23021965732989622,
-5678634307471068018]}, 2637179460878857783 * 7579289663952885632, [{f0: false,
f1: 26, f2: '씎䷀쭫恃ꍑ췴躳䯑푶'}, {f0: true, f1: -101, f2: '宂둉樑䗟'}]) USING TIMESTAMP
17 -- on node1
57: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 LIMIT 921 -- By Partition Key, on
node1
58: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) PER PARTITION
LIMIT 45 LIMIT 760 -- by token, on node1
59: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND ck0 >=
00000000-0000-4600-b400-000000000000 PER PARTITION LIMIT 466 LIMIT 898 ALLOW
FILTERING -- ck0 uuid (reversed), indexed with SAI, on node1
60: SELECT * FROM ks1.tbl WHERE s0 = (-16323, {3.633346E-25})
AND pk1 = 00000000-0000-4500-9e00-000000000000 AND v3 = -844467582658381797 AND
v1 = {{f0: 0x487ddc7830}: [7904404607542179003, -457828847990759307], {f0:
0xe5216b5d7d0e0381787b}: [-8132031026799433302, -7693009312950744208]} AND ck1
= 0x63f5 AND ck0 = 00000000-0000-4a00-8c00-000000000000 PER PARTITION LIMIT 372
LIMIT 166 ALLOW FILTERING -- s0 frozen<tuple<smallint, frozen<set<float>>>>
(indexed with SAI), pk1 uuid (indexed with SAI), v3 bigint (indexed with SAI),
v1 frozen<map<frozen<"0">, vector<bigint, 2>>> (indexed with SAI), ck1 blob
(reversed), ck0 uuid (reversed) (indexed with SAI), on node1
61: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 PER PARTITION LIMIT 203 -- By
Partition Key, on node1
62: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 PER PARTITION LIMIT 82 -- By
Partition Key, on node1
63: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
ck1 = 0x3cfba69ba50245 AND v1 = {{f0: 0x19d176c92cb8}: [-7441098625465562907,
6685037052700030619], {f0: 0x883bcf7bed789c}: [-23021965732989622,
-5678634307471068018]} AND ck0 = 00000000-0000-4b00-8a00-000000000000 AND pk1 =
00000000-0000-4000-ad00-000000000000 AND v3 = 1085511645222800011 AND s0 =
(-16323, {3.633346E-25}) PER PARTITION LIMIT 266 ALLOW FILTERING -- pk0 time
(indexed with SAI), ck1 blob (reversed), v1 frozen<map<frozen<"0">,
vector<bigint, 2>>> (indexed with SAI), ck0 uuid (reversed) (indexed with SAI),
pk1 uuid (indexed with SAI), v3 bigint (indexed with SAI), s0
frozen<tuple<smallint, frozen<set<float>>>> (indexed with SAI), on node1
64: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) PER PARTITION LIMIT 977 LIMIT 835 -- by
token range, on node1
65: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 AND ck0 =
00000000-0000-4a00-8c00-000000000000 AND ck1 = 0x3cfba69ba50245 PER PARTITION
LIMIT 842 LIMIT 900 -- By Primary Key, on node1
66: SELECT * FROM ks1.tbl WHERE v1 = {{f0: 0x5df1}:
[414225888834712632, -5730196176171247108], {f0: 0x92c1497d7072b81c91}:
[-7587541014989351350, -2813091340484612608]} AND ck1 = 0x3cfba69ba50245 AND
pk0 = '07:08:47.775161332' AND ck0 = 00000000-0000-4a00-a500-000000000000 PER
PARTITION LIMIT 700 LIMIT 464 ALLOW FILTERING -- v1 frozen<map<frozen<"0">,
vector<bigint, 2>>> (indexed with SAI), ck1 blob (reversed), pk0 time (indexed
with SAI), ck0 uuid (reversed) (indexed with SAI), on node1
67: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND ck0 =
00000000-0000-4600-b400-000000000000 AND ck1 = 0x63f5 -- By Primary Key, on
node1
68: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) PER PARTITION LIMIT 28 LIMIT 413 -- by
token range, on node1
69: DELETE FROM ks1.tbl USING TIMESTAMP 18 WHERE pk0 =
'04:57:43.310908495' AND pk1 = 00000000-0000-4500-9300-000000000000 -- on node1
70: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 >
00000000-0000-4500-8500-000000000000 PER PARTITION LIMIT 706 ALLOW FILTERING --
ck0 uuid (reversed), indexed with SAI, on node1
71: UPDATE ks1.tbl USING TIMESTAMP 19 SET v1={{f0:
0xc0082750d3dcdf38}: [5588198537739420010, -639973581677511835]}, v2=[{f0:
false, f1: 33, f2: '鏽ᄓ똰忢'}, {f0: true, f1: 124, f2: '⒌疳㮑痕ࠀ'}], s0=(-32759,
{-53.369495, 4.6899182E23}) WHERE pk0 = '02:43:47.716011275' AND pk1 =
00000000-0000-4200-b200-000000000000 AND ck0 =
00000000-0000-4e00-8100-000000000000 AND ck1 = 0xfc05ba5e68e8 -- on node1
72: SELECT * FROM ks1.tbl WHERE ck1 = 0x63f5 AND ck0 =
00000000-0000-4a00-a500-000000000000 PER PARTITION LIMIT 318 LIMIT 978 ALLOW
FILTERING -- ck1 blob (reversed), ck0 uuid (reversed) (indexed with SAI), on
node1
73: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token('02:43:47.716011275', 00000000-0000-4200-b200-000000000000) PER PARTITION
LIMIT 738 LIMIT 170 -- by token range, on node1, fetch size 1000
74: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) LIMIT 654 --
by token, on node1, fetch size 10
75: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND ck0 =
00000000-0000-4600-b400-000000000000 LIMIT 385 ALLOW FILTERING -- ck0 uuid
(reversed), indexed with SAI, on node1, fetch size 1
76: SELECT * FROM ks1.tbl WHERE pk0 = '02:43:47.716011275' AND
pk1 = 00000000-0000-4200-b200-000000000000 LIMIT 200 -- By Partition Key, on
node1, fetch size 10
77: DELETE FROM ks1.tbl USING TIMESTAMP 20 WHERE pk0 =
'23:58:16.336753539' AND pk1 = 00000000-0000-4400-8200-000000000000 AND ck0 =
00000000-0000-4900-9800-000000000000 AND ck1 = 0xcea410ce94 -- on node1
78: SELECT * FROM ks1.tbl WHERE v3 = 9206814797433618983 AND s0
= (-32759, {-53.369495, 4.6899182E23}) ALLOW FILTERING -- v3 bigint (indexed
with SAI), s0 frozen<tuple<smallint, frozen<set<float>>>> (indexed with SAI),
on node1, fetch size 1000
79: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 PER PARTITION LIMIT 22 -- By
Partition Key, on node1, fetch size 10
80: DELETE FROM ks1.tbl USING TIMESTAMP 21 WHERE pk0 =
'07:08:47.775161332' AND pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 =
00000000-0000-4f00-8600-000000000000 AND ck1 = 0xd1e5f09b32 -- on node1
81: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) PER PARTITION LIMIT 114 -- by token
range, on node1, fetch size 1000
82: SELECT * FROM ks1.tbl WHERE pk1 =
00000000-0000-4500-9e00-000000000000 AND ck1 = 0x3cfba69ba50245 LIMIT 889 ALLOW
FILTERING -- pk1 uuid (indexed with SAI), ck1 blob (reversed), on node1, fetch
size 10
83: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) LIMIT 252 --
by token, on node1, fetch size 1000
84: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) PER PARTITION LIMIT 557 LIMIT 866 -- by
token range, on node1, fetch size 1000
85: SELECT * FROM ks1.tbl WHERE v1 >= {{f0:
0xc0082750d3dcdf38}: [5588198537739420010, -639973581677511835]} ALLOW
FILTERING -- v1 frozen<map<frozen<"0">, vector<bigint, 2>>>, indexed with SAI,
on node1, fetch size 100
86: SELECT * FROM ks1.tbl WHERE pk0 = '02:43:47.716011275' AND
pk1 = 00000000-0000-4200-b200-000000000000 AND v1 > {{f0: 0xc0082750d3dcdf38}:
[5588198537739420010, -639973581677511835]} PER PARTITION LIMIT 94 LIMIT 26
ALLOW FILTERING -- v1 frozen<map<frozen<"0">, vector<bigint, 2>>>, indexed with
SAI, on node1
87: SELECT * FROM ks1.tbl WHERE v1 = {{f0: 0x73e1}:
[-6348065865830433534, -6759265680224526862], {f0: 0x812d}:
[8558329330827688068, 7430601506500167401]} AND pk0 = '07:08:47.775161332' AND
s0 = (28387, {-1.18764904E-20}) AND pk1 = 00000000-0000-4000-ad00-000000000000
AND ck1 = 0xa06bb301 LIMIT 966 ALLOW FILTERING -- v1 frozen<map<frozen<"0">,
vector<bigint, 2>>> (indexed with SAI), pk0 time (indexed with SAI), s0
frozen<tuple<smallint, frozen<set<float>>>> (indexed with SAI), pk1 uuid
(indexed with SAI), ck1 blob (reversed), on node1
88: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 AND ck1 > 0xfef0d63ff7 PER PARTITION
LIMIT 212 ALLOW FILTERING -- ck1 blob (reversed), on node1
89: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) LIMIT 343 --
by token range, on node1
90: SELECT * FROM ks1.tbl WHERE pk0 = '02:43:47.716011275' AND
pk1 = 00000000-0000-4200-b200-000000000000 -- By Partition Key, on node1
91: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 AND v3 = 5794306794061466752 PER
PARTITION LIMIT 22 -- v3 bigint, indexed with SAI, on node1
92: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) LIMIT 488 -- by token range, on node1
93: SELECT * FROM ks1.tbl WHERE ck0 =
00000000-0000-4e00-8100-000000000000 AND v1 = {{f0: 0xd9c3ab}:
[-9002034104664383537, -8074261670215737032]} PER PARTITION LIMIT 89 ALLOW
FILTERING -- ck0 uuid (reversed) (indexed with SAI), v1 frozen<map<frozen<"0">,
vector<bigint, 2>>> (indexed with SAI), on node1
94: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) -- by token,
on node1
95: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token(pk0, pk1) <= token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) -- by token range, on node1
96: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND v3 = -1345538647735785820 LIMIT
851 -- v3 bigint, indexed with SAI, on node1
97: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('02:43:47.716011275', 00000000-0000-4200-b200-000000000000) PER PARTITION
LIMIT 902 -- by token, on node1
98: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) PER PARTITION
LIMIT 345 -- by token, on node1
99: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 AND ck1 = 0x3cfba69ba50245 ALLOW
FILTERING -- ck1 blob (reversed), on node1
100: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND ck0 =
00000000-0000-4000-9f00-000000000000 AND ck1 = 0xa06bb301 PER PARTITION LIMIT
58 -- By Primary Key, on node1
101: DELETE FROM ks1.tbl USING TIMESTAMP 22 WHERE pk0 =
'07:08:47.775161332' AND pk1 = 00000000-0000-4800-ad00-000000000000 -- on node1
102: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) PER PARTITION LIMIT 32 -- by token range,
on node1
103: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND v3 >= 9206814797433618983 -- v3
bigint, indexed with SAI, on node1
104: SELECT * FROM ks1.tbl WHERE pk0 = '02:43:47.716011275' AND
pk1 = 00000000-0000-4200-b200-000000000000 LIMIT 311 -- By Partition Key, on
node1
105: SELECT * FROM ks1.tbl WHERE ck0 =
00000000-0000-4a00-8c00-000000000000 AND v3 = 9206814797433618983 AND v1 =
{{f0: 0xc0082750d3dcdf38}: [5588198537739420010, -639973581677511835]} PER
PARTITION LIMIT 58 ALLOW FILTERING -- ck0 uuid (reversed) (indexed with SAI),
v3 bigint (indexed with SAI), v1 frozen<map<frozen<"0">, vector<bigint, 2>>>
(indexed with SAI), on node1
106: DELETE FROM ks1.tbl USING TIMESTAMP 23 WHERE pk0 =
'07:08:47.775161332' AND pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 =
00000000-0000-4f00-b800-000000000000 AND ck1 = 0x823dfa5f87042d -- on node1
107: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token('02:43:47.716011275', 00000000-0000-4200-b200-000000000000) PER PARTITION
LIMIT 25 LIMIT 551 -- by token range, on node1
108: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token('02:43:47.716011275', 00000000-0000-4200-b200-000000000000) PER PARTITION
LIMIT 186 LIMIT 405 -- by token range, on node1
109: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) PER PARTITION LIMIT 152 -- by token
range, on node1, fetch size 1000
110: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 AND ck1 > 0x3cfba69ba50245 LIMIT 674
ALLOW FILTERING -- ck1 blob (reversed), on node1, fetch size 1000
111: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 AND ck0 =
00000000-0000-4a00-8c00-000000000000 LIMIT 906 ALLOW FILTERING -- ck0 uuid
(reversed), indexed with SAI, on node1, fetch size 1000
112: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) PER PARTITION
LIMIT 65 LIMIT 559 -- by token, on node1
113: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
ck1 = 0xfc05ba5e68e8 AND v3 = -1345538647735785820 AND pk1 =
00000000-0000-4200-b200-000000000000 AND ck0 =
00000000-0000-4600-b400-000000000000 AND s0 = (-16323, {3.633346E-25}) AND v1 =
{{f0: 0xc0082750d3dcdf38}: [5588198537739420010, -639973581677511835]} LIMIT
318 ALLOW FILTERING -- pk0 time (indexed with SAI), ck1 blob (reversed), v3
bigint (indexed with SAI), pk1 uuid (indexed with SAI), ck0 uuid (reversed)
(indexed with SAI), s0 frozen<tuple<smallint, frozen<set<float>>>> (indexed
with SAI), v1 frozen<map<frozen<"0">, vector<bigint, 2>>> (indexed with SAI),
on node1
114: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 AND ck0 =
00000000-0000-4a00-8c00-000000000000 AND ck1 = 0x3cfba69ba50245 -- By Primary
Key, on node1
115: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
ck0 = 00000000-0000-4000-9f00-000000000000 AND s0 = (-16323, {3.633346E-25})
AND ck1 = 0xfc05ba5e68e8 LIMIT 95 ALLOW FILTERING -- pk0 time (indexed with
SAI), ck0 uuid (reversed) (indexed with SAI), s0 frozen<tuple<smallint,
frozen<set<float>>>> (indexed with SAI), ck1 blob (reversed), on node1, fetch
size 10
116: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) PER PARTITION
LIMIT 57 LIMIT 619 -- by token, on node1, fetch size 10
117: SELECT * FROM ks1.tbl WHERE pk0 = '02:43:47.716011275' AND
pk1 = 00000000-0000-4200-b200-000000000000 AND ck0 =
00000000-0000-4e00-8100-000000000000 AND ck1 = 0xfc05ba5e68e8 PER PARTITION
LIMIT 30 -- By Primary Key, on node1, fetch size 1000
118: SELECT * FROM ks1.tbl WHERE v3 = 9206814797433618983 AND
ck1 = 0xa06bb301 PER PARTITION LIMIT 148 LIMIT 443 ALLOW FILTERING -- v3 bigint
(indexed with SAI), ck1 blob (reversed), on node1, fetch size 1000
119: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) <= token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) PER PARTITION LIMIT 69 -- by token range,
on node1, fetch size 10
120: SELECT * FROM ks1.tbl WHERE pk1 =
00000000-0000-4200-b200-000000000000 AND v1 = {{f0: 0x19d176c92cb8}:
[-7441098625465562907, 6685037052700030619], {f0: 0x883bcf7bed789c}:
[-23021965732989622, -5678634307471068018]} AND s0 = (-16323, {3.633346E-25})
AND pk0 = '05:05:39.676771737' AND ck1 = 0xa06bb301 AND ck0 =
00000000-0000-4000-9f00-000000000000 PER PARTITION LIMIT 741 ALLOW FILTERING --
pk1 uuid (indexed with SAI), v1 frozen<map<frozen<"0">, vector<bigint, 2>>>
(indexed with SAI), s0 frozen<tuple<smallint, frozen<set<float>>>> (indexed
with SAI), pk0 time (indexed with SAI), ck1 blob (reversed), ck0 uuid
(reversed) (indexed with SAI), on node1, fetch size 1000
121: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 LIMIT 54 -- By Partition Key, on
node1, fetch size 5000
122: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token(pk0, pk1) <= token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) PER PARTITION LIMIT 943 LIMIT 317 -- by
token range, on node1, fetch size 10
123: SELECT * FROM ks1.tbl WHERE pk0 = '02:43:47.716011275' AND
pk1 = 00000000-0000-4200-b200-000000000000 AND v2 < [{f0: false, f1: 33, f2:
'鏽ᄓ똰忢'}, {f0: true, f1: 124, f2: '⒌疳㮑痕ࠀ'}] LIMIT 151 ALLOW FILTERING -- v2
vector<frozen<"g8BJ1wxrLatl5q3OkJhLsD1FaKwFx8qu2Tjyqk1BOt">, 2>, on node1,
fetch size 5000
124: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4500-9e00-000000000000 AND v1 = {{f0: 0x19d176c92cb8}:
[-7441098625465562907, 6685037052700030619], {f0: 0x883bcf7bed789c}:
[-23021965732989622, -5678634307471068018]} AND ck1 = 0x3cfba69ba50245 AND s0 =
(-16323, {3.633346E-25}) AND ck0 = 00000000-0000-4600-b400-000000000000 AND v3
= 5794306794061466752 LIMIT 31 ALLOW FILTERING -- pk0 time (indexed with SAI),
pk1 uuid (indexed with SAI), v1 frozen<map<frozen<"0">, vector<bigint, 2>>>
(indexed with SAI), ck1 blob (reversed), s0 frozen<tuple<smallint,
frozen<set<float>>>> (indexed with SAI), ck0 uuid (reversed) (indexed with
SAI), v3 bigint (indexed with SAI), on node1, fetch size 1000
125: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) PER PARTITION
LIMIT 984 LIMIT 56 -- by token, on node1
126: SELECT * FROM ks1.tbl WHERE s0 = (28387,
{-1.18764904E-20}) AND pk1 = 00000000-0000-4000-ad00-000000000000 AND ck1 =
0xa06bb301 PER PARTITION LIMIT 25 LIMIT 307 ALLOW FILTERING -- s0
frozen<tuple<smallint, frozen<set<float>>>> (indexed with SAI), pk1 uuid
(indexed with SAI), ck1 blob (reversed), on node1
Caused by: java.lang.AssertionError: No rows returned
Expected:
pk0 | pk1 | ck0
| ck1 | s0 | v0
| v1
| v2
| v3
'03:36:30.876439626' | 00000000-0000-4000-ad00-000000000000 |
00000000-0000-4000-9f00-000000000000 | 0xa06bb301 | (28387, {-1.18764904E-20})
| [[672139924, -1253475201], [353181149, -1829076723], [179355765, 379303855]]
| {{f0: 0x64850696464d}: [-7485547085069825418, 7795885370802556756], {f0:
0x67633db6f091}: [-8484578637223040646, 8216210044102487771]} | [{f0: true, f1:
68, f2: '䝿ᝧ䶨푥펟겭매郂쀌'}, {f0: true, f1: 98, f2: '髃爫삿챥卛☓읂ີ?'}] | 9206814797433618983
{code}
I ran this seed bug disabled PER PARTITION LIMIT (and made sure this didn't
break the random history) and the test fails the same way
was (Author: dcapwell):
Here is another possible seed
https://github.com/apache/cassandra/pull/4006
SHA: 6aaf39a6563314bc110c8ef217d09dd66ca6ced0
{code}
accord.utils.Property$PropertyError: Property error detected:
Seed = -464866883761188308
Examples = 1
Pure = true
Error: Unexpected results for query: SELECT * FROM ks1.tbl WHERE s0 = (28387,
{-1.18764904E-20}) AND pk1 = 00000000-0000-4000-ad00-000000000000 AND ck1 =
0xa06bb301 PER PARTITION LIMIT 25 LIMIT 307 ALLOW FILTERING
Steps: 400
Values:
State:
Setup:
CREATE KEYSPACE IF NOT EXISTS ks1 WITH replication = {'class':
'SimpleStrategy', 'replication_factor': 1};
CREATE TYPE IF NOT EXISTS ks1."0" (
f0 blob
);;
CREATE TYPE IF NOT EXISTS
ks1."g8BJ1wxrLatl5q3OkJhLsD1FaKwFx8qu2Tjyqk1BOt" (
f0 boolean,
f1 tinyint,
f2 text
);;
CREATE TABLE ks1.tbl (
pk0 time,
pk1 uuid,
ck0 uuid,
ck1 blob,
s0 frozen<tuple<smallint, frozen<set<float>>>> static,
v0 vector<vector<int, 2>, 3>,
v1 frozen<map<frozen<"0">, vector<bigint, 2>>>,
v2
vector<frozen<"g8BJ1wxrLatl5q3OkJhLsD1FaKwFx8qu2Tjyqk1BOt">, 2>,
v3 bigint,
PRIMARY KEY ((pk0, pk1), ck0, ck1)
) WITH CLUSTERING ORDER BY (ck0 DESC, ck1 DESC)
AND additional_write_policy = '99p'
AND allow_auto_snapshot = true
AND bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND cdc = false
AND comment = ''
AND compaction = {'bucket_high': '1.5692993708987346',
'bucket_low': '0.21912280187999553', 'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32', 'min_sstable_size': '15728640', 'min_threshold': '4',
'only_purge_repaired_tombstones': 'false', 'provide_overlapping_tombstones':
'CELL', 'tombstone_threshold': '0.26826942'}
AND compression = {'enabled': 'false'}
AND memtable = 'default'
AND crc_check_chance = 1.0
AND default_time_to_live = 0
AND extensions = {}
AND gc_grace_seconds = 864000
AND incremental_backups = true
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair = 'BLOCKING'
AND speculative_retry = '99p';
CREATE CUSTOM INDEX tbl_pk0 ON ks1.tbl(pk0) USING
'StorageAttachedIndex';
CREATE CUSTOM INDEX tbl_pk1 ON ks1.tbl(pk1) USING
'StorageAttachedIndex';
CREATE CUSTOM INDEX tbl_ck0 ON ks1.tbl(ck0) USING
'StorageAttachedIndex';
CREATE INDEX tbl_s0 ON ks1.tbl(s0) USING 'SAI';
CREATE INDEX tbl_v1 ON ks1.tbl(FULL(v1)) USING 'SAI';
CREATE INDEX tbl_v3 ON ks1.tbl(v3) USING 'SAI';:
org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.State
History:
1: DELETE s0 FROM ks1.tbl USING TIMESTAMP 1 WHERE pk0 =
'05:05:39.676771737' AND pk1 = 00000000-0000-4500-9e00-000000000000 -- on node1
2: DELETE FROM ks1.tbl USING TIMESTAMP 2 WHERE pk0 =
'07:08:47.775161332' AND pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 =
00000000-0000-4a00-a600-000000000000 AND ck1 = 0x65bb -- on node1
3: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2, v3)
VALUES ('02:43:47.716011275', 00000000-0000-4200-b200-000000000000,
00000000-0000-4e00-8400-000000000000, 0xf2791941aea8e469, (12129,
{-2.58545975E14}), [[-1781797567, 330686172], [103364202, 2031130152],
[-550709009, 492544493]], {{f0: 0x34839b8bae653b2bdee8}: [-8431172225521461427,
8894719445990427242]}, [{f0: false, f1: 53, f2: '嵆왛孷쏆䊖恣'}, {f0: true, f1: 21,
f2: 'ᨚ?榥쯢?ɚ챛ퟡ'}], 9167463065336786821) USING TIMESTAMP 3 -- on node1
4: SELECT * FROM ks1.tbl PER PARTITION LIMIT 238 LIMIT 253 --
full table scan, on node1
5: SELECT * FROM ks1.tbl WHERE ck0 =
00000000-0000-4e00-8400-000000000000 AND ck1 = 0xf2791941aea8e469 AND pk0 =
'02:43:47.716011275' AND s0 = (12129, {-2.58545975E14}) AND v1 = {{f0:
0x34839b8bae653b2bdee8}: [-8431172225521461427, 8894719445990427242]} AND pk1 =
00000000-0000-4200-b200-000000000000 AND v3 = 9167463065336786821 PER PARTITION
LIMIT 728 ALLOW FILTERING -- ck0 uuid (reversed) (indexed with SAI), ck1 blob
(reversed), pk0 time (indexed with SAI), s0 frozen<tuple<smallint,
frozen<set<float>>>> (indexed with SAI), v1 frozen<map<frozen<"0">,
vector<bigint, 2>>> (indexed with SAI), pk1 uuid (indexed with SAI), v3 bigint
(indexed with SAI), on node1, fetch size 1000
6: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('02:43:47.716011275', 00000000-0000-4200-b200-000000000000) AND
token(pk0, pk1) <= token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) -- by token range, on node1
7: UPDATE ks1.tbl USING TIMESTAMP 4 SET s0=(23307,
{-8.214548E-18}), v0=[[672139924, -1253475201], [353181149, -1829076723],
[179355765, 379303855]], v1={{f0: 0x64850696464d}: [-7485547085069825418,
7795885370802556756], {f0: 0x67633db6f091}: [-8484578637223040646,
8216210044102487771]}, v2=[{f0: true, f1: 68, f2: '䝿ᝧ䶨푥펟겭매郂쀌'}, {f0: true, f1:
98, f2: '髃爫삿챥卛☓읂ີ?'}], v3=-4626482462417652499 * -7377486305688263453 WHERE
pk0 = '03:36:30.876439626' AND pk1 = 00000000-0000-4000-ad00-000000000000 AND
ck0 = 00000000-0000-4000-9f00-000000000000 AND ck1 = 0xa06bb301 -- on node1
8: SELECT * FROM ks1.tbl WHERE ck1 = 0xa06bb301 AND pk0 =
'02:43:47.716011275' AND v1 = {{f0: 0x34839b8bae653b2bdee8}:
[-8431172225521461427, 8894719445990427242]} AND s0 = (12129, {-2.58545975E14})
AND pk1 = 00000000-0000-4000-ad00-000000000000 AND ck0 =
00000000-0000-4e00-8400-000000000000 PER PARTITION LIMIT 150 LIMIT 329 ALLOW
FILTERING -- ck1 blob (reversed), pk0 time (indexed with SAI), v1
frozen<map<frozen<"0">, vector<bigint, 2>>> (indexed with SAI), s0
frozen<tuple<smallint, frozen<set<float>>>> (indexed with SAI), pk1 uuid
(indexed with SAI), ck0 uuid (reversed) (indexed with SAI), on node1
9: SELECT * FROM ks1.tbl WHERE pk0 = '02:43:47.716011275' AND
pk1 = 00000000-0000-4200-b200-000000000000 AND ck0 =
00000000-0000-4e00-8400-000000000000 AND ck1 = 0xf2791941aea8e469 PER PARTITION
LIMIT 245 LIMIT 338 -- By Primary Key, on node1
10: SELECT * FROM ks1.tbl WHERE pk1 =
00000000-0000-4000-ad00-000000000000 AND s0 = (12129, {-2.58545975E14}) AND ck1
= 0xa06bb301 AND v3 = 9206814797433618983 PER PARTITION LIMIT 812 ALLOW
FILTERING -- pk1 uuid (indexed with SAI), s0 frozen<tuple<smallint,
frozen<set<float>>>> (indexed with SAI), ck1 blob (reversed), v3 bigint
(indexed with SAI), on node1, fetch size 1000
11: SELECT * FROM ks1.tbl WHERE s0 = (23307, {-8.214548E-18})
AND ck0 = 00000000-0000-4000-9f00-000000000000 AND ck1 = 0xa06bb301 AND pk0 =
'02:43:47.716011275' AND v1 = {{f0: 0x34839b8bae653b2bdee8}:
[-8431172225521461427, 8894719445990427242]} AND pk1 =
00000000-0000-4000-ad00-000000000000 ALLOW FILTERING -- s0
frozen<tuple<smallint, frozen<set<float>>>> (indexed with SAI), ck0 uuid
(reversed) (indexed with SAI), ck1 blob (reversed), pk0 time (indexed with
SAI), v1 frozen<map<frozen<"0">, vector<bigint, 2>>> (indexed with SAI), pk1
uuid (indexed with SAI), on node1
12: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) -- by token range, on node1
13: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) -- by token range, on node1
14: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) LIMIT 845 -- by token range, on node1,
fetch size 1000
15: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) <= token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) LIMIT 680 -- by token range, on node1
16: SELECT * FROM ks1.tbl WHERE ck1 = 0xa06bb301 AND v1 = {{f0:
0x64850696464d}: [-7485547085069825418, 7795885370802556756], {f0:
0x67633db6f091}: [-8484578637223040646, 8216210044102487771]} AND ck0 =
00000000-0000-4e00-8400-000000000000 PER PARTITION LIMIT 462 ALLOW FILTERING --
ck1 blob (reversed), v1 frozen<map<frozen<"0">, vector<bigint, 2>>> (indexed
with SAI), ck0 uuid (reversed) (indexed with SAI), on node1
17: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
v3) VALUES ('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000,
00000000-0000-4a00-a500-000000000000, 0xfef0d63ff7, (-15283, {-1.132058E24,
2.9319742E-31}), [[-335960956, 678086816], [-2139882146, 1011627708],
[-55338955, -2094185756]], {{f0: 0xd9c3ab}: [-9002034104664383537,
-8074261670215737032]}, [{f0: true, f1: -79, f2: '霠♘칳⦵ঋ幗䶐'}, {f0: true, f1: 7,
f2: '䉻ݹ鞞텔㙠'}], 1885613374025825905) USING TIMESTAMP 5 -- on node1
18: DELETE FROM ks1.tbl USING TIMESTAMP 6 WHERE pk0 =
'14:02:14.975449434' AND pk1 = 00000000-0000-4900-9900-000000000000 -- on node1
19: DELETE FROM ks1.tbl USING TIMESTAMP 7 WHERE pk0 =
'12:15:35.151327231' AND pk1 = 00000000-0000-4500-ac00-000000000000 -- on node1
20: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
v1 = {{f0: 0x34839b8bae653b2bdee8}: [-8431172225521461427,
8894719445990427242]} AND v3 = 9206814797433618983 AND ck1 = 0xfef0d63ff7 AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND s0 = (23307, {-8.214548E-18})
AND ck0 = 00000000-0000-4e00-8400-000000000000 PER PARTITION LIMIT 78 ALLOW
FILTERING -- pk0 time (indexed with SAI), v1 frozen<map<frozen<"0">,
vector<bigint, 2>>> (indexed with SAI), v3 bigint (indexed with SAI), ck1 blob
(reversed), pk1 uuid (indexed with SAI), s0 frozen<tuple<smallint,
frozen<set<float>>>> (indexed with SAI), ck0 uuid (reversed) (indexed with
SAI), on node1, fetch size 10
21: DELETE FROM ks1.tbl USING TIMESTAMP 8 WHERE pk0 =
'07:08:47.775161332' AND pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 =
00000000-0000-4b00-b000-000000000000 AND ck1 = 0xa4121adb08 -- on node1
22: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 PER PARTITION LIMIT 101 LIMIT 260 --
By Partition Key, on node1, fetch size 100
23: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
v3) VALUES ('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000,
00000000-0000-4600-b400-000000000000, 0x63f5, (28387, {-1.18764904E-20}),
[[-441895935, 313114446], [-740629531, -678512740], [1429899934, -1259907921]],
{{f0: 0x5df1}: [414225888834712632, -5730196176171247108], {f0:
0x92c1497d7072b81c91}: [-7587541014989351350, -2813091340484612608]}, [{f0:
true, f1: 41, f2: '쎺╇⒀왶'}, {f0: true, f1: -84, f2: '턺䋏篷'}],
-1473884563651667176 + 128345915915881356) USING TIMESTAMP 9 -- on node1
24: SELECT * FROM ks1.tbl PER PARTITION LIMIT 765 LIMIT 966 --
full table scan, on node1, fetch size 10
25: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) LIMIT 930 -- by token range, on node1,
fetch size 1
26: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) PER PARTITION LIMIT 390 LIMIT 371 -- by
token range, on node1, fetch size 10
27: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('02:43:47.716011275', 00000000-0000-4200-b200-000000000000) -- by token,
on node1, fetch size 10
28: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) LIMIT 674 -- by token range, on node1
29: DELETE FROM ks1.tbl USING TIMESTAMP 10 WHERE pk0 =
'02:43:47.716011275' AND pk1 = 00000000-0000-4200-b200-000000000000 -- on node1
30: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 -- By Partition Key, on node1
31: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token(pk0, pk1) <= token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) -- by token range, on node1
32: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND ck1 = 0x63f5 PER PARTITION LIMIT
121 LIMIT 268 ALLOW FILTERING -- ck1 blob (reversed), on node1
33: DELETE s0, s0 FROM ks1.tbl USING TIMESTAMP 11 WHERE pk0 =
'07:08:47.775161332' AND pk1 = 00000000-0000-4800-ad00-000000000000 -- on node1
34: DELETE FROM ks1.tbl USING TIMESTAMP 12 WHERE pk0 =
'14:02:14.975449434' AND pk1 = 00000000-0000-4900-9900-000000000000 -- on node1
35: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) PER PARTITION LIMIT 77 LIMIT 406 -- by
token range, on node1
36: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) LIMIT 878 --
by token, on node1
37: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 -- By Partition Key, on node1
38: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 LIMIT 336 -- By Partition Key, on
node1
39: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 AND v2 = [{f0: true, f1: -79, f2:
'霠♘칳⦵ঋ幗䶐'}, {f0: true, f1: 7, f2: '䉻ݹ鞞텔㙠'}] PER PARTITION LIMIT 448 LIMIT 827
ALLOW FILTERING -- v2
vector<frozen<"g8BJ1wxrLatl5q3OkJhLsD1FaKwFx8qu2Tjyqk1BOt">, 2>, on node1
40: nodetool flush ks1 tbl
41: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) PER PARTITION
LIMIT 200 LIMIT 16 -- by token, on node1, fetch size 10
42: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) PER PARTITION LIMIT 499 -- by token
range, on node1, fetch size 1000
43: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) LIMIT 521 --
by token, on node1, fetch size 10
44: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v2,
v3) VALUES ('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000,
00000000-0000-4b00-8a00-000000000000, 0x796832dd393ed9, (-5067, {1.6430526E-26,
9.1520835E-9}), [[282190412, -1332742488], [-1326870972, -1507032445],
[2130920808, -507072905]], {{f0: 0x487ddc7830}: [7904404607542179003,
-457828847990759307], {f0: 0xe5216b5d7d0e0381787b}: [-8132031026799433302,
-7693009312950744208]}, [{f0: false, f1: -23, f2: '뷛熬羚?㵩䒪䰀鳷'}, {f0: true, f1:
10, f2: '滠?겨䍝쌢⟚㩊'}], -2173067216381309339 * 8003217163647839791) USING
TIMESTAMP 13 -- on node1
45: DELETE FROM ks1.tbl USING TIMESTAMP 14 WHERE pk0 =
'09:30:17.241628150' AND pk1 = 00000000-0000-4b00-b100-000000000000 AND ck0 =
00000000-0000-4000-9100-000000000000 AND ck1 = 0x3cafa20e28bf -- on node1
46: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 =
00000000-0000-4a00-a500-000000000000 AND ck1 = 0xfef0d63ff7 LIMIT 126 -- By
Primary Key, on node1, fetch size 10
47: SELECT * FROM ks1.tbl WHERE v1 = {{f0: 0x64850696464d}:
[-7485547085069825418, 7795885370802556756], {f0: 0x67633db6f091}:
[-8484578637223040646, 8216210044102487771]} AND ck0 =
00000000-0000-4000-9f00-000000000000 AND pk1 =
00000000-0000-4800-ad00-000000000000 AND s0 = (28387, {-1.18764904E-20}) AND v3
= 9206814797433618983 AND ck1 = 0xfef0d63ff7 AND pk0 = '03:36:30.876439626'
LIMIT 579 ALLOW FILTERING -- v1 frozen<map<frozen<"0">, vector<bigint, 2>>>
(indexed with SAI), ck0 uuid (reversed) (indexed with SAI), pk1 uuid (indexed
with SAI), s0 frozen<tuple<smallint, frozen<set<float>>>> (indexed with SAI),
v3 bigint (indexed with SAI), ck1 blob (reversed), pk0 time (indexed with SAI),
on node1, fetch size 100
48: DELETE FROM ks1.tbl USING TIMESTAMP 15 WHERE pk0 =
'07:08:47.775161332' AND pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 =
00000000-0000-4a00-9f00-000000000000 AND ck1 = 0x96 -- on node1
49: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) LIMIT 963 --
by token range, on node1, fetch size 10
50: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 =
00000000-0000-4a00-a500-000000000000 AND ck1 = 0xfef0d63ff7 LIMIT 16 -- By
Primary Key, on node1, fetch size 10
51: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) LIMIT 341 -- by token range, on node1
52: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) -- by token range, on node1
53: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, v3, v1, v0) VALUES
('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000,
00000000-0000-4500-8500-000000000000, 0x6d698f, 4193636848147638568 -
5038104430806020365, {{f0: 0x73e1}: [-6348065865830433534,
-6759265680224526862], {f0: 0x812d}: [8558329330827688068,
7430601506500167401]}, null) USING TIMESTAMP 16 -- on node1
54: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) LIMIT 921 --
by token, on node1
55: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) LIMIT 679 -- by token range, on node1
56: INSERT INTO ks1.tbl (pk0, pk1, ck0, ck1, s0, v0, v1, v3,
v2) VALUES ('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000,
00000000-0000-4a00-8c00-000000000000, 0x3cfba69ba50245, (-16323,
{3.633346E-25}), [[1151922109, 1690784253], [1784763947, -143592121],
[-1530655107, 1326912056]], {{f0: 0x19d176c92cb8}: [-7441098625465562907,
6685037052700030619], {f0: 0x883bcf7bed789c}: [-23021965732989622,
-5678634307471068018]}, 2637179460878857783 * 7579289663952885632, [{f0: false,
f1: 26, f2: '씎䷀쭫恃ꍑ췴躳䯑푶'}, {f0: true, f1: -101, f2: '宂둉樑䗟'}]) USING TIMESTAMP
17 -- on node1
57: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 LIMIT 921 -- By Partition Key, on
node1
58: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) PER PARTITION
LIMIT 45 LIMIT 760 -- by token, on node1
59: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND ck0 >=
00000000-0000-4600-b400-000000000000 PER PARTITION LIMIT 466 LIMIT 898 ALLOW
FILTERING -- ck0 uuid (reversed), indexed with SAI, on node1
60: SELECT * FROM ks1.tbl WHERE s0 = (-16323, {3.633346E-25})
AND pk1 = 00000000-0000-4500-9e00-000000000000 AND v3 = -844467582658381797 AND
v1 = {{f0: 0x487ddc7830}: [7904404607542179003, -457828847990759307], {f0:
0xe5216b5d7d0e0381787b}: [-8132031026799433302, -7693009312950744208]} AND ck1
= 0x63f5 AND ck0 = 00000000-0000-4a00-8c00-000000000000 PER PARTITION LIMIT 372
LIMIT 166 ALLOW FILTERING -- s0 frozen<tuple<smallint, frozen<set<float>>>>
(indexed with SAI), pk1 uuid (indexed with SAI), v3 bigint (indexed with SAI),
v1 frozen<map<frozen<"0">, vector<bigint, 2>>> (indexed with SAI), ck1 blob
(reversed), ck0 uuid (reversed) (indexed with SAI), on node1
61: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 PER PARTITION LIMIT 203 -- By
Partition Key, on node1
62: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 PER PARTITION LIMIT 82 -- By
Partition Key, on node1
63: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
ck1 = 0x3cfba69ba50245 AND v1 = {{f0: 0x19d176c92cb8}: [-7441098625465562907,
6685037052700030619], {f0: 0x883bcf7bed789c}: [-23021965732989622,
-5678634307471068018]} AND ck0 = 00000000-0000-4b00-8a00-000000000000 AND pk1 =
00000000-0000-4000-ad00-000000000000 AND v3 = 1085511645222800011 AND s0 =
(-16323, {3.633346E-25}) PER PARTITION LIMIT 266 ALLOW FILTERING -- pk0 time
(indexed with SAI), ck1 blob (reversed), v1 frozen<map<frozen<"0">,
vector<bigint, 2>>> (indexed with SAI), ck0 uuid (reversed) (indexed with SAI),
pk1 uuid (indexed with SAI), v3 bigint (indexed with SAI), s0
frozen<tuple<smallint, frozen<set<float>>>> (indexed with SAI), on node1
64: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) PER PARTITION LIMIT 977 LIMIT 835 -- by
token range, on node1
65: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 AND ck0 =
00000000-0000-4a00-8c00-000000000000 AND ck1 = 0x3cfba69ba50245 PER PARTITION
LIMIT 842 LIMIT 900 -- By Primary Key, on node1
66: SELECT * FROM ks1.tbl WHERE v1 = {{f0: 0x5df1}:
[414225888834712632, -5730196176171247108], {f0: 0x92c1497d7072b81c91}:
[-7587541014989351350, -2813091340484612608]} AND ck1 = 0x3cfba69ba50245 AND
pk0 = '07:08:47.775161332' AND ck0 = 00000000-0000-4a00-a500-000000000000 PER
PARTITION LIMIT 700 LIMIT 464 ALLOW FILTERING -- v1 frozen<map<frozen<"0">,
vector<bigint, 2>>> (indexed with SAI), ck1 blob (reversed), pk0 time (indexed
with SAI), ck0 uuid (reversed) (indexed with SAI), on node1
67: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND ck0 =
00000000-0000-4600-b400-000000000000 AND ck1 = 0x63f5 -- By Primary Key, on
node1
68: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) PER PARTITION LIMIT 28 LIMIT 413 -- by
token range, on node1
69: DELETE FROM ks1.tbl USING TIMESTAMP 18 WHERE pk0 =
'04:57:43.310908495' AND pk1 = 00000000-0000-4500-9300-000000000000 -- on node1
70: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 >
00000000-0000-4500-8500-000000000000 PER PARTITION LIMIT 706 ALLOW FILTERING --
ck0 uuid (reversed), indexed with SAI, on node1
71: UPDATE ks1.tbl USING TIMESTAMP 19 SET v1={{f0:
0xc0082750d3dcdf38}: [5588198537739420010, -639973581677511835]}, v2=[{f0:
false, f1: 33, f2: '鏽ᄓ똰忢'}, {f0: true, f1: 124, f2: '⒌疳㮑痕ࠀ'}], s0=(-32759,
{-53.369495, 4.6899182E23}) WHERE pk0 = '02:43:47.716011275' AND pk1 =
00000000-0000-4200-b200-000000000000 AND ck0 =
00000000-0000-4e00-8100-000000000000 AND ck1 = 0xfc05ba5e68e8 -- on node1
72: SELECT * FROM ks1.tbl WHERE ck1 = 0x63f5 AND ck0 =
00000000-0000-4a00-a500-000000000000 PER PARTITION LIMIT 318 LIMIT 978 ALLOW
FILTERING -- ck1 blob (reversed), ck0 uuid (reversed) (indexed with SAI), on
node1
73: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) AND
token('02:43:47.716011275', 00000000-0000-4200-b200-000000000000) PER PARTITION
LIMIT 738 LIMIT 170 -- by token range, on node1, fetch size 1000
74: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) LIMIT 654 --
by token, on node1, fetch size 10
75: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND ck0 =
00000000-0000-4600-b400-000000000000 LIMIT 385 ALLOW FILTERING -- ck0 uuid
(reversed), indexed with SAI, on node1, fetch size 1
76: SELECT * FROM ks1.tbl WHERE pk0 = '02:43:47.716011275' AND
pk1 = 00000000-0000-4200-b200-000000000000 LIMIT 200 -- By Partition Key, on
node1, fetch size 10
77: DELETE FROM ks1.tbl USING TIMESTAMP 20 WHERE pk0 =
'23:58:16.336753539' AND pk1 = 00000000-0000-4400-8200-000000000000 AND ck0 =
00000000-0000-4900-9800-000000000000 AND ck1 = 0xcea410ce94 -- on node1
78: SELECT * FROM ks1.tbl WHERE v3 = 9206814797433618983 AND s0
= (-32759, {-53.369495, 4.6899182E23}) ALLOW FILTERING -- v3 bigint (indexed
with SAI), s0 frozen<tuple<smallint, frozen<set<float>>>> (indexed with SAI),
on node1, fetch size 1000
79: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 PER PARTITION LIMIT 22 -- By
Partition Key, on node1, fetch size 10
80: DELETE FROM ks1.tbl USING TIMESTAMP 21 WHERE pk0 =
'07:08:47.775161332' AND pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 =
00000000-0000-4f00-8600-000000000000 AND ck1 = 0xd1e5f09b32 -- on node1
81: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) PER PARTITION LIMIT 114 -- by token
range, on node1, fetch size 1000
82: SELECT * FROM ks1.tbl WHERE pk1 =
00000000-0000-4500-9e00-000000000000 AND ck1 = 0x3cfba69ba50245 LIMIT 889 ALLOW
FILTERING -- pk1 uuid (indexed with SAI), ck1 blob (reversed), on node1, fetch
size 10
83: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) LIMIT 252 --
by token, on node1, fetch size 1000
84: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) PER PARTITION LIMIT 557 LIMIT 866 -- by
token range, on node1, fetch size 1000
85: SELECT * FROM ks1.tbl WHERE v1 >= {{f0:
0xc0082750d3dcdf38}: [5588198537739420010, -639973581677511835]} ALLOW
FILTERING -- v1 frozen<map<frozen<"0">, vector<bigint, 2>>>, indexed with SAI,
on node1, fetch size 100
86: SELECT * FROM ks1.tbl WHERE pk0 = '02:43:47.716011275' AND
pk1 = 00000000-0000-4200-b200-000000000000 AND v1 > {{f0: 0xc0082750d3dcdf38}:
[5588198537739420010, -639973581677511835]} PER PARTITION LIMIT 94 LIMIT 26
ALLOW FILTERING -- v1 frozen<map<frozen<"0">, vector<bigint, 2>>>, indexed with
SAI, on node1
87: SELECT * FROM ks1.tbl WHERE v1 = {{f0: 0x73e1}:
[-6348065865830433534, -6759265680224526862], {f0: 0x812d}:
[8558329330827688068, 7430601506500167401]} AND pk0 = '07:08:47.775161332' AND
s0 = (28387, {-1.18764904E-20}) AND pk1 = 00000000-0000-4000-ad00-000000000000
AND ck1 = 0xa06bb301 LIMIT 966 ALLOW FILTERING -- v1 frozen<map<frozen<"0">,
vector<bigint, 2>>> (indexed with SAI), pk0 time (indexed with SAI), s0
frozen<tuple<smallint, frozen<set<float>>>> (indexed with SAI), pk1 uuid
(indexed with SAI), ck1 blob (reversed), on node1
88: SELECT * FROM ks1.tbl WHERE pk0 = '07:08:47.775161332' AND
pk1 = 00000000-0000-4800-ad00-000000000000 AND ck1 > 0xfef0d63ff7 PER PARTITION
LIMIT 212 ALLOW FILTERING -- ck1 blob (reversed), on node1
89: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) LIMIT 343 --
by token range, on node1
90: SELECT * FROM ks1.tbl WHERE pk0 = '02:43:47.716011275' AND
pk1 = 00000000-0000-4200-b200-000000000000 -- By Partition Key, on node1
91: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 AND v3 = 5794306794061466752 PER
PARTITION LIMIT 22 -- v3 bigint, indexed with SAI, on node1
92: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) LIMIT 488 -- by token range, on node1
93: SELECT * FROM ks1.tbl WHERE ck0 =
00000000-0000-4e00-8100-000000000000 AND v1 = {{f0: 0xd9c3ab}:
[-9002034104664383537, -8074261670215737032]} PER PARTITION LIMIT 89 ALLOW
FILTERING -- ck0 uuid (reversed) (indexed with SAI), v1 frozen<map<frozen<"0">,
vector<bigint, 2>>> (indexed with SAI), on node1
94: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('07:08:47.775161332', 00000000-0000-4800-ad00-000000000000) -- by token,
on node1
95: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token(pk0, pk1) <= token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) -- by token range, on node1
96: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND v3 = -1345538647735785820 LIMIT
851 -- v3 bigint, indexed with SAI, on node1
97: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('02:43:47.716011275', 00000000-0000-4200-b200-000000000000) PER PARTITION
LIMIT 902 -- by token, on node1
98: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) PER PARTITION
LIMIT 345 -- by token, on node1
99: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 AND ck1 = 0x3cfba69ba50245 ALLOW
FILTERING -- ck1 blob (reversed), on node1
100: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND ck0 =
00000000-0000-4000-9f00-000000000000 AND ck1 = 0xa06bb301 PER PARTITION LIMIT
58 -- By Primary Key, on node1
101: DELETE FROM ks1.tbl USING TIMESTAMP 22 WHERE pk0 =
'07:08:47.775161332' AND pk1 = 00000000-0000-4800-ad00-000000000000 -- on node1
102: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token(pk0, pk1) < token('03:36:30.876439626',
00000000-0000-4000-ad00-000000000000) PER PARTITION LIMIT 32 -- by token range,
on node1
103: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4000-ad00-000000000000 AND v3 >= 9206814797433618983 -- v3
bigint, indexed with SAI, on node1
104: SELECT * FROM ks1.tbl WHERE pk0 = '02:43:47.716011275' AND
pk1 = 00000000-0000-4200-b200-000000000000 LIMIT 311 -- By Partition Key, on
node1
105: SELECT * FROM ks1.tbl WHERE ck0 =
00000000-0000-4a00-8c00-000000000000 AND v3 = 9206814797433618983 AND v1 =
{{f0: 0xc0082750d3dcdf38}: [5588198537739420010, -639973581677511835]} PER
PARTITION LIMIT 58 ALLOW FILTERING -- ck0 uuid (reversed) (indexed with SAI),
v3 bigint (indexed with SAI), v1 frozen<map<frozen<"0">, vector<bigint, 2>>>
(indexed with SAI), on node1
106: DELETE FROM ks1.tbl USING TIMESTAMP 23 WHERE pk0 =
'07:08:47.775161332' AND pk1 = 00000000-0000-4800-ad00-000000000000 AND ck0 =
00000000-0000-4f00-b800-000000000000 AND ck1 = 0x823dfa5f87042d -- on node1
107: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token('02:43:47.716011275', 00000000-0000-4200-b200-000000000000) PER PARTITION
LIMIT 25 LIMIT 551 -- by token range, on node1
108: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) BETWEEN
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token('02:43:47.716011275', 00000000-0000-4200-b200-000000000000) PER PARTITION
LIMIT 186 LIMIT 405 -- by token range, on node1
109: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) < token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) PER PARTITION LIMIT 152 -- by token
range, on node1, fetch size 1000
110: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 AND ck1 > 0x3cfba69ba50245 LIMIT 674
ALLOW FILTERING -- ck1 blob (reversed), on node1, fetch size 1000
111: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 AND ck0 =
00000000-0000-4a00-8c00-000000000000 LIMIT 906 ALLOW FILTERING -- ck0 uuid
(reversed), indexed with SAI, on node1, fetch size 1000
112: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) PER PARTITION
LIMIT 65 LIMIT 559 -- by token, on node1
113: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
ck1 = 0xfc05ba5e68e8 AND v3 = -1345538647735785820 AND pk1 =
00000000-0000-4200-b200-000000000000 AND ck0 =
00000000-0000-4600-b400-000000000000 AND s0 = (-16323, {3.633346E-25}) AND v1 =
{{f0: 0xc0082750d3dcdf38}: [5588198537739420010, -639973581677511835]} LIMIT
318 ALLOW FILTERING -- pk0 time (indexed with SAI), ck1 blob (reversed), v3
bigint (indexed with SAI), pk1 uuid (indexed with SAI), ck0 uuid (reversed)
(indexed with SAI), s0 frozen<tuple<smallint, frozen<set<float>>>> (indexed
with SAI), v1 frozen<map<frozen<"0">, vector<bigint, 2>>> (indexed with SAI),
on node1
114: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 AND ck0 =
00000000-0000-4a00-8c00-000000000000 AND ck1 = 0x3cfba69ba50245 -- By Primary
Key, on node1
115: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
ck0 = 00000000-0000-4000-9f00-000000000000 AND s0 = (-16323, {3.633346E-25})
AND ck1 = 0xfc05ba5e68e8 LIMIT 95 ALLOW FILTERING -- pk0 time (indexed with
SAI), ck0 uuid (reversed) (indexed with SAI), s0 frozen<tuple<smallint,
frozen<set<float>>>> (indexed with SAI), ck1 blob (reversed), on node1, fetch
size 10
116: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) PER PARTITION
LIMIT 57 LIMIT 619 -- by token, on node1, fetch size 10
117: SELECT * FROM ks1.tbl WHERE pk0 = '02:43:47.716011275' AND
pk1 = 00000000-0000-4200-b200-000000000000 AND ck0 =
00000000-0000-4e00-8100-000000000000 AND ck1 = 0xfc05ba5e68e8 PER PARTITION
LIMIT 30 -- By Primary Key, on node1, fetch size 1000
118: SELECT * FROM ks1.tbl WHERE v3 = 9206814797433618983 AND
ck1 = 0xa06bb301 PER PARTITION LIMIT 148 LIMIT 443 ALLOW FILTERING -- v3 bigint
(indexed with SAI), ck1 blob (reversed), on node1, fetch size 1000
119: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >
token('03:36:30.876439626', 00000000-0000-4000-ad00-000000000000) AND
token(pk0, pk1) <= token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) PER PARTITION LIMIT 69 -- by token range,
on node1, fetch size 10
120: SELECT * FROM ks1.tbl WHERE pk1 =
00000000-0000-4200-b200-000000000000 AND v1 = {{f0: 0x19d176c92cb8}:
[-7441098625465562907, 6685037052700030619], {f0: 0x883bcf7bed789c}:
[-23021965732989622, -5678634307471068018]} AND s0 = (-16323, {3.633346E-25})
AND pk0 = '05:05:39.676771737' AND ck1 = 0xa06bb301 AND ck0 =
00000000-0000-4000-9f00-000000000000 PER PARTITION LIMIT 741 ALLOW FILTERING --
pk1 uuid (indexed with SAI), v1 frozen<map<frozen<"0">, vector<bigint, 2>>>
(indexed with SAI), s0 frozen<tuple<smallint, frozen<set<float>>>> (indexed
with SAI), pk0 time (indexed with SAI), ck1 blob (reversed), ck0 uuid
(reversed) (indexed with SAI), on node1, fetch size 1000
121: SELECT * FROM ks1.tbl WHERE pk0 = '05:05:39.676771737' AND
pk1 = 00000000-0000-4500-9e00-000000000000 LIMIT 54 -- By Partition Key, on
node1, fetch size 5000
122: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) >=
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) AND
token(pk0, pk1) <= token('02:43:47.716011275',
00000000-0000-4200-b200-000000000000) PER PARTITION LIMIT 943 LIMIT 317 -- by
token range, on node1, fetch size 10
123: SELECT * FROM ks1.tbl WHERE pk0 = '02:43:47.716011275' AND
pk1 = 00000000-0000-4200-b200-000000000000 AND v2 < [{f0: false, f1: 33, f2:
'鏽ᄓ똰忢'}, {f0: true, f1: 124, f2: '⒌疳㮑痕ࠀ'}] LIMIT 151 ALLOW FILTERING -- v2
vector<frozen<"g8BJ1wxrLatl5q3OkJhLsD1FaKwFx8qu2Tjyqk1BOt">, 2>, on node1,
fetch size 5000
124: SELECT * FROM ks1.tbl WHERE pk0 = '03:36:30.876439626' AND
pk1 = 00000000-0000-4500-9e00-000000000000 AND v1 = {{f0: 0x19d176c92cb8}:
[-7441098625465562907, 6685037052700030619], {f0: 0x883bcf7bed789c}:
[-23021965732989622, -5678634307471068018]} AND ck1 = 0x3cfba69ba50245 AND s0 =
(-16323, {3.633346E-25}) AND ck0 = 00000000-0000-4600-b400-000000000000 AND v3
= 5794306794061466752 LIMIT 31 ALLOW FILTERING -- pk0 time (indexed with SAI),
pk1 uuid (indexed with SAI), v1 frozen<map<frozen<"0">, vector<bigint, 2>>>
(indexed with SAI), ck1 blob (reversed), s0 frozen<tuple<smallint,
frozen<set<float>>>> (indexed with SAI), ck0 uuid (reversed) (indexed with
SAI), v3 bigint (indexed with SAI), on node1, fetch size 1000
125: SELECT * FROM ks1.tbl WHERE token(pk0, pk1) =
token('05:05:39.676771737', 00000000-0000-4500-9e00-000000000000) PER PARTITION
LIMIT 984 LIMIT 56 -- by token, on node1
126: SELECT * FROM ks1.tbl WHERE s0 = (28387,
{-1.18764904E-20}) AND pk1 = 00000000-0000-4000-ad00-000000000000 AND ck1 =
0xa06bb301 PER PARTITION LIMIT 25 LIMIT 307 ALLOW FILTERING -- s0
frozen<tuple<smallint, frozen<set<float>>>> (indexed with SAI), pk1 uuid
(indexed with SAI), ck1 blob (reversed), on node1
Caused by: java.lang.AssertionError: No rows returned
Expected:
pk0 | pk1 | ck0
| ck1 | s0 | v0
| v1
| v2
| v3
'03:36:30.876439626' | 00000000-0000-4000-ad00-000000000000 |
00000000-0000-4000-9f00-000000000000 | 0xa06bb301 | (28387, {-1.18764904E-20})
| [[672139924, -1253475201], [353181149, -1829076723], [179355765, 379303855]]
| {{f0: 0x64850696464d}: [-7485547085069825418, 7795885370802556756], {f0:
0x67633db6f091}: [-8484578637223040646, 8216210044102487771]} | [{f0: true, f1:
68, f2: '䝿ᝧ䶨푥펟겭매郂쀌'}, {f0: true, f1: 98, f2: '髃爫삿챥卛☓읂ີ?'}] | 9206814797433618983
{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
