cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "zhaoyan (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-9606) this query is not supported in new version
Date Wed, 17 Jun 2015 01:51:00 GMT

     [ 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)

Mime
View raw message