cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "William Streaker (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-10832) DevCenter gives extraneous input error when using order by ASC and limit
Date Wed, 09 Dec 2015 14:58:11 GMT

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

William Streaker updated CASSANDRA-10832:
-----------------------------------------
    Summary: DevCenter gives extraneous input error when using order by ASC and limit  (was:
DevCenter gives extranious input error when using order by ASC and limit)

> DevCenter gives extraneous input error when using order by ASC and limit
> ------------------------------------------------------------------------
>
>                 Key: CASSANDRA-10832
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-10832
>             Project: Cassandra
>          Issue Type: Bug
>          Components: CQL, Tools
>         Environment: Windows 8.1 64Bit
>            Reporter: William Streaker
>            Priority: Minor
>             Fix For: 2.1.x
>
>
> When issuing the following statement:
> select * from crlfile where group = 'Active'
> order by createDt ASC limit 1;
> I get this error:
> Unable to execute CQL script on 'laptopCluster@envieta':
> com.datastax.driver.core.exceptions.SyntaxError: line 2:23 extraneous input '1' expecting
EOF
> When issuing the statement using DESC order it works.   It will also work if I remove
the 'limit 1'.   This issue occurs with DevCenter 1.4, 1.4.1, and 1.5
> Table Definition:
> CREATE TABLE CRLFile (
>    group       TEXT,       -- Group Files by Year-Month(YYYYMM).  Latest file will be
in group "Active"
>    createDt TimeStamp,     -- Date File was created
>    fileContents BLOB,      -- File itself for download
>   PRIMARY KEY ( group, createDt ))
>   WITH CLUSTERING ORDER BY (createDt DESC);
>   



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message