[
https://issues.apache.org/jira/browse/CASSANDRA-20295?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17925063#comment-17925063
]
Stefan Miklosovic commented on CASSANDRA-20295:
-----------------------------------------------
[CASSANDRA-20295-trunk|https://github.com/instaclustr/cassandra/tree/CASSANDRA-20295-trunk]
{noformat}
java17_pre-commit_tests
✓ j17_build 4m 35s
✓ j17_cqlsh_dtests_py311 7m 0s
✓ j17_cqlsh_dtests_py311_vnode 7m 35s
✓ j17_cqlsh_dtests_py38 6m 59s
✓ j17_cqlshlib_cython_tests 8m 14s
✓ j17_cqlshlib_tests 7m 19s
✓ j17_dtests_latest 41m 50s
✓ j17_dtests_vnode 41m 54s
✓ j17_unit_tests 15m 49s
✓ j17_unit_tests_repeat 12m 52s
✓ j17_utests_latest 17m 35s
✓ j17_utests_latest_repeat 13m 14s
✓ j17_utests_oa 16m 29s
✓ j17_utests_oa_repeat 14m 23s
✕ j17_cqlsh_dtests_py38_vnode 8m 41s
cqlsh_tests.test_cqlsh_copy.TestCqlshCopy
test_bulk_round_trip_with_timeouts
✕ j17_dtests 38m 42s
refresh_test.TestRefresh test_refresh_deadlock_startup
✕ j17_jvm_dtests 24m 32s
org.apache.cassandra.fuzz.sai.MultiNodeSAITest indexOnlySaiTest TIMEOUTED
✕ j17_jvm_dtests_latest_vnode 24m 55s
org.apache.cassandra.fuzz.sai.MultiNodeSAITest indexOnlySaiTest TIMEOUTED
{noformat}
[java17_pre-commit_tests|https://app.circleci.com/pipelines/github/instaclustr/cassandra/5394/workflows/b6a6c3a7-ecdd-4bda-bc02-0f4efecf34be]
> Fix Min/Max aggregation function on reversed types
> ---------------------------------------------------
>
> Key: CASSANDRA-20295
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20295
> Project: Apache Cassandra
> Issue Type: Bug
> Components: Legacy/Core, Legacy/Local Write-Read Paths
> Reporter: Artem Golovko
> Assignee: Stefan Miklosovic
> Priority: Normal
> Fix For: 5.0.x, 5.x
>
> Time Spent: 1h 10m
> Remaining Estimate: 0h
>
> *Cassandra version*
> 5.0.3
> docker run --name cassandra -d cassandra:5
> docker exec -it cassandra cqlsh
>
> *Data schema*
> {code:java}
> CREATE KEYSPACE IF NOT EXISTS test WITH replication = { 'class':
> 'SimpleStrategy', 'replication_factor': 1 } AND durable_writes = true;
> USE test;
> CREATE TABLE data(
> sensor_id text,
> time timestamp,
> value double,
> PRIMARY KEY (sensor_id, time)
> ) WITH CLUSTERING ORDER BY (time DESC)
> AND compaction = {'class': 'TimeWindowCompactionStrategy' };
> INSERT INTO data (sensor_id, time, value) VALUES ('s1', 0, 1);
> INSERT INTO data (sensor_id, time, value) VALUES ('s1', 1000, 2);{code}
>
> *Actual result*
> {code:java}
> SELECT min(time), max(time) FROM data WHERE sensor_id = 's1';
> system.min(time) | system.max(time)
> ---------------------------------+---------------------------------
> 1970-01-01 00:00:01.000000+0000 | 1970-01-01 00:00:00.000000+0000(1
> rows){code}
>
> {*}Expected result{*}{*}{*}
> On cassandra 4 (tested with 4.1.8) everything is working fine
> {code:java}
> SELECT min(time), max(time) FROM data WHERE sensor_id = 's1';
> system.min(time) | system.max(time)
> ---------------------------------+---------------------------------
> 1970-01-01 00:00:00.000000+0000 | 1970-01-01 00:00:01.000000+0000(1
> rows){code}
> *Note*
> If we'll change clustering order from DESC to ASC then problem disappear
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
