CREATE OR REPLACE TRIGGER FORM.AFTER_UPDATE
  AFTER UPDATE
  ON SCHEMA.TABLE
  REFERENCING 
    NEW AS new_
    OLD AS old_
  FOR EACH ROW
  BEGIN ATOMIC
    
    DECLARE OLD_START_DATE_AFTER DATE;
    DECLARE OLD_START_DATE_BEFORE DATE;

    
    IF (new_.START_DATE is not null) and (old_.start_date is null)
    THEN
    
      SET OLD_START_DATE_AFTER = (select coalesce(min(t.start_date), '01.01.2999') 
          FROM SCHEMA.TABLE t 
          WHERE t.id = new_.id and t.START_DATE > new_.start_date);
          
          
      SET OLD_START_DATE_BEFORE = (select coalesce(max(t.start_date), '01.01.2999') 
          FROM SCHEMA.TABLEt 
          WHERE t.id = new_.id and t.START_DATE < new_.start_date);
      
      IF (OLD_START_DATE_AFTER > new_.start_date) and (OLD_START_DATE_AFTER <> '01.01.2999') THEN
      
        UPDATE SCHEMA.TABLE t SET t.END_DATE = OLD_START_DATE_AFTER- 1  day
          WHERE t.ID = new_.id and t.START_DATE = new_.start_date;
          
      END IF;
      
      IF (OLD_START_DATE_BEFORE <> '01.01.2999')THEN
      
        UPDATE SCHEMA.TABLE t SET t.END_DATE = new_.START_DATE - 1  day
          WHERE t.ID = new_.id and t.START_DATE = OLD_START_DATE_BEFORE;
          
      END IF;
      
    END IF;
    
  END;

CREATE OR REPLACE TRIGGER FORM.AFTER_UPDATE
  AFTER UPDATE START_DATE
  ON SCHEMA.TABLE
  REFERENCING 
    NEW AS new_
    OLD AS old_
  FOR EACH ROW
  BEGIN ATOMIC