[
https://issues.apache.org/jira/browse/CASSANDRA-20295?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17924994#comment-17924994
]
Stefan Miklosovic commented on CASSANDRA-20295:
-----------------------------------------------
[CASSANDRA-20295-5.0|https://github.com/instaclustr/cassandra/tree/CASSANDRA-20295-5.0]
{noformat}
java17_pre-commit_tests
✓ j17_build 3m 54s
✓ j17_cqlsh_dtests_py311 6m 27s
✓ j17_cqlsh_dtests_py311_vnode 6m 33s
✓ j17_cqlsh_dtests_py38 6m 13s
✓ j17_cqlsh_dtests_py38_vnode 5m 53s
✓ j17_cqlshlib_cython_tests 7m 32s
✓ j17_cqlshlib_tests 9m 47s
✓ j17_dtests_latest 40m 24s
✓ j17_jvm_dtests 23m 54s
✓ j17_jvm_dtests_latest_vnode 20m 16s
✓ j17_unit_tests 17m 7s
✓ j17_unit_tests_repeat 12m 47s
✓ j17_utests_latest 17m 3s
✓ j17_utests_latest_repeat 14m 37s
✓ j17_utests_oa 17m 11s
✓ j17_utests_oa_repeat 14m 5s
✕ j17_dtests 34m 58s
refresh_test.TestRefresh test_refresh_deadlock_startup
✕ j17_dtests_vnode 42m 19s
bootstrap_test.TestBootstrap test_killed_wiped_node_cannot_join
{noformat}
[java17_pre-commit_tests|https://app.circleci.com/pipelines/github/instaclustr/cassandra/5388/workflows/1a51861a-d14f-44da-ac92-3171972c64e8]
> 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]
