You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Samuel Wu (JIRA)" <ji...@apache.org> on 2018/01/18 01:06:01 UTC
[jira] [Created] (CASSANDRA-14172) Select with multiple clustering
columns and inequality doesn't work
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: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org