cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sean Billig (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-4216) CQL 3 "select count(*)" doesn't work
Date Thu, 03 May 2012 16:18:49 GMT

     [ 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

        

Mime
View raw message