[
https://issues.apache.org/jira/browse/CASSANDRA-20278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Caleb Rackliffe updated CASSANDRA-20278:
----------------------------------------
Resolution: Duplicate
Status: Resolved (was: Open)
> SAI range query returned duplicate results
> ------------------------------------------
>
> Key: CASSANDRA-20278
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20278
> Project: Apache Cassandra
> Issue Type: Bug
> Components: Feature/SAI
> Reporter: David Capwell
> Assignee: Caleb Rackliffe
> Priority: Normal
> Fix For: 5.0.x, 5.1
>
>
> This was found by CASSANDRA-20156
> The query
> {code}
> SELECT * FROM ks1.tbl WHERE pk0 <= 899031163 -- pk0 int, indexed with SAI, on
> node1, fetch size 10
> {code}
> Returned duplicate rows, which was unexpected behavior. This test was first
> found on a multi node test, but it was rerun with a single node and
> reproduced there as well; the error and history are below
> Error
> {code}
> Caused by: java.lang.AssertionError: Unexpected results for query: SELECT *
> FROM ks1.tbl WHERE pk0 <= 899031163
> Caused by: java.lang.AssertionError: Duplicate row in response at row 17:
> [899031163, '166.83.96.184', '1976-01-10T17:24:38.783Z', false,
> 8201882284927653861, 00000000-0000-4400-b300-000000000000]
> Expected:
> pk0 | pk1 | ck0
> | s0 | v0 | v1
> 39449600 | '81.198.103.152' |
> '2045-08-05T02:37:57.171Z' | true | -2476516224653398512 |
> 00000000-0000-4e00-b600-000000000000
> 39449600 | '81.198.103.152' |
> '2036-06-10T22:00:17.792Z' | true | -80747231541411067 | null
>
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' |
> '2066-09-19T04:00:25.392Z' | null | 8590534382743815013 |
> 00000000-0000-4e00-9800-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' |
> '2061-11-20T03:37:53.545Z' | null | 1291125393530733493 |
> 00000000-0000-4400-8000-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' |
> '2055-08-22T09:11:43.351Z' | null | 5849756315687015356 |
> 00000000-0000-4500-9800-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' |
> '2033-08-05T19:00:42.577Z' | null | null |
> 00000000-0000-4e00-b500-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' |
> '2024-12-20T13:01:46.053Z' | null | -7968182913511381934 |
> 00000000-0000-4800-a300-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' |
> '2017-02-18T11:21:43.841Z' | null | -9163063412452511790 |
> 00000000-0000-4e00-9500-000000000000
> -1588614995 | 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe' |
> '2044-12-12T16:20:23.180Z' | false | -8119861318124410395 |
> 00000000-0000-4400-8a00-000000000000
> 899031163 | '166.83.96.184' |
> '2069-01-02T11:41:56.180Z' | false | -8679274544229216450 | null
>
> 899031163 | '166.83.96.184' |
> '2061-09-17T23:03:12.731Z' | false | 5137350797308537490 |
> 00000000-0000-4e00-9a00-000000000000
> 899031163 | '166.83.96.184' |
> '2060-12-05T18:37:09.359Z' | false | -5445897667865003538 |
> 00000000-0000-4f00-8e00-000000000000
> 899031163 | '166.83.96.184' |
> '2046-05-22T01:59:21.957Z' | false | 4069527879523850349 |
> 00000000-0000-4900-a600-000000000000
> 899031163 | '166.83.96.184' |
> '2041-05-26T01:48:18.393Z' | false | -1309942315708652688 |
> 00000000-0000-4e00-9000-000000000000
> 899031163 | '166.83.96.184' |
> '2023-11-28T14:35:29.979Z' | false | 1522521532393520102 |
> 00000000-0000-4e00-b500-000000000000
> 899031163 | '166.83.96.184' |
> '2018-05-27T13:34:49.688Z' | false | 4942506467166386576 |
> 00000000-0000-4000-af00-000000000000
> 899031163 | '166.83.96.184' |
> '1976-01-10T17:24:38.783Z' | false | 8201882284927653861 |
> 00000000-0000-4400-b300-000000000000
> -674540792 | '231.35.74.202' |
> '2015-01-16T13:44:30.399Z' | true | 8409782327800029767 |
> 00000000-0000-4300-8f00-000000000000
> -674540792 | '231.35.74.202' |
> '1990-02-17T08:46:41.775Z' | true | -3157133547435245197 |
> 00000000-0000-4e00-8400-000000000000
> -674540792 | '231.35.74.202' |
> '1973-01-10T03:07:46.590Z' | true | 7977795665840050417 |
> 00000000-0000-4300-af00-000000000000
> Actual:
> pk0 | pk1 | ck0
> | s0 | v0 | v1
> 39449600 | '81.198.103.152' |
> '2045-08-05T02:37:57.171Z' | true | -2476516224653398512 |
> 00000000-0000-4e00-b600-000000000000
> 39449600 | '81.198.103.152' |
> '2036-06-10T22:00:17.792Z' | true | -80747231541411067 | null
>
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' |
> '2066-09-19T04:00:25.392Z' | null | 8590534382743815013 |
> 00000000-0000-4e00-9800-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' |
> '2061-11-20T03:37:53.545Z' | null | 1291125393530733493 |
> 00000000-0000-4400-8000-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' |
> '2055-08-22T09:11:43.351Z' | null | 5849756315687015356 |
> 00000000-0000-4500-9800-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' |
> '2033-08-05T19:00:42.577Z' | null | null |
> 00000000-0000-4e00-b500-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' |
> '2024-12-20T13:01:46.053Z' | null | -7968182913511381934 |
> 00000000-0000-4800-a300-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' |
> '2017-02-18T11:21:43.841Z' | null | -9163063412452511790 |
> 00000000-0000-4e00-9500-000000000000
> -1588614995 | 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe' |
> '2044-12-12T16:20:23.180Z' | false | -8119861318124410395 |
> 00000000-0000-4400-8a00-000000000000
> 899031163 | '166.83.96.184' |
> '2069-01-02T11:41:56.180Z' | false | -8679274544229216450 | null
>
> 899031163 | '166.83.96.184' |
> '2061-09-17T23:03:12.731Z' | false | 5137350797308537490 |
> 00000000-0000-4e00-9a00-000000000000
> 899031163 | '166.83.96.184' |
> '2060-12-05T18:37:09.359Z' | false | -5445897667865003538 |
> 00000000-0000-4f00-8e00-000000000000
> 899031163 | '166.83.96.184' |
> '2046-05-22T01:59:21.957Z' | false | 4069527879523850349 |
> 00000000-0000-4900-a600-000000000000
> 899031163 | '166.83.96.184' |
> '2041-05-26T01:48:18.393Z' | false | -1309942315708652688 |
> 00000000-0000-4e00-9000-000000000000
> 899031163 | '166.83.96.184' |
> '2023-11-28T14:35:29.979Z' | false | 1522521532393520102 |
> 00000000-0000-4e00-b500-000000000000
> 899031163 | '166.83.96.184' |
> '2018-05-27T13:34:49.688Z' | false | 4942506467166386576 |
> 00000000-0000-4000-af00-000000000000
> 899031163 | '166.83.96.184' |
> '1976-01-10T17:24:38.783Z' | false | 8201882284927653861 |
> 00000000-0000-4400-b300-000000000000
> 899031163 | '166.83.96.184' |
> '1976-01-10T17:24:38.783Z' | false | 8201882284927653861 |
> 00000000-0000-4400-b300-000000000000
> -674540792 | '231.35.74.202' |
> '2015-01-16T13:44:30.399Z' | true | 8409782327800029767 |
> 00000000-0000-4300-8f00-000000000000
> -674540792 | '231.35.74.202' |
> '1990-02-17T08:46:41.775Z' | true | -3157133547435245197 |
> 00000000-0000-4e00-8400-000000000000
> -674540792 | '231.35.74.202' |
> '1973-01-10T03:07:46.590Z' | true | 7977795665840050417 |
> 00000000-0000-4300-af00-000000000000
> at
> org.apache.cassandra.harry.model.ASTSingleTableModel.validateNoDuplicates(ASTSingleTableModel.java:526)
> at
> org.apache.cassandra.harry.model.ASTSingleTableModel.validate(ASTSingleTableModel.java:458)
> {code}
> History
> {code}
> CREATE KEYSPACE IF NOT EXISTS ks1 WITH replication = {'class':
> 'SimpleStrategy', 'replication_factor': 1};
> CREATE TABLE ks1.tbl (
> pk0 int,
> pk1 inet,
> ck0 timestamp,
> s0 boolean static,
> v0 bigint,
> v1 uuid,
> PRIMARY KEY ((pk0, pk1), 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': 'NONE'}
> AND cdc = false
> AND comment = ''
> AND compaction = {'class':
> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
> 'max_threshold': '32', 'min_threshold': '4'}
> AND compression = {'chunk_length_in_kb': '16', 'class':
> 'org.apache.cassandra.io.compress.LZ4Compressor'}
> AND memtable = 'default'
> AND crc_check_chance = 1.0
> AND default_time_to_live = 0
> AND extensions = {}
> AND gc_grace_seconds = 864000
> AND incremental_backups = true
> AND max_index_interval = 2048
> AND memtable_flush_period_in_ms = 0
> AND min_index_interval = 128
> AND read_repair = 'BLOCKING'
> AND speculative_retry = '99p';
> CREATE CUSTOM INDEX tbl_pk0 ON ks1.tbl(pk0) USING
> 'StorageAttachedIndex';
> CREATE INDEX tbl_pk1 ON ks1.tbl(pk1) USING 'SAI';
> 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_v0 ON ks1.tbl(v0) USING
> 'StorageAttachedIndex';
> CREATE CUSTOM INDEX tbl_v1 ON ks1.tbl(v1) USING
> 'StorageAttachedIndex';:
> org.apache.cassandra.distributed.test.cql3.MultiNodeTableWalkTest.MultiNodeState
> History:
> 2: DELETE v1 FROM ks1.tbl WHERE pk0 = -1588614995 AND pk1 =
> 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe' AND ck0 =
> '2055-10-08T04:23:08.001Z' -- on node1
> 3: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (-674540792, '231.35.74.202', '1973-01-10T03:07:46.590Z', true,
> -1608632915548222072 + -8860315492321279127,
> 00000000-0000-4300-af00-000000000000) -- on node1
> 4: DELETE v0, v1, s0 FROM ks1.tbl WHERE pk0 = -1588614995 AND
> pk1 = 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe' AND ck0 =
> '2036-05-27T15:59:40.725Z' -- on node1
> 6: DELETE FROM ks1.tbl WHERE pk0 = -1588614995 AND pk1 =
> 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe' AND ck0 =
> '2016-05-14T07:50:09.449Z' -- on node1
> 9: UPDATE ks1.tbl SET s0=false, v0=1398032085572706939 *
> -2993723032305989674, v1=00000000-0000-4e00-9500-000000000000 WHERE pk0 =
> -1604814500 AND pk1 = '2b38:8656:b4c3:662a:1129:ad75:c557:1959' AND ck0 =
> '2017-02-18T11:21:43.841Z' -- on node1
> 10: UPDATE ks1.tbl SET v0=-3535561236849850017 *
> -8043433388328290760 WHERE pk0 = 942134495 AND pk1 =
> '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3' AND ck0 =
> '1971-10-27T07:57:08.066Z' -- on node1
> 13: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (942134495, '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3',
> '1978-08-29T04:29:27.730Z', true, -5389597202918249395 -
> -6026126177165020130, 00000000-0000-4f00-8200-000000000000) -- on node1
> 16: DELETE FROM ks1.tbl WHERE pk0 = 942134495 AND pk1 =
> '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3' -- on node1
> 23: UPDATE ks1.tbl SET v0=-1783520945422376140,
> v1=00000000-0000-4800-b000-000000000000 WHERE pk0 = 39449600 AND pk1 =
> '81.198.103.152' AND ck0 = '2002-11-28T09:12:35.970Z' -- on node1
> 25: UPDATE ks1.tbl SET v0=1936354366539578581,
> v1=00000000-0000-4600-9f00-000000000000, s0=true WHERE pk0 = 1725529242 AND
> pk1 = '117:867a:7a41:e846:36d5:1555:39c6:83f6' AND ck0 =
> '1988-10-09T01:31:28.554Z' -- on node1
> 26: INSERT INTO ks1.tbl (pk0, pk1, ck0, v0, v1) VALUES
> (39449600, '81.198.103.152', '1993-12-13T13:32:05.859Z', 1636375529996901105,
> 00000000-0000-4800-8f00-000000000000) -- on node1
> 27: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (899031163, '166.83.96.184', '1976-01-10T17:24:38.783Z', true,
> 8201882284927653861, 00000000-0000-4400-b300-000000000000) -- on node1
> 31: UPDATE ks1.tbl SET v0=7308869628918268475 -
> 2419563561742694375, v1=00000000-0000-4500-b800-000000000000, s0=false WHERE
> pk0 = 942134495 AND pk1 = '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3' AND ck0
> = '2016-07-07T09:13:00.539Z' -- on node1
> 34: DELETE FROM ks1.tbl WHERE pk0 = 1725529242 AND pk1 =
> '117:867a:7a41:e846:36d5:1555:39c6:83f6' AND ck0 =
> '2046-02-13T02:24:53.626Z' -- on node1
> 37: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (-1604814500, '2b38:8656:b4c3:662a:1129:ad75:c557:1959',
> '2066-09-19T04:00:25.392Z', true, 8590534382743815013,
> 00000000-0000-4e00-9800-000000000000) -- on node1
> 42: UPDATE ks1.tbl SET v1=00000000-0000-4e00-b500-000000000000
> WHERE pk0 = -1604814500 AND pk1 = '2b38:8656:b4c3:662a:1129:ad75:c557:1959'
> AND ck0 = '2033-08-05T19:00:42.577Z' -- on node1
> 48: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (-1604814500, '2b38:8656:b4c3:662a:1129:ad75:c557:1959',
> '2061-11-20T03:37:53.545Z', true, 1291125393530733493,
> 00000000-0000-4400-8000-000000000000) -- on node1
> 50: UPDATE ks1.tbl SET v0=-6261429098999922749 -
> 7242808507543242291, v1=00000000-0000-4000-af00-000000000000 WHERE pk0 =
> 899031163 AND pk1 = '166.83.96.184' AND ck0 = '2018-05-27T13:34:49.688Z' --
> on node1
> 51: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (39449600, '81.198.103.152', '2032-07-29T10:41:03.504Z', false,
> 4548936738637010119 * -4155195644767826103,
> 00000000-0000-4d00-8300-000000000000) -- on node1
> 52: UPDATE ks1.tbl SET v1=00000000-0000-4f00-ba00-000000000000,
> s0=false WHERE pk0 = 39449600 AND pk1 = '81.198.103.152' AND ck0 =
> '1985-08-02T19:35:17.160Z' -- on node1
> 55: DELETE FROM ks1.tbl WHERE pk0 = 942134495 AND pk1 =
> '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3' AND ck0 =
> '2068-05-30T12:45:46.214Z' -- on node1
> 56: DELETE s0, s0 FROM ks1.tbl WHERE pk0 = 1725529242 AND pk1
> = '117:867a:7a41:e846:36d5:1555:39c6:83f6' -- on node1
> 57: DELETE FROM ks1.tbl WHERE pk0 = -674540792 AND pk1 =
> '231.35.74.202' AND ck0 = '2027-07-14T09:16:28.536Z' -- on node1
> 69: UPDATE ks1.tbl SET s0=true, v0=-2947636590983477748 -
> 8247102155612683121, v1=00000000-0000-4500-9b00-000000000000 WHERE pk0 =
> 39449600 AND pk1 = '81.198.103.152' AND ck0 = '2011-10-30T23:31:12.495Z' --
> on node1
> 78: UPDATE ks1.tbl SET s0=true, v0=2922387005817199167 *
> -7560409299577766895, v1=00000000-0000-4800-bd00-000000000000 WHERE pk0 =
> 1725529242 AND pk1 = '117:867a:7a41:e846:36d5:1555:39c6:83f6' AND ck0 =
> '2032-09-30T05:32:09.786Z' -- on node1
> 81: UPDATE ks1.tbl SET v0=-3809815611870385136,
> v1=00000000-0000-4000-be00-000000000000 WHERE pk0 = 39449600 AND pk1 =
> '81.198.103.152' AND ck0 = '1986-09-03T11:33:38.890Z' -- on node1
> 84: UPDATE ks1.tbl SET v0=4069527879523850349,
> v1=00000000-0000-4900-a600-000000000000 WHERE pk0 = 899031163 AND pk1 =
> '166.83.96.184' AND ck0 = '2046-05-22T01:59:21.957Z' -- on node1
> 85: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (899031163, '166.83.96.184', '2060-12-05T18:37:09.359Z', true,
> -5445897667865003538, 00000000-0000-4f00-8e00-000000000000) -- on node1
> 90: UPDATE ks1.tbl SET s0=false, v0=1522521532393520102,
> v1=00000000-0000-4e00-b500-000000000000 WHERE pk0 = 899031163 AND pk1 =
> '166.83.96.184' AND ck0 = '2023-11-28T14:35:29.979Z' -- on node1
> 96: DELETE s0 FROM ks1.tbl WHERE pk0 = 899031163 AND pk1 =
> '166.83.96.184' -- on node1
> 98: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (-674540792, '231.35.74.202', '2015-01-16T13:44:30.399Z', true,
> 8409782327800029767, 00000000-0000-4300-8f00-000000000000) -- on node1
> 101: UPDATE ks1.tbl SET v0=1597043131977600325 *
> 5466235106362256012, v1=00000000-0000-4500-9800-000000000000, s0=true WHERE
> pk0 = -1604814500 AND pk1 = '2b38:8656:b4c3:662a:1129:ad75:c557:1959' AND
> ck0 = '2055-08-22T09:11:43.351Z' -- on node1
> 104: DELETE FROM ks1.tbl WHERE pk0 = 899031163 AND pk1 =
> '166.83.96.184' AND ck0 = '2026-09-10T09:05:17.045Z' -- on node1
> 106: UPDATE ks1.tbl SET s0=false, v0=7853943918757719482 *
> 8311442026616271709, v1=00000000-0000-4e00-9a00-000000000000 WHERE pk0 =
> 899031163 AND pk1 = '166.83.96.184' AND ck0 = '2061-09-17T23:03:12.731Z' --
> on node1
> 107: UPDATE ks1.tbl SET s0=true, v0=9184601897606684178,
> v1=00000000-0000-4900-9500-000000000000 WHERE pk0 = 1725529242 AND pk1 =
> '117:867a:7a41:e846:36d5:1555:39c6:83f6' AND ck0 =
> '2066-04-13T17:10:41.249Z' -- on node1
> 108: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (-674540792, '231.35.74.202', '1990-02-17T08:46:41.775Z', true,
> -2068989779579395794 - 1088143767855849403,
> 00000000-0000-4e00-8400-000000000000) -- on node1
> 118: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (-1588614995, 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe',
> '2044-12-12T16:20:23.180Z', false, -8119861318124410395,
> 00000000-0000-4400-8a00-000000000000) -- on node1
> 129: DELETE v0, v1 FROM ks1.tbl WHERE pk0 = 1725529242 AND
> pk1 = '117:867a:7a41:e846:36d5:1555:39c6:83f6' AND ck0 =
> '2025-06-04T02:16:39.616Z' -- on node1
> 132: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (-1604814500, '2b38:8656:b4c3:662a:1129:ad75:c557:1959',
> '2024-12-20T13:01:46.053Z', false, -7968182913511381934,
> 00000000-0000-4800-a300-000000000000) -- on node1
> 139: DELETE FROM ks1.tbl WHERE pk0 = 899031163 AND pk1 =
> '166.83.96.184' AND ck0 = '2021-02-16T03:32:23.585Z' -- on node1
> 140: DELETE s0, s0 FROM ks1.tbl WHERE pk0 = -1604814500 AND
> pk1 = '2b38:8656:b4c3:662a:1129:ad75:c557:1959' -- on node1
> 146: DELETE FROM ks1.tbl WHERE pk0 = 1725529242 AND pk1 =
> '117:867a:7a41:e846:36d5:1555:39c6:83f6' AND ck0 =
> '2005-04-29T06:16:39.217Z' -- on node1
> 149: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (1725529242, '117:867a:7a41:e846:36d5:1555:39c6:83f6',
> '1972-05-27T07:54:21.124Z', true, -5070627253851794547,
> 00000000-0000-4e00-b100-000000000000) -- on node1
> 150: DELETE FROM ks1.tbl WHERE pk0 = -1588614995 AND pk1 =
> 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe' AND ck0 =
> '2019-09-09T03:26:32.918Z' -- on node1
> 165: DELETE FROM ks1.tbl WHERE pk0 = -1604814500 AND pk1 =
> '2b38:8656:b4c3:662a:1129:ad75:c557:1959' AND ck0 =
> '2068-02-02T09:30:37.941Z' -- on node1
> 170: DELETE FROM ks1.tbl WHERE pk0 = 899031163 AND pk1 =
> '166.83.96.184' AND ck0 = '2044-10-25T22:52:54.949Z' -- on node1
> 184: DELETE FROM ks1.tbl WHERE pk0 = 39449600 AND pk1 =
> '81.198.103.152' -- on node1
> 198: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (1725529242, '117:867a:7a41:e846:36d5:1555:39c6:83f6',
> '1992-10-25T01:43:46.783Z', true, 6351968542588291471 - 8198394538441004069,
> 00000000-0000-4800-8c00-000000000000) -- on node1
> 213: DELETE FROM ks1.tbl WHERE pk0 = 899031163 AND pk1 =
> '166.83.96.184' AND ck0 = '1990-10-23T09:18:06.920Z' -- on node1
> 214: UPDATE ks1.tbl SET v0=-8299137650853321859 +
> -380136893375894591 WHERE pk0 = 899031163 AND pk1 = '166.83.96.184' AND
> ck0 = '2069-01-02T11:41:56.180Z' -- on node1
> 215: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (899031163, '166.83.96.184', '2041-05-26T01:48:18.393Z', false,
> -1309942315708652688, 00000000-0000-4e00-9000-000000000000) -- on node1
> 217: DELETE FROM ks1.tbl WHERE pk0 = -1588614995 AND pk1 =
> 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe' AND ck0 =
> '2042-05-11T02:00:40.702Z' -- on node1
> 224: UPDATE ks1.tbl SET v0=4244754967876539698 -
> 4325502199417950765, s0=true WHERE pk0 = 39449600 AND pk1 =
> '81.198.103.152' AND ck0 = '2036-06-10T22:00:17.792Z' -- on node1
> 227: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES
> (942134495, '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3',
> '2065-05-12T02:51:46.440Z', false, 8287983160203037938,
> 00000000-0000-4a00-9600-000000000000) -- on node1
> 228: nodetool flush ks1 tbl
> 229: UPDATE ks1.tbl SET v0=-6424812408535177370 *
> -4016939246762444862 WHERE pk0 = 942134495 AND pk1 =
> '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3' AND ck0 =
> '2041-08-28T15:34:53.914Z' -- on node1
> 232: UPDATE ks1.tbl SET v0=-2476516224653398512,
> v1=00000000-0000-4e00-b600-000000000000 WHERE pk0 = 39449600 AND pk1 =
> '81.198.103.152' AND ck0 = '2045-08-05T02:37:57.171Z' -- on node1
> 235: DELETE FROM ks1.tbl WHERE pk0 = 942134495 AND pk1 =
> '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3' -- on node1
> 242: SELECT * FROM ks1.tbl WHERE pk0 <= 899031163 -- pk0 int,
> indexed with SAI, on node1, fetch size 10
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
