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

Regression in ORDER BY

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: 2.0.12, 2.1.3
    • Component/s: None
    • Labels:
    • Severity:
      Normal
    • Since Version:

      Description

      The dtest cql_tests.py:TestCQL.order_by_multikey_test is now failing in 2.0:
      http://cassci.datastax.com/job/cassandra-2.0_dtest/lastCompletedBuild/testReport/cql_tests/TestCQL/order_by_multikey_test/history/

      This failure began at the commit for CASSANDRA-8178.

      The error message reads

      ======================================================================
      ERROR: order_by_multikey_test (cql_tests.TestCQL)
      ----------------------------------------------------------------------
      Traceback (most recent call last):
        File "/Users/philipthompson/cstar/cassandra-dtest/dtest.py", line 524, in wrapped
          f(obj)
        File "/Users/philipthompson/cstar/cassandra-dtest/cql_tests.py", line 1807, in order_by_multikey_test
          res = cursor.execute("SELECT col1 FROM test WHERE my_id in('key1', 'key2', 'key3') ORDER BY col1;")
        File "/Library/Python/2.7/site-packages/cassandra/cluster.py", line 1281, in execute
          result = future.result(timeout)
        File "/Library/Python/2.7/site-packages/cassandra/cluster.py", line 2771, in result
          raise self._final_exception
      InvalidRequest: code=2200 [Invalid query] message="ORDER BY could not be used on columns missing in select clause."

      and occurs at the query SELECT col1 FROM test WHERE my_id in('key1', 'key2', 'key3') ORDER BY col1;

        Attachments

        1. 8286-trunk-v2.txt
          20 kB
          Tyler Hobbs
        2. 8286-trunk.txt
          7 kB
          Tyler Hobbs
        3. 8286-2.1-v2.txt
          23 kB
          Tyler Hobbs
        4. 8286-2.1.txt
          10 kB
          Tyler Hobbs
        5. 8286-2.0-v2.txt
          34 kB
          Tyler Hobbs
        6. 8286-2.0.txt
          8 kB
          Tyler Hobbs

          Issue Links

            Activity

              People

              • Assignee:
                thobbs Tyler Hobbs
                Reporter:
                philipthompson Philip Thompson
                Authors:
                Tyler Hobbs
                Reviewers:
                Benjamin Lerer
                Tester:
                Philip Thompson
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: