[ https://issues.apache.org/jira/browse/CASSANDRA-5620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksey Yeschenko reassigned CASSANDRA-5620: -------------------------------------------- Assignee: Aleksey Yeschenko > 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