[IOTDB-971] More precise error messages of slimit and soffset

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.11.0
• Component/s: Planner/SQLOptimizer
• Labels: print pull-request-available slimit soffset
• Assignee: Unassigned
• Reporter: Tian Jiang
• Created: 30/Oct/20 03:05
• Updated: 03/Nov/20 14:13
• Resolved: 03/Nov/20 06:39

Description

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
```

Issue Links

• links to: Github PR #1913
• links to: GitHub Pull Request #1913