Samuel Wu created CASSANDRA-14172:
-------------------------------------
Summary: Select with multiple clustering columns and inequality
doesn't work
Key: CASSANDRA-14172
URL: https://issues.apache.org/jira/browse/CASSANDRA-14172
Project: Cassandra
Issue Type: Bug
Components: CQL
Environment: com.datastax.cassandra:cassandra-driver-core:3.3.0 on
linux
Reporter: Samuel Wu
Fix For: 3.11.1
* I have a table created as the following command.
* CREATE TABLE IF NOT EXISTS test.discrepancies(
modality text,
disease text,
location text,
type text,
status text,
studyDate timestamp,
birthDay timestamp,
discoveryTime timestamp,
reportId uuid,
mrn text,
firstName text,
PRIMARY KEY ((location, modality, disease), type, status, studyDate, birthDay,
discoveryTime)
);
* The following data are populated in the table
* location | modality | disease | type | status | studydate
| birthday | discoverytime |
firstname | mrn | reportid
----------+----------+----------+------+--------+---------------------------------+---------------------------------+---------------------------------+-----------+------+--------------------------------------
West | CX | disease1 | PLD | OPEN | 2018-01-17
15:06:44.138000+0000 | 1970-01-02 10:17:36.789000+0000 | 2018-01-17
15:06:44.138000+0000 | name1 | mrn1 | 9a545096-6191-4275-86b3-cc89e181f494
* When the following command was run, I would expect no row found since the
birthday and discoveoytime is out of range.
* select * from test.discrepancies where disease='disease1' and
location='West' and modality='CX' and type='PLD' and status='OPEN' and
(studydate, birthday, discoverytime) < (2516201604308,0,0);
* But the above row was returned instead.
* This feature was implemented in
https://issues.apache.org/jira/browse/CASSANDRA-4851
* see https://docs.datastax.com/en/cql/3.3/cql/cql_using/useQueryIN.html
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
