[ https://issues.apache.org/jira/browse/CASSANDRA-8286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Philip Thompson updated CASSANDRA-8286: --------------------------------------- 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 {code}====================================================================== 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."{code} and occurs at the query {{SELECT col1 FROM test WHERE my_id in('key1', 'key2', 'key3') ORDER BY col1;}} was: 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 {code}====================================================================== 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."{code} and occurs at the query {{SELECT col1 FROM test WHERE my_id in('key1', 'key2', 'key3') ORDER BY col1;}} > Regression in ORDER BY > ---------------------- > > Key: CASSANDRA-8286 > URL: https://issues.apache.org/jira/browse/CASSANDRA-8286 > Project: Cassandra > Issue Type: Bug > Reporter: Philip Thompson > Assignee: Tyler Hobbs > Labels: cql > Fix For: 2.1.3 > > > 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 > {code}====================================================================== > 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."{code} > and occurs at the query {{SELECT col1 FROM test WHERE my_id in('key1', > 'key2', 'key3') ORDER BY col1;}} -- This message was sent by Atlassian JIRA (v6.3.4#6332)