[jira] [Commented] (CASSANDRA-11863) dtest failure in upgrade_tests.cql_tests.TestCQLNodes3RF3_Upgrade_current_2_0_x_To_indev_2_1_x.static_columns_with_distinct_test

["Sean McCarthy (JIRA)" <ji...@apache.org>]

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

Sean McCarthy commented on CASSANDRA-11863:
-------------------------------------------

The test sets up this table:

{code}
CREATE TABLE test (
                k int,
                p int,
                s int static,
                PRIMARY KEY (k, p)
            )

cursor.execute("INSERT INTO test (k, p) VALUES (1, 1)")
cursor.execute("INSERT INTO test (k, p) VALUES (1, 2)")
{code}

Then this query works on the 2.1 node but not the 2.0 node:

{code}
assert_one(cursor, "SELECT DISTINCT k, s FROM test", [1, None])
{code}

On the 2.0 node it returns all of the rows in the table, not just the distinct ones. [~slebresne], should we just restrict this to run on 2.1+?

> dtest failure in upgrade_tests.cql_tests.TestCQLNodes3RF3_Upgrade_current_2_0_x_To_indev_2_1_x.static_columns_with_distinct_test
> --------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-11863
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11863
>             Project: Cassandra
>          Issue Type: Test
>            Reporter: Philip Thompson
>            Assignee: Sean McCarthy
>              Labels: dtest
>
> {{Expected [[1, None]] from SELECT DISTINCT k, s FROM test, but got [[1, None], [1, None]]}}
> example failure:
> http://cassci.datastax.com/job/upgrade_tests-all/46/testReport/upgrade_tests.cql_tests/TestCQLNodes3RF3_Upgrade_current_2_0_x_To_indev_2_1_x/static_columns_with_distinct_test
> Failed on CassCI build upgrade_tests-all #46
> This might actually be a bug, but needs looked at first.



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