Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-10832

DevCenter gives extraneous input error when using order by ASC and limit

Agile BoardAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Low
    • Resolution: Not A Problem
    • 2.1.x
    • Legacy/CQL, Legacy/Tools
    • None
    • Windows 8.1 64Bit

    • Low

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

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned Assign to me
            wildwillie William Streaker
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment