[
https://issues.apache.org/jira/browse/IOTDB-971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17225167#comment-17225167
]
Jialin Qiao commented on IOTDB-971:
-----------------------------------
https://github.com/apache/iotdb/pull/1913
> More precise error messages of slimit and soffset
> -------------------------------------------------
>
> Key: IOTDB-971
> URL: https://issues.apache.org/jira/browse/IOTDB-971
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Planner/SQLOptimizer
> Reporter: Tian Jiang
> Priority: Minor
> Labels: print, slimit, soffset
>
> When using slimit/soffset with improper parameters, the error messages are
> confusing. For example:
> ```
> 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.
> ```
> The result from the first example makes little sense to users, and I think
> it is probably not right even, since there are 100 measurements for each
> device.
> The second result is also confusing, "root.group_0aaaa" does not exist and
> that should be the root cause.
> The schemas are generated by IoTDB-benchmark with the following configurtions:
> ```
> #存储组数，必须小于等于设备数
> GROUP_NUMBER=3
> #总设备数
> DEVICE_NUMBER=10
> #每个设备的传感器数，总时间序列条数=DEVICE_NUMBER*SENSOR_NUMBER
> SENSOR_NUMBER=100
> ```
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
