[IOTDB-5018] NPE when using uppercase function name in GROUP BY LEVEL

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: master branch
• Fix Version/s: master branch, 1.0.0
• Component/s: mpp-cluster
• Labels: pull-request-available
• Sprint: 2022-11-Cluster
• Assignee: Minghui Liu
• Reporter: Chao Wang
• Created: 22/Nov/22 07:46
• Updated: 23/Nov/22 06:17
• Resolved: 23/Nov/22 06:17

Description

INSERT INTO root.test.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (1, false, 3, 5, 6.8, 99.88, 'IoTDB');
INSERT INTO root.test.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2, false, 3, 5, 6.8, 99.88, 'IoTDB'),(10, true, 3, 5, 6.8, 99.88, 'IoTDB');
INSERT INTO root.test.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (11, false, 3, 5, 6.8, 99.88, 'IoTDB'),(20, false, 3, 5, 6.8, 99.88, 'IoTDB'),(12, true, 3, 5, 6.8, 99.88, 'IoTDB');
select COUNT(ts0), FIRST_VALUE(ts1), FIRST_VALUE(ts2) , LAST_VALUE(ts3) , MAX_TIME(ts4), MIN_TIME(ts5)  from root.test.wf01.wt01 group by level = 1,3

 

Msg: 500: [INTERNAL_SERVER_ERROR(500)] Exception occurred: "select COUNT(ts0)  from root.test.wf01.wt01 group by level = 1,3". executeStatement failed. null

Issue Links

• duplicates: IOTDB-4882 NPE appears when using uppercase count
• links to: GitHub Pull Request #8108