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

Regression in ORDER BY

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • 2.0.12, 2.1.3
    • None
    • Normal

    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
          Tom Hobbs
        2. 8286-2.1-v2.txt
          23 kB
          Tom Hobbs
        3. 8286-2.0-v2.txt
          34 kB
          Tom Hobbs
        4. 8286-2.0.txt
          8 kB
          Tom Hobbs
        5. 8286-trunk.txt
          7 kB
          Tom Hobbs
        6. 8286-2.1.txt
          10 kB
          Tom Hobbs

        Issue Links

          Activity

            People

              thobbs Tom Hobbs
              philipthompson Philip Thompson
              Tom Hobbs
              Benjamin Lerer
              Philip Thompson Philip Thompson
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: