[jira] [Created] (IOTDB-971) More precise error messages of slimit and soffset

["Tian Jiang (Jira)" <ji...@apache.org>]

Tian Jiang created IOTDB-971:
--------------------------------

             Summary: 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


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)