When the following database:
SET SQL DIALECT 3;
CREATE TABLE LOGGER (DET_TIME TIMESTAMP,
AC INTEGER);
SET TERM ^ ;
CREATE TRIGGER LOGGER
ACTIVE ON DISCONNECT POSITION 0
as declare variable c int; begin select count(*) from mon$attachments into :c; insert into logger values(current_timestamp, :c); end ^
SET TERM ; ^
COMMIT WORK;
having at least one additional attachment is shutdown SS hangs.
When the following database:
SET SQL DIALECT 3;
CREATE TABLE LOGGER (DET_TIME TIMESTAMP,
AC INTEGER);
SET TERM ^ ;
CREATE TRIGGER LOGGER
ACTIVE ON DISCONNECT POSITION 0
as declare variable c int; begin select count(*) from mon$attachments into :c; insert into logger values(current_timestamp, :c); end ^
SET TERM ; ^
COMMIT WORK;
having at least one additional attachment is shutdown SS hangs.