Caleb Rackliffe created CASSANDRA-20541:
-------------------------------------------
Summary: RowFilter incorrectly hides deletion information from
replica filtering protection
Key: CASSANDRA-20541
URL: https://issues.apache.org/jira/browse/CASSANDRA-20541
Project: Apache Cassandra
Issue Type: Bug
Components: Consistency/Coordination, Legacy/CQL
Reporter: Caleb Rackliffe
Assignee: Caleb Rackliffe
{{MultiNodeTableWalkWithoutReadRepairTest}} surfaced an error with seed
{{6640281155419111674}} that exposes {{RowFilter}} purging deletion information
required by RFP when the query needs reconciliation. This is broken in all
currently supported releases, much like CASSANDRA-19007, but it has a much
simpler fix.
{noformat}
accord.utils.Property$PropertyError: Property error detected:
Seed = 6640281155419111674
Examples = 10
Pure = true
Error: Unexpected results for query: SELECT * FROM ks1.tbl WHERE s0 =
[(00000000-0000-1300-b500-000000000000, 'se.}\u0017H`4y|', '=q')] PER PARTITION
LIMIT 74 LIMIT 654 ALLOW FILTERING
Steps: 400
Values:
State:
Setup:
CREATE KEYSPACE IF NOT EXISTS ks1 WITH replication = {'class':
'SimpleStrategy', 'replication_factor': 3};
CREATE TABLE ks1.tbl (
pk0 double,
ck0 boolean,
s0 vector<frozen<tuple<timeuuid, ascii, ascii>>, 1> static,
v0 ascii,
PRIMARY KEY (pk0, ck0)
) WITH CLUSTERING ORDER BY (ck0 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': 'ALL'}
AND cdc = false
AND comment = ''
AND compaction = {'bucket_high': '1.604189461436093',
'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '13', 'min_threshold': '4', 'provide_overlapping_tombstones':
'ROW'}
AND compression = {'chunk_length_in_kb': '16', 'class':
'org.apache.cassandra.io.compress.NoopCompressor'}
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 = 'NONE'
AND speculative_retry = '99p';:
org.apache.cassandra.distributed.test.cql3.MultiNodeTableWalkBase.MultiNodeState
History:
1: SELECT * FROM ks1.tbl PER PARTITION LIMIT 441 LIMIT 663 --
full table scan, on node3, fetch size 5000
2: DELETE FROM ks1.tbl USING TIMESTAMP 1 WHERE pk0 =
-1.8696416693874086E283 -- on node1
3: SELECT * FROM ks1.tbl PER PARTITION LIMIT 32 LIMIT 461 --
full table scan, on node3, fetch size 1
4: SELECT * FROM ks1.tbl PER PARTITION LIMIT 111 LIMIT 574 --
full table scan, on node3, fetch size 1
5: UPDATE ks1.tbl USING TIMESTAMP 2 SET
s0=[(00000000-0000-1100-8d00-000000000000, 'JkjV"''ibPf',
'eo\u000F{\u00102=\u0010\u0009_')] WHERE pk0 = 2.888626647113732E132 -- on
node1
6: INSERT INTO ks1.tbl (pk0, s0) VALUES
(1.2705479108470307E-207, [(00000000-0000-1000-9a00-000000000000,
')\u001D|K''2\u000DI\u0004\u0002', '\u0018p
gf')]) USING TIMESTAMP 3 -- on node3
7: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(1.2705479108470307E-207) AND token(pk0) <= token(2.888626647113732E132)
PER PARTITION LIMIT 202 LIMIT 223 -- by token range, on node1, fetch size 1
8: SELECT * FROM ks1.tbl PER PARTITION LIMIT 44 LIMIT 612 --
full table scan, on node1, fetch size 1000
9: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(2.888626647113732E132) PER PARTITION LIMIT 162 LIMIT 243 -- by token, on
node3, fetch size 100
10: INSERT INTO ks1.tbl (pk0, s0) VALUES
(-6.165121722793825E-272, [(00000000-0000-1a00-8f00-000000000000, 'Y',
'9o"o\u00124#pG~')]) USING TIMESTAMP 4 -- on node2
11: SELECT * FROM ks1.tbl PER PARTITION LIMIT 429 LIMIT 789 --
full table scan, on node1, fetch size 1000
12: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(-6.165121722793825E-272) AND token(pk0) < token(2.888626647113732E132)
PER PARTITION LIMIT 100 LIMIT 197 -- by token range, on node2, fetch size 1
13: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 320 LIMIT 886 -- by token,
on node2, fetch size 10
14: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 110 LIMIT 264 -- by token,
on node2, fetch size 10
15: DELETE FROM ks1.tbl USING TIMESTAMP 5 WHERE pk0 =
-6.165121722793825E-272 -- on node2
16: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(1.2705479108470307E-207) AND token(pk0) <= token(2.888626647113732E132)
PER PARTITION LIMIT 372 LIMIT 730 -- by token range, on node2, fetch size 100
17: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(1.2705479108470307E-207) AND token(pk0) <= token(2.888626647113732E132)
PER PARTITION LIMIT 28 LIMIT 521 -- by token range, on node1, fetch size 100
18: UPDATE ks1.tbl USING TIMESTAMP 6 SET
s0=[(00000000-0000-1700-a200-000000000000, '\u001F\u0003kbx\u0007', '`(')]
WHERE pk0 = 6.443617907362642E236 -- on node3
19: SELECT * FROM ks1.tbl PER PARTITION LIMIT 723 LIMIT 263 --
full table scan, on node2, fetch size 1000
20: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(2.888626647113732E132) PER PARTITION LIMIT 243 LIMIT 655 -- by token, on
node3, fetch size 100
21: DELETE s0, s0 FROM ks1.tbl USING TIMESTAMP 7 WHERE pk0 =
6.443617907362642E236 -- on node2
22: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(1.2705479108470307E-207) AND token(pk0) < token(2.888626647113732E132)
PER PARTITION LIMIT 921 LIMIT 968 -- by token range, on node2, fetch size 5000
23: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 935 LIMIT 537 -- by token,
on node3, fetch size 5000
24: SELECT * FROM ks1.tbl PER PARTITION LIMIT 901 LIMIT 900 --
full table scan, on node3, fetch size 5000
25: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(2.888626647113732E132) PER PARTITION LIMIT 753 LIMIT 996 -- by token, on
node2, fetch size 10
26: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(1.2705479108470307E-207) AND token(pk0) < token(2.888626647113732E132)
PER PARTITION LIMIT 399 LIMIT 744 -- by token range, on node1, fetch size 5000
27: SELECT * FROM ks1.tbl PER PARTITION LIMIT 633 LIMIT 716 --
full table scan, on node1, fetch size 1000
28: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(2.888626647113732E132) PER PARTITION LIMIT 858 LIMIT 262 -- by token, on
node3, fetch size 1000
29: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 649 LIMIT 936 -- by token,
on node3, fetch size 100
30: SELECT * FROM ks1.tbl PER PARTITION LIMIT 85 LIMIT 859 --
full table scan, on node3, fetch size 1
31: SELECT * FROM ks1.tbl PER PARTITION LIMIT 940 LIMIT 114 --
full table scan, on node1, fetch size 100
32: SELECT * FROM ks1.tbl WHERE pk0 = 1.2705479108470307E-207
PER PARTITION LIMIT 161 LIMIT 905 -- By Partition Key, on node2, fetch size 10
33: DELETE FROM ks1.tbl USING TIMESTAMP 8 WHERE pk0 =
2.888626647113732E132 -- on node1
34: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(1.2705479108470307E-207) AND token(pk0) <= token(1.2705479108470307E-207)
PER PARTITION LIMIT 11 LIMIT 247 -- by token range, on node2, fetch size 5000
35: SELECT * FROM ks1.tbl WHERE token(pk0) BETWEEN
token(1.2705479108470307E-207) AND token(1.2705479108470307E-207) PER PARTITION
LIMIT 757 LIMIT 199 -- by token range, on node1, fetch size 1
36: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 722 LIMIT 831 -- by token,
on node2, fetch size 100
37: SELECT * FROM ks1.tbl PER PARTITION LIMIT 45 LIMIT 756 --
full table scan, on node3, fetch size 10
38: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(1.2705479108470307E-207) AND token(pk0) <= token(1.2705479108470307E-207)
PER PARTITION LIMIT 252 LIMIT 165 -- by token range, on node3, fetch size 1000
39: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 136 LIMIT 595 -- by token,
on node2, fetch size 1000
40: SELECT * FROM ks1.tbl PER PARTITION LIMIT 41 LIMIT 39 --
full table scan, on node2, fetch size 1000
41: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(1.2705479108470307E-207) AND token(pk0) <= token(1.2705479108470307E-207)
PER PARTITION LIMIT 171 LIMIT 907 -- by token range, on node1, fetch size 10
42: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 231 LIMIT 756 -- by token,
on node3, fetch size 100
43: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 662 LIMIT 718 -- by token,
on node3, fetch size 10
44: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 34 LIMIT 163 -- by token, on
node2, fetch size 100
45: SELECT * FROM ks1.tbl PER PARTITION LIMIT 528 LIMIT 575 --
full table scan, on node2, fetch size 5000
46: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 61 LIMIT 518 -- by token, on
node2, fetch size 100
47: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 111 LIMIT 200 -- by token,
on node1, fetch size 1
48: SELECT * FROM ks1.tbl PER PARTITION LIMIT 918 LIMIT 663 --
full table scan, on node1, fetch size 5000
49: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 145 LIMIT 714 -- by token,
on node2, fetch size 1000
50: SELECT * FROM ks1.tbl PER PARTITION LIMIT 862 LIMIT 674 --
full table scan, on node3, fetch size 1000
51: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(1.2705479108470307E-207) AND token(pk0) <= token(1.2705479108470307E-207)
PER PARTITION LIMIT 253 LIMIT 126 -- by token range, on node3, fetch size 5000
52: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(1.2705479108470307E-207) AND token(pk0) < token(1.2705479108470307E-207)
PER PARTITION LIMIT 687 LIMIT 157 -- by token range, on node3, fetch size 1000
53: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(1.2705479108470307E-207) AND token(pk0) <= token(1.2705479108470307E-207)
PER PARTITION LIMIT 260 LIMIT 121 -- by token range, on node1, fetch size 1000
54: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 60 LIMIT 149 -- by token, on
node3, fetch size 1000
55: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 190 LIMIT 825 -- by token,
on node2, fetch size 5000
56: SELECT * FROM ks1.tbl WHERE pk0 = 1.2705479108470307E-207
PER PARTITION LIMIT 995 LIMIT 758 -- By Partition Key, on node3, fetch size 1000
57: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 683 LIMIT 591 -- by token,
on node3, fetch size 1
58: INSERT INTO ks1.tbl (pk0, ck0, v0, s0) VALUES
(1.2705479108470307E-207, true, '4B \u0004#\u0005',
[(00000000-0000-1e00-b300-000000000000, 'c9\u007F`!', '\u000Dq)\u0001')]) USING
TIMESTAMP 9 -- on node3
59: SELECT * FROM ks1.tbl PER PARTITION LIMIT 398 LIMIT 770 --
full table scan, on node3, fetch size 1
60: SELECT * FROM ks1.tbl WHERE s0 >
[(00000000-0000-1e00-b300-000000000000, 'c9\u007F`!', '\u000Dq)\u0001')] PER
PARTITION LIMIT 201 LIMIT 928 ALLOW FILTERING -- s0
vector<frozen<tuple<timeuuid, ascii, ascii>>, 1>, on node3, fetch size 10
61: SELECT * FROM ks1.tbl WHERE ck0 <= true PER PARTITION LIMIT
147 LIMIT 884 ALLOW FILTERING -- ck0 boolean (reversed), on node2, fetch size 1
62: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(1.2705479108470307E-207) AND token(pk0) <= token(1.2705479108470307E-207)
PER PARTITION LIMIT 985 LIMIT 229 -- by token range, on node3, fetch size 10
63: SELECT * FROM ks1.tbl WHERE pk0 = 1.2705479108470307E-207
AND v0 = '4B \u0004#\u0005' PER PARTITION LIMIT 629 LIMIT 812 ALLOW FILTERING
-- v0 ascii, on node1, fetch size 5000
64: SELECT * FROM ks1.tbl WHERE pk0 = 1.2705479108470307E-207
AND ck0 = true PER PARTITION LIMIT 156 LIMIT 212 ALLOW FILTERING -- ck0 boolean
(reversed), on node1, fetch size 10
65: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 252 LIMIT 702 -- by token,
on node1, fetch size 10
66: SELECT * FROM ks1.tbl WHERE token(pk0) BETWEEN
token(1.2705479108470307E-207) AND token(1.2705479108470307E-207) PER PARTITION
LIMIT 665 LIMIT 707 -- by token range, on node2, fetch size 5000
67: DELETE FROM ks1.tbl USING TIMESTAMP 10 WHERE pk0 =
1.2705479108470307E-207 -- on node2
68: SELECT * FROM ks1.tbl PER PARTITION LIMIT 208 LIMIT 724 --
full table scan, on node3, fetch size 1
69: INSERT INTO ks1.tbl (pk0, s0) VALUES
(1.2705479108470307E-207, [(00000000-0000-1500-a400-000000000000, 'bUl\u0004P',
' \u007F\u0010!m')]) USING TIMESTAMP 11 -- on node3
70: DELETE FROM ks1.tbl USING TIMESTAMP 12 WHERE pk0 =
2.888626647113732E132 -- on node3
71: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(1.2705479108470307E-207) AND token(pk0) < token(1.2705479108470307E-207)
PER PARTITION LIMIT 966 LIMIT 943 -- by token range, on node2, fetch size 5000
72: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 762 LIMIT 796 -- by token,
on node1, fetch size 10
73: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(1.2705479108470307E-207) AND token(pk0) <= token(1.2705479108470307E-207)
PER PARTITION LIMIT 34 LIMIT 509 -- by token range, on node3, fetch size 100
74: SELECT * FROM ks1.tbl PER PARTITION LIMIT 139 LIMIT 688 --
full table scan, on node1, fetch size 5000
75: UPDATE ks1.tbl USING TIMESTAMP 13 SET
s0=[(00000000-0000-1c00-9500-000000000000, '\u0010:F47\u00053',
'\u0004`cz,rU_\u001C6')] WHERE pk0 = 1.2705479108470307E-207 -- on node1
76: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 325 LIMIT 950 -- by token,
on node2, fetch size 100
77: DELETE FROM ks1.tbl USING TIMESTAMP 14 WHERE pk0 =
-1.8696416693874086E283 -- on node1
78: SELECT * FROM ks1.tbl PER PARTITION LIMIT 444 LIMIT 643 --
full table scan, on node3, fetch size 10
79: SELECT * FROM ks1.tbl PER PARTITION LIMIT 29 LIMIT 125 --
full table scan, on node3, fetch size 100
80: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(1.2705479108470307E-207) AND token(pk0) <= token(1.2705479108470307E-207)
LIMIT 102 -- by token range, on node1, fetch size 10
81: SELECT * FROM ks1.tbl PER PARTITION LIMIT 468 LIMIT 951 --
full table scan, on node2, fetch size 100
82: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 4 LIMIT 616 -- by token, on
node1, fetch size 5000
83: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(1.2705479108470307E-207) AND token(pk0) < token(1.2705479108470307E-207)
PER PARTITION LIMIT 14 LIMIT 211 -- by token range, on node1, fetch size 5000
84: DELETE v0, s0 FROM ks1.tbl USING TIMESTAMP 15 WHERE pk0 =
2.888626647113732E132 AND ck0 = true -- on node1
85: INSERT INTO ks1.tbl (pk0, s0) VALUES
(-3.5354888023116683E99, [(00000000-0000-1300-b900-000000000000,
'`N3t\u000FKcwH', 'Uv2=kj\u0006CW?')]) USING TIMESTAMP 16 -- on node2
86: UPDATE ks1.tbl USING TIMESTAMP 17 SET v0='k"\u001E\u000D#'
+ 'Xt' WHERE pk0 = 6.443617907362642E236 AND ck0 = true -- on node2
87: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(6.443617907362642E236) PER PARTITION LIMIT 174 LIMIT 526 -- by token, on
node2, fetch size 1000
88: INSERT INTO ks1.tbl (pk0, ck0, s0, v0) VALUES
(1.2705479108470307E-207, false, [(00000000-0000-1100-af00-000000000000,
'4f\u000B\u000F;\u0002', '\u001D:K\u0004P(Fxb')], null) USING TIMESTAMP 18 --
on node2
89: INSERT INTO ks1.tbl (pk0, ck0, s0, v0) VALUES
(-2.999315679486166E-221, true, [(00000000-0000-1c00-ab00-000000000000,
'fT\u000B(;1nZ', '\u0005s>l3\u001F')], 'x' + '\u000C\u0018yh0') USING TIMESTAMP
19 -- on node2
90: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(6.443617907362642E236) AND token(pk0) <= token(-2.999315679486166E-221)
PER PARTITION LIMIT 717 LIMIT 769 -- by token range, on node3, fetch size 5000
91: SELECT * FROM ks1.tbl PER PARTITION LIMIT 394 LIMIT 182 --
full table scan, on node3, fetch size 100
92: SELECT * FROM ks1.tbl WHERE s0 =
[(00000000-0000-1100-af00-000000000000, '4f\u000B\u000F;\u0002',
'\u001D:K\u0004P(Fxb')] PER PARTITION LIMIT 461 LIMIT 758 ALLOW FILTERING -- s0
vector<frozen<tuple<timeuuid, ascii, ascii>>, 1>, on node1, fetch size 1000
93: SELECT * FROM ks1.tbl WHERE pk0 = 6.443617907362642E236 AND
ck0 <= true PER PARTITION LIMIT 771 LIMIT 690 ALLOW FILTERING -- ck0 boolean
(reversed), on node1, fetch size 1
94: SELECT * FROM ks1.tbl WHERE s0 >
[(00000000-0000-1c00-ab00-000000000000, 'fT\u000B(;1nZ', '\u0005s>l3\u001F')]
PER PARTITION LIMIT 125 LIMIT 731 ALLOW FILTERING -- s0
vector<frozen<tuple<timeuuid, ascii, ascii>>, 1>, on node3, fetch size 10
95: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(-3.5354888023116683E99) PER PARTITION LIMIT 186 LIMIT 478 -- by token, on
node1, fetch size 5000
96: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(6.443617907362642E236) AND token(pk0) <= token(-3.5354888023116683E99)
PER PARTITION LIMIT 650 LIMIT 396 -- by token range, on node2, fetch size 1
97: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 381 LIMIT 791 -- by token,
on node2, fetch size 1000
98: SELECT * FROM ks1.tbl WHERE s0 >
[(00000000-0000-1100-af00-000000000000, '4f\u000B\u000F;\u0002',
'\u001D:K\u0004P(Fxb')] PER PARTITION LIMIT 100 LIMIT 531 ALLOW FILTERING -- s0
vector<frozen<tuple<timeuuid, ascii, ascii>>, 1>, on node2, fetch size 1000
99: SELECT * FROM ks1.tbl WHERE pk0 = 1.2705479108470307E-207
AND s0 > [(00000000-0000-1100-af00-000000000000, '4f\u000B\u000F;\u0002',
'\u001D:K\u0004P(Fxb')] PER PARTITION LIMIT 639 LIMIT 313 ALLOW FILTERING -- s0
vector<frozen<tuple<timeuuid, ascii, ascii>>, 1>, on node2, fetch size 1000
100: SELECT * FROM ks1.tbl WHERE v0 = 'k"\u001E\u000D#Xt' PER
PARTITION LIMIT 476 LIMIT 267 ALLOW FILTERING -- v0 ascii, on node3, fetch size
5000
101: SELECT * FROM ks1.tbl PER PARTITION LIMIT 134 LIMIT 994 --
full table scan, on node1, fetch size 1000
102: SELECT * FROM ks1.tbl WHERE s0 =
[(00000000-0000-1c00-ab00-000000000000, 'fT\u000B(;1nZ', '\u0005s>l3\u001F')]
PER PARTITION LIMIT 966 LIMIT 237 ALLOW FILTERING -- s0
vector<frozen<tuple<timeuuid, ascii, ascii>>, 1>, on node2, fetch size 1
103: DELETE FROM ks1.tbl USING TIMESTAMP 20 WHERE pk0 =
-7.020335250121226E-119 AND ck0 = false -- on node1
104: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(-2.999315679486166E-221) PER PARTITION LIMIT 275 LIMIT 829 -- by token,
on node2, fetch size 5000
105: SELECT * FROM ks1.tbl PER PARTITION LIMIT 477 LIMIT 346 --
full table scan, on node3, fetch size 100
106: SELECT * FROM ks1.tbl PER PARTITION LIMIT 141 LIMIT 774 --
full table scan, on node1, fetch size 10
107: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(1.2705479108470307E-207) AND token(pk0) <= token(-3.5354888023116683E99)
PER PARTITION LIMIT 117 LIMIT 877 -- by token range, on node1, fetch size 1000
108: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(1.2705479108470307E-207) AND token(pk0) < token(-3.5354888023116683E99)
PER PARTITION LIMIT 272 LIMIT 586 -- by token range, on node1, fetch size 1
109: INSERT INTO ks1.tbl (pk0, s0) VALUES
(-2.999315679486166E-221, [(00000000-0000-1a00-b400-000000000000, ';\u0002K',
'\u0015zLe')]) USING TIMESTAMP 21 -- on node3
110: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(6.443617907362642E236) AND token(pk0) <= token(-3.5354888023116683E99)
PER PARTITION LIMIT 499 LIMIT 679 -- by token range, on node3, fetch size 1
111: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(6.443617907362642E236) PER PARTITION LIMIT 28 LIMIT 253 -- by token, on
node1, fetch size 100
112: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 100 LIMIT 97 -- by token, on
node3, fetch size 5000
113: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 208 LIMIT 260 -- by token,
on node2, fetch size 100
114: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(6.443617907362642E236) LIMIT 87 -- by token, on node2, fetch size 5000
115: SELECT * FROM ks1.tbl WHERE token(pk0) BETWEEN
token(6.443617907362642E236) AND token(-2.999315679486166E-221) PER PARTITION
LIMIT 926 LIMIT 625 -- by token range, on node1, fetch size 100
116: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(-3.5354888023116683E99) AND token(pk0) < token(-2.999315679486166E-221)
PER PARTITION LIMIT 91 LIMIT 955 -- by token range, on node2, fetch size 1
117: SELECT * FROM ks1.tbl PER PARTITION LIMIT 676 LIMIT 728 --
full table scan, on node1, fetch size 1
118: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(-2.999315679486166E-221) PER PARTITION LIMIT 9 LIMIT 354 -- by token, on
node1, fetch size 10
119: SELECT * FROM ks1.tbl WHERE s0 =
[(00000000-0000-1100-af00-000000000000, '4f\u000B\u000F;\u0002',
'\u001D:K\u0004P(Fxb')] PER PARTITION LIMIT 786 LIMIT 724 ALLOW FILTERING -- s0
vector<frozen<tuple<timeuuid, ascii, ascii>>, 1>, on node1, fetch size 5000
120: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(1.2705479108470307E-207) AND token(pk0) < token(6.443617907362642E236)
PER PARTITION LIMIT 226 LIMIT 637 -- by token range, on node1, fetch size 1
121: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(-3.5354888023116683E99) PER PARTITION LIMIT 215 LIMIT 651 -- by token, on
node2, fetch size 1000
122: SELECT * FROM ks1.tbl WHERE token(pk0) BETWEEN
token(6.443617907362642E236) AND token(-3.5354888023116683E99) PER PARTITION
LIMIT 646 LIMIT 805 -- by token range, on node2, fetch size 1000
123: SELECT * FROM ks1.tbl WHERE pk0 = 6.443617907362642E236
PER PARTITION LIMIT 61 LIMIT 537 -- By Partition Key, on node3, fetch size 100
124: SELECT * FROM ks1.tbl WHERE ck0 > true PER PARTITION LIMIT
339 LIMIT 280 ALLOW FILTERING -- ck0 boolean (reversed), on node1, fetch size 10
125: SELECT * FROM ks1.tbl WHERE pk0 = 1.2705479108470307E-207
AND s0 >= [(00000000-0000-1100-af00-000000000000, '4f\u000B\u000F;\u0002',
'\u001D:K\u0004P(Fxb')] PER PARTITION LIMIT 458 LIMIT 137 ALLOW FILTERING -- s0
vector<frozen<tuple<timeuuid, ascii, ascii>>, 1>, on node1, fetch size 1000
126: SELECT * FROM ks1.tbl WHERE pk0 = 1.2705479108470307E-207
AND ck0 = false PER PARTITION LIMIT 945 LIMIT 770 ALLOW FILTERING -- ck0
boolean (reversed), on node3, fetch size 1
127: SELECT * FROM ks1.tbl WHERE ck0 = false PER PARTITION
LIMIT 291 LIMIT 749 ALLOW FILTERING -- ck0 boolean (reversed), on node2, fetch
size 1000
128: SELECT * FROM ks1.tbl WHERE v0 = 'k"\u001E\u000D#Xt' PER
PARTITION LIMIT 98 LIMIT 614 ALLOW FILTERING -- v0 ascii, on node3, fetch size 1
129: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(-3.5354888023116683E99) AND token(pk0) < token(-2.999315679486166E-221)
PER PARTITION LIMIT 689 LIMIT 637 -- by token range, on node3, fetch size 5000
130: SELECT * FROM ks1.tbl WHERE v0 > 'k"\u001E\u000D#Xt' PER
PARTITION LIMIT 629 LIMIT 189 ALLOW FILTERING -- v0 ascii, on node3, fetch size
1000
131: SELECT * FROM ks1.tbl WHERE s0 >
[(00000000-0000-1a00-b400-000000000000, ';\u0002K', '\u0015zLe')] PER PARTITION
LIMIT 916 LIMIT 799 ALLOW FILTERING -- s0 vector<frozen<tuple<timeuuid, ascii,
ascii>>, 1>, on node1, fetch size 1000
132: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(1.2705479108470307E-207) AND token(pk0) <= token(-2.999315679486166E-221)
PER PARTITION LIMIT 195 LIMIT 713 -- by token range, on node2, fetch size 1
133: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(6.443617907362642E236) PER PARTITION LIMIT 940 LIMIT 348 -- by token, on
node2, fetch size 1000
134: SELECT * FROM ks1.tbl WHERE ck0 < false PER PARTITION
LIMIT 903 LIMIT 999 ALLOW FILTERING -- ck0 boolean (reversed), on node3, fetch
size 5000
135: SELECT * FROM ks1.tbl WHERE pk0 = 6.443617907362642E236
AND v0 = 'k"\u001E\u000D#Xt' PER PARTITION LIMIT 168 LIMIT 653 ALLOW FILTERING
-- v0 ascii, on node3, fetch size 1000
136: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(-3.5354888023116683E99) PER PARTITION LIMIT 207 LIMIT 142 -- by token, on
node3, fetch size 100
137: SELECT * FROM ks1.tbl PER PARTITION LIMIT 579 LIMIT 612 --
full table scan, on node3, fetch size 100
138: SELECT * FROM ks1.tbl PER PARTITION LIMIT 608 LIMIT 722 --
full table scan, on node1, fetch size 1000
139: INSERT INTO ks1.tbl (pk0, s0) VALUES
(-6.165121722793825E-272, [(00000000-0000-1600-b300-000000000000, 'e72JH2$',
'\u0015RZ2\u0009\u0000')]) USING TIMESTAMP 22 -- on node3
140: SELECT * FROM ks1.tbl WHERE v0 = 'x\u000C\u0018yh0' PER
PARTITION LIMIT 96 LIMIT 78 ALLOW FILTERING -- v0 ascii, on node1, fetch size
1000
141: SELECT * FROM ks1.tbl WHERE pk0 = -2.999315679486166E-221
AND ck0 = true PER PARTITION LIMIT 231 LIMIT 428 ALLOW FILTERING -- ck0 boolean
(reversed), on node2, fetch size 100
142: SELECT * FROM ks1.tbl WHERE v0 <= 'k"\u001E\u000D#Xt' PER
PARTITION LIMIT 109 LIMIT 396 ALLOW FILTERING -- v0 ascii, on node1, fetch size
5000
143: SELECT * FROM ks1.tbl PER PARTITION LIMIT 836 LIMIT 811 --
full table scan, on node3, fetch size 1
144: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 274 LIMIT 971 -- by token,
on node3, fetch size 100
145: SELECT * FROM ks1.tbl PER PARTITION LIMIT 933 LIMIT 788 --
full table scan, on node3, fetch size 1000
146: SELECT * FROM ks1.tbl WHERE pk0 = -2.999315679486166E-221
AND v0 <= 'x\u000C\u0018yh0' PER PARTITION LIMIT 670 LIMIT 686 ALLOW FILTERING
-- v0 ascii, on node3, fetch size 5000
147: SELECT * FROM ks1.tbl WHERE ck0 = true PER PARTITION LIMIT
501 LIMIT 522 ALLOW FILTERING -- ck0 boolean (reversed), on node1, fetch size
100
148: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(1.2705479108470307E-207) AND token(pk0) <= token(6.443617907362642E236)
PER PARTITION LIMIT 426 LIMIT 193 -- by token range, on node3, fetch size 100
149: DELETE FROM ks1.tbl USING TIMESTAMP 23 WHERE pk0 =
1.2705479108470307E-207 AND ck0 = true -- on node3
150: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(6.443617907362642E236) PER PARTITION LIMIT 108 LIMIT 912 -- by token, on
node1, fetch size 100
151: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(1.2705479108470307E-207) AND token(pk0) <= token(-6.165121722793825E-272)
PER PARTITION LIMIT 125 LIMIT 523 -- by token range, on node3, fetch size 5000
152: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(-3.5354888023116683E99) AND token(pk0) < token(-2.999315679486166E-221)
PER PARTITION LIMIT 42 LIMIT 947 -- by token range, on node2, fetch size 1000
153: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(1.2705479108470307E-207) AND token(pk0) <= token(-2.999315679486166E-221)
PER PARTITION LIMIT 288 LIMIT 930 -- by token range, on node1, fetch size 1
154: SELECT * FROM ks1.tbl WHERE v0 = 'k"\u001E\u000D#Xt' PER
PARTITION LIMIT 158 LIMIT 710 ALLOW FILTERING -- v0 ascii, on node3, fetch size
5000
155: UPDATE ks1.tbl USING TIMESTAMP 24 SET v0='',
s0=[(00000000-0000-1300-8700-000000000000, 'K\u0013$\u0004\u007F[*\u001BH?',
'kPd!B\u0019d2#u')] WHERE pk0 = 1.2705479108470307E-207 AND ck0 = false -- on
node3
156: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(6.443617907362642E236) PER PARTITION LIMIT 222 LIMIT 243 -- by token, on
node3, fetch size 1
157: SELECT * FROM ks1.tbl WHERE v0 >= 'x\u000C\u0018yh0' PER
PARTITION LIMIT 48 LIMIT 31 ALLOW FILTERING -- v0 ascii, on node3, fetch size 10
158: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(1.2705479108470307E-207) AND token(pk0) < token(-3.5354888023116683E99)
PER PARTITION LIMIT 247 LIMIT 743 -- by token range, on node2, fetch size 5000
159: SELECT * FROM ks1.tbl WHERE pk0 = 6.443617907362642E236
PER PARTITION LIMIT 121 LIMIT 114 -- By Partition Key, on node2, fetch size 1
160: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(-6.165121722793825E-272) AND token(pk0) <= token(-3.5354888023116683E99)
PER PARTITION LIMIT 452 LIMIT 116 -- by token range, on node3, fetch size 1
161: SELECT * FROM ks1.tbl PER PARTITION LIMIT 915 LIMIT 796 --
full table scan, on node1, fetch size 5000
162: UPDATE ks1.tbl USING TIMESTAMP 25 SET
s0=[(00000000-0000-1b00-bb00-000000000000, '08n\u007F', 'cH\u0013x')],
v0='tP\u0005\u0009\u0001\u0001O' + '>{XA' WHERE pk0 = -2.999315679486166E-221
AND ck0 IN (false, true) -- on node3
163: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(6.443617907362642E236) PER PARTITION LIMIT 211 LIMIT 657 -- by token, on
node2, fetch size 100
164: SELECT * FROM ks1.tbl WHERE ck0 > true PER PARTITION LIMIT
81 LIMIT 547 ALLOW FILTERING -- ck0 boolean (reversed), on node2, fetch size
5000
165: SELECT * FROM ks1.tbl WHERE ck0 = false PER PARTITION
LIMIT 123 LIMIT 101 ALLOW FILTERING -- ck0 boolean (reversed), on node2, fetch
size 10
166: SELECT * FROM ks1.tbl PER PARTITION LIMIT 159 LIMIT 758 --
full table scan, on node3, fetch size 10
167: DELETE s0 FROM ks1.tbl USING TIMESTAMP 26 WHERE pk0 =
6.443617907362642E236 -- on node3
168: INSERT INTO ks1.tbl (pk0, ck0, s0) VALUES
(-1.8696416693874086E283, false, [(00000000-0000-1700-8d00-000000000000,
'*Fl)h~\u0016', 'x\|]')]) USING TIMESTAMP 27 -- on node2
169: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(6.443617907362642E236) AND token(pk0) < token(-3.5354888023116683E99) PER
PARTITION LIMIT 824 LIMIT 720 -- by token range, on node2, fetch size 1000
170: SELECT * FROM ks1.tbl WHERE ck0 = true PER PARTITION LIMIT
184 LIMIT 146 ALLOW FILTERING -- ck0 boolean (reversed), on node3, fetch size
100
171: SELECT * FROM ks1.tbl WHERE ck0 = true PER PARTITION LIMIT
65 LIMIT 174 ALLOW FILTERING -- ck0 boolean (reversed), on node2, fetch size 1
172: SELECT * FROM ks1.tbl WHERE s0 >=
[(00000000-0000-1700-8d00-000000000000, '*Fl)h~\u0016', 'x\|]')] PER PARTITION
LIMIT 134 LIMIT 902 ALLOW FILTERING -- s0 vector<frozen<tuple<timeuuid, ascii,
ascii>>, 1>, on node3, fetch size 5000
173: SELECT * FROM ks1.tbl WHERE ck0 > false PER PARTITION
LIMIT 566 LIMIT 595 ALLOW FILTERING -- ck0 boolean (reversed), on node2, fetch
size 1
174: DELETE FROM ks1.tbl USING TIMESTAMP 28 WHERE pk0 =
-7.020335250121226E-119 -- on node1
175: SELECT * FROM ks1.tbl PER PARTITION LIMIT 189 LIMIT 551 --
full table scan, on node3, fetch size 100
176: SELECT * FROM ks1.tbl PER PARTITION LIMIT 824 LIMIT 719 --
full table scan, on node3, fetch size 1000
177: INSERT INTO ks1.tbl (pk0, s0) VALUES
(-1.8696416693874086E283, [(00000000-0000-1600-8700-000000000000, '\u000D',
'u')]) USING TIMESTAMP 29 -- on node1
178: SELECT * FROM ks1.tbl WHERE v0 >
'tP\u0005\u0009\u0001\u0001O>{XA' PER PARTITION LIMIT 180 LIMIT 887 ALLOW
FILTERING -- v0 ascii, on node1, fetch size 1
179: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(-6.165121722793825E-272) AND token(pk0) < token(-3.5354888023116683E99)
PER PARTITION LIMIT 134 LIMIT 569 -- by token range, on node2, fetch size 1000
180: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(-3.5354888023116683E99) PER PARTITION LIMIT 139 LIMIT 206 -- by token, on
node3, fetch size 5000
181: DELETE FROM ks1.tbl USING TIMESTAMP 30 WHERE pk0 =
-2.999315679486166E-221 AND ck0 = true -- on node1
182: SELECT * FROM ks1.tbl WHERE pk0 = 6.443617907362642E236
PER PARTITION LIMIT 950 LIMIT 714 -- By Partition Key, on node2, fetch size 10
183: SELECT * FROM ks1.tbl WHERE ck0 = true PER PARTITION LIMIT
959 LIMIT 626 ALLOW FILTERING -- ck0 boolean (reversed), on node2, fetch size
1000
184: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(-1.8696416693874086E283) AND token(pk0) < token(-2.999315679486166E-221)
PER PARTITION LIMIT 700 LIMIT 858 -- by token range, on node1, fetch size 1000
185: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(-2.999315679486166E-221) PER PARTITION LIMIT 304 LIMIT 524 -- by token,
on node1, fetch size 1
186: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(-6.165121722793825E-272) PER PARTITION LIMIT 751 LIMIT 574 -- by token,
on node2, fetch size 1000
187: SELECT * FROM ks1.tbl WHERE ck0 = true PER PARTITION LIMIT
594 LIMIT 302 ALLOW FILTERING -- ck0 boolean (reversed), on node3, fetch size
1000
188: SELECT * FROM ks1.tbl PER PARTITION LIMIT 204 LIMIT 888 --
full table scan, on node1, fetch size 5000
189: SELECT * FROM ks1.tbl WHERE ck0 = false PER PARTITION
LIMIT 901 LIMIT 125 ALLOW FILTERING -- ck0 boolean (reversed), on node3, fetch
size 5000
190: SELECT * FROM ks1.tbl PER PARTITION LIMIT 713 LIMIT 100 --
full table scan, on node2, fetch size 5000
191: SELECT * FROM ks1.tbl PER PARTITION LIMIT 399 LIMIT 182 --
full table scan, on node2, fetch size 1
192: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(6.443617907362642E236) AND token(pk0) <= token(-3.5354888023116683E99)
PER PARTITION LIMIT 94 LIMIT 657 -- by token range, on node3, fetch size 10
193: SELECT * FROM ks1.tbl WHERE s0 =
[(00000000-0000-1b00-bb00-000000000000, '08n\u007F', 'cH\u0013x')] PER
PARTITION LIMIT 795 LIMIT 13 ALLOW FILTERING -- s0
vector<frozen<tuple<timeuuid, ascii, ascii>>, 1>, on node1, fetch size 1000
194: SELECT * FROM ks1.tbl PER PARTITION LIMIT 335 LIMIT 276 --
full table scan, on node2, fetch size 100
195: SELECT * FROM ks1.tbl WHERE s0 =
[(00000000-0000-1600-8700-000000000000, '\u000D', 'u')] PER PARTITION LIMIT 66
LIMIT 306 ALLOW FILTERING -- s0 vector<frozen<tuple<timeuuid, ascii, ascii>>,
1>, on node1, fetch size 100
196: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(6.443617907362642E236) PER PARTITION LIMIT 80 LIMIT 838 -- by token, on
node2, fetch size 100
197: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 6 LIMIT 342 -- by token, on
node3, fetch size 5000
198: SELECT * FROM ks1.tbl WHERE pk0 = -6.165121722793825E-272
PER PARTITION LIMIT 67 LIMIT 226 -- By Partition Key, on node3, fetch size 1
199: SELECT * FROM ks1.tbl PER PARTITION LIMIT 455 LIMIT 597 --
full table scan, on node2, fetch size 5000
200: SELECT * FROM ks1.tbl PER PARTITION LIMIT 238 LIMIT 958 --
full table scan, on node1, fetch size 10
201: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(-2.999315679486166E-221) PER PARTITION LIMIT 656 LIMIT 623 -- by token,
on node2, fetch size 5000
202: SELECT * FROM ks1.tbl PER PARTITION LIMIT 894 LIMIT 110 --
full table scan, on node3, fetch size 1000
203: SELECT * FROM ks1.tbl WHERE s0 >
[(00000000-0000-1600-8700-000000000000, '\u000D', 'u')] PER PARTITION LIMIT 415
LIMIT 972 ALLOW FILTERING -- s0 vector<frozen<tuple<timeuuid, ascii, ascii>>,
1>, on node1, fetch size 1000
204: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(-1.8696416693874086E283) PER PARTITION LIMIT 602 LIMIT 761 -- by token,
on node2, fetch size 1000
205: SELECT * FROM ks1.tbl LIMIT 505 -- full table scan, on
node2, fetch size 1000
206: SELECT * FROM ks1.tbl WHERE s0 >=
[(00000000-0000-1b00-bb00-000000000000, '08n\u007F', 'cH\u0013x')] PER
PARTITION LIMIT 63 LIMIT 565 ALLOW FILTERING -- s0
vector<frozen<tuple<timeuuid, ascii, ascii>>, 1>, on node1, fetch size 1
207: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 611 LIMIT 733 -- by token,
on node2, fetch size 1
208: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(-6.165121722793825E-272) PER PARTITION LIMIT 191 LIMIT 923 -- by token,
on node2, fetch size 10
209: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(-6.165121722793825E-272) AND token(pk0) < token(-2.999315679486166E-221)
PER PARTITION LIMIT 73 LIMIT 575 -- by token range, on node2, fetch size 1
210: INSERT INTO ks1.tbl (pk0, s0) VALUES
(-1.8696416693874086E283, [(00000000-0000-1300-bc00-000000000000,
'L\u000BxN\u0000\u001Fl', '
f%>wN[%')]) USING TIMESTAMP 31 -- on node3
211: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 152 LIMIT 39 -- by token, on
node3, fetch size 5000
212: SELECT * FROM ks1.tbl PER PARTITION LIMIT 908 LIMIT 555 --
full table scan, on node1, fetch size 100
213: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 110 LIMIT 947 -- by token,
on node3, fetch size 1000
214: SELECT * FROM ks1.tbl WHERE ck0 >= true PER PARTITION
LIMIT 27 LIMIT 357 ALLOW FILTERING -- ck0 boolean (reversed), on node3, fetch
size 1000
215: SELECT * FROM ks1.tbl WHERE ck0 > true PER PARTITION LIMIT
618 LIMIT 589 ALLOW FILTERING -- ck0 boolean (reversed), on node3, fetch size
1000
216: SELECT * FROM ks1.tbl WHERE v0 = 'k"\u001E\u000D#Xt' PER
PARTITION LIMIT 399 LIMIT 722 ALLOW FILTERING -- v0 ascii, on node2, fetch size
10
217: SELECT * FROM ks1.tbl WHERE v0 > 'k"\u001E\u000D#Xt' PER
PARTITION LIMIT 122 LIMIT 763 ALLOW FILTERING -- v0 ascii, on node3, fetch size
1000
218: SELECT * FROM ks1.tbl WHERE v0 =
'tP\u0005\u0009\u0001\u0001O>{XA' PER PARTITION LIMIT 150 LIMIT 741 ALLOW
FILTERING -- v0 ascii, on node1, fetch size 1000
219: SELECT * FROM ks1.tbl WHERE pk0 = -1.8696416693874086E283
AND ck0 = false PER PARTITION LIMIT 872 LIMIT 683 ALLOW FILTERING -- ck0
boolean (reversed), on node2, fetch size 1000
220: INSERT INTO ks1.tbl (pk0, ck0, s0) VALUES
(-1.8696416693874086E283, false, [(00000000-0000-1500-9900-000000000000,
'\u0014;\u0003:\u0013H', 'T4u')]) USING TIMESTAMP 32 -- on node3
221: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(-6.165121722793825E-272) PER PARTITION LIMIT 90 LIMIT 593 -- by token, on
node3, fetch size 5000
222: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(-3.5354888023116683E99) PER PARTITION LIMIT 195 LIMIT 291 -- by token, on
node2, fetch size 5000
223: INSERT INTO ks1.tbl (pk0, s0) VALUES
(-6.165121722793825E-272, [(00000000-0000-1100-a100-000000000000, '(qD*',
'\u001AEU')]) USING TIMESTAMP 33 -- on node1
224: SELECT * FROM ks1.tbl WHERE ck0 = true PER PARTITION LIMIT
366 LIMIT 705 ALLOW FILTERING -- ck0 boolean (reversed), on node3, fetch size 10
225: SELECT * FROM ks1.tbl WHERE s0 =
[(00000000-0000-1500-9900-000000000000, '\u0014;\u0003:\u0013H', 'T4u')] PER
PARTITION LIMIT 139 LIMIT 36 ALLOW FILTERING -- s0
vector<frozen<tuple<timeuuid, ascii, ascii>>, 1>, on node3, fetch size 1000
226: SELECT * FROM ks1.tbl WHERE s0 =
[(00000000-0000-1500-9900-000000000000, '\u0014;\u0003:\u0013H', 'T4u')] PER
PARTITION LIMIT 336 LIMIT 920 ALLOW FILTERING -- s0
vector<frozen<tuple<timeuuid, ascii, ascii>>, 1>, on node3, fetch size 100
227: SELECT * FROM ks1.tbl WHERE token(pk0) =
token(1.2705479108470307E-207) PER PARTITION LIMIT 74 LIMIT 515 -- by token, on
node3, fetch size 1000
228: SELECT * FROM ks1.tbl WHERE token(pk0) >
token(-6.165121722793825E-272) AND token(pk0) <= token(-2.999315679486166E-221)
PER PARTITION LIMIT 636 LIMIT 768 -- by token range, on node2, fetch size 100
229: INSERT INTO ks1.tbl (pk0, ck0, s0, v0) VALUES
(-2.999315679486166E-221, false, [(00000000-0000-1300-b500-000000000000,
'se.}\u0017H`4y|', '=q')], 'Hs_\u007FkgvFu') USING TIMESTAMP 34 -- on node1
230: SELECT * FROM ks1.tbl WHERE v0 = 'k"\u001E\u000D#Xt' PER
PARTITION LIMIT 665 LIMIT 740 ALLOW FILTERING -- v0 ascii, on node2, fetch size
10
231: SELECT * FROM ks1.tbl WHERE token(pk0) >=
token(-6.165121722793825E-272) AND token(pk0) < token(6.443617907362642E236)
PER PARTITION LIMIT 91 LIMIT 139 -- by token range, on node2, fetch size 100
232: SELECT * FROM ks1.tbl WHERE s0 =
[(00000000-0000-1300-b500-000000000000, 'se.}\u0017H`4y|', '=q')] PER PARTITION
LIMIT 74 LIMIT 654 ALLOW FILTERING -- s0 vector<frozen<tuple<timeuuid, ascii,
ascii>>, 1>, on node2, fetch size 100
Caused by: java.lang.AssertionError: Unexpected results for query: SELECT *
FROM ks1.tbl WHERE s0 = [(00000000-0000-1300-b500-000000000000,
'se.}\u0017H`4y|', '=q')] PER PARTITION LIMIT 74 LIMIT 654 ALLOW FILTERING
Caused by: java.lang.AssertionError: Unexpected rows found:
pk0 | ck0 | s0
| v0
-2.999315679486166E-221 | true | [(00000000-0000-1300-b500-000000000000,
'se.}\u0017H`4y|', '=q')] | 'tP\u0005\u0009\u0001\u0001O>{XA'
Expected:
pk0 | ck0 | s0
| v0
-2.999315679486166E-221 | false | [(00000000-0000-1300-b500-000000000000,
'se.}\u0017H`4y|', '=q')] | 'Hs_\u007FkgvFu'
{noformat}
--
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
