[ https://issues.apache.org/jira/browse/CASSANDRA-13017?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tyler Hobbs updated CASSANDRA-13017: ------------------------------------ Status: Ready to Commit (was: Patch Available) > DISTINCT queries on partition keys and static column might not return all the > results > ------------------------------------------------------------------------------------- > > Key: CASSANDRA-13017 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13017 > Project: Cassandra > Issue Type: Bug > Components: CQL > Reporter: Benjamin Lerer > Assignee: Benjamin Lerer > Fix For: 2.1.x, 2.2.x > > > In {{2.1}} and {{2.2}}, a {{DISTINCT}} query on partition keys and static > columns might not return all the data if some rows have no data and the > static columns have also no values. > The problem can be reproduced using the Java driver with the following code: > {code} > session = cluster.connect(); > session.execute("CREATE KEYSPACE IF NOT EXISTS test WITH REPLICATION > = {'class' : 'SimpleStrategy', 'replication_factor' : '1'}"); > session.execute("USE test"); > session.execute("DROP TABLE IF EXISTS test"); > session.execute("CREATE TABLE test (pk int, c int, v int, s int > static, primary key(pk, c))"); > PreparedStatement prepare = session.prepare("INSERT INTO test (pk, c, > v, s) VALUES (?, ?, ?, ?)"); > for (int i = 0; i < 10; i++) > for (int j = 0; j < 1; j++) > session.execute(prepare.bind(i, j, null, null)); > for (Row row : session.execute(new SimpleStatement("SELECT DISTINCT > token(pk), pk, s FROM test").setFetchSize(2))) > { > System.out.println(row); > } > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)