[IOTDB-2548] When according to yyyy.MM.dd HH:mm:ss to write data, an error is reported.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.13.0-SNAPSHOT
• Component/s: Client/CLI, Core/Server
• Labels: pull-request-available
• Sprint: 2022-2-Tian
• Assignee: Minghui Liu
• Reporter: xiaozhihong
• Created: 16/Feb/22 06:32
• Updated: 21/Feb/22 07:49
• Resolved: 17/Feb/22 11:05

Description

 

In the CLI, according to the supported time format mentioned in the userguide to insert data , an error will be reported when yyyy.MM.dd HH:mm:ss is encountered.

IoTDB> insert into root.ln.wf01.wt01(time,temperature) values(2022.02.10 10:12:10,12.12)
Msg: 401: Error occurred while parsing SQL to physical plan: line 1:66 extraneous input '10:12:10' expecting {NOW, '-', '+', '.', ',', '(', ')', STRING_LITERAL, DATETIME_LITERAL, INTEGER_LITERAL, EXPONENT_NUM_PART, BOOLEAN_LITERAL, NULL_LITERAL, NAN_LITERAL} 

If the time format of yyyy.MM.dd HH:mm:ss is not supported in V0.13, this part of the content needs to be removed in the userguide.

 

Issue Links

• links to: GitHub Pull Request #5071