[ https://issues.apache.org/jira/browse/CASSANDRA-8286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14205331#comment-14205331 ]
Philip Thompson commented on CASSANDRA-8286: -------------------------------------------- However, in the 2.1 test {{TestCQL.in_order_by_without_selecting_test}}, the following exception has begun appearing at the same time: http://cassci.datastax.com/job/cassandra-2.1_dtest/lastCompletedBuild/testReport/cql_tests/TestCQL/in_order_by_without_selecting_test/history/ {code}ERROR [SharedPool-Worker-3] 2014-11-10 14:58:28,591 Message.java :538 - Unexpected exception during request; channel = [id: 0x5aa e53fd, /127.0.0.1:63101 => /127.0.0.1:9042] java.lang.AssertionError: null at org.apache.cassandra.cql3.ResultSet.addRow(ResultSet.java:63) ~[main/:na] at org.apache.cassandra.cql3.statements.Selection$ResultSetBuilder.newRow(Selection.java:333) ~[main/:na] at org.apache.cassandra.cql3.statements.SelectStatement.processColumnFamily(SelectStatement.java:1227) ~[main/:na] at org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:1161) ~[main/:na] at org.apache.cassandra.cql3.statements.SelectStatement.processResults(SelectStatement.java:290) ~[main/:na] at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:267) ~[main/:na] at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:215) ~[main/:na] at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:64) ~[main/:na] at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:226) ~[main/:na] at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:248) ~[main/:na] at org.apache.cassandra.transport.messages.QueryMessage.execute(QueryMessage.java:119) ~[main/:na] at org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:439) [main/:na] at org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:335) [main/:na] at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105) [netty-all-4.0.23.Final.jar:4.0.23.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333) [netty-all-4.0.23.Final.jar:4.0.23.Final] at io.netty.channel.AbstractChannelHandlerContext.access$700(AbstractChannelHandlerContext.java:32) [netty-all-4.0.23.Final.jar:4.0.23.Final] at io.netty.channel.AbstractChannelHandlerContext$8.run(AbstractChannelHandlerContext.java:324) [netty-all-4.0.23.Final.jar:4.0.23.Final] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [na:1.7.0_67] at org.apache.cassandra.concurrent.AbstractTracingAwareExecutorService$FutureTask.run(AbstractTracingAwareExecutorService.java:164) [main/:na] at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105) [main/:na] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_67]{code} > 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.0.12 > > > 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)