cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Blake Visin (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4405) SELECT FIRST [N] * does not return KEY
Date Tue, 03 Jul 2012 05:35:02 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-4405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13405635#comment-13405635
] 

Blake Visin commented on CASSANDRA-4405:
----------------------------------------

This could possibly be a cql2 bug...BUT we just upgraded our Cassandra cluster to 1.1.1 and
I have tried this with cql version 1.0.7 and 1.0.8 against 1.1.1 (we were running both on
production) and have the same results.  We upgraded Cassandra version from 1.0.8 to 1.1.1
and this seems to be causing the issue.  Please let me know if there is more information I
can provide, or what I might do about fixing this.  Again it was working correctly on cql
1.0.8 with cassandra 1.0.8 AS WELL AS cassandra 1.0.8 with cql 1.0.10. it is after the upgrade
to cassandra 1.1.1 that it broke.
                
> SELECT FIRST [N] * does not return KEY
> --------------------------------------
>
>                 Key: CASSANDRA-4405
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4405
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Drivers
>    Affects Versions: 1.1.1
>         Environment: CQL version 1.0.10
> Cassandra version 1.1.1
> cqlsh version 2.2.0
> Ubuntu 11.04
>            Reporter: Blake Visin
>            Assignee: paul cannon
>              Labels: cql, cqlsh
>
> cqlsh:ovg> CREATE COLUMNFAMILY 'testing_bug' (KEY text PRIMARY KEY);
> cqlsh:ovg> UPDATE testing_bug SET 'test_col' = 'test_row' where KEY = '1';
> cqlsh:ovg> UPDATE testing_bug SET 'test_col_1' = 'test_row_1' where KEY = '1';
> cqlsh:ovg> UPDATE testing_bug SET 'test_col_2' = 'test_row_2' where KEY = '1';
> cqlsh:ovg> SELECT * FROM testing_bug WHERE KEY = '1';
>  KEY | test_col | test_col_1 | test_col_2
> -----+----------+------------+------------
>    1 | test_row | test_row_1 | test_row_2
> cqlsh:ovg> SELECT FIRST 1 * FROM testing_bug WHERE KEY = '1';
>  test_col
> ----------
>  test_row
> See that KEY is not returned in the second result.  This becomes a problem when combining
this with IN as we don't know what the row key is.
> cqlsh:ovg> SELECT * FROM testing_bug WHERE KEY IN ('1', '2', '3');
>  KEY,1 | test_col,test_row | test_col_1,test_row_1 | test_col_2,test_row_2
>  KEY,2
>  KEY,3
> This may also be another problem:
> cqlsh:ovg> SELECT FIRST 1 * FROM testing_bug WHERE KEY IN ('1', '2', '3');
>  test_col,test_row
> need more than 0 values to unpack

--
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