cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Samuel Wu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-14172) Select with multiple clustering columns and inequality doesn't work
Date Thu, 18 Jan 2018 01:06:01 GMT
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


Mime
View raw message