[ https://issues.apache.org/jira/browse/CASSANDRA-9606?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
zhaoyan updated CASSANDRA-9606: ------------------------------- Description: Background: 1、create a table: {code} CREATE TABLE test ( a int, b int, c int, d int, PRIMARY KEY (a, b, c) ); {code} 2、query by a=1 and b<3 {code} select * from test where a=1 and b<6; a | b | c | d ---+---+---+--- 1 | 3 | 1 | 2 1 | 3 | 2 | 2 1 | 3 | 4 | 2 1 | 3 | 5 | 2 1 | 4 | 4 | 2 1 | 5 | 5 | 2 (6 rows) {code} 3、query by page first page: {code} select * from test where a=1 and b<6 limit 2; a | b | c | d ---+---+---+--- 1 | 3 | 1 | 2 1 | 3 | 2 | 2 (2 rows) {code} fsecond page: {code} select * from test where a=1 and b<6 and (b,c) > (3,2) limit 2; a | b | c | d ---+---+---+--- 1 | 3 | 4 | 2 1 | 3 | 5 | 2 (2 rows) last page: {code} select * from test where a=1 and b<6 and (b,c) > (3,5) limit 2; a | b | c | d ---+---+---+--- 1 | 4 | 4 | 2 1 | 5 | 5 | 2 (2 rows) {code} question: this query by page is ok when cassandra 2.0.8. but is not supported in the latest version 2.1.6 when execute: {code} select * from test where a=1 and b<6 and (b,c) > (3,2) limit 2; {code} get one error message: InvalidRequest: code=2200 [Invalid query] message="Column "b" cannot have both tuple-notation inequalities and single-column inequalities: (b, c) > (3, 2)" was: Background: 1、create a table: {code} CREATE TABLE test ( a int, b int, c int, d int, PRIMARY KEY (a, b, c) ); {code} 2、query by a=1 and b<3 {code} select * from test where a=1 and b<6; a | b | c | d ---+---+---+--- 1 | 3 | 1 | 2 1 | 3 | 2 | 2 1 | 3 | 4 | 2 1 | 3 | 5 | 2 1 | 4 | 4 | 2 1 | 5 | 5 | 2 (6 rows) {code} 3、query by page first page: {code} select * from test where a=1 and b<6 limit 2; a | b | c | d ---+---+---+--- 1 | 3 | 1 | 2 1 | 3 | 2 | 2 (2 rows) {code} fsecond page: select * from test where a=1 and b<6 and (b,c) > (3,2) limit 2; a | b | c | d ---+---+---+--- 1 | 3 | 4 | 2 1 | 3 | 5 | 2 (2 rows) last page: {code} select * from test where a=1 and b<6 and (b,c) > (3,5) limit 2; a | b | c | d ---+---+---+--- 1 | 4 | 4 | 2 1 | 5 | 5 | 2 (2 rows) {code} question: this query by page is ok when cassandra 2.0.8. but is not supported in the latest version 2.1.6 when execute: {code} select * from test where a=1 and b<6 and (b,c) > (3,2) limit 2; {code} get one error message: InvalidRequest: code=2200 [Invalid query] message="Column "b" cannot have both tuple-notation inequalities and single-column inequalities: (b, c) > (3, 2)" > this query is not supported in new version > ------------------------------------------ > > Key: CASSANDRA-9606 > URL: https://issues.apache.org/jira/browse/CASSANDRA-9606 > Project: Cassandra > Issue Type: Bug > Components: Core > Environment: cassandra 2.1.6 > jdk 1.7.0_55 > Reporter: zhaoyan > > Background: > 1、create a table: > {code} > CREATE TABLE test ( > a int, > b int, > c int, > d int, > PRIMARY KEY (a, b, c) > ); > {code} > 2、query by a=1 and b<3 > {code} > select * from test where a=1 and b<6; > a | b | c | d > ---+---+---+--- > 1 | 3 | 1 | 2 > 1 | 3 | 2 | 2 > 1 | 3 | 4 | 2 > 1 | 3 | 5 | 2 > 1 | 4 | 4 | 2 > 1 | 5 | 5 | 2 > (6 rows) > {code} > 3、query by page > first page: > {code} > select * from test where a=1 and b<6 limit 2; > a | b | c | d > ---+---+---+--- > 1 | 3 | 1 | 2 > 1 | 3 | 2 | 2 > (2 rows) > {code} > fsecond page: > {code} > select * from test where a=1 and b<6 and (b,c) > (3,2) limit 2; > a | b | c | d > ---+---+---+--- > 1 | 3 | 4 | 2 > 1 | 3 | 5 | 2 > (2 rows) > last page: > {code} > select * from test where a=1 and b<6 and (b,c) > (3,5) limit 2; > a | b | c | d > ---+---+---+--- > 1 | 4 | 4 | 2 > 1 | 5 | 5 | 2 > (2 rows) > {code} > question: > this query by page is ok when cassandra 2.0.8. > but is not supported in the latest version 2.1.6 > when execute: > {code} > select * from test where a=1 and b<6 and (b,c) > (3,2) limit 2; > {code} > get one error message: > InvalidRequest: code=2200 [Invalid query] message="Column "b" cannot have > both tuple-notation inequalities and single-column inequalities: (b, c) > (3, > 2)" -- This message was sent by Atlassian JIRA (v6.3.4#6332)