You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "zhaoyan (JIRA)" <ji...@apache.org> on 2015/06/17 03:49:00 UTC
[jira] [Created] (CASSANDRA-9606) this query is not supported in
new version
zhaoyan created CASSANDRA-9606:
----------------------------------
Summary: 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:
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)