David Capwell created CASSANDRA-20278:
-----------------------------------------
Summary: 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
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]
