Hi Tian,

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

Best,
Steve Su 

------------------ ???????? ------------------
??????: "Steve Su" <steveyuron...@qq.com>;
????????: 2020??10??30??(??????) ????11:40
??????: "dev"<dev@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" <jt2594...@163.com>;
????????: 2020??10??30??(??????) ????11:10
??????: "dev"<dev@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

Reply via email to