cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4796) composite indexes don't always return results they should
Date Tue, 16 Oct 2012 01:31:03 GMT

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

Jonathan Ellis commented on CASSANDRA-4796:
-------------------------------------------

+1
                
> composite indexes don't always return results they should
> ---------------------------------------------------------
>
>                 Key: CASSANDRA-4796
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4796
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>            Reporter: Brandon Williams
>            Assignee: Sylvain Lebresne
>             Fix For: 1.2.0 beta 2
>
>         Attachments: 4726.txt
>
>
> composite_index_with_pk_test in the dtests is failing and it reproduces manually.
> {noformat}
> cqlsh:foo>            CREATE TABLE blogs (                 blog_id int,          
      time1 int,                 time2 int,                 author text,                 content
text,                 PRIMARY KEY (blog_id, time1, time2)             ) ;
> cqlsh:foo> create index on blogs(author);
> cqlsh:foo> INSERT INTO blogs (blog_id, time1, time2, author, content) VALUES (1, 0,
0, 'foo', 'bar1');
> cqlsh:foo> INSERT INTO blogs (blog_id, time1, time2, author, content) VALUES (1, 0,
1, 'foo', 'bar2');
> cqlsh:foo> INSERT INTO blogs (blog_id, time1, time2, author, content) VALUES (2, 1,
0, 'foo', 'baz');
> cqlsh:foo> INSERT INTO blogs (blog_id, time1, time2, author, content) VALUES (3, 0,
1, 'gux', 'qux');
> cqlsh:foo> SELECT blog_id, content FROM blogs WHERE time1 = 1 AND author='foo';
> cqlsh:foo>
> {noformat}
> The expected result is:
> {noformat}
>  blog_id | time1 | time2 | author | content
> ---------+-------+-------+--------+---------
>        2 |     1 |     0 |    foo |     baz
> {noformat}

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

Mime
View raw message