Return-Path: 
 <commits-return-79844-apmail-cassandra-commits-archive=cassandra.apache.org@cassandra.apache.org>
X-Original-To: apmail-cassandra-commits-archive@www.apache.org
Delivered-To: apmail-cassandra-commits-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 84C6010932
	for <apmail-cassandra-commits-archive@www.apache.org>;
 Fri, 23 Aug 2013 17:29:55 +0000 (UTC)
Received: (qmail 91391 invoked by uid 500); 23 Aug 2013 17:29:54 -0000
Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org
Received: (qmail 91270 invoked by uid 500); 23 Aug 2013 17:29:53 -0000
Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:commits-help@cassandra.apache.org>
List-Unsubscribe: <mailto:commits-unsubscribe@cassandra.apache.org>
List-Post: <mailto:commits@cassandra.apache.org>
List-Id: <commits.cassandra.apache.org>
Reply-To: dev@cassandra.apache.org
Delivered-To: mailing list commits@cassandra.apache.org
Received: (qmail 91238 invoked by uid 99); 23 Aug 2013 17:29:53 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Aug 2013 17:29:53 +0000
Date: Fri, 23 Aug 2013 17:29:53 +0000 (UTC)
From: "Aleksey Yeschenko (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12651414.1370543796360.24016.1377278993015@arcas>
In-Reply-To: <JIRA.12651414.1370543796360@arcas>
References: <JIRA.12651414.1370543796360@arcas>
Subject: [jira] [Resolved] (CASSANDRA-5620) Incorrect Syntax for Timestamp
 in Select query
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


     [ 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