[CASSANDRA-10832] DevCenter gives extraneous input error when using order by ASC and limit

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Not A Problem
• Fix Version/s: 2.1.x
• Component/s: Legacy/CQL, Legacy/Tools

Environment

Windows 8.1 64Bit

• Severity: Low
• Assignee: Unassigned
• Reporter: William Streaker
• Created: 09/Dec/15 14:56
• Updated: 16/Apr/19 09:30
• Resolved: 10/Mar/16 20:55

Description

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);