xiaozhihong created IOTDB-5890: ---------------------------------- Summary: The exception messages for order by queries need to be optimised Key: IOTDB-5890 URL: https://issues.apache.org/jira/browse/IOTDB-5890 Project: Apache IoTDB Issue Type: Bug Components: Core/Query Affects Versions: master branch Reporter: xiaozhihong Assignee: yang caiyin
Branch : MasterĀ commit ab43262e3974574334ca7ff131e8d11e7f5da69f Question1 : When executing aggregation and raw order by queries, the msg returned need to be optimised and the current message is unclear. {code:java} IoTDB> select s3,s4 from root.sg.d1 order by mode(s1) desc; Msg: 301: ComparatorChains must contain at least one Comparator IoTDB> select sum(s1),max_value(s1) from root.sg.d1 order by s6 desc align by device; Msg: 701: Raw data and aggregation hybrid query is not supported. {code} Question2 : The prompt message has an internal error message when executing last query. {code:java} IoTDB> select last * from root.sg.d1 order by s1 desc; Msg: 305: [INTERNAL_SERVER_ERROR(305)] Exception occurred: "select last * from root.sg.d1 order by s1 desc". executeStatement failed. Last queries only support sorting by timeseries now. {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)