[ https://issues.apache.org/jira/browse/CASSANDRA-6748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sylvain Lebresne reassigned CASSANDRA-6748: ------------------------------------------- Assignee: Sylvain Lebresne > If null is explicitly set to a column, paging_state will not work > ----------------------------------------------------------------- > > Key: CASSANDRA-6748 > URL: https://issues.apache.org/jira/browse/CASSANDRA-6748 > Project: Cassandra > Issue Type: Bug > Environment: Cassandra 2.0.5 > Ubuntu 12.04 > Reporter: Katsutoshi Nagaoka > Assignee: Sylvain Lebresne > > If null is explicitly set to a column, paging_state will not work. My test > procedure is as follows: > ------ > Create a table and insert 10 records using cqlsh. The query is as follows: > {code} > CREATE TABLE mytable (id int, range int, value text, PRIMARY KEY (id, range)); > INSERT INTO mytable (id, range) VALUES (0, 0); > INSERT INTO mytable (id, range) VALUES (0, 1); > INSERT INTO mytable (id, range) VALUES (0, 2); > INSERT INTO mytable (id, range) VALUES (0, 3); > INSERT INTO mytable (id, range) VALUES (0, 4); > INSERT INTO mytable (id, range, value) VALUES (0, 5, null); > INSERT INTO mytable (id, range, value) VALUES (0, 6, null); > INSERT INTO mytable (id, range, value) VALUES (0, 7, null); > INSERT INTO mytable (id, range, value) VALUES (0, 8, null); > INSERT INTO mytable (id, range, value) VALUES (0, 9, null); > {code} > Select 10 records using datastax driver. The pseudocode is as follows: > {code} > Statement statement = QueryBuilder.select().from("mytable").setFetchSize(1); > ResultSet rs = session.execute(statement); > for(Row row : rs){ > System.out.println(String.format("id=%d, range=%d, value=%s", > row.getInt("id"), row.getInt("range"), row.getString("value"))); > } > {code} > The result is as follows: > {code} > id=0, range=0, value=null > id=0, range=1, value=null > id=0, range=2, value=null > id=0, range=3, value=null > id=0, range=4, value=null > id=0, range=5, value=null > id=0, range=7, value=null > id=0, range=9, value=null > {code} > ------ > Result is 8 records although 10 records were expected. I originally raised > this issue in the mailing lists: > http://www.mail-archive.com/user@cassandra.apache.org/msg34752.html -- This message was sent by Atlassian JIRA (v6.1.5#6160)