Sean Billig created CASSANDRA-4216:
--------------------------------------
Summary: 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
"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}
--
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