[ https://issues.apache.org/jira/browse/CASSANDRA-11208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15189049#comment-15189049 ]
Sylvain Lebresne commented on CASSANDRA-11208: ---------------------------------------------- +1 but can you fix the 2 following typos while committing: * "If the _the_ clustering..." * ".. in both cases there are _not_ data remaining" (that one is not new to the patch) > Paging is broken for IN queries > ------------------------------- > > Key: CASSANDRA-11208 > URL: https://issues.apache.org/jira/browse/CASSANDRA-11208 > Project: Cassandra > Issue Type: Bug > Components: CQL > Reporter: Benjamin Lerer > Assignee: Benjamin Lerer > Attachments: 11208-3.0.txt > > > If the number of selected row is greater than the page size, C* will return > some duplicates. > The problem can be reproduced with the java driver using 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 (rc int, pk int, PRIMARY KEY > (pk))"); > for (int i = 0; i < 5; i++) > session.execute("INSERT INTO test (pk, rc) VALUES (?, ?);", i, i); > ResultSet rs = session.execute(session.newSimpleStatement("SELECT * > FROM test WHERE pk IN (1, 2, 3)").setFetchSize(2)); > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)