Yuan Tian created IOTDB-5553:
--------------------------------
Summary: Got NPE while using count_if and group by level
Key: IOTDB-5553
URL: https://issues.apache.org/jira/browse/IOTDB-5553
Project: Apache IoTDB
Issue Type: Bug
Components: Core/Query
Reporter: Yuan Tian
Assignee: 李伟豪
You can use the following sqls to reproduce:
insert into root.sg.d1(time,s1,s2,vehicle_status) aligned values(1,1,1,1);
insert into root.sg.d1(time,s1,s2,vehicle_status) aligned values(3,2,2,1);
insert into root.sg.d1(time,s1,s2,vehicle_status) aligned values(10,10,10,1);
insert into root.sg.d1(time,s1,s2) aligned values(11,10,10); insert into
root.sg.d1(time,s1,s2,vehicle_status) aligned values(12,12,12,0); insert into
root.sg.d1(time,s1,s2,vehicle_status) aligned values(30,12,12,0); insert into
root.sg.d1(time,s1,s2,vehicle_status) aligned values(35,12,12,0); insert into
root.sg.d1(time,s1,s2,vehicle_status) aligned values(36,12,12,1); insert into
root.sg.d1(time,s1,s2,vehicle_status) aligned values(40,12,12,1); insert into
root.sg.d1(time,s1,s2,vehicle_status) aligned values(41,12,12,0); insert into
root.sg.d1(time,s1,s2,vehicle_status) aligned values(1000000000,12,12,0);
insert into root.sg.d1(time,s1,s2,vehicle_status) aligned
values(1000000001,12,12,1); insert into root.sg.d1(time,s1,s2,vehicle_status)
aligned values(1000000009,12,12,1); insert into root.sg.d1(time,s1,s2) aligned
values(1000000010,12,12); insert into root.sg.d1(time,s1,s2,vehicle_status)
aligned values(1000000011,12,12,1); insert into
root.sg.d1(time,s1,s2,vehicle_status) aligned values(1000000012,12,12,1);
insert into root.sg.d2(time,s1,s2,vehicle_status) aligned values(1,1,1,1);
insert into root.sg.d2(time,s1,s2,vehicle_status) aligned values(3,2,2,1);
insert into root.sg.d2(time,s1,s2,vehicle_status) aligned values(10,10,10,1);
insert into root.sg.d2(time,s1,s2) aligned values(11,10,10); insert into
root.sg.d2(time,s1,s2,vehicle_status) aligned values(12,12,12,0); insert into
root.sg.d2(time,s1,s2,vehicle_status) aligned values(30,12,12,0); insert into
root.sg.d2(time,s1,s2,vehicle_status) aligned values(35,12,12,0); insert into
root.sg.d2(time,s1,s2,vehicle_status) aligned values(36,12,12,1); insert into
root.sg.d2(time,s1,s2,vehicle_status) aligned values(40,12,12,1); insert into
root.sg.d2(time,s1,s2,vehicle_status) aligned values(41,12,12,0); insert into
root.sg.d2(time,s1,s2,vehicle_status) aligned values(1000000000,12,12,0);
insert into root.sg.d2(time,s1,s2,vehicle_status) aligned
values(1000000001,12,12,1); insert into root.sg.d2(time,s1,s2,vehicle_status)
aligned values(1000000009,12,12,1); insert into root.sg.d2(time,s1,s2) aligned
values(1000000010,12,12); insert into root.sg.d2(time,s1,s2,vehicle_status)
aligned values(1000000011,12,12,1); insert into
root.sg.d2(time,s1,s2,vehicle_status) aligned values(1000000012,12,12,1);
insert into root.sg.d3(time,s1,s2,vehicle_status) aligned values(1,1,1,1);
insert into root.sg.d3(time,s1,s2,vehicle_status) aligned values(3,2,2,1);
insert into root.sg.d3(time,s1,s2,vehicle_status) aligned values(10,10,10,1);
insert into root.sg.d3(time,s1,s2) aligned values(11,10,10); insert into
root.sg.d3(time,s1,s2,vehicle_status) aligned values(12,12,12,0); insert into
root.sg.d3(time,s1,s2,vehicle_status) aligned values(30,12,12,0); insert into
root.sg.d3(time,s1,s2,vehicle_status) aligned values(35,12,12,0); insert into
root.sg.d3(time,s1,s2,vehicle_status) aligned values(36,12,12,1); insert into
root.sg.d3(time,s1,s2,vehicle_status) aligned values(40,12,12,1); insert into
root.sg.d3(time,s1,s2,vehicle_status) aligned values(41,12,12,0); insert into
root.sg.d3(time,s1,s2,vehicle_status) aligned values(1000000000,12,12,0);
insert into root.sg.d3(time,s1,s2,vehicle_status) aligned
values(1000000001,12,12,1); insert into root.sg.d3(time,s1,s2,vehicle_status)
aligned values(1000000009,12,12,1); insert into root.sg.d3(time,s1,s2) aligned
values(1000000010,12,12); insert into root.sg.d3(time,s1,s2,vehicle_status)
aligned values(1000000011,12,12,1); insert into
root.sg.d3(time,s1,s2,vehicle_status) aligned values(1000000012,12,12,1);
insert into root.sg.d4(time,s1,s2,vehicle_status) aligned values(1,1,1,1);
insert into root.sg.d4(time,s1,s2,vehicle_status) aligned values(3,2,2,1);
insert into root.sg.d4(time,s1,s2,vehicle_status) aligned values(10,10,10,1);
insert into root.sg.d4(time,s1,s2) aligned values(11,10,10); insert into
root.sg.d4(time,s1,s2,vehicle_status) aligned values(12,12,12,0); insert into
root.sg.d4(time,s1,s2,vehicle_status) aligned values(30,12,12,0); insert into
root.sg.d4(time,s1,s2,vehicle_status) aligned values(35,12,12,0); insert into
root.sg.d4(time,s1,s2,vehicle_status) aligned values(36,12,12,1); insert into
root.sg.d4(time,s1,s2,vehicle_status) aligned values(40,12,12,1); insert into
root.sg.d4(time,s1,s2,vehicle_status) aligned values(41,12,12,0); insert into
root.sg.d4(time,s1,s2,vehicle_status) aligned values(1000000000,12,12,0);
insert into root.sg.d4(time,s1,s2,vehicle_status) aligned
values(1000000001,12,12,1); insert into root.sg.d4(time,s1,s2,vehicle_status)
aligned values(1000000009,12,12,1); insert into root.sg.d4(time,s1,s2) aligned
values(1000000010,12,12); insert into root.sg.d4(time,s1,s2,vehicle_status)
aligned values(1000000011,12,12,1); insert into
root.sg.d4(time,s1,s2,vehicle_status) aligned values(1000000012,12,12,1);
insert into root.sg.d5(time,s1,s2,vehicle_status) aligned values(1,1,1,1);
insert into root.sg.d5(time,s1,s2,vehicle_status) aligned values(3,2,2,1);
insert into root.sg.d5(time,s1,s2,vehicle_status) aligned values(10,10,10,1);
insert into root.sg.d5(time,s1,s2) aligned values(11,10,10); insert into
root.sg.d5(time,s1,s2,vehicle_status) aligned values(12,12,12,0); insert into
root.sg.d5(time,s1,s2,vehicle_status) aligned values(30,12,12,0); insert into
root.sg.d5(time,s1,s2,vehicle_status) aligned values(35,12,12,0); insert into
root.sg.d5(time,s1,s2,vehicle_status) aligned values(36,12,12,1); insert into
root.sg.d5(time,s1,s2,vehicle_status) aligned values(40,12,12,1); insert into
root.sg.d5(time,s1,s2,vehicle_status) aligned values(41,12,12,0); insert into
root.sg.d5(time,s1,s2,vehicle_status) aligned values(1000000000,12,12,0);
insert into root.sg.d5(time,s1,s2,vehicle_status) aligned
values(1000000001,12,12,1); insert into root.sg.d5(time,s1,s2,vehicle_status)
aligned values(1000000009,12,12,1); insert into root.sg.d5(time,s1,s2) aligned
values(1000000010,12,12); insert into root.sg.d5(time,s1,s2,vehicle_status)
aligned values(1000000011,12,12,1); insert into
root.sg.d5(time,s1,s2,vehicle_status) aligned values(1000000012,12,12,1);
insert into root.sg.d6(time,s1,s2,vehicle_status) aligned values(1,1,1,1);
insert into root.sg.d6(time,s1,s2,vehicle_status) aligned values(3,2,2,1);
insert into root.sg.d6(time,s1,s2,vehicle_status) aligned values(10,10,10,1);
insert into root.sg.d6(time,s1,s2) aligned values(11,10,10); insert into
root.sg.d6(time,s1,s2,vehicle_status) aligned values(12,12,12,0); insert into
root.sg.d6(time,s1,s2,vehicle_status) aligned values(30,12,12,0); insert into
root.sg.d6(time,s1,s2,vehicle_status) aligned values(35,12,12,0); insert into
root.sg.d6(time,s1,s2,vehicle_status) aligned values(36,12,12,1); insert into
root.sg.d6(time,s1,s2,vehicle_status) aligned values(40,12,12,1); insert into
root.sg.d6(time,s1,s2,vehicle_status) aligned values(41,12,12,0); insert into
root.sg.d6(time,s1,s2,vehicle_status) aligned values(1000000000,12,12,0);
insert into root.sg.d6(time,s1,s2,vehicle_status) aligned
values(1000000001,12,12,1); insert into root.sg.d6(time,s1,s2,vehicle_status)
aligned values(1000000009,12,12,1); insert into root.sg.d6(time,s1,s2) aligned
values(1000000010,12,12); insert into root.sg.d6(time,s1,s2,vehicle_status)
aligned values(1000000011,12,12,1); insert into
root.sg.d6(time,s1,s2,vehicle_status) aligned values(1000000012,12,12,1);
insert into root.sg.d7(time,s1,s2,vehicle_status) aligned values(1,1,1,1);
insert into root.sg.d7(time,s1,s2,vehicle_status) aligned values(3,2,2,1);
insert into root.sg.d7(time,s1,s2,vehicle_status) aligned values(10,10,10,1);
insert into root.sg.d7(time,s1,s2) aligned values(11,10,10); insert into
root.sg.d7(time,s1,s2,vehicle_status) aligned values(12,12,12,0); insert into
root.sg.d7(time,s1,s2,vehicle_status) aligned values(30,12,12,0); insert into
root.sg.d7(time,s1,s2,vehicle_status) aligned values(35,12,12,0); insert into
root.sg.d7(time,s1,s2,vehicle_status) aligned values(36,12,12,1); insert into
root.sg.d7(time,s1,s2,vehicle_status) aligned values(40,12,12,1); insert into
root.sg.d7(time,s1,s2,vehicle_status) aligned values(41,12,12,0); insert into
root.sg.d7(time,s1,s2,vehicle_status) aligned values(1000000000,12,12,0);
insert into root.sg.d7(time,s1,s2,vehicle_status) aligned
values(1000000001,12,12,1); insert into root.sg.d7(time,s1,s2,vehicle_status)
aligned values(1000000009,12,12,1); insert into root.sg.d7(time,s1,s2) aligned
values(1000000010,12,12); insert into root.sg.d7(time,s1,s2,vehicle_status)
aligned values(1000000011,12,12,1); insert into
root.sg.d7(time,s1,s2,vehicle_status) aligned values(1000000012,12,12,1);
insert into root.sg.d8(time,s1,s2,vehicle_status) aligned values(1,1,1,1);
insert into root.sg.d8(time,s1,s2,vehicle_status) aligned values(3,2,2,1);
insert into root.sg.d8(time,s1,s2,vehicle_status) aligned values(10,10,10,1);
insert into root.sg.d8(time,s1,s2) aligned values(11,10,10); insert into
root.sg.d8(time,s1,s2,vehicle_status) aligned values(12,12,12,0); insert into
root.sg.d8(time,s1,s2,vehicle_status) aligned values(30,12,12,0); insert into
root.sg.d8(time,s1,s2,vehicle_status) aligned values(35,12,12,0); insert into
root.sg.d8(time,s1,s2,vehicle_status) aligned values(36,12,12,1); insert into
root.sg.d8(time,s1,s2,vehicle_status) aligned values(40,12,12,1); insert into
root.sg.d8(time,s1,s2,vehicle_status) aligned values(41,12,12,0); insert into
root.sg.d8(time,s1,s2,vehicle_status) aligned values(1000000000,12,12,0);
insert into root.sg.d8(time,s1,s2,vehicle_status) aligned
values(1000000001,12,12,1); insert into root.sg.d8(time,s1,s2,vehicle_status)
aligned values(1000000009,12,12,1); insert into root.sg.d8(time,s1,s2) aligned
values(1000000010,12,12); insert into root.sg.d8(time,s1,s2,vehicle_status)
aligned values(1000000011,12,12,1); insert into
root.sg.d8(time,s1,s2,vehicle_status) aligned values(1000000012,12,12,1);
insert into root.sg.d9(time,s1,s2,vehicle_status) aligned values(1,1,1,1);
insert into root.sg.d9(time,s1,s2,vehicle_status) aligned values(3,2,2,1);
insert into root.sg.d9(time,s1,s2,vehicle_status) aligned values(10,10,10,1);
insert into root.sg.d9(time,s1,s2) aligned values(11,10,10); insert into
root.sg.d9(time,s1,s2,vehicle_status) aligned values(12,12,12,0); insert into
root.sg.d9(time,s1,s2,vehicle_status) aligned values(30,12,12,0); insert into
root.sg.d9(time,s1,s2,vehicle_status) aligned values(35,12,12,0); insert into
root.sg.d9(time,s1,s2,vehicle_status) aligned values(36,12,12,1); insert into
root.sg.d9(time,s1,s2,vehicle_status) aligned values(40,12,12,1); insert into
root.sg.d9(time,s1,s2,vehicle_status) aligned values(41,12,12,0); insert into
root.sg.d9(time,s1,s2,vehicle_status) aligned values(1000000000,12,12,0);
insert into root.sg.d9(time,s1,s2,vehicle_status) aligned
values(1000000001,12,12,1); insert into root.sg.d9(time,s1,s2,vehicle_status)
aligned values(1000000009,12,12,1); insert into root.sg.d9(time,s1,s2) aligned
values(1000000010,12,12); insert into root.sg.d9(time,s1,s2,vehicle_status)
aligned values(1000000011,12,12,1); insert into
root.sg.d9(time,s1,s2,vehicle_status) aligned values(1000000012,12,12,1);
insert into root.sg.d0(time,s1,s2,vehicle_status) aligned values(1,1,1,1);
insert into root.sg.d0(time,s1,s2,vehicle_status) aligned values(3,2,2,1);
insert into root.sg.d0(time,s1,s2,vehicle_status) aligned values(10,10,10,1);
insert into root.sg.d0(time,s1,s2) aligned values(11,10,10); insert into
root.sg.d0(time,s1,s2,vehicle_status) aligned values(12,12,12,0); insert into
root.sg.d0(time,s1,s2,vehicle_status) aligned values(30,12,12,0); insert into
root.sg.d0(time,s1,s2,vehicle_status) aligned values(35,12,12,0); insert into
root.sg.d0(time,s1,s2,vehicle_status) aligned values(36,12,12,1); insert into
root.sg.d0(time,s1,s2,vehicle_status) aligned values(40,12,12,1); insert into
root.sg.d0(time,s1,s2,vehicle_status) aligned values(41,12,12,0); insert into
root.sg.d0(time,s1,s2,vehicle_status) aligned values(1000000000,12,12,0);
insert into root.sg.d0(time,s1,s2,vehicle_status) aligned
values(1000000001,12,12,1); insert into root.sg.d0(time,s1,s2,vehicle_status)
aligned values(1000000009,12,12,1); insert into root.sg.d0(time,s1,s2) aligned
values(1000000010,12,12); insert into root.sg.d0(time,s1,s2,vehicle_status)
aligned values(1000000011,12,12,1); insert into
root.sg.d0(time,s1,s2,vehicle_status) aligned values(1000000012,12,12,1);
insert into root.sg.d321(time,s1,s2,vehicle_status) aligned values(1,1,1,1);
insert into root.sg.d321(time,s1,s2,vehicle_status) aligned values(3,2,2,1);
insert into root.sg.d321(time,s1,s2,vehicle_status) aligned values(10,10,10,1);
insert into root.sg.d321(time,s1,s2) aligned values(11,10,10); insert into
root.sg.d321(time,s1,s2,vehicle_status) aligned values(12,12,12,0); insert into
root.sg.d321(time,s1,s2,vehicle_status) aligned values(30,12,12,0); insert into
root.sg.d321(time,s1,s2,vehicle_status) aligned values(35,12,12,0); insert into
root.sg.d321(time,s1,s2,vehicle_status) aligned values(36,12,12,1); insert into
root.sg.d321(time,s1,s2,vehicle_status) aligned values(40,12,12,1); insert into
root.sg.d321(time,s1,s2,vehicle_status) aligned values(41,12,12,0); insert into
root.sg.d321(time,s1,s2,vehicle_status) aligned values(1000000000,12,12,0);
insert into root.sg.d321(time,s1,s2,vehicle_status) aligned
values(1000000001,12,12,1); insert into root.sg.d321(time,s1,s2,vehicle_status)
aligned values(1000000009,12,12,1); insert into root.sg.d321(time,s1,s2)
aligned values(1000000010,12,12); insert into
root.sg.d321(time,s1,s2,vehicle_status) aligned values(1000000011,12,12,1);
insert into root.sg.d321(time,s1,s2,vehicle_status) aligned
values(1000000012,12,12,1);
select count_if(vehicle_status = 1, KEEP >= 2, 'ignoreNull'='false') as
abnormal_value from [root.sg|http://root.sg/].** group by([1, 42), 10ms),
level=1
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
