You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Tyler Patterson (JIRA)" <ji...@apache.org> on 2012/09/19 16:58:07 UTC
[jira] [Created] (CASSANDRA-4689) Log error when using IN together
with ORDER BY
Tyler Patterson created CASSANDRA-4689:
------------------------------------------
Summary: Log error when using IN together with ORDER BY
Key: CASSANDRA-4689
URL: https://issues.apache.org/jira/browse/CASSANDRA-4689
Project: Cassandra
Issue Type: Bug
Environment: built from source on cassandra-1.1 (b43cc362aa568a46bc53e545c68518b0bd350b76)
os: ubuntu
Reporter: Tyler Patterson
Assignee: Pavel Yaskevich
{code}
$ bin/cqlsh -3
Connected to Test Cluster at localhost:9160.
[cqlsh 2.2.0 | Cassandra 1.1.5-SNAPSHOT | CQL spec 3.0.0 | Thrift protocol 19.32.0]
Use HELP for help.
cqlsh> use ks;
cqlsh:ks> drop TABLE test;
cqlsh:ks> CREATE TABLE test (my_id varchar, time_id uuid, value int, PRIMARY KEY (my_id, time_id));
cqlsh:ks> INSERT INTO test (my_id, time_id, value) VALUES ('key1', 1, 1);
cqlsh:ks> INSERT INTO test (my_id, time_id, value) VALUES ('key2', 2, 2);
cqlsh:ks> select * from test where my_id in('key1', 'key2') order by time_id;
TSocket read 0 bytes
{code}
The log shows this:
{code}
ERROR [Thrift:5] 2012-09-19 08:44:59,859 CustomTThreadPoolServer.java (line 204) Error occurred during processing of message.
java.lang.IllegalArgumentException: Column time_id wasn't found in select clause.
at org.apache.cassandra.cql3.statements.SelectStatement.getColumnPositionInSelect(SelectStatement.java:866)
at org.apache.cassandra.cql3.statements.SelectStatement.orderResults(SelectStatement.java:836)
at org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:807)
at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:137)
at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:108)
at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:121)
at org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1242)
at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3542)
at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3530)
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:186)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
{code}
NOTE: This issue appears similar to https://issues.apache.org/jira/browse/CASSANDRA-4612 from the user perspective, even though 4612 was verified as fixed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4689) Log error when using IN
together with ORDER BY
Posted by "Sylvain Lebresne (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13459515#comment-13459515 ]
Sylvain Lebresne commented on CASSANDRA-4689:
---------------------------------------------
+1
> Log error when using IN together with ORDER BY
> ----------------------------------------------
>
> Key: CASSANDRA-4689
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4689
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.1.5
> Environment: built from source on cassandra-1.1 (b43cc362aa568a46bc53e545c68518b0bd350b76)
> os: ubuntu
> Reporter: Tyler Patterson
> Assignee: Pavel Yaskevich
> Fix For: 1.1.6
>
> Attachments: CASSANDRA-4689.patch
>
>
> {code}
> $ bin/cqlsh -3
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.2.0 | Cassandra 1.1.5-SNAPSHOT | CQL spec 3.0.0 | Thrift protocol 19.32.0]
> Use HELP for help.
> cqlsh> use ks;
> cqlsh:ks> drop TABLE test;
> cqlsh:ks> CREATE TABLE test (my_id varchar, time_id uuid, value int, PRIMARY KEY (my_id, time_id));
> cqlsh:ks> INSERT INTO test (my_id, time_id, value) VALUES ('key1', 1, 1);
> cqlsh:ks> INSERT INTO test (my_id, time_id, value) VALUES ('key2', 2, 2);
> cqlsh:ks> select * from test where my_id in('key1', 'key2') order by time_id;
> TSocket read 0 bytes
> {code}
> The log shows this:
> {code}
> ERROR [Thrift:5] 2012-09-19 08:44:59,859 CustomTThreadPoolServer.java (line 204) Error occurred during processing of message.
> java.lang.IllegalArgumentException: Column time_id wasn't found in select clause.
> at org.apache.cassandra.cql3.statements.SelectStatement.getColumnPositionInSelect(SelectStatement.java:866)
> at org.apache.cassandra.cql3.statements.SelectStatement.orderResults(SelectStatement.java:836)
> at org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:807)
> at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:137)
> at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:108)
> at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:121)
> at org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1242)
> at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3542)
> at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3530)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
> at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:186)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> {code}
> NOTE: This issue appears similar to https://issues.apache.org/jira/browse/CASSANDRA-4612 from the user perspective, even though 4612 was verified as fixed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-4689) Log error when using IN together
with ORDER BY
Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pavel Yaskevich updated CASSANDRA-4689:
---------------------------------------
Attachment: CASSANDRA-4689.patch
changes from CASSANDRA-4612 aren't covering extended selections properly.
> Log error when using IN together with ORDER BY
> ----------------------------------------------
>
> Key: CASSANDRA-4689
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4689
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.1.5
> Environment: built from source on cassandra-1.1 (b43cc362aa568a46bc53e545c68518b0bd350b76)
> os: ubuntu
> Reporter: Tyler Patterson
> Assignee: Sylvain Lebresne
> Fix For: 1.1.6
>
> Attachments: CASSANDRA-4689.patch
>
>
> {code}
> $ bin/cqlsh -3
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.2.0 | Cassandra 1.1.5-SNAPSHOT | CQL spec 3.0.0 | Thrift protocol 19.32.0]
> Use HELP for help.
> cqlsh> use ks;
> cqlsh:ks> drop TABLE test;
> cqlsh:ks> CREATE TABLE test (my_id varchar, time_id uuid, value int, PRIMARY KEY (my_id, time_id));
> cqlsh:ks> INSERT INTO test (my_id, time_id, value) VALUES ('key1', 1, 1);
> cqlsh:ks> INSERT INTO test (my_id, time_id, value) VALUES ('key2', 2, 2);
> cqlsh:ks> select * from test where my_id in('key1', 'key2') order by time_id;
> TSocket read 0 bytes
> {code}
> The log shows this:
> {code}
> ERROR [Thrift:5] 2012-09-19 08:44:59,859 CustomTThreadPoolServer.java (line 204) Error occurred during processing of message.
> java.lang.IllegalArgumentException: Column time_id wasn't found in select clause.
> at org.apache.cassandra.cql3.statements.SelectStatement.getColumnPositionInSelect(SelectStatement.java:866)
> at org.apache.cassandra.cql3.statements.SelectStatement.orderResults(SelectStatement.java:836)
> at org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:807)
> at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:137)
> at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:108)
> at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:121)
> at org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1242)
> at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3542)
> at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3530)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
> at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:186)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> {code}
> NOTE: This issue appears similar to https://issues.apache.org/jira/browse/CASSANDRA-4612 from the user perspective, even though 4612 was verified as fixed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (CASSANDRA-4689) Log error when using IN together
with ORDER BY
Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pavel Yaskevich reassigned CASSANDRA-4689:
------------------------------------------
Assignee: Pavel Yaskevich (was: Sylvain Lebresne)
> Log error when using IN together with ORDER BY
> ----------------------------------------------
>
> Key: CASSANDRA-4689
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4689
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.1.5
> Environment: built from source on cassandra-1.1 (b43cc362aa568a46bc53e545c68518b0bd350b76)
> os: ubuntu
> Reporter: Tyler Patterson
> Assignee: Pavel Yaskevich
> Fix For: 1.1.6
>
> Attachments: CASSANDRA-4689.patch
>
>
> {code}
> $ bin/cqlsh -3
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.2.0 | Cassandra 1.1.5-SNAPSHOT | CQL spec 3.0.0 | Thrift protocol 19.32.0]
> Use HELP for help.
> cqlsh> use ks;
> cqlsh:ks> drop TABLE test;
> cqlsh:ks> CREATE TABLE test (my_id varchar, time_id uuid, value int, PRIMARY KEY (my_id, time_id));
> cqlsh:ks> INSERT INTO test (my_id, time_id, value) VALUES ('key1', 1, 1);
> cqlsh:ks> INSERT INTO test (my_id, time_id, value) VALUES ('key2', 2, 2);
> cqlsh:ks> select * from test where my_id in('key1', 'key2') order by time_id;
> TSocket read 0 bytes
> {code}
> The log shows this:
> {code}
> ERROR [Thrift:5] 2012-09-19 08:44:59,859 CustomTThreadPoolServer.java (line 204) Error occurred during processing of message.
> java.lang.IllegalArgumentException: Column time_id wasn't found in select clause.
> at org.apache.cassandra.cql3.statements.SelectStatement.getColumnPositionInSelect(SelectStatement.java:866)
> at org.apache.cassandra.cql3.statements.SelectStatement.orderResults(SelectStatement.java:836)
> at org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:807)
> at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:137)
> at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:108)
> at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:121)
> at org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1242)
> at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3542)
> at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3530)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
> at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:186)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> {code}
> NOTE: This issue appears similar to https://issues.apache.org/jira/browse/CASSANDRA-4612 from the user perspective, even though 4612 was verified as fixed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-4689) Log error when using IN together
with ORDER BY
Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pavel Yaskevich updated CASSANDRA-4689:
---------------------------------------
Reviewer: slebresne
> Log error when using IN together with ORDER BY
> ----------------------------------------------
>
> Key: CASSANDRA-4689
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4689
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.1.5
> Environment: built from source on cassandra-1.1 (b43cc362aa568a46bc53e545c68518b0bd350b76)
> os: ubuntu
> Reporter: Tyler Patterson
> Assignee: Pavel Yaskevich
> Fix For: 1.1.6
>
> Attachments: CASSANDRA-4689.patch
>
>
> {code}
> $ bin/cqlsh -3
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.2.0 | Cassandra 1.1.5-SNAPSHOT | CQL spec 3.0.0 | Thrift protocol 19.32.0]
> Use HELP for help.
> cqlsh> use ks;
> cqlsh:ks> drop TABLE test;
> cqlsh:ks> CREATE TABLE test (my_id varchar, time_id uuid, value int, PRIMARY KEY (my_id, time_id));
> cqlsh:ks> INSERT INTO test (my_id, time_id, value) VALUES ('key1', 1, 1);
> cqlsh:ks> INSERT INTO test (my_id, time_id, value) VALUES ('key2', 2, 2);
> cqlsh:ks> select * from test where my_id in('key1', 'key2') order by time_id;
> TSocket read 0 bytes
> {code}
> The log shows this:
> {code}
> ERROR [Thrift:5] 2012-09-19 08:44:59,859 CustomTThreadPoolServer.java (line 204) Error occurred during processing of message.
> java.lang.IllegalArgumentException: Column time_id wasn't found in select clause.
> at org.apache.cassandra.cql3.statements.SelectStatement.getColumnPositionInSelect(SelectStatement.java:866)
> at org.apache.cassandra.cql3.statements.SelectStatement.orderResults(SelectStatement.java:836)
> at org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:807)
> at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:137)
> at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:108)
> at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:121)
> at org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1242)
> at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3542)
> at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3530)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
> at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:186)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> {code}
> NOTE: This issue appears similar to https://issues.apache.org/jira/browse/CASSANDRA-4612 from the user perspective, even though 4612 was verified as fixed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4689) Log error when using IN
together with ORDER BY
Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13458864#comment-13458864 ]
Pavel Yaskevich commented on CASSANDRA-4689:
--------------------------------------------
Jonathan, I can easily handle this one if Sylvain has a lot on his plate.
> Log error when using IN together with ORDER BY
> ----------------------------------------------
>
> Key: CASSANDRA-4689
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4689
> Project: Cassandra
> Issue Type: Bug
> Environment: built from source on cassandra-1.1 (b43cc362aa568a46bc53e545c68518b0bd350b76)
> os: ubuntu
> Reporter: Tyler Patterson
> Assignee: Sylvain Lebresne
>
> {code}
> $ bin/cqlsh -3
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.2.0 | Cassandra 1.1.5-SNAPSHOT | CQL spec 3.0.0 | Thrift protocol 19.32.0]
> Use HELP for help.
> cqlsh> use ks;
> cqlsh:ks> drop TABLE test;
> cqlsh:ks> CREATE TABLE test (my_id varchar, time_id uuid, value int, PRIMARY KEY (my_id, time_id));
> cqlsh:ks> INSERT INTO test (my_id, time_id, value) VALUES ('key1', 1, 1);
> cqlsh:ks> INSERT INTO test (my_id, time_id, value) VALUES ('key2', 2, 2);
> cqlsh:ks> select * from test where my_id in('key1', 'key2') order by time_id;
> TSocket read 0 bytes
> {code}
> The log shows this:
> {code}
> ERROR [Thrift:5] 2012-09-19 08:44:59,859 CustomTThreadPoolServer.java (line 204) Error occurred during processing of message.
> java.lang.IllegalArgumentException: Column time_id wasn't found in select clause.
> at org.apache.cassandra.cql3.statements.SelectStatement.getColumnPositionInSelect(SelectStatement.java:866)
> at org.apache.cassandra.cql3.statements.SelectStatement.orderResults(SelectStatement.java:836)
> at org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:807)
> at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:137)
> at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:108)
> at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:121)
> at org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1242)
> at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3542)
> at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3530)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
> at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:186)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> {code}
> NOTE: This issue appears similar to https://issues.apache.org/jira/browse/CASSANDRA-4612 from the user perspective, even though 4612 was verified as fixed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-4689) Log error when using IN together
with ORDER BY
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis updated CASSANDRA-4689:
--------------------------------------
Assignee: Sylvain Lebresne (was: Pavel Yaskevich)
> Log error when using IN together with ORDER BY
> ----------------------------------------------
>
> Key: CASSANDRA-4689
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4689
> Project: Cassandra
> Issue Type: Bug
> Environment: built from source on cassandra-1.1 (b43cc362aa568a46bc53e545c68518b0bd350b76)
> os: ubuntu
> Reporter: Tyler Patterson
> Assignee: Sylvain Lebresne
>
> {code}
> $ bin/cqlsh -3
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.2.0 | Cassandra 1.1.5-SNAPSHOT | CQL spec 3.0.0 | Thrift protocol 19.32.0]
> Use HELP for help.
> cqlsh> use ks;
> cqlsh:ks> drop TABLE test;
> cqlsh:ks> CREATE TABLE test (my_id varchar, time_id uuid, value int, PRIMARY KEY (my_id, time_id));
> cqlsh:ks> INSERT INTO test (my_id, time_id, value) VALUES ('key1', 1, 1);
> cqlsh:ks> INSERT INTO test (my_id, time_id, value) VALUES ('key2', 2, 2);
> cqlsh:ks> select * from test where my_id in('key1', 'key2') order by time_id;
> TSocket read 0 bytes
> {code}
> The log shows this:
> {code}
> ERROR [Thrift:5] 2012-09-19 08:44:59,859 CustomTThreadPoolServer.java (line 204) Error occurred during processing of message.
> java.lang.IllegalArgumentException: Column time_id wasn't found in select clause.
> at org.apache.cassandra.cql3.statements.SelectStatement.getColumnPositionInSelect(SelectStatement.java:866)
> at org.apache.cassandra.cql3.statements.SelectStatement.orderResults(SelectStatement.java:836)
> at org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:807)
> at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:137)
> at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:108)
> at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:121)
> at org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1242)
> at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3542)
> at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3530)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34)
> at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:186)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> {code}
> NOTE: This issue appears similar to https://issues.apache.org/jira/browse/CASSANDRA-4612 from the user perspective, even though 4612 was verified as fixed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira