Pavel Eremeev created CASSANDRA-6956: ----------------------------------------
Summary: SELECT ... LIMIT offset by 1 with static columns Key: CASSANDRA-6956 URL: https://issues.apache.org/jira/browse/CASSANDRA-6956 Project: Cassandra Issue Type: Bug Environment: cqlsh 4.1.1 | Cassandra 2.0.6 | CQL spec 3.1.1 Reporter: Pavel Eremeev First, repro case: {code} cqlsh:test> create table test ( pk1 text, pk2 timeuuid, data1 text static, data2 text, PRIMARY KEY( pk1, pk2 ) ); cqlsh:test> update test set data1 = 'data1', data2 = 'data2' where pk1 = 'pk1' and pk2 = now(); cqlsh:test> update test set data1 = 'data1', data2 = 'data2' where pk1 = 'pk1' and pk2 = now(); cqlsh:test> select * from test limit 1; pk1 | pk2 | data1 | data2 -----+------+-------+------- pk1 | null | data1 | null (1 rows) cqlsh:test> select * from test limit 2; pk1 | pk2 | data1 | data2 -----+--------------------------------------+-------+------- pk1 | 9b068ee0-b8b0-11e3-a345-49baa9ac32e6 | data1 | data2 (1 rows) cqlsh:test> select * from test limit 3; pk1 | pk2 | data1 | data2 -----+--------------------------------------+-------+------- pk1 | 9b068ee0-b8b0-11e3-a345-49baa9ac32e6 | data1 | data2 pk1 | 0af67a40-b8ba-11e3-a345-49baa9ac32e6 | data1 | data2 (2 rows) {code} I think that: 1) if this is a static columns feature it should be documented so I can use it safely or 2) it should be fixed (return 2 rows with limit 2 for query above). -- This message was sent by Atlassian JIRA (v6.2#6252)