Chandran Anjur Narasimhan created CASSANDRA-10428:
-----------------------------------------------------
Summary: select with exact date is not working
Key: CASSANDRA-10428
URL: https://issues.apache.org/jira/browse/CASSANDRA-10428
Project: Cassandra
Issue Type: Bug
Components: Tools
Environment: OSX 10.10.2
Reporter: Chandran Anjur Narasimhan
Fix For: 2.1.x
Query with >= timestamp works. But the exact timestamp value is not working.
{quote}
NCHAN-M-D0LZ:bin nchan$ ./cqlsh
Connected to CCC Multi-Region Cassandra Cluster at <host>:<port>.
[cqlsh 5.0.1 | Cassandra 2.1.7 | CQL spec 3.2.0 | Native protocol v3]
Use HELP for help.
cqlsh>
{quote}
:
{panel:title=Working|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1|bgColor=#FFFFCE}
cqlsh:ccc> select submissionid, ezid, name, time, state, status,
translated_criteria_status from ez_task_result where
submissionid='760dd154670811e58c04005056bb6ff0' and
ezid='760dd6de670811e594fc005056bb6ff0' and name='run-sanities' and
time>='2015-09-29 20:54:23-0700';
submissionid | ezid | name
| time | state | status |
translated_criteria_status
----------------------------------+----------------------------------+--------------+--------------------------+-----------+-------------+----------------------------
760dd154670811e58c04005056bb6ff0 | 760dd6de670811e594fc005056bb6ff0 |
run-sanities | 2015-09-29 20:54:23-0700 | EXECUTING | IN_PROGRESS |
run-sanities started
(1 rows)
cqlsh:ccc>
{panel}
{panel:title=Not
working|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1|bgColor=#FFFFCE}
cqlsh:ccc> select submissionid, ezid, name, time, state, status,
translated_criteria_status from ez_task_result where
submissionid='760dd154670811e58c04005056bb6ff0' and
ezid='760dd6de670811e594fc005056bb6ff0' and name='run-sanities' and
time='2015-09-29 20:54:23-0700';
submissionid | ezid | name | time | analyzed_index_root | analyzed_log_path |
clientid | end_time | jenkins_path | log_file_path | path_available |
path_to_task | required_for_overall_status | start_time | state | status |
translated_criteria_status | type
--------------+------+------+------+---------------------+-------------------+----------+----------+--------------+---------------+----------------+--------------+-----------------------------+------------+-------+--------+----------------------------+------
(0 rows)
cqlsh:ccc>
{panel}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
