[ https://issues.apache.org/jira/browse/CASSANDRA-4216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Billig updated CASSANDRA-4216: ----------------------------------- Description: "select count(1)" works fine; "select count(*)" fails with "Bad Request: Only COUNT(*) and COUNT(1) operations are currently supported." Tested from cqlsh 2.2.0 and current C++ Thrift interface. {code:title=CQL 3} [cqlsh 2.2.0 | Cassandra 1.1.0 | CQL spec 3.0.0 | Thrift protocol 19.30.0] Use HELP for help. cqlsh> use warehouse1; cqlsh:warehouse1> select count(1) from trans; count ------- 504 cqlsh:warehouse1> select count(*) from trans; Bad Request: Only COUNT(*) and COUNT(1) operations are currently supported. {code} CQL 2 works fine: {code:title=CQL 2} [cqlsh 2.2.0 | Cassandra 1.1.0 | CQL spec 2.0.0 | Thrift protocol 19.30.0] Use HELP for help. cqlsh> use warehouse1; cqlsh:warehouse1> select count(*) from trans; count ------- 1562 cqlsh:warehouse1> select count(1) from trans; count ------- 1567 {code} No errors logged by the server. was: "select count(1)" works fine; "select count(*)" fails with "Bad Request: Only COUNT(*) and COUNT(1) operations are currently supported." Tested from cqlsh 2.2.0 and current C++ Thrift interface. {code:title=CQL 3} [cqlsh 2.2.0 | Cassandra 1.1.0 | CQL spec 3.0.0 | Thrift protocol 19.30.0] Use HELP for help. cqlsh> use warehouse1; cqlsh:warehouse1> select count(1) from trans; count ------- 504 cqlsh:warehouse1> select count(*) from trans; Bad Request: Only COUNT(*) and COUNT(1) operations are currently supported. {code} CQL 2 works fine: {code:title=CQL 2} [cqlsh 2.2.0 | Cassandra 1.1.0 | CQL spec 2.0.0 | Thrift protocol 19.30.0] Use HELP for help. cqlsh> use warehouse1; cqlsh:warehouse1> select count(*) from trans; count ------- 1562 cqlsh:warehouse1> select count(1) from trans; count ------- 1567 {code} > CQL 3 "select count(*)" doesn't work > ------------------------------------ > > Key: CASSANDRA-4216 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4216 > Project: Cassandra > Issue Type: Bug > Affects Versions: 1.1.0 > Environment: OSX 10.6.8 > Reporter: Sean Billig > Priority: Minor > Labels: cql3 > > "select count(1)" works fine; "select count(*)" fails with "Bad Request: Only > COUNT(*) and COUNT(1) operations are currently supported." > Tested from cqlsh 2.2.0 and current C++ Thrift interface. > {code:title=CQL 3} > [cqlsh 2.2.0 | Cassandra 1.1.0 | CQL spec 3.0.0 | Thrift protocol 19.30.0] > Use HELP for help. > cqlsh> use warehouse1; > cqlsh:warehouse1> select count(1) from trans; > count > ------- > 504 > cqlsh:warehouse1> select count(*) from trans; > Bad Request: Only COUNT(*) and COUNT(1) operations are currently supported. > {code} > CQL 2 works fine: > {code:title=CQL 2} > [cqlsh 2.2.0 | Cassandra 1.1.0 | CQL spec 2.0.0 | Thrift protocol 19.30.0] > Use HELP for help. > cqlsh> use warehouse1; > cqlsh:warehouse1> select count(*) from trans; > count > ------- > 1562 > cqlsh:warehouse1> select count(1) from trans; > count > ------- > 1567 > {code} > No errors logged by the server. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira