You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@iotdb.apache.org by Tian Jiang <jt...@163.com> on 2020/10/30 03:10:37 UTC

Please take a look at SLIMIT and SOFFSET


Greetings,


Recently, when I was using queries with SLIMIT and SOFFSET clauses, I found something was not so graceful, even wrong maybe.
```
IoTDB> select count(*) from root.group_0.d_0 slimit 10 soffset 10
Msg: 500: toIndex = 20
IoTDB> select count(*) from root.group_0aaaa slimit 10 soffset 10
Msg: 411: Meet error in query process: SOFFSET <SOFFSETValue>: SOFFSETValue exceeds the range.
```
If you are interested, please refer to [1] for more details.


[1] https://issues.apache.org/jira/browse/IOTDB-971


Best,
Tian Jiang

Re: Please take a look at SLIMIT and SOFFSET

Posted by Steve Su <st...@qq.com>.

Hi Tian,

I've submitted a PR for this. Please have a look.

Best,
Steve Su 

------------------ 原始邮件 ------------------
发件人: "Steve Su" <st...@qq.com>;
发送时间: 2020年10月30日(星期五) 中午11:40
收件人: "dev"<de...@iotdb.apache.org>;
主题: Re: Please take a look at SLIMIT and SOFFSET

Hi Tian,

Thanks for reporting this. 

@Yuan Tian and I recently modified the code associated with SLIMIT and SOFFSET in PR#1367 and PR#1884. The issue you reported may have been caused by our code.

I will take a look. 

Best,
Steve

------------------ 原始邮件 ------------------
发件人: "dev" <jt...@163.com>;
发送时间: 2020年10月30日(星期五) 中午11:10
收件人: "dev"<de...@iotdb.apache.org>;
主题: Please take a look at SLIMIT and SOFFSET


Greetings,


Recently, when I was using queries with SLIMIT and SOFFSET clauses, I found something was not so graceful, even wrong maybe.
```
IoTDB> select count(*) from root.group_0.d_0 slimit 10 soffset 10
Msg: 500: toIndex = 20
IoTDB> select count(*) from root.group_0aaaa slimit 10 soffset 10
Msg: 411: Meet error in query process: SOFFSET <SOFFSETValue>: SOFFSETValue exceeds the range.
```
If you are interested, please refer to [1] for more details.


[1] https://issues.apache.org/jira/browse/IOTDB-971


Best,
Tian Jiang

Re: Please take a look at SLIMIT and SOFFSET

Posted by Steve Su <st...@qq.com>.

Hi Tian,

Thanks for reporting this. 

@Yuan Tian and I recently modified the code associated with SLIMIT and SOFFSET in PR#1367 and PR#1884. The issue you reported may have been caused by our code.

I will take a look. 

Best,
Steve

------------------ 原始邮件 ------------------
发件人: "dev" <jt...@163.com>;
发送时间: 2020年10月30日(星期五) 中午11:10
收件人: "dev"<de...@iotdb.apache.org>;
主题: Please take a look at SLIMIT and SOFFSET


Greetings,


Recently, when I was using queries with SLIMIT and SOFFSET clauses, I found something was not so graceful, even wrong maybe.
```
IoTDB> select count(*) from root.group_0.d_0 slimit 10 soffset 10
Msg: 500: toIndex = 20
IoTDB> select count(*) from root.group_0aaaa slimit 10 soffset 10
Msg: 411: Meet error in query process: SOFFSET <SOFFSETValue>: SOFFSETValue exceeds the range.
```
If you are interested, please refer to [1] for more details.


[1] https://issues.apache.org/jira/browse/IOTDB-971


Best,
Tian Jiang