cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Benjamin Lerer (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-8275) Some queries with multicolumn relation do not behave properly when secondary index is used
Date Fri, 07 Nov 2014 09:44:34 GMT
Benjamin Lerer created CASSANDRA-8275:
-----------------------------------------

             Summary: Some queries with multicolumn relation do not behave properly when secondary
index is used
                 Key: CASSANDRA-8275
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8275
             Project: Cassandra
          Issue Type: Bug
            Reporter: Benjamin Lerer


In the case where we perform a select using a multicolumn relation over multiple columns that
use a secondary index the error message returned is wrong.

The following unit test can be use to reproduce the problem:

{code}
    @Test
    public void testMultipleClusteringWithIndex() throws Throwable
    {
        createTable("CREATE TABLE %s (a int, b int, c int, d int, PRIMARY KEY (a, b, c, d))");
        createIndex("CREATE INDEX ON %s (b)"); 
        
        execute("INSERT INTO %s (a, b, c, d) VALUES (?, ?, ?, ?)", 0, 0, 0, 0);
        execute("INSERT INTO %s (a, b, c, d) VALUES (?, ?, ?, ?)", 0, 0, 1, 0);
        execute("INSERT INTO %s (a, b, c, d) VALUES (?, ?, ?, ?)", 0, 0, 1, 1);

        execute("INSERT INTO %s (a, b, c, d) VALUES (?, ?, ?, ?)", 0, 1, 0, 0);
        execute("INSERT INTO %s (a, b, c, d) VALUES (?, ?, ?, ?)", 0, 1, 1, 0);
        execute("INSERT INTO %s (a, b, c, d) VALUES (?, ?, ?, ?)", 0, 1, 1, 1);

        assertRows(execute("SELECT * FROM %s WHERE (b) = (?)", 1),
                   row(0, 1, 0, 0),
                   row(0, 1, 1, 0),
                   row(0, 1, 1, 1)
               );
        
        assertRows(execute("SELECT * FROM %s WHERE (b, c) = (?, ?) ALLOW FILTERING", 1, 1),
                   row(0, 1, 1, 0),
                   row(0, 1, 1, 1)
               );
    }
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message