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)