insert into SIMONOV_UPDATE_CONFLICT (ID, PAYLOAD)
SELECT ID, 100 FROM SIMONOV_INSERT

35 записей было обновлено в таблице SIMONOV_UPDATE_CONFLICT

19 записей было добавлено в таблицу SIMONOV_UPDATE_CONFLICT

------ Информация о производительности ------
Время подготовки запроса = 0ms
Время выполнения запроса = 16ms
Current memory = 9 479 692
Max memory = 9 794 612
Memory buffers = 2 048
Reads from disk to cache = 0
Writes from cache to disk = 0
Чтений из кэша = 535

create or alter procedure SIMONOV_INSERT
returns (
    ID integer)
as
begin
  id = 1;
  while ( ID < 20 ) do
  begin
    suspend;
    id = id + 1;
  end
end

CREATE TABLE SIMONOV_UPDATE_CONFLICT (
    ID         INTEGER NOT NULL,
    PAYLOAD    INTEGER NOT NULL,
    AGGREGATE  INTEGER
);

ALTER TABLE SIMONOV_UPDATE_CONFLICT ADD CONSTRAINT PK_SIMONOV_UPDATE_CONFLICT PRIMARY KEY (ID);

SET TERM ^ ;

CREATE OR ALTER TRIGGER SIMONOV_UPDATE_CONFLICT_AI0 FOR SIMONOV_UPDATE_CONFLICT
ACTIVE AFTER INSERT POSITION 0
AS
begin
  update SIMONOV_UPDATE_CONFLICT
  set AGGREGATE = AGGREGATE + 1
  where (ID between NEW.ID-2 and NEW.ID+2) and (ID <> NEW.ID);
end
^

CREATE OR ALTER TRIGGER SIMONOV_UPDATE_CONFLICT_BI0 FOR SIMONOV_UPDATE_CONFLICT
ACTIVE BEFORE INSERT POSITION 0
AS
begin
  NEW.AGGREGATE = NEW.AGGREGATE + 1;
end
^

create or alter procedure SIMONOV_INSERT
returns (
    ID integer,
    V integer)
as
begin
  id = 1; V = 1;
  while ( V < 20 ) do
  begin
    suspend;
    V = V + 1;
    id = mod(V * 1111, 777);
  end
  suspend;
end^

SET TERM ; ^

CREATE TABLE SIMONOV_UPDATE_CONFLICT (
    ID         INTEGER NOT NULL,
    PAYLOAD    INTEGER NOT NULL,
    AGGREGATE  INTEGER DEFAULT 0 NOT NULL
);

ALTER TABLE SIMONOV_UPDATE_CONFLICT ADD CONSTRAINT PK_SIMONOV_UPDATE_CONFLICT PRIMARY KEY (ID);

SET TERM ^ ;

CREATE OR ALTER TRIGGER SIMONOV_UPDATE_CONFLICT_AI0 FOR SIMONOV_UPDATE_CONFLICT
ACTIVE AFTER INSERT POSITION 0
AS
begin
  update SIMONOV_UPDATE_CONFLICT
  set AGGREGATE = AGGREGATE + New.payload
  where (ID between NEW.ID-100 and NEW.ID+100) and (ID <> NEW.ID);
end
^

CREATE OR ALTER TRIGGER SIMONOV_UPDATE_CONFLICT_BI0 FOR SIMONOV_UPDATE_CONFLICT
ACTIVE BEFORE INSERT POSITION 0
AS
begin
  NEW.AGGREGATE = NEW.AGGREGATE + New.Payload;
end
^

insert into SIMONOV_UPDATE_CONFLICT (ID, PAYLOAD)
SELECT ID, V FROM SIMONOV_INSERT

22 записей было обновлено в таблице SIMONOV_UPDATE_CONFLICT

20 записей было добавлено в таблицу SIMONOV_UPDATE_CONFLICT

------ Информация о производительности ------
Время подготовки запроса = 0ms
Время выполнения запроса = 0ms
Current memory = 9 126 340
Max memory = 9 383 324
Memory buffers = 2 048
Reads from disk to cache = 0
Writes from cache to disk = 0
Чтений из кэша = 406

CREATE OR ALTER TRIGGER SIMONOV_UPDATE_CONFLICT_AI0 FOR SIMONOV_UPDATE_CONFLICT
ACTIVE AFTER INSERT OR UPDATE POSITION 0
AS
begin
  if (new.payload is distinct from old.payload) then
  begin
    update SIMONOV_UPDATE_CONFLICT
    set AGGREGATE = AGGREGATE + New.payload
    where (ID between NEW.ID-100 and NEW.ID+100) -- and (ID <> NEW.ID)
    ;
  end
end
^


/* Trigger: SIMONOV_UPDATE_CONFLICT_BI0 */
CREATE OR ALTER TRIGGER SIMONOV_UPDATE_CONFLICT_BI0 FOR SIMONOV_UPDATE_CONFLICT
ACTIVE BEFORE INSERT POSITION 0
AS
begin
  -- NEW.AGGREGATE = NEW.AGGREGATE + New.Payload;
end

42 записей было обновлено в таблице SIMONOV_UPDATE_CONFLICT

20 записей было добавлено в таблицу SIMONOV_UPDATE_CONFLICT

update SIMONOV_UPDATE_CONFLICT
set PAYLOAD = - payload
where mod(id / 10, 6) <= 2

43 записей было обновлено в таблице SIMONOV_UPDATE_CONFLICT