[IOTDB-6300] Support time column at any column in insert sql

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Core/Query
• Labels: pull-request-available
• Assignee: Yuan Tian
• Reporter: Yuan Tian
• Created: 23/Feb/24 08:24
• Updated: 28/Feb/24 00:38

Description

Now we only support time column at the first column of insert sql, like:

insert into root.db.d1(time,s1,s2) values(1,2,3); 

And we don't support `` to include the `time`, if we do so, we will get an error:

insert into root.db.d1(`time`,s1,s2) values(1,2,3);  

 

So we want to support the following two cases:

1. time column can be placed at any index of the column list:

insert into root.db.d1(s1,s2,time) values(1,2,3);  

2. we can add `` in time column:

insert into root.db.d1(`time`,s1,s2) values(1,2,3);  

Issue Links

• links to: GitHub Pull Request #12074