cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aleksey Yeschenko (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CASSANDRA-5620) Incorrect Syntax for Timestamp in Select query
Date Fri, 23 Aug 2013 17:29:53 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-5620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Aleksey Yeschenko resolved CASSANDRA-5620.
------------------------------------------

    Resolution: Fixed

Fixed on Aug 10 by 2a8379372e6cbcd2fa3008b203c70f57ad29f392
                
> Incorrect Syntax for Timestamp in Select query
> ----------------------------------------------
>
>                 Key: CASSANDRA-5620
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5620
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Documentation & website
>            Reporter: tariq rahiman
>            Assignee: Aleksey Yeschenko
>            Priority: Minor
>
> In the page http://cassandra.apache.org/doc/cql3/CQL.html under the heading Queries -->
SELECT --> <where-clause>  We have a table posts followed by a Query which doesnt
seem to work against the Cassandra Server. 
> Timestamp requires quotes in the WHERE clause.
> CREATE TABLE posts (
>     userid text,
>     blog_title text,
>     posted_at timestamp,
>     entry_title text,
>     content text,
>     category int,
>     PRIMARY KEY (userid, blog_title, posted_at)
> )
> Incorrect
> SELECT entry_title, content FROM posts WHERE userid='john doe' AND blog_title='John's
Blog' AND posted_at >= 2012-01-01 AND posted_at < 2012-01-31
> I get the the error mismatched character '<EOF>' expecting '''
> If I correc the error in Johns''Blog and proceed I get missing EOF at '-01'
> Correct
> SELECT entry_title, content FROM posts WHERE userid='john doe' AND blog_title='John''s
Blog' AND posted_at >= '2012-01-01' AND posted_at < '2012-01-31'

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message