[
https://issues.apache.org/jira/browse/CASSANDRA-20154?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18053379#comment-18053379
]
David Capwell commented on CASSANDRA-20154:
-------------------------------------------
||Repo||Branch||Parent Branch||SHA||Status||
|https://github.com/dcapwell/cassandra.git|commit_remote_branch/CASSANDRA-20154-trunk-9BC4FDE7-C088-4D5D-AA58-ABF51DB65678|trunk|406b8946d8ffae95ae4eec5ad3d9900d17c431a6|Unstable
Failed Builds:
||Build||Result||Reason||
| jvm-dtest-simulator | fail | Test
org.apache.cassandra.simulator.test.EpochStressTest::manyEpochsAndAccordConverges-_jdk11
had an |
| jvm-upgrade-dtests | fail | Test
org.apache.cassandra.distributed.upgrade.ClusterMetadataUpgradeHarryTest::simpleUpgradeTest-_jd
|
| jvm-utests-latest | fail | Test
org.apache.cassandra.index.accord.RouteIndexTest::test-cassandra.testtag_IS_UNDEFINED
had an er |
| jvm11-dtests | fail | Test
org.apache.cassandra.distributed.test.accord.AccordBootstrapTest::mappertimedout
had an error,T |
| jvm11-dtests-fuzz | fail | Test
org.apache.cassandra.fuzz.topology.AccordBootstrapTest::bootstrapFuzzTest-_jdk11
failed |
| jvm17-dtests | fail | Test
org.apache.cassandra.distributed.test.accord.MigrationFromAccordWriteRaceTest::testSplitAndRetr
|
| jvm17-dtests-fuzz | fail | Test
org.apache.cassandra.fuzz.topology.AccordBootstrapTest::bootstrapFuzzTest-_jdk17
failed |
| jvm17-utests | fail | Test
org.apache.cassandra.index.accord.RouteIndexTest::test-cassandra.testtag_IS_UNDEFINED
had an er |
| python-dtests | fail | Test
gossip_test.TestGossip::gossip_test.py::TestGossip::test_2dc_parallel_startup_one_seed
failed,T |
| python-dtests-latest | fail | Test
bootstrap_test.TestBootstrap::bootstrap_test.py::TestBootstrap::test_decommissioned_wiped_node_
|
| python-upgrade-dtests | fail | Test
upgrade_tests.upgrade_through_versions_test.TestProtoV5Upgrade_AllVersions_RandomPartitioner_En
|
| python-upgrade-dtests-large | fail | Test
upgrade_tests.upgrade_through_versions_test.TestProtoV5Upgrade_AllVersions_RandomPartitioner_En
|
> BETWEEN where token(Y) > token(Z) returns wrong answer
> ------------------------------------------------------
>
> Key: CASSANDRA-20154
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20154
> Project: Apache Cassandra
> Issue Type: Bug
> Components: CQL/Semantics
> Reporter: Ariel Weisberg
> Assignee: Arvind Kandpal
> Priority: Urgent
> Labels: lhf, low-hanging-fruit, lowhanging-fruit
> Fix For: 6.x
>
> Attachments:
> ci_summary-trunk-406b8946d8ffae95ae4eec5ad3d9900d17c431a6.html,
> result_details-trunk-406b8946d8ffae95ae4eec5ad3d9900d17c431a6.tar.gz
>
> Time Spent: 5.5h
> Remaining Estimate: 0h
>
> Noticed it’s not compliant with the SQL specification for BETWEEN and so
> doesn’t match what other databases do (tested on Postgres and MySQL).
> Here is the [SQL 92
> spec|https://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt] (later
> versions probably don't change something so fundamental).
> In particular rule 6 doesn't match the observed behavior which is to swap Y
> and Z and then return what is in between them which is pretty surprising as a
> result.
> {noformat}
> 6) "X BETWEEN Y AND Z" is equivalent to "X>=Y AND X<=Z".
> {noformat}
> {noformat}
> 8.3 <between predicate>
> Function
> Specify a range comparison.
> Format
> <between predicate> ::=
> <row value constructor> [ NOT ] BETWEEN
> <row value constructor> AND <row value constructor>
> Syntax Rules
> 1) The three <row value constructor>s shall be of the same degree.
> 2) Let respective values be values with the same ordinal position
> in the two <row value constructor>s.
> 3) The data types of the respective values of the three <row value
> constructor>s shall be comparable.
> 4) Let X, Y, and Z be the first, second, and third <row value con-
> structor>s, respectively.
> 5) "X NOT BETWEEN Y AND Z" is equivalent to "NOT ( X BETWEEN Y AND
> Z )".
> 6) "X BETWEEN Y AND Z" is equivalent to "X>=Y AND X<=Z".
> {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]
