[
https://issues.apache.org/jira/browse/CASSANDRA-20541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Caleb Rackliffe updated CASSANDRA-20541:
----------------------------------------
Reviewers: David Capwell (was: Caleb Rackliffe, David Capwell)
> 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
> Priority: Normal
> Fix For: 4.0.x, 4.1.x, 5.0.x, 5.x
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> {{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: [email protected]
For additional commands, e-mail: [email protected]
