You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "刘珍 (Jira)" <ji...@apache.org> on 2022/03/23 07:28:00 UTC
[jira] [Created] (IOTDB-2790) [Trigger] Insert existing timestamp data, trigger did not fire
刘珍 created IOTDB-2790:
-------------------------
Summary: [Trigger] Insert existing timestamp data, trigger did not fire
Key: IOTDB-2790
URL: https://issues.apache.org/jira/browse/IOTDB-2790
Project: Apache IoTDB
Issue Type: Bug
Components: Core/Server
Affects Versions: 0.13.0
Reporter: 刘珍
Assignee: Steve Yurong Su
Attachments: TriggerTest.jar, TriggerTest.java, image-2022-03-23-15-25-12-318.png
0.13.0 rc1
测试用例:
delete storage group root.**;
set storage group to root.sg1;
CREATE TIMESERIES root.sg1.dev1.s_1 WITH DATATYPE=INT32, ENCODING=GORILLA;
CREATE TIMESERIES root.sg1.dev1.s_2 WITH DATATYPE=INT64, ENCODING=PLAIN;
CREATE TIMESERIES root.sg1.dev1.s_3 WITH DATATYPE=float, ENCODING=RLE;
CREATE TIMESERIES root.sg1.dev1.s_4 WITH DATATYPE=double, ENCODING=TS_2DIFF;
CREATE TIMESERIES root.sg1.dev1.s_5 WITH DATATYPE=text, ENCODING=DICTIONARY;
CREATE TIMESERIES root.sg1.dev1.s_6 WITH DATATYPE=boolean, ENCODING=PLAIN;
CREATE TRIGGER trig1
AFTER INSERT
ON root.sg1.dev1.s_1
AS 'TriggerTest'
WITH (
'ts_type' = 'int32',
'remote_ip' = '127.0.0.1',
'trig_name'='trig1'
);
CREATE TRIGGER trig2
AFTER INSERT
ON root.sg1.dev1.s_2
AS 'TriggerTest'
WITH (
'ts_type' = 'int64',
'remote_ip' = '127.0.0.1',
'trig_name'='trig2'
);
insert into root.sg1.dev1(time,s_1,s_2) values(1,100,200),(2,300,400),(3,500,600),(4,700,800),(5,900,1000);
insert into root.sg1.dev1(time,s_1,s_2) values(11,1100,1200),(12,1300,1400),(13,1500,1600),(14,1700,1800),(15,1900,2000);
insert into root.sg1.dev1(time,s_1,s_2) values(111,11100,11200),(112,11300,11400),(113,11500,11600),(114,11700,11800),(115,11900,21000);
flush;
select s_1,s_2,s_3,s_4,s_5,s_6 from root.sg1.dev1;
select local_trig1,local_trig2,remotetrig1,remotetrig2 from root.target.alerting;
{color:#DE350B}*-- 4.7 相同时间戳 更新一下值(乱序)*{color}
insert into root.sg1.dev1(time,s_1,s_2) values(11,11300,12300),(12,13300,14300),(13,15300,16300),(14,17300,18300),(15,19300,23000);
flush;
select s_1,s_2,s_3,s_4,s_5,s_6 from root.sg1.dev1;
select local_trig1,local_trig2,remotetrig1,remotetrig2 from root.target.alerting;
触发器的数据没更新:
!image-2022-03-23-15-25-12-318.png!
--
This message was sent by Atlassian Jira
(v8.20.1#820001)