Check firebird.log [no messages found for interval when this test was running]
Jump to: output_first_mismatch    outcomes_full_history    elapsed_time_chart
Show cross-report outcomes.

Annotation type Annotation details
2 @message
assert   
    MON$SEC_DATABASE Self
  + Statement failed, SQLSTATE = 42000
  + unsuccessful metadata update
  + -CREATE MAPPING MG_EXISTENT failed
  + -CREATE MAPPING MG_EXISTENT failed
  + -Dynamic SQL Error
  + -SQL error code = -504
  + -CHARACTER SET "UTF8" is not defined
    ID 1
    DDL_TRIGGER_NAME DROP_MAPPING_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE MAPPING
    DDL_EVENT DROP MAPPING
    OBJECT_NAME MP_EXISTENT
    ID 2
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE MAPPING
    DDL_EVENT DROP MAPPING
    OBJECT_NAME MP_EXISTENT
    ID 3
    DDL_TRIGGER_NAME DROP_MAPPING_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE MAPPING
    DDL_EVENT DROP MAPPING
    OBJECT_NAME MP_EXISTENT
    ID 4
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE MAPPING
    DDL_EVENT DROP MAPPING
    OBJECT_NAME MP_EXISTENT
    ID 5
  - DDL_TRIGGER_NAME DROP_MAPPING_BEFORE
  + DDL_TRIGGER_NAME DROP_USER_BEFORE
    EVENT_TYPE DROP
  - OBJECT_TYPE MAPPING
  - DDL_EVENT DROP MAPPING
  + OBJECT_TYPE USER
  + DDL_EVENT DROP USER
  - OBJECT_NAME MG_EXISTENT
  + OBJECT_NAME U_EXISTENT
    ID 6
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
    EVENT_TYPE DROP
  - OBJECT_TYPE MAPPING
  - DDL_EVENT DROP MAPPING
  + OBJECT_TYPE USER
  + DDL_EVENT DROP USER
  - OBJECT_NAME MG_EXISTENT
  + OBJECT_NAME U_EXISTENT
    ID 7
  - DDL_TRIGGER_NAME DROP_MAPPING_AFTER
  + DDL_TRIGGER_NAME DROP_USER_AFTER
    EVENT_TYPE DROP
  - OBJECT_TYPE MAPPING
  - DDL_EVENT DROP MAPPING
  + OBJECT_TYPE USER
  + DDL_EVENT DROP USER
  - OBJECT_NAME MG_EXISTENT
  + OBJECT_NAME U_EXISTENT
    ID 8
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
    EVENT_TYPE DROP
  - OBJECT_TYPE MAPPING
  - DDL_EVENT DROP MAPPING
  + OBJECT_TYPE USER
  + DDL_EVENT DROP USER
  - OBJECT_NAME MG_EXISTENT
  + OBJECT_NAME U_EXISTENT
    ID 9
    DDL_TRIGGER_NAME DROP_USER_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE USER
    DDL_EVENT DROP USER
  - OBJECT_NAME U_EXISTENT
  + OBJECT_NAME U_NON_EXISTENT
    ID 10
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE USER
    DDL_EVENT DROP USER
  - OBJECT_NAME U_EXISTENT
  + OBJECT_NAME U_NON_EXISTENT
    ID 11
    DDL_TRIGGER_NAME DROP_USER_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE USER
    DDL_EVENT DROP USER
  - OBJECT_NAME U_EXISTENT
  + OBJECT_NAME U_NON_EXISTENT
    ID 12
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE USER
    DDL_EVENT DROP USER
  - OBJECT_NAME U_EXISTENT
  + OBJECT_NAME U_NON_EXISTENT
    ID 13
  - DDL_TRIGGER_NAME DROP_USER_BEFORE
  - EVENT_TYPE DROP
  - OBJECT_TYPE USER
  - DDL_EVENT DROP USER
  - OBJECT_NAME U_NON_EXISTENT
  - ID 14
  - DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
  - EVENT_TYPE DROP
  - OBJECT_TYPE USER
  - DDL_EVENT DROP USER
  - OBJECT_NAME U_NON_EXISTENT
  - ID 15
  - DDL_TRIGGER_NAME DROP_USER_AFTER
  - EVENT_TYPE DROP
  - OBJECT_TYPE USER
  - DDL_EVENT DROP USER
  - OBJECT_NAME U_NON_EXISTENT
  - ID 16
  - DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
  - EVENT_TYPE DROP
  - OBJECT_TYPE USER
  - DDL_EVENT DROP USER
  - OBJECT_NAME U_NON_EXISTENT
  - ID 17
    DDL_TRIGGER_NAME DROP_ROLE_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE ROLE
    DDL_EVENT DROP ROLE
    OBJECT_NAME R_EXISTENT
  - ID 18
  + ID 14
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE ROLE
    DDL_EVENT DROP ROLE
    OBJECT_NAME R_EXISTENT
  - ID 19
  + ID 15
    DDL_TRIGGER_NAME DROP_ROLE_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE ROLE
    DDL_EVENT DROP ROLE
    OBJECT_NAME R_EXISTENT
  - ID 20
  + ID 16
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE ROLE
    DDL_EVENT DROP ROLE
    OBJECT_NAME R_EXISTENT
  - ID 21
  + ID 17
    DDL_TRIGGER_NAME DROP_DOMAIN_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE DOMAIN
    DDL_EVENT DROP DOMAIN
    OBJECT_NAME D_EXISTENT
  - ID 22
  + ID 18
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE DOMAIN
    DDL_EVENT DROP DOMAIN
    OBJECT_NAME D_EXISTENT
  - ID 23
  + ID 19
    DDL_TRIGGER_NAME DROP_DOMAIN_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE DOMAIN
    DDL_EVENT DROP DOMAIN
    OBJECT_NAME D_EXISTENT
  - ID 24
  + ID 20
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE DOMAIN
    DDL_EVENT DROP DOMAIN
    OBJECT_NAME D_EXISTENT
  - ID 25
  + ID 21
    DDL_TRIGGER_NAME DROP_SEQUENCE_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE SEQUENCE
    DDL_EVENT DROP SEQUENCE
    OBJECT_NAME G_EXISTENT
  - ID 26
  + ID 22
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE SEQUENCE
    DDL_EVENT DROP SEQUENCE
    OBJECT_NAME G_EXISTENT
  - ID 27
  + ID 23
    DDL_TRIGGER_NAME DROP_SEQUENCE_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE SEQUENCE
    DDL_EVENT DROP SEQUENCE
    OBJECT_NAME G_EXISTENT
  - ID 28
  + ID 24
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE SEQUENCE
    DDL_EVENT DROP SEQUENCE
    OBJECT_NAME G_EXISTENT
  - ID 29
  + ID 25
    DDL_TRIGGER_NAME DROP_COLLATION_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE COLLATION
    DDL_EVENT DROP COLLATION
    OBJECT_NAME CN_EXISTENT
  - ID 30
  + ID 26
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE COLLATION
    DDL_EVENT DROP COLLATION
    OBJECT_NAME CN_EXISTENT
  - ID 31
  + ID 27
    DDL_TRIGGER_NAME DROP_COLLATION_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE COLLATION
    DDL_EVENT DROP COLLATION
    OBJECT_NAME CN_EXISTENT
  - ID 32
  + ID 28
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE COLLATION
    DDL_EVENT DROP COLLATION
    OBJECT_NAME CN_EXISTENT
  - ID 33
  + ID 29
    DDL_TRIGGER_NAME DROP_INDEX_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE INDEX
    DDL_EVENT DROP INDEX
    OBJECT_NAME T_EXISTENT_F01
  - ID 34
  + ID 30
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE INDEX
    DDL_EVENT DROP INDEX
    OBJECT_NAME T_EXISTENT_F01
  - ID 35
  + ID 31
    DDL_TRIGGER_NAME DROP_INDEX_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE INDEX
    DDL_EVENT DROP INDEX
    OBJECT_NAME T_EXISTENT_F01
  - ID 36
  + ID 32
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE INDEX
    DDL_EVENT DROP INDEX
    OBJECT_NAME T_EXISTENT_F01
  - ID 37
  + ID 33
    DDL_TRIGGER_NAME DROP_VIEW_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE VIEW
    DDL_EVENT DROP VIEW
    OBJECT_NAME V_EXISTENT
  - ID 38
  + ID 34
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE VIEW
    DDL_EVENT DROP VIEW
    OBJECT_NAME V_EXISTENT
  - ID 39
  + ID 35
    DDL_TRIGGER_NAME DROP_VIEW_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE VIEW
    DDL_EVENT DROP VIEW
    OBJECT_NAME V_EXISTENT
  - ID 40
  + ID 36
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE VIEW
    DDL_EVENT DROP VIEW
    OBJECT_NAME V_EXISTENT
  - ID 41
  + ID 37
    DDL_TRIGGER_NAME DROP_TRIGGER_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE TRIGGER
    DDL_EVENT DROP TRIGGER
    OBJECT_NAME TG_EXISTENT
  - ID 42
  + ID 38
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE TRIGGER
    DDL_EVENT DROP TRIGGER
    OBJECT_NAME TG_EXISTENT
  - ID 43
  + ID 39
    DDL_TRIGGER_NAME DROP_TRIGGER_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE TRIGGER
    DDL_EVENT DROP TRIGGER
    OBJECT_NAME TG_EXISTENT
  - ID 44
  + ID 40
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE TRIGGER
    DDL_EVENT DROP TRIGGER
    OBJECT_NAME TG_EXISTENT
  - ID 45
  + ID 41
    DDL_TRIGGER_NAME DROP_PROCEDURE_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE PROCEDURE
    DDL_EVENT DROP PROCEDURE
    OBJECT_NAME SP_EXISTENT
  - ID 46
  + ID 42
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE PROCEDURE
    DDL_EVENT DROP PROCEDURE
    OBJECT_NAME SP_EXISTENT
  - ID 47
  + ID 43
    DDL_TRIGGER_NAME DROP_PROCEDURE_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE PROCEDURE
    DDL_EVENT DROP PROCEDURE
    OBJECT_NAME SP_EXISTENT
  - ID 48
  + ID 44
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE PROCEDURE
    DDL_EVENT DROP PROCEDURE
    OBJECT_NAME SP_EXISTENT
  - ID 49
  + ID 45
    DDL_TRIGGER_NAME DROP_FUNCTION_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE FUNCTION
    DDL_EVENT DROP FUNCTION
    OBJECT_NAME FN_EXISTENT
  - ID 50
  + ID 46
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE FUNCTION
    DDL_EVENT DROP FUNCTION
    OBJECT_NAME FN_EXISTENT
  - ID 51
  + ID 47
    DDL_TRIGGER_NAME DROP_FUNCTION_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE FUNCTION
    DDL_EVENT DROP FUNCTION
    OBJECT_NAME FN_EXISTENT
  - ID 52
  + ID 48
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE FUNCTION
    DDL_EVENT DROP FUNCTION
    OBJECT_NAME FN_EXISTENT
  - ID 53
  + ID 49
    DDL_TRIGGER_NAME DROP_PACKAGE_BODY_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE PACKAGE BODY
    DDL_EVENT DROP PACKAGE BODY
    OBJECT_NAME PG_EXISTENT
  - ID 54
  + ID 50
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
    EVENT_TYPE DROP
    OBJECT_TYPE PACKAGE BODY
    DDL_EVENT DROP PACKAGE BODY
    OBJECT_NAME PG_EXISTENT
  - ID 55
  + ID 51
    DDL_TRIGGER_NAME DROP_PACKAGE_BODY_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE PACKAGE BODY
    DDL_EVENT DROP PACKAGE BODY
    OBJECT_NAME PG_EXISTENT
  - ID 56
  + ID 52
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
    EVENT_TYPE DROP
    OBJECT_TYPE PACKAGE BODY
    DDL_EVENT DROP PACKAGE BODY
    OBJECT_NAME PG_EXISTENT
  + ID 53
  + DDL_TRIGGER_NAME ALTER_TABLE_BEFORE
  + EVENT_TYPE ALTER
  + OBJECT_TYPE TABLE
  + DDL_EVENT ALTER TABLE
  + OBJECT_NAME T_EXISTENT
  + ID 54
  + DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
  + EVENT_TYPE ALTER
  + OBJECT_TYPE TABLE
  + DDL_EVENT ALTER TABLE
  + OBJECT_NAME T_EXISTENT
  + ID 55
  + DDL_TRIGGER_NAME ALTER_TABLE_AFTER
  + EVENT_TYPE ALTER
  + OBJECT_TYPE TABLE
  + DDL_EVENT ALTER TABLE
  + OBJECT_NAME T_EXISTENT
  + ID 56
  + DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
  + EVENT_TYPE ALTER
  + OBJECT_TYPE TABLE
  + DDL_EVENT ALTER TABLE
  + OBJECT_NAME T_EXISTENT
    ID 57
    DDL_TRIGGER_NAME ALTER_TABLE_BEFORE
    EVENT_TYPE ALTER
    OBJECT_TYPE TABLE
    DDL_EVENT ALTER TABLE
    OBJECT_NAME T_EXISTENT
    ID 58
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
    EVENT_TYPE ALTER
    OBJECT_TYPE TABLE
    DDL_EVENT ALTER TABLE
    OBJECT_NAME T_EXISTENT
    ID 59
    DDL_TRIGGER_NAME ALTER_TABLE_AFTER
    EVENT_TYPE ALTER
    OBJECT_TYPE TABLE
    DDL_EVENT ALTER TABLE
    OBJECT_NAME T_EXISTENT
    ID 60
    DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
    EVENT_TYPE ALTER
    OBJECT_TYPE TABLE
    DDL_EVENT ALTER TABLE
    OBJECT_NAME T_EXISTENT
  - ID 61
  - DDL_TRIGGER_NAME ALTER_TABLE_BEFORE
  - EVENT_TYPE ALTER
  - OBJECT_TYPE TABLE
  - DDL_EVENT ALTER TABLE
  - OBJECT_NAME T_EXISTENT
  - ID 62
  - DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
  - EVENT_TYPE ALTER
  - OBJECT_TYPE TABLE
  - DDL_EVENT ALTER TABLE
  - OBJECT_NAME T_EXISTENT
  - ID 63
  - DDL_TRIGGER_NAME ALTER_TABLE_AFTER
  - EVENT_TYPE ALTER
  - OBJECT_TYPE TABLE
  - DDL_EVENT ALTER TABLE
  - OBJECT_NAME T_EXISTENT
  - ID 64
  - DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
  - EVENT_TYPE ALTER
  - OBJECT_TYPE TABLE
  - DDL_EVENT ALTER TABLE
  - OBJECT_NAME T_EXISTENT
  - Records affected: 64
  + Records affected: 60

LOG DETAILS:

2025-06-25 05:21:37.499
2025-06-25 05:21:37.505 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-25 05:21:37.511 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-25 05:21:37.517
2025-06-25 05:21:37.523 @pytest.mark.version('>=6.0')
2025-06-25 05:21:37.528 def test_1(act: Action, capsys):
2025-06-25 05:21:37.533
2025-06-25 05:21:37.544 # Scan line-by-line through databases.conf, find line starting with REQUIRED_ALIAS and extract name of file that
2025-06-25 05:21:37.558 # must be created in the $(dir_sampleDb)/qa/ folder. This name will be used further as target database (tmp_fdb).
2025-06-25 05:21:37.567 # NOTE: we have to SKIP lines which are commented out, i.e. if they starts with '#':
2025-06-25 05:21:37.577 p_required_alias_ptn =  re.compile( '^(?!#)((^|\\s+)' + REQUIRED_ALIAS + ')\\s*=\\s*\\$\\(dir_sampleDb\\)/qa/', re.IGNORECASE )
2025-06-25 05:21:37.589 fname_in_dbconf = None
2025-06-25 05:21:37.601
2025-06-25 05:21:37.609 with open(act.home_dir/'databases.conf', 'r') as f:
2025-06-25 05:21:37.619 for line in f:
2025-06-25 05:21:37.626 if p_required_alias_ptn.search(line):
2025-06-25 05:21:37.633 # If databases.conf contains line like this:
2025-06-25 05:21:37.641 #     tmp_4203_alias = $(dir_sampleDb)/qa/tmp_qa_4203.fdb
2025-06-25 05:21:37.648 # - then we extract filename: 'tmp_qa_4203.fdb' (see below):
2025-06-25 05:21:37.655 fname_in_dbconf = Path(line.split('=')[1].strip()).name
2025-06-25 05:21:37.665 break
2025-06-25 05:21:37.676
2025-06-25 05:21:37.685 # if 'fname_in_dbconf' remains undefined here then propably REQUIRED_ALIAS not equals to specified in the databases.conf!
2025-06-25 05:21:37.693 #
2025-06-25 05:21:37.699 assert fname_in_dbconf
2025-06-25 05:21:37.705
2025-06-25 05:21:37.711 check_sql = f"""
2025-06-25 05:21:37.717 -- DO NOT: set bail on; -- we have to drop database at final point!
2025-06-25 05:21:37.733 set list on;
2025-06-25 05:21:37.743 rollback;
2025-06-25 05:21:37.750 create database '{REQUIRED_ALIAS}';
2025-06-25 05:21:37.757 commit;
2025-06-25 05:21:37.764 connect '{REQUIRED_ALIAS}' user {act.db.user};
2025-06-25 05:21:37.771 select mon$sec_database from mon$database; -- must be: 'Self'
2025-06-25 05:21:37.778 commit;
2025-06-25 05:21:37.789
2025-06-25 05:21:37.805 create mapping mp_existent using plugin Srp from any user to user;
2025-06-25 05:21:37.814 create global mapping mg_existent using plugin Srp from any user to user;
2025-06-25 05:21:37.823 create user u_existent password '123';
2025-06-25 05:21:37.831 create role r_existent;
2025-06-25 05:21:37.838 create domain d_existent as int;
2025-06-25 05:21:37.848 create sequence g_existent;
2025-06-25 05:21:37.860 create exception e_existent 'foo';
2025-06-25 05:21:37.871
2025-06-25 05:21:37.878 create collation cn_existent for utf8 from unicode;
2025-06-25 05:21:37.885
2025-06-25 05:21:37.892 recreate table log_ddl_triggers_activity (
2025-06-25 05:21:37.899 id int generated by default as identity constraint pk_log_ddl_triggers_activity primary key
2025-06-25 05:21:37.905 ,ddl_trigger_name varchar(64)
2025-06-25 05:21:37.911 ,event_type varchar(25) not null
2025-06-25 05:21:37.917 ,object_type varchar(25) not null
2025-06-25 05:21:37.923 ,ddl_event varchar(25) not null
2025-06-25 05:21:37.929 ,object_name varchar(64) not null
2025-06-25 05:21:37.943 ,dts timestamp default 'now'
2025-06-25 05:21:37.952 );
2025-06-25 05:21:37.960
2025-06-25 05:21:37.971 create table t_existent (
2025-06-25 05:21:37.976 id int primary key
2025-06-25 05:21:37.981 ,pid int
2025-06-25 05:21:37.986 ,f01_existent int
2025-06-25 05:21:37.999 ,f02_existent int
2025-06-25 05:21:38.013 ,f03_existent int
2025-06-25 05:21:38.022 ,constraint t_existent_fk foreign key(pid) references t_existent(id) on delete cascade
2025-06-25 05:21:38.034 );
2025-06-25 05:21:38.044 create index t_existent_f01 on t_existent(f01_existent);
2025-06-25 05:21:38.053 create view v_existent as select * from t_existent;
2025-06-25 05:21:38.063 set term ^;
2025-06-25 05:21:38.073 create trigger tg_existent for t_existent before insert as
2025-06-25 05:21:38.081 begin
2025-06-25 05:21:38.088 end
2025-06-25 05:21:38.095 ^
2025-06-25 05:21:38.101 create procedure sp_existent as
2025-06-25 05:21:38.107 begin
2025-06-25 05:21:38.112 end
2025-06-25 05:21:38.119 ^
2025-06-25 05:21:38.129 create function fn_existent returns int as
2025-06-25 05:21:38.135 begin
2025-06-25 05:21:38.142 return 1;
2025-06-25 05:21:38.149 end
2025-06-25 05:21:38.156 ^
2025-06-25 05:21:38.169 create package pg_existent as
2025-06-25 05:21:38.177 begin
2025-06-25 05:21:38.188 procedure p;
2025-06-25 05:21:38.201 function f returns int;
2025-06-25 05:21:38.209 end
2025-06-25 05:21:38.216 ^
2025-06-25 05:21:38.223 create package body pg_existent as
2025-06-25 05:21:38.229 begin
2025-06-25 05:21:38.234 procedure p as
2025-06-25 05:21:38.244 begin
2025-06-25 05:21:38.254 end
2025-06-25 05:21:38.263 function f returns int as
2025-06-25 05:21:38.274 begin
2025-06-25 05:21:38.283 return 1;
2025-06-25 05:21:38.291 end
2025-06-25 05:21:38.298 end
2025-06-25 05:21:38.304 ^
2025-06-25 05:21:38.311 create package pg_empty as
2025-06-25 05:21:38.321 begin
2025-06-25 05:21:38.328 procedure p;
2025-06-25 05:21:38.335 function f returns int;
2025-06-25 05:21:38.342 end
2025-06-25 05:21:38.351 ^
2025-06-25 05:21:38.360 commit
2025-06-25 05:21:38.371 ^
2025-06-25 05:21:38.380
2025-06-25 05:21:38.389 execute block as
2025-06-25 05:21:38.397 declare v_lf char(1) = x'0A';
2025-06-25 05:21:38.403 begin
2025-06-25 05:21:38.411 rdb$set_context('USER_SESSION', 'SKIP_DDL_TRIGGER', '1');
2025-06-25 05:21:38.421
2025-06-25 05:21:38.433 for
2025-06-25 05:21:38.444 with
2025-06-25 05:21:38.456 a as (
2025-06-25 05:21:38.465 select 'ANY DDL STATEMENT' x from rdb$database union all
2025-06-25 05:21:38.474 select 'ALTER TABLE' from rdb$database union all
2025-06-25 05:21:38.482 select 'DROP MAPPING' from rdb$database union all
2025-06-25 05:21:38.488 select 'DROP TABLE' from rdb$database union all
2025-06-25 05:21:38.495 select 'DROP PROCEDURE' from rdb$database union all
2025-06-25 05:21:38.506 select 'DROP FUNCTION' from rdb$database union all
2025-06-25 05:21:38.515 select 'DROP TRIGGER' from rdb$database union all
2025-06-25 05:21:38.523 select 'DROP EXCEPTION' from rdb$database union all
2025-06-25 05:21:38.535 select 'DROP VIEW' from rdb$database union all
2025-06-25 05:21:38.547 select 'DROP DOMAIN' from rdb$database union all
2025-06-25 05:21:38.562 select 'DROP ROLE' from rdb$database union all
2025-06-25 05:21:38.574 select 'DROP SEQUENCE' from rdb$database union all
2025-06-25 05:21:38.582 select 'DROP USER' from rdb$database union all
2025-06-25 05:21:38.587 select 'DROP INDEX' from rdb$database union all
2025-06-25 05:21:38.593 select 'DROP COLLATION' from rdb$database union all
2025-06-25 05:21:38.600 select 'DROP PACKAGE' from rdb$database union all
2025-06-25 05:21:38.611 select 'DROP PACKAGE BODY' from rdb$database
2025-06-25 05:21:38.622 )
2025-06-25 05:21:38.628 ,e as (
2025-06-25 05:21:38.634 select 'before' w from rdb$database union all select 'after' from rdb$database
2025-06-25 05:21:38.641 )
2025-06-25 05:21:38.648 ,t as (
2025-06-25 05:21:38.655 select upper(trim(replace(trim(a.x),' ','_')) || iif(e.w='before', '_before', '_after')) as trg_name, a.x, e.w
2025-06-25 05:21:38.663 from e, a
2025-06-25 05:21:38.673 )
2025-06-25 05:21:38.680
2025-06-25 05:21:38.686 select
2025-06-25 05:21:38.692 'create trigger trg_' || t.trg_name
2025-06-25 05:21:38.697 || ' active ' || t.w || ' ' || trim(t.x) || ' as '
2025-06-25 05:21:38.703 || :v_lf
2025-06-25 05:21:38.708 || 'begin'
2025-06-25 05:21:38.713 || :v_lf
2025-06-25 05:21:38.720 || q'!    if (rdb$get_context('USER_SESSION', 'SKIP_DDL_TRIGGER') is null) then!'
2025-06-25 05:21:38.726 || :v_lf
2025-06-25 05:21:38.734 || '        insert into log_ddl_triggers_activity(ddl_trigger_name, event_type, object_type, ddl_event, object_name) values('
2025-06-25 05:21:38.745 || :v_lf
2025-06-25 05:21:38.755 || q'!'!' || trim(t.trg_name) || q'!'!'
2025-06-25 05:21:38.762 || :v_lf
2025-06-25 05:21:38.766 || q'!, rdb$get_context('DDL_TRIGGER', 'EVENT_TYPE')!'
2025-06-25 05:21:38.771 || :v_lf
2025-06-25 05:21:38.776 || q'!, rdb$get_context('DDL_TRIGGER', 'OBJECT_TYPE')!'
2025-06-25 05:21:38.781 || :v_lf
2025-06-25 05:21:38.787 || q'!, rdb$get_context('DDL_TRIGGER', 'DDL_EVENT')!'
2025-06-25 05:21:38.792 || :v_lf
2025-06-25 05:21:38.798 || q'!, rdb$get_context('DDL_TRIGGER', 'OBJECT_NAME')!'
2025-06-25 05:21:38.804 || :v_lf
2025-06-25 05:21:38.810 || ');'
2025-06-25 05:21:38.817 || :v_lf
2025-06-25 05:21:38.823 || ' end'
2025-06-25 05:21:38.832 as sttm
2025-06-25 05:21:38.845 from t
2025-06-25 05:21:38.854 as cursor c
2025-06-25 05:21:38.859 do begin
2025-06-25 05:21:38.865 execute statement(c.sttm) with autonomous transaction;
2025-06-25 05:21:38.870 end
2025-06-25 05:21:38.880
2025-06-25 05:21:38.885 rdb$set_context('USER_SESSION', 'SKIP_DDL_TRIGGER', null);
2025-06-25 05:21:38.889 end
2025-06-25 05:21:38.894 ^
2025-06-25 05:21:38.898 commit
2025-06-25 05:21:38.906 ^
2025-06-25 05:21:38.916 set term ;^
2025-06-25 05:21:38.926
2025-06-25 05:21:38.937 --#####################################################################
2025-06-25 05:21:38.946
2025-06-25 05:21:38.956 drop mapping if exists mp_existent;
2025-06-25 05:21:38.966 drop mapping if exists mp_non_existent;
2025-06-25 05:21:38.975 drop global mapping if exists mg_existent;
2025-06-25 05:21:38.982 drop global mapping if exists mg_non_existent;
2025-06-25 05:21:38.991 drop user if exists u_existent;
2025-06-25 05:21:39.004 drop user if exists u_non_existent;
2025-06-25 05:21:39.017 drop role if exists r_existent;
2025-06-25 05:21:39.028 drop role if exists r_non_existent;
2025-06-25 05:21:39.037 drop domain if exists d_existent;
2025-06-25 05:21:39.045 drop domain if exists d_non_existent;
2025-06-25 05:21:39.051 drop sequence if exists g_existent;
2025-06-25 05:21:39.059 drop sequence if exists g_non_existent;
2025-06-25 05:21:39.069 drop collation if exists cn_existent;
2025-06-25 05:21:39.077 drop collation if exists cn_non_existent;
2025-06-25 05:21:39.084 drop index if exists t_existent_f01;
2025-06-25 05:21:39.091
2025-06-25 05:21:39.100 -- failed before https://github.com/FirebirdSQL/firebird/commit/a04784d5020326bdd42817eb0c9022b93d364f4a
2025-06-25 05:21:39.109 drop index if exists t_non_existent_f01;
2025-06-25 05:21:39.116
2025-06-25 05:21:39.123 drop view if exists v_existent;
2025-06-25 05:21:39.129 drop view if exists v_non_existent;
2025-06-25 05:21:39.135 drop trigger if exists tg_existent;
2025-06-25 05:21:39.141 drop trigger if exists tg_non_existent;
2025-06-25 05:21:39.146 drop procedure if exists sp_existent;
2025-06-25 05:21:39.156 drop procedure if exists sp_non_existent;
2025-06-25 05:21:39.168 drop function if exists fn_existent;
2025-06-25 05:21:39.178 drop function if exists fn_non_existent;
2025-06-25 05:21:39.187 drop package body if exists pg_existent;
2025-06-25 05:21:39.194
2025-06-25 05:21:39.205 -- failed before https://github.com/FirebirdSQL/firebird/commit/252a675c2adb95aca4fecb42d7433b39f669c20a
2025-06-25 05:21:39.216 drop package body if exists pg_non_existent;
2025-06-25 05:21:39.223
2025-06-25 05:21:39.231 -- must be logged because column 'f01_existent' DOES exist:
2025-06-25 05:21:39.242 alter table t_existent
2025-06-25 05:21:39.252 drop if exists f01_existent
2025-06-25 05:21:39.262 ;
2025-06-25 05:21:39.274
2025-06-25 05:21:39.286 -- must NOT be logged because column 'g01_non_existent' does NOT exist:
2025-06-25 05:21:39.295 alter table t_existent
2025-06-25 05:21:39.306 drop if exists g01_non_existent
2025-06-25 05:21:39.316 ;
2025-06-25 05:21:39.324
2025-06-25 05:21:39.331 -- must be logged because at least one column ('f02_existent') DOES exist:
2025-06-25 05:21:39.338 alter table t_existent
2025-06-25 05:21:39.349 drop if exists g01_non_existent
2025-06-25 05:21:39.360 ,drop if exists g02_non_existent
2025-06-25 05:21:39.369 ,drop if exists f02_existent
2025-06-25 05:21:39.376 ;
2025-06-25 05:21:39.383
2025-06-25 05:21:39.388 commit;
2025-06-25 05:21:39.393
2025-06-25 05:21:39.397 set count on;
2025-06-25 05:21:39.403 select
2025-06-25 05:21:39.408 id
2025-06-25 05:21:39.413 ,ddl_trigger_name
2025-06-25 05:21:39.419 ,event_type
2025-06-25 05:21:39.424 ,object_type
2025-06-25 05:21:39.429 ,ddl_event
2025-06-25 05:21:39.434 ,object_name
2025-06-25 05:21:39.438 from log_ddl_triggers_activity
2025-06-25 05:21:39.443 order by id;
2025-06-25 05:21:39.448 commit;
2025-06-25 05:21:39.454
2025-06-25 05:21:39.458 connect '{REQUIRED_ALIAS}' user {act.db.user};
2025-06-25 05:21:39.463 drop database;
2025-06-25 05:21:39.467 quit;
2025-06-25 05:21:39.471 """
2025-06-25 05:21:39.476
2025-06-25 05:21:39.480 expected_stdout = f"""
2025-06-25 05:21:39.484 MON$SEC_DATABASE Self
2025-06-25 05:21:39.489
2025-06-25 05:21:39.493 ID 1
2025-06-25 05:21:39.497 DDL_TRIGGER_NAME DROP_MAPPING_BEFORE
2025-06-25 05:21:39.501 EVENT_TYPE DROP
2025-06-25 05:21:39.506 OBJECT_TYPE MAPPING
2025-06-25 05:21:39.510 DDL_EVENT DROP MAPPING
2025-06-25 05:21:39.514 OBJECT_NAME MP_EXISTENT
2025-06-25 05:21:39.519 ID 2
2025-06-25 05:21:39.523 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:39.527 EVENT_TYPE DROP
2025-06-25 05:21:39.532 OBJECT_TYPE MAPPING
2025-06-25 05:21:39.540 DDL_EVENT DROP MAPPING
2025-06-25 05:21:39.550 OBJECT_NAME MP_EXISTENT
2025-06-25 05:21:39.557 ID 3
2025-06-25 05:21:39.563 DDL_TRIGGER_NAME DROP_MAPPING_AFTER
2025-06-25 05:21:39.570 EVENT_TYPE DROP
2025-06-25 05:21:39.577 OBJECT_TYPE MAPPING
2025-06-25 05:21:39.584 DDL_EVENT DROP MAPPING
2025-06-25 05:21:39.589 OBJECT_NAME MP_EXISTENT
2025-06-25 05:21:39.595 ID 4
2025-06-25 05:21:39.603 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:39.615 EVENT_TYPE DROP
2025-06-25 05:21:39.625 OBJECT_TYPE MAPPING
2025-06-25 05:21:39.633 DDL_EVENT DROP MAPPING
2025-06-25 05:21:39.639 OBJECT_NAME MP_EXISTENT
2025-06-25 05:21:39.649 ID 5
2025-06-25 05:21:39.655 DDL_TRIGGER_NAME DROP_MAPPING_BEFORE
2025-06-25 05:21:39.661 EVENT_TYPE DROP
2025-06-25 05:21:39.668 OBJECT_TYPE MAPPING
2025-06-25 05:21:39.676 DDL_EVENT DROP MAPPING
2025-06-25 05:21:39.683 OBJECT_NAME MG_EXISTENT
2025-06-25 05:21:39.692 ID 6
2025-06-25 05:21:39.700 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:39.706 EVENT_TYPE DROP
2025-06-25 05:21:39.711 OBJECT_TYPE MAPPING
2025-06-25 05:21:39.717 DDL_EVENT DROP MAPPING
2025-06-25 05:21:39.723 OBJECT_NAME MG_EXISTENT
2025-06-25 05:21:39.729 ID 7
2025-06-25 05:21:39.735 DDL_TRIGGER_NAME DROP_MAPPING_AFTER
2025-06-25 05:21:39.742 EVENT_TYPE DROP
2025-06-25 05:21:39.749 OBJECT_TYPE MAPPING
2025-06-25 05:21:39.756 DDL_EVENT DROP MAPPING
2025-06-25 05:21:39.763 OBJECT_NAME MG_EXISTENT
2025-06-25 05:21:39.770 ID 8
2025-06-25 05:21:39.777 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:39.783 EVENT_TYPE DROP
2025-06-25 05:21:39.790 OBJECT_TYPE MAPPING
2025-06-25 05:21:39.802 DDL_EVENT DROP MAPPING
2025-06-25 05:21:39.809 OBJECT_NAME MG_EXISTENT
2025-06-25 05:21:39.819 ID 9
2025-06-25 05:21:39.829 DDL_TRIGGER_NAME DROP_USER_BEFORE
2025-06-25 05:21:39.838 EVENT_TYPE DROP
2025-06-25 05:21:39.845 OBJECT_TYPE USER
2025-06-25 05:21:39.852 DDL_EVENT DROP USER
2025-06-25 05:21:39.864 OBJECT_NAME U_EXISTENT
2025-06-25 05:21:39.876 ID 10
2025-06-25 05:21:39.885 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:39.893 EVENT_TYPE DROP
2025-06-25 05:21:39.900 OBJECT_TYPE USER
2025-06-25 05:21:39.907 DDL_EVENT DROP USER
2025-06-25 05:21:39.915 OBJECT_NAME U_EXISTENT
2025-06-25 05:21:39.926 ID 11
2025-06-25 05:21:39.936 DDL_TRIGGER_NAME DROP_USER_AFTER
2025-06-25 05:21:39.944 EVENT_TYPE DROP
2025-06-25 05:21:39.951 OBJECT_TYPE USER
2025-06-25 05:21:39.957 DDL_EVENT DROP USER
2025-06-25 05:21:39.963 OBJECT_NAME U_EXISTENT
2025-06-25 05:21:39.975 ID 12
2025-06-25 05:21:39.984 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:39.992 EVENT_TYPE DROP
2025-06-25 05:21:39.999 OBJECT_TYPE USER
2025-06-25 05:21:40.014 DDL_EVENT DROP USER
2025-06-25 05:21:40.024 OBJECT_NAME U_EXISTENT
2025-06-25 05:21:40.031 ID 13
2025-06-25 05:21:40.037 DDL_TRIGGER_NAME DROP_USER_BEFORE
2025-06-25 05:21:40.043 EVENT_TYPE DROP
2025-06-25 05:21:40.049 OBJECT_TYPE USER
2025-06-25 05:21:40.055 DDL_EVENT DROP USER
2025-06-25 05:21:40.064 OBJECT_NAME U_NON_EXISTENT
2025-06-25 05:21:40.071 ID 14
2025-06-25 05:21:40.078 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:40.083 EVENT_TYPE DROP
2025-06-25 05:21:40.088 OBJECT_TYPE USER
2025-06-25 05:21:40.094 DDL_EVENT DROP USER
2025-06-25 05:21:40.105 OBJECT_NAME U_NON_EXISTENT
2025-06-25 05:21:40.112 ID 15
2025-06-25 05:21:40.119 DDL_TRIGGER_NAME DROP_USER_AFTER
2025-06-25 05:21:40.126 EVENT_TYPE DROP
2025-06-25 05:21:40.132 OBJECT_TYPE USER
2025-06-25 05:21:40.138 DDL_EVENT DROP USER
2025-06-25 05:21:40.144 OBJECT_NAME U_NON_EXISTENT
2025-06-25 05:21:40.156 ID 16
2025-06-25 05:21:40.168 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:40.181 EVENT_TYPE DROP
2025-06-25 05:21:40.194 OBJECT_TYPE USER
2025-06-25 05:21:40.206 DDL_EVENT DROP USER
2025-06-25 05:21:40.216 OBJECT_NAME U_NON_EXISTENT
2025-06-25 05:21:40.225 ID 17
2025-06-25 05:21:40.232 DDL_TRIGGER_NAME DROP_ROLE_BEFORE
2025-06-25 05:21:40.239 EVENT_TYPE DROP
2025-06-25 05:21:40.246 OBJECT_TYPE ROLE
2025-06-25 05:21:40.258 DDL_EVENT DROP ROLE
2025-06-25 05:21:40.267 OBJECT_NAME R_EXISTENT
2025-06-25 05:21:40.276 ID 18
2025-06-25 05:21:40.284 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:40.296 EVENT_TYPE DROP
2025-06-25 05:21:40.307 OBJECT_TYPE ROLE
2025-06-25 05:21:40.320 DDL_EVENT DROP ROLE
2025-06-25 05:21:40.336 OBJECT_NAME R_EXISTENT
2025-06-25 05:21:40.344 ID 19
2025-06-25 05:21:40.351 DDL_TRIGGER_NAME DROP_ROLE_AFTER
2025-06-25 05:21:40.358 EVENT_TYPE DROP
2025-06-25 05:21:40.365 OBJECT_TYPE ROLE
2025-06-25 05:21:40.371 DDL_EVENT DROP ROLE
2025-06-25 05:21:40.376 OBJECT_NAME R_EXISTENT
2025-06-25 05:21:40.383 ID 20
2025-06-25 05:21:40.391 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:40.397 EVENT_TYPE DROP
2025-06-25 05:21:40.406 OBJECT_TYPE ROLE
2025-06-25 05:21:40.415 DDL_EVENT DROP ROLE
2025-06-25 05:21:40.423 OBJECT_NAME R_EXISTENT
2025-06-25 05:21:40.434 ID 21
2025-06-25 05:21:40.442 DDL_TRIGGER_NAME DROP_DOMAIN_BEFORE
2025-06-25 05:21:40.451 EVENT_TYPE DROP
2025-06-25 05:21:40.460 OBJECT_TYPE DOMAIN
2025-06-25 05:21:40.473 DDL_EVENT DROP DOMAIN
2025-06-25 05:21:40.486 OBJECT_NAME D_EXISTENT
2025-06-25 05:21:40.495 ID 22
2025-06-25 05:21:40.501 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:40.507 EVENT_TYPE DROP
2025-06-25 05:21:40.512 OBJECT_TYPE DOMAIN
2025-06-25 05:21:40.518 DDL_EVENT DROP DOMAIN
2025-06-25 05:21:40.523 OBJECT_NAME D_EXISTENT
2025-06-25 05:21:40.528 ID 23
2025-06-25 05:21:40.534 DDL_TRIGGER_NAME DROP_DOMAIN_AFTER
2025-06-25 05:21:40.544 EVENT_TYPE DROP
2025-06-25 05:21:40.554 OBJECT_TYPE DOMAIN
2025-06-25 05:21:40.562 DDL_EVENT DROP DOMAIN
2025-06-25 05:21:40.570 OBJECT_NAME D_EXISTENT
2025-06-25 05:21:40.580 ID 24
2025-06-25 05:21:40.589 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:40.596 EVENT_TYPE DROP
2025-06-25 05:21:40.603 OBJECT_TYPE DOMAIN
2025-06-25 05:21:40.608 DDL_EVENT DROP DOMAIN
2025-06-25 05:21:40.614 OBJECT_NAME D_EXISTENT
2025-06-25 05:21:40.623 ID 25
2025-06-25 05:21:40.632 DDL_TRIGGER_NAME DROP_SEQUENCE_BEFORE
2025-06-25 05:21:40.639 EVENT_TYPE DROP
2025-06-25 05:21:40.646 OBJECT_TYPE SEQUENCE
2025-06-25 05:21:40.655 DDL_EVENT DROP SEQUENCE
2025-06-25 05:21:40.666 OBJECT_NAME G_EXISTENT
2025-06-25 05:21:40.679 ID 26
2025-06-25 05:21:40.689 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:40.697 EVENT_TYPE DROP
2025-06-25 05:21:40.704 OBJECT_TYPE SEQUENCE
2025-06-25 05:21:40.708 DDL_EVENT DROP SEQUENCE
2025-06-25 05:21:40.714 OBJECT_NAME G_EXISTENT
2025-06-25 05:21:40.719 ID 27
2025-06-25 05:21:40.724 DDL_TRIGGER_NAME DROP_SEQUENCE_AFTER
2025-06-25 05:21:40.731 EVENT_TYPE DROP
2025-06-25 05:21:40.739 OBJECT_TYPE SEQUENCE
2025-06-25 05:21:40.749 DDL_EVENT DROP SEQUENCE
2025-06-25 05:21:40.757 OBJECT_NAME G_EXISTENT
2025-06-25 05:21:40.763 ID 28
2025-06-25 05:21:40.769 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:40.774 EVENT_TYPE DROP
2025-06-25 05:21:40.779 OBJECT_TYPE SEQUENCE
2025-06-25 05:21:40.784 DDL_EVENT DROP SEQUENCE
2025-06-25 05:21:40.790 OBJECT_NAME G_EXISTENT
2025-06-25 05:21:40.802 ID 29
2025-06-25 05:21:40.813 DDL_TRIGGER_NAME DROP_COLLATION_BEFORE
2025-06-25 05:21:40.821 EVENT_TYPE DROP
2025-06-25 05:21:40.829 OBJECT_TYPE COLLATION
2025-06-25 05:21:40.835 DDL_EVENT DROP COLLATION
2025-06-25 05:21:40.842 OBJECT_NAME CN_EXISTENT
2025-06-25 05:21:40.853 ID 30
2025-06-25 05:21:40.861 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:40.871 EVENT_TYPE DROP
2025-06-25 05:21:40.881 OBJECT_TYPE COLLATION
2025-06-25 05:21:40.888 DDL_EVENT DROP COLLATION
2025-06-25 05:21:40.895 OBJECT_NAME CN_EXISTENT
2025-06-25 05:21:40.903 ID 31
2025-06-25 05:21:40.912 DDL_TRIGGER_NAME DROP_COLLATION_AFTER
2025-06-25 05:21:40.920 EVENT_TYPE DROP
2025-06-25 05:21:40.928 OBJECT_TYPE COLLATION
2025-06-25 05:21:40.936 DDL_EVENT DROP COLLATION
2025-06-25 05:21:40.948 OBJECT_NAME CN_EXISTENT
2025-06-25 05:21:40.956 ID 32
2025-06-25 05:21:40.965 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:40.977 EVENT_TYPE DROP
2025-06-25 05:21:40.987 OBJECT_TYPE COLLATION
2025-06-25 05:21:40.998 DDL_EVENT DROP COLLATION
2025-06-25 05:21:41.009 OBJECT_NAME CN_EXISTENT
2025-06-25 05:21:41.018 ID 33
2025-06-25 05:21:41.029 DDL_TRIGGER_NAME DROP_INDEX_BEFORE
2025-06-25 05:21:41.037 EVENT_TYPE DROP
2025-06-25 05:21:41.044 OBJECT_TYPE INDEX
2025-06-25 05:21:41.050 DDL_EVENT DROP INDEX
2025-06-25 05:21:41.056 OBJECT_NAME T_EXISTENT_F01
2025-06-25 05:21:41.062 ID 34
2025-06-25 05:21:41.070 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:41.080 EVENT_TYPE DROP
2025-06-25 05:21:41.088 OBJECT_TYPE INDEX
2025-06-25 05:21:41.095 DDL_EVENT DROP INDEX
2025-06-25 05:21:41.102 OBJECT_NAME T_EXISTENT_F01
2025-06-25 05:21:41.107 ID 35
2025-06-25 05:21:41.114 DDL_TRIGGER_NAME DROP_INDEX_AFTER
2025-06-25 05:21:41.119 EVENT_TYPE DROP
2025-06-25 05:21:41.125 OBJECT_TYPE INDEX
2025-06-25 05:21:41.131 DDL_EVENT DROP INDEX
2025-06-25 05:21:41.139 OBJECT_NAME T_EXISTENT_F01
2025-06-25 05:21:41.150 ID 36
2025-06-25 05:21:41.159 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:41.166 EVENT_TYPE DROP
2025-06-25 05:21:41.172 OBJECT_TYPE INDEX
2025-06-25 05:21:41.176 DDL_EVENT DROP INDEX
2025-06-25 05:21:41.181 OBJECT_NAME T_EXISTENT_F01
2025-06-25 05:21:41.186 ID 37
2025-06-25 05:21:41.194 DDL_TRIGGER_NAME DROP_VIEW_BEFORE
2025-06-25 05:21:41.201 EVENT_TYPE DROP
2025-06-25 05:21:41.208 OBJECT_TYPE VIEW
2025-06-25 05:21:41.215 DDL_EVENT DROP VIEW
2025-06-25 05:21:41.225 OBJECT_NAME V_EXISTENT
2025-06-25 05:21:41.235 ID 38
2025-06-25 05:21:41.242 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:41.249 EVENT_TYPE DROP
2025-06-25 05:21:41.256 OBJECT_TYPE VIEW
2025-06-25 05:21:41.262 DDL_EVENT DROP VIEW
2025-06-25 05:21:41.267 OBJECT_NAME V_EXISTENT
2025-06-25 05:21:41.275 ID 39
2025-06-25 05:21:41.285 DDL_TRIGGER_NAME DROP_VIEW_AFTER
2025-06-25 05:21:41.296 EVENT_TYPE DROP
2025-06-25 05:21:41.307 OBJECT_TYPE VIEW
2025-06-25 05:21:41.318 DDL_EVENT DROP VIEW
2025-06-25 05:21:41.330 OBJECT_NAME V_EXISTENT
2025-06-25 05:21:41.344 ID 40
2025-06-25 05:21:41.353 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:41.360 EVENT_TYPE DROP
2025-06-25 05:21:41.367 OBJECT_TYPE VIEW
2025-06-25 05:21:41.375 DDL_EVENT DROP VIEW
2025-06-25 05:21:41.385 OBJECT_NAME V_EXISTENT
2025-06-25 05:21:41.393 ID 41
2025-06-25 05:21:41.400 DDL_TRIGGER_NAME DROP_TRIGGER_BEFORE
2025-06-25 05:21:41.406 EVENT_TYPE DROP
2025-06-25 05:21:41.412 OBJECT_TYPE TRIGGER
2025-06-25 05:21:41.417 DDL_EVENT DROP TRIGGER
2025-06-25 05:21:41.422 OBJECT_NAME TG_EXISTENT
2025-06-25 05:21:41.428 ID 42
2025-06-25 05:21:41.433 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:41.439 EVENT_TYPE DROP
2025-06-25 05:21:41.448 OBJECT_TYPE TRIGGER
2025-06-25 05:21:41.457 DDL_EVENT DROP TRIGGER
2025-06-25 05:21:41.464 OBJECT_NAME TG_EXISTENT
2025-06-25 05:21:41.470 ID 43
2025-06-25 05:21:41.480 DDL_TRIGGER_NAME DROP_TRIGGER_AFTER
2025-06-25 05:21:41.490 EVENT_TYPE DROP
2025-06-25 05:21:41.496 OBJECT_TYPE TRIGGER
2025-06-25 05:21:41.503 DDL_EVENT DROP TRIGGER
2025-06-25 05:21:41.508 OBJECT_NAME TG_EXISTENT
2025-06-25 05:21:41.513 ID 44
2025-06-25 05:21:41.519 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:41.524 EVENT_TYPE DROP
2025-06-25 05:21:41.529 OBJECT_TYPE TRIGGER
2025-06-25 05:21:41.535 DDL_EVENT DROP TRIGGER
2025-06-25 05:21:41.540 OBJECT_NAME TG_EXISTENT
2025-06-25 05:21:41.546 ID 45
2025-06-25 05:21:41.552 DDL_TRIGGER_NAME DROP_PROCEDURE_BEFORE
2025-06-25 05:21:41.558 EVENT_TYPE DROP
2025-06-25 05:21:41.564 OBJECT_TYPE PROCEDURE
2025-06-25 05:21:41.570 DDL_EVENT DROP PROCEDURE
2025-06-25 05:21:41.576 OBJECT_NAME SP_EXISTENT
2025-06-25 05:21:41.581 ID 46
2025-06-25 05:21:41.588 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:41.594 EVENT_TYPE DROP
2025-06-25 05:21:41.599 OBJECT_TYPE PROCEDURE
2025-06-25 05:21:41.605 DDL_EVENT DROP PROCEDURE
2025-06-25 05:21:41.611 OBJECT_NAME SP_EXISTENT
2025-06-25 05:21:41.620 ID 47
2025-06-25 05:21:41.631 DDL_TRIGGER_NAME DROP_PROCEDURE_AFTER
2025-06-25 05:21:41.640 EVENT_TYPE DROP
2025-06-25 05:21:41.647 OBJECT_TYPE PROCEDURE
2025-06-25 05:21:41.655 DDL_EVENT DROP PROCEDURE
2025-06-25 05:21:41.662 OBJECT_NAME SP_EXISTENT
2025-06-25 05:21:41.669 ID 48
2025-06-25 05:21:41.675 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:41.679 EVENT_TYPE DROP
2025-06-25 05:21:41.684 OBJECT_TYPE PROCEDURE
2025-06-25 05:21:41.689 DDL_EVENT DROP PROCEDURE
2025-06-25 05:21:41.694 OBJECT_NAME SP_EXISTENT
2025-06-25 05:21:41.700 ID 49
2025-06-25 05:21:41.707 DDL_TRIGGER_NAME DROP_FUNCTION_BEFORE
2025-06-25 05:21:41.715 EVENT_TYPE DROP
2025-06-25 05:21:41.725 OBJECT_TYPE FUNCTION
2025-06-25 05:21:41.732 DDL_EVENT DROP FUNCTION
2025-06-25 05:21:41.740 OBJECT_NAME FN_EXISTENT
2025-06-25 05:21:41.748 ID 50
2025-06-25 05:21:41.755 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:41.761 EVENT_TYPE DROP
2025-06-25 05:21:41.767 OBJECT_TYPE FUNCTION
2025-06-25 05:21:41.773 DDL_EVENT DROP FUNCTION
2025-06-25 05:21:41.785 OBJECT_NAME FN_EXISTENT
2025-06-25 05:21:41.797 ID 51
2025-06-25 05:21:41.804 DDL_TRIGGER_NAME DROP_FUNCTION_AFTER
2025-06-25 05:21:41.810 EVENT_TYPE DROP
2025-06-25 05:21:41.816 OBJECT_TYPE FUNCTION
2025-06-25 05:21:41.822 DDL_EVENT DROP FUNCTION
2025-06-25 05:21:41.827 OBJECT_NAME FN_EXISTENT
2025-06-25 05:21:41.833 ID 52
2025-06-25 05:21:41.838 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:41.845 EVENT_TYPE DROP
2025-06-25 05:21:41.850 OBJECT_TYPE FUNCTION
2025-06-25 05:21:41.860 DDL_EVENT DROP FUNCTION
2025-06-25 05:21:41.869 OBJECT_NAME FN_EXISTENT
2025-06-25 05:21:41.876 ID 53
2025-06-25 05:21:41.885 DDL_TRIGGER_NAME DROP_PACKAGE_BODY_BEFORE
2025-06-25 05:21:41.895 EVENT_TYPE DROP
2025-06-25 05:21:41.908 OBJECT_TYPE PACKAGE BODY
2025-06-25 05:21:41.918 DDL_EVENT DROP PACKAGE BODY
2025-06-25 05:21:41.924 OBJECT_NAME PG_EXISTENT
2025-06-25 05:21:41.929 ID 54
2025-06-25 05:21:41.935 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:41.940 EVENT_TYPE DROP
2025-06-25 05:21:41.946 OBJECT_TYPE PACKAGE BODY
2025-06-25 05:21:41.951 DDL_EVENT DROP PACKAGE BODY
2025-06-25 05:21:41.957 OBJECT_NAME PG_EXISTENT
2025-06-25 05:21:41.963 ID 55
2025-06-25 05:21:41.969 DDL_TRIGGER_NAME DROP_PACKAGE_BODY_AFTER
2025-06-25 05:21:41.974 EVENT_TYPE DROP
2025-06-25 05:21:41.980 OBJECT_TYPE PACKAGE BODY
2025-06-25 05:21:41.985 DDL_EVENT DROP PACKAGE BODY
2025-06-25 05:21:41.991 OBJECT_NAME PG_EXISTENT
2025-06-25 05:21:41.996 ID 56
2025-06-25 05:21:42.002 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:42.013 EVENT_TYPE DROP
2025-06-25 05:21:42.023 OBJECT_TYPE PACKAGE BODY
2025-06-25 05:21:42.030 DDL_EVENT DROP PACKAGE BODY
2025-06-25 05:21:42.038 OBJECT_NAME PG_EXISTENT
2025-06-25 05:21:42.043 ID 57
2025-06-25 05:21:42.049 DDL_TRIGGER_NAME ALTER_TABLE_BEFORE
2025-06-25 05:21:42.054 EVENT_TYPE ALTER
2025-06-25 05:21:42.060 OBJECT_TYPE TABLE
2025-06-25 05:21:42.065 DDL_EVENT ALTER TABLE
2025-06-25 05:21:42.071 OBJECT_NAME T_EXISTENT
2025-06-25 05:21:42.078 ID 58
2025-06-25 05:21:42.089 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:42.097 EVENT_TYPE ALTER
2025-06-25 05:21:42.104 OBJECT_TYPE TABLE
2025-06-25 05:21:42.115 DDL_EVENT ALTER TABLE
2025-06-25 05:21:42.128 OBJECT_NAME T_EXISTENT
2025-06-25 05:21:42.138 ID 59
2025-06-25 05:21:42.147 DDL_TRIGGER_NAME ALTER_TABLE_AFTER
2025-06-25 05:21:42.159 EVENT_TYPE ALTER
2025-06-25 05:21:42.168 OBJECT_TYPE TABLE
2025-06-25 05:21:42.176 DDL_EVENT ALTER TABLE
2025-06-25 05:21:42.182 OBJECT_NAME T_EXISTENT
2025-06-25 05:21:42.189 ID 60
2025-06-25 05:21:42.194 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:42.200 EVENT_TYPE ALTER
2025-06-25 05:21:42.205 OBJECT_TYPE TABLE
2025-06-25 05:21:42.211 DDL_EVENT ALTER TABLE
2025-06-25 05:21:42.219 OBJECT_NAME T_EXISTENT
2025-06-25 05:21:42.227 ID 61
2025-06-25 05:21:42.234 DDL_TRIGGER_NAME ALTER_TABLE_BEFORE
2025-06-25 05:21:42.241 EVENT_TYPE ALTER
2025-06-25 05:21:42.247 OBJECT_TYPE TABLE
2025-06-25 05:21:42.253 DDL_EVENT ALTER TABLE
2025-06-25 05:21:42.258 OBJECT_NAME T_EXISTENT
2025-06-25 05:21:42.262 ID 62
2025-06-25 05:21:42.267 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:42.271 EVENT_TYPE ALTER
2025-06-25 05:21:42.275 OBJECT_TYPE TABLE
2025-06-25 05:21:42.279 DDL_EVENT ALTER TABLE
2025-06-25 05:21:42.296 OBJECT_NAME T_EXISTENT
2025-06-25 05:21:42.304 ID 63
2025-06-25 05:21:42.310 DDL_TRIGGER_NAME ALTER_TABLE_AFTER
2025-06-25 05:21:42.315 EVENT_TYPE ALTER
2025-06-25 05:21:42.320 OBJECT_TYPE TABLE
2025-06-25 05:21:42.326 DDL_EVENT ALTER TABLE
2025-06-25 05:21:42.337 OBJECT_NAME T_EXISTENT
2025-06-25 05:21:42.348 ID 64
2025-06-25 05:21:42.356 DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:42.363 EVENT_TYPE ALTER
2025-06-25 05:21:42.369 OBJECT_TYPE TABLE
2025-06-25 05:21:42.375 DDL_EVENT ALTER TABLE
2025-06-25 05:21:42.381 OBJECT_NAME T_EXISTENT
2025-06-25 05:21:42.387
2025-06-25 05:21:42.398 Records affected: 64
2025-06-25 05:21:42.406 """
2025-06-25 05:21:42.416
2025-06-25 05:21:42.428 act.expected_stdout = expected_stdout
2025-06-25 05:21:42.439
2025-06-25 05:21:42.449 act.isql(switches=['-q', act.db.db_path, '-user', act.db.user], input = check_sql, credentials = False, connect_db = False, combine_output = True, io_enc = locale.getpreferredencoding())
2025-06-25 05:21:42.459
2025-06-25 05:21:42.471 >       assert act.clean_stdout == act.clean_expected_stdout # and act.clean_stderr == act.clean_expected_stderr
2025-06-25 05:21:42.482 E       assert
2025-06-25 05:21:42.490 E           MON$SEC_DATABASE Self
2025-06-25 05:21:42.496 E         + Statement failed, SQLSTATE = 42000
2025-06-25 05:21:42.500 E         + unsuccessful metadata update
2025-06-25 05:21:42.505 E         + -CREATE MAPPING MG_EXISTENT failed
2025-06-25 05:21:42.509 E         + -CREATE MAPPING MG_EXISTENT failed
2025-06-25 05:21:42.514 E         + -Dynamic SQL Error
2025-06-25 05:21:42.518 E         + -SQL error code = -504
2025-06-25 05:21:42.522 E         + -CHARACTER SET "UTF8" is not defined
2025-06-25 05:21:42.527 E           ID 1
2025-06-25 05:21:42.531 E           DDL_TRIGGER_NAME DROP_MAPPING_BEFORE
2025-06-25 05:21:42.536 E           EVENT_TYPE DROP
2025-06-25 05:21:42.541 E           OBJECT_TYPE MAPPING
2025-06-25 05:21:42.547 E           DDL_EVENT DROP MAPPING
2025-06-25 05:21:42.551 E           OBJECT_NAME MP_EXISTENT
2025-06-25 05:21:42.555 E           ID 2
2025-06-25 05:21:42.560 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:42.564 E           EVENT_TYPE DROP
2025-06-25 05:21:42.568 E           OBJECT_TYPE MAPPING
2025-06-25 05:21:42.573 E           DDL_EVENT DROP MAPPING
2025-06-25 05:21:42.577 E           OBJECT_NAME MP_EXISTENT
2025-06-25 05:21:42.581 E           ID 3
2025-06-25 05:21:42.586 E           DDL_TRIGGER_NAME DROP_MAPPING_AFTER
2025-06-25 05:21:42.590 E           EVENT_TYPE DROP
2025-06-25 05:21:42.594 E           OBJECT_TYPE MAPPING
2025-06-25 05:21:42.599 E           DDL_EVENT DROP MAPPING
2025-06-25 05:21:42.603 E           OBJECT_NAME MP_EXISTENT
2025-06-25 05:21:42.607 E           ID 4
2025-06-25 05:21:42.612 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:42.616 E           EVENT_TYPE DROP
2025-06-25 05:21:42.620 E           OBJECT_TYPE MAPPING
2025-06-25 05:21:42.625 E           DDL_EVENT DROP MAPPING
2025-06-25 05:21:42.629 E           OBJECT_NAME MP_EXISTENT
2025-06-25 05:21:42.633 E           ID 5
2025-06-25 05:21:42.638 E         - DDL_TRIGGER_NAME DROP_MAPPING_BEFORE
2025-06-25 05:21:42.647 E         + DDL_TRIGGER_NAME DROP_USER_BEFORE
2025-06-25 05:21:42.658 E           EVENT_TYPE DROP
2025-06-25 05:21:42.667 E         - OBJECT_TYPE MAPPING
2025-06-25 05:21:42.678 E         - DDL_EVENT DROP MAPPING
2025-06-25 05:21:42.686 E         + OBJECT_TYPE USER
2025-06-25 05:21:42.692 E         + DDL_EVENT DROP USER
2025-06-25 05:21:42.697 E         - OBJECT_NAME MG_EXISTENT
2025-06-25 05:21:42.712 E         + OBJECT_NAME U_EXISTENT
2025-06-25 05:21:42.730 E           ID 6
2025-06-25 05:21:42.743 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:42.754 E           EVENT_TYPE DROP
2025-06-25 05:21:42.765 E         - OBJECT_TYPE MAPPING
2025-06-25 05:21:42.775 E         - DDL_EVENT DROP MAPPING
2025-06-25 05:21:42.789 E         + OBJECT_TYPE USER
2025-06-25 05:21:42.800 E         + DDL_EVENT DROP USER
2025-06-25 05:21:42.813 E         - OBJECT_NAME MG_EXISTENT
2025-06-25 05:21:42.830 E         + OBJECT_NAME U_EXISTENT
2025-06-25 05:21:42.845 E           ID 7
2025-06-25 05:21:42.851 E         - DDL_TRIGGER_NAME DROP_MAPPING_AFTER
2025-06-25 05:21:42.872 E         + DDL_TRIGGER_NAME DROP_USER_AFTER
2025-06-25 05:21:42.887 E           EVENT_TYPE DROP
2025-06-25 05:21:42.895 E         - OBJECT_TYPE MAPPING
2025-06-25 05:21:42.906 E         - DDL_EVENT DROP MAPPING
2025-06-25 05:21:42.916 E         + OBJECT_TYPE USER
2025-06-25 05:21:42.927 E         + DDL_EVENT DROP USER
2025-06-25 05:21:42.938 E         - OBJECT_NAME MG_EXISTENT
2025-06-25 05:21:42.957 E         + OBJECT_NAME U_EXISTENT
2025-06-25 05:21:42.976 E           ID 8
2025-06-25 05:21:42.987 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:42.996 E           EVENT_TYPE DROP
2025-06-25 05:21:43.004 E         - OBJECT_TYPE MAPPING
2025-06-25 05:21:43.011 E         - DDL_EVENT DROP MAPPING
2025-06-25 05:21:43.017 E         + OBJECT_TYPE USER
2025-06-25 05:21:43.023 E         + DDL_EVENT DROP USER
2025-06-25 05:21:43.030 E         - OBJECT_NAME MG_EXISTENT
2025-06-25 05:21:43.049 E         + OBJECT_NAME U_EXISTENT
2025-06-25 05:21:43.068 E           ID 9
2025-06-25 05:21:43.075 E           DDL_TRIGGER_NAME DROP_USER_BEFORE
2025-06-25 05:21:43.082 E           EVENT_TYPE DROP
2025-06-25 05:21:43.087 E           OBJECT_TYPE USER
2025-06-25 05:21:43.091 E           DDL_EVENT DROP USER
2025-06-25 05:21:43.095 E         - OBJECT_NAME U_EXISTENT
2025-06-25 05:21:43.099 E         + OBJECT_NAME U_NON_EXISTENT
2025-06-25 05:21:43.108 E           ID 10
2025-06-25 05:21:43.113 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:43.117 E           EVENT_TYPE DROP
2025-06-25 05:21:43.121 E           OBJECT_TYPE USER
2025-06-25 05:21:43.125 E           DDL_EVENT DROP USER
2025-06-25 05:21:43.130 E         - OBJECT_NAME U_EXISTENT
2025-06-25 05:21:43.134 E         + OBJECT_NAME U_NON_EXISTENT
2025-06-25 05:21:43.142 E           ID 11
2025-06-25 05:21:43.147 E           DDL_TRIGGER_NAME DROP_USER_AFTER
2025-06-25 05:21:43.152 E           EVENT_TYPE DROP
2025-06-25 05:21:43.156 E           OBJECT_TYPE USER
2025-06-25 05:21:43.160 E           DDL_EVENT DROP USER
2025-06-25 05:21:43.165 E         - OBJECT_NAME U_EXISTENT
2025-06-25 05:21:43.169 E         + OBJECT_NAME U_NON_EXISTENT
2025-06-25 05:21:43.177 E           ID 12
2025-06-25 05:21:43.182 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:43.186 E           EVENT_TYPE DROP
2025-06-25 05:21:43.191 E           OBJECT_TYPE USER
2025-06-25 05:21:43.201 E           DDL_EVENT DROP USER
2025-06-25 05:21:43.211 E         - OBJECT_NAME U_EXISTENT
2025-06-25 05:21:43.220 E         + OBJECT_NAME U_NON_EXISTENT
2025-06-25 05:21:43.233 E           ID 13
2025-06-25 05:21:43.239 E         - DDL_TRIGGER_NAME DROP_USER_BEFORE
2025-06-25 05:21:43.244 E         - EVENT_TYPE DROP
2025-06-25 05:21:43.248 E         - OBJECT_TYPE USER
2025-06-25 05:21:43.253 E         - DDL_EVENT DROP USER
2025-06-25 05:21:43.259 E         - OBJECT_NAME U_NON_EXISTENT
2025-06-25 05:21:43.266 E         - ID 14
2025-06-25 05:21:43.271 E         - DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:43.276 E         - EVENT_TYPE DROP
2025-06-25 05:21:43.281 E         - OBJECT_TYPE USER
2025-06-25 05:21:43.286 E         - DDL_EVENT DROP USER
2025-06-25 05:21:43.292 E         - OBJECT_NAME U_NON_EXISTENT
2025-06-25 05:21:43.297 E         - ID 15
2025-06-25 05:21:43.303 E         - DDL_TRIGGER_NAME DROP_USER_AFTER
2025-06-25 05:21:43.316 E         - EVENT_TYPE DROP
2025-06-25 05:21:43.325 E         - OBJECT_TYPE USER
2025-06-25 05:21:43.332 E         - DDL_EVENT DROP USER
2025-06-25 05:21:43.337 E         - OBJECT_NAME U_NON_EXISTENT
2025-06-25 05:21:43.342 E         - ID 16
2025-06-25 05:21:43.348 E         - DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:43.353 E         - EVENT_TYPE DROP
2025-06-25 05:21:43.360 E         - OBJECT_TYPE USER
2025-06-25 05:21:43.367 E         - DDL_EVENT DROP USER
2025-06-25 05:21:43.373 E         - OBJECT_NAME U_NON_EXISTENT
2025-06-25 05:21:43.378 E         - ID 17
2025-06-25 05:21:43.384 E           DDL_TRIGGER_NAME DROP_ROLE_BEFORE
2025-06-25 05:21:43.390 E           EVENT_TYPE DROP
2025-06-25 05:21:43.400 E           OBJECT_TYPE ROLE
2025-06-25 05:21:43.413 E           DDL_EVENT DROP ROLE
2025-06-25 05:21:43.423 E           OBJECT_NAME R_EXISTENT
2025-06-25 05:21:43.432 E         - ID 18
2025-06-25 05:21:43.447 E         + ID 14
2025-06-25 05:21:43.468 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:43.479 E           EVENT_TYPE DROP
2025-06-25 05:21:43.488 E           OBJECT_TYPE ROLE
2025-06-25 05:21:43.494 E           DDL_EVENT DROP ROLE
2025-06-25 05:21:43.499 E           OBJECT_NAME R_EXISTENT
2025-06-25 05:21:43.505 E         - ID 19
2025-06-25 05:21:43.518 E         + ID 15
2025-06-25 05:21:43.537 E           DDL_TRIGGER_NAME DROP_ROLE_AFTER
2025-06-25 05:21:43.544 E           EVENT_TYPE DROP
2025-06-25 05:21:43.549 E           OBJECT_TYPE ROLE
2025-06-25 05:21:43.554 E           DDL_EVENT DROP ROLE
2025-06-25 05:21:43.558 E           OBJECT_NAME R_EXISTENT
2025-06-25 05:21:43.563 E         - ID 20
2025-06-25 05:21:43.568 E         + ID 16
2025-06-25 05:21:43.579 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:43.588 E           EVENT_TYPE DROP
2025-06-25 05:21:43.596 E           OBJECT_TYPE ROLE
2025-06-25 05:21:43.602 E           DDL_EVENT DROP ROLE
2025-06-25 05:21:43.607 E           OBJECT_NAME R_EXISTENT
2025-06-25 05:21:43.615 E         - ID 21
2025-06-25 05:21:43.633 E         + ID 17
2025-06-25 05:21:43.647 E           DDL_TRIGGER_NAME DROP_DOMAIN_BEFORE
2025-06-25 05:21:43.653 E           EVENT_TYPE DROP
2025-06-25 05:21:43.659 E           OBJECT_TYPE DOMAIN
2025-06-25 05:21:43.665 E           DDL_EVENT DROP DOMAIN
2025-06-25 05:21:43.670 E           OBJECT_NAME D_EXISTENT
2025-06-25 05:21:43.677 E         - ID 22
2025-06-25 05:21:43.683 E         + ID 18
2025-06-25 05:21:43.689 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:43.694 E           EVENT_TYPE DROP
2025-06-25 05:21:43.704 E           OBJECT_TYPE DOMAIN
2025-06-25 05:21:43.713 E           DDL_EVENT DROP DOMAIN
2025-06-25 05:21:43.722 E           OBJECT_NAME D_EXISTENT
2025-06-25 05:21:43.733 E         - ID 23
2025-06-25 05:21:43.743 E         + ID 19
2025-06-25 05:21:43.751 E           DDL_TRIGGER_NAME DROP_DOMAIN_AFTER
2025-06-25 05:21:43.760 E           EVENT_TYPE DROP
2025-06-25 05:21:43.767 E           OBJECT_TYPE DOMAIN
2025-06-25 05:21:43.774 E           DDL_EVENT DROP DOMAIN
2025-06-25 05:21:43.780 E           OBJECT_NAME D_EXISTENT
2025-06-25 05:21:43.785 E         - ID 24
2025-06-25 05:21:43.796 E         + ID 20
2025-06-25 05:21:43.808 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:43.814 E           EVENT_TYPE DROP
2025-06-25 05:21:43.820 E           OBJECT_TYPE DOMAIN
2025-06-25 05:21:43.825 E           DDL_EVENT DROP DOMAIN
2025-06-25 05:21:43.829 E           OBJECT_NAME D_EXISTENT
2025-06-25 05:21:43.834 E         - ID 25
2025-06-25 05:21:43.843 E         + ID 21
2025-06-25 05:21:43.860 E           DDL_TRIGGER_NAME DROP_SEQUENCE_BEFORE
2025-06-25 05:21:43.867 E           EVENT_TYPE DROP
2025-06-25 05:21:43.874 E           OBJECT_TYPE SEQUENCE
2025-06-25 05:21:43.884 E           DDL_EVENT DROP SEQUENCE
2025-06-25 05:21:43.892 E           OBJECT_NAME G_EXISTENT
2025-06-25 05:21:43.898 E         - ID 26
2025-06-25 05:21:43.918 E         + ID 22
2025-06-25 05:21:43.936 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:43.947 E           EVENT_TYPE DROP
2025-06-25 05:21:43.958 E           OBJECT_TYPE SEQUENCE
2025-06-25 05:21:43.967 E           DDL_EVENT DROP SEQUENCE
2025-06-25 05:21:43.975 E           OBJECT_NAME G_EXISTENT
2025-06-25 05:21:43.987 E         - ID 27
2025-06-25 05:21:44.010 E         + ID 23
2025-06-25 05:21:44.029 E           DDL_TRIGGER_NAME DROP_SEQUENCE_AFTER
2025-06-25 05:21:44.036 E           EVENT_TYPE DROP
2025-06-25 05:21:44.043 E           OBJECT_TYPE SEQUENCE
2025-06-25 05:21:44.049 E           DDL_EVENT DROP SEQUENCE
2025-06-25 05:21:44.058 E           OBJECT_NAME G_EXISTENT
2025-06-25 05:21:44.071 E         - ID 28
2025-06-25 05:21:44.093 E         + ID 24
2025-06-25 05:21:44.108 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:44.113 E           EVENT_TYPE DROP
2025-06-25 05:21:44.120 E           OBJECT_TYPE SEQUENCE
2025-06-25 05:21:44.127 E           DDL_EVENT DROP SEQUENCE
2025-06-25 05:21:44.137 E           OBJECT_NAME G_EXISTENT
2025-06-25 05:21:44.146 E         - ID 29
2025-06-25 05:21:44.159 E         + ID 25
2025-06-25 05:21:44.170 E           DDL_TRIGGER_NAME DROP_COLLATION_BEFORE
2025-06-25 05:21:44.181 E           EVENT_TYPE DROP
2025-06-25 05:21:44.193 E           OBJECT_TYPE COLLATION
2025-06-25 05:21:44.205 E           DDL_EVENT DROP COLLATION
2025-06-25 05:21:44.212 E           OBJECT_NAME CN_EXISTENT
2025-06-25 05:21:44.218 E         - ID 30
2025-06-25 05:21:44.223 E         + ID 26
2025-06-25 05:21:44.229 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:44.234 E           EVENT_TYPE DROP
2025-06-25 05:21:44.240 E           OBJECT_TYPE COLLATION
2025-06-25 05:21:44.245 E           DDL_EVENT DROP COLLATION
2025-06-25 05:21:44.251 E           OBJECT_NAME CN_EXISTENT
2025-06-25 05:21:44.257 E         - ID 31
2025-06-25 05:21:44.263 E         + ID 27
2025-06-25 05:21:44.270 E           DDL_TRIGGER_NAME DROP_COLLATION_AFTER
2025-06-25 05:21:44.277 E           EVENT_TYPE DROP
2025-06-25 05:21:44.283 E           OBJECT_TYPE COLLATION
2025-06-25 05:21:44.290 E           DDL_EVENT DROP COLLATION
2025-06-25 05:21:44.297 E           OBJECT_NAME CN_EXISTENT
2025-06-25 05:21:44.303 E         - ID 32
2025-06-25 05:21:44.321 E         + ID 28
2025-06-25 05:21:44.339 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:44.345 E           EVENT_TYPE DROP
2025-06-25 05:21:44.351 E           OBJECT_TYPE COLLATION
2025-06-25 05:21:44.357 E           DDL_EVENT DROP COLLATION
2025-06-25 05:21:44.362 E           OBJECT_NAME CN_EXISTENT
2025-06-25 05:21:44.368 E         - ID 33
2025-06-25 05:21:44.373 E         + ID 29
2025-06-25 05:21:44.379 E           DDL_TRIGGER_NAME DROP_INDEX_BEFORE
2025-06-25 05:21:44.385 E           EVENT_TYPE DROP
2025-06-25 05:21:44.390 E           OBJECT_TYPE INDEX
2025-06-25 05:21:44.397 E           DDL_EVENT DROP INDEX
2025-06-25 05:21:44.404 E           OBJECT_NAME T_EXISTENT_F01
2025-06-25 05:21:44.410 E         - ID 34
2025-06-25 05:21:44.421 E         + ID 30
2025-06-25 05:21:44.431 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:44.437 E           EVENT_TYPE DROP
2025-06-25 05:21:44.443 E           OBJECT_TYPE INDEX
2025-06-25 05:21:44.449 E           DDL_EVENT DROP INDEX
2025-06-25 05:21:44.455 E           OBJECT_NAME T_EXISTENT_F01
2025-06-25 05:21:44.462 E         - ID 35
2025-06-25 05:21:44.475 E         + ID 31
2025-06-25 05:21:44.488 E           DDL_TRIGGER_NAME DROP_INDEX_AFTER
2025-06-25 05:21:44.495 E           EVENT_TYPE DROP
2025-06-25 05:21:44.503 E           OBJECT_TYPE INDEX
2025-06-25 05:21:44.513 E           DDL_EVENT DROP INDEX
2025-06-25 05:21:44.521 E           OBJECT_NAME T_EXISTENT_F01
2025-06-25 05:21:44.526 E         - ID 36
2025-06-25 05:21:44.536 E         + ID 32
2025-06-25 05:21:44.545 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:44.550 E           EVENT_TYPE DROP
2025-06-25 05:21:44.556 E           OBJECT_TYPE INDEX
2025-06-25 05:21:44.561 E           DDL_EVENT DROP INDEX
2025-06-25 05:21:44.567 E           OBJECT_NAME T_EXISTENT_F01
2025-06-25 05:21:44.574 E         - ID 37
2025-06-25 05:21:44.591 E         + ID 33
2025-06-25 05:21:44.607 E           DDL_TRIGGER_NAME DROP_VIEW_BEFORE
2025-06-25 05:21:44.617 E           EVENT_TYPE DROP
2025-06-25 05:21:44.624 E           OBJECT_TYPE VIEW
2025-06-25 05:21:44.630 E           DDL_EVENT DROP VIEW
2025-06-25 05:21:44.636 E           OBJECT_NAME V_EXISTENT
2025-06-25 05:21:44.641 E         - ID 38
2025-06-25 05:21:44.653 E         + ID 34
2025-06-25 05:21:44.670 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:44.683 E           EVENT_TYPE DROP
2025-06-25 05:21:44.689 E           OBJECT_TYPE VIEW
2025-06-25 05:21:44.696 E           DDL_EVENT DROP VIEW
2025-06-25 05:21:44.702 E           OBJECT_NAME V_EXISTENT
2025-06-25 05:21:44.709 E         - ID 39
2025-06-25 05:21:44.722 E         + ID 35
2025-06-25 05:21:44.735 E           DDL_TRIGGER_NAME DROP_VIEW_AFTER
2025-06-25 05:21:44.742 E           EVENT_TYPE DROP
2025-06-25 05:21:44.753 E           OBJECT_TYPE VIEW
2025-06-25 05:21:44.763 E           DDL_EVENT DROP VIEW
2025-06-25 05:21:44.769 E           OBJECT_NAME V_EXISTENT
2025-06-25 05:21:44.775 E         - ID 40
2025-06-25 05:21:44.788 E         + ID 36
2025-06-25 05:21:44.799 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:44.813 E           EVENT_TYPE DROP
2025-06-25 05:21:44.821 E           OBJECT_TYPE VIEW
2025-06-25 05:21:44.828 E           DDL_EVENT DROP VIEW
2025-06-25 05:21:44.836 E           OBJECT_NAME V_EXISTENT
2025-06-25 05:21:44.842 E         - ID 41
2025-06-25 05:21:44.847 E         + ID 37
2025-06-25 05:21:44.853 E           DDL_TRIGGER_NAME DROP_TRIGGER_BEFORE
2025-06-25 05:21:44.859 E           EVENT_TYPE DROP
2025-06-25 05:21:44.869 E           OBJECT_TYPE TRIGGER
2025-06-25 05:21:44.880 E           DDL_EVENT DROP TRIGGER
2025-06-25 05:21:44.888 E           OBJECT_NAME TG_EXISTENT
2025-06-25 05:21:44.895 E         - ID 42
2025-06-25 05:21:44.903 E         + ID 38
2025-06-25 05:21:44.914 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:44.921 E           EVENT_TYPE DROP
2025-06-25 05:21:44.932 E           OBJECT_TYPE TRIGGER
2025-06-25 05:21:44.942 E           DDL_EVENT DROP TRIGGER
2025-06-25 05:21:44.954 E           OBJECT_NAME TG_EXISTENT
2025-06-25 05:21:44.964 E         - ID 43
2025-06-25 05:21:44.979 E         + ID 39
2025-06-25 05:21:44.991 E           DDL_TRIGGER_NAME DROP_TRIGGER_AFTER
2025-06-25 05:21:44.999 E           EVENT_TYPE DROP
2025-06-25 05:21:45.008 E           OBJECT_TYPE TRIGGER
2025-06-25 05:21:45.018 E           DDL_EVENT DROP TRIGGER
2025-06-25 05:21:45.029 E           OBJECT_NAME TG_EXISTENT
2025-06-25 05:21:45.039 E         - ID 44
2025-06-25 05:21:45.053 E         + ID 40
2025-06-25 05:21:45.071 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:45.082 E           EVENT_TYPE DROP
2025-06-25 05:21:45.091 E           OBJECT_TYPE TRIGGER
2025-06-25 05:21:45.099 E           DDL_EVENT DROP TRIGGER
2025-06-25 05:21:45.107 E           OBJECT_NAME TG_EXISTENT
2025-06-25 05:21:45.118 E         - ID 45
2025-06-25 05:21:45.132 E         + ID 41
2025-06-25 05:21:45.149 E           DDL_TRIGGER_NAME DROP_PROCEDURE_BEFORE
2025-06-25 05:21:45.158 E           EVENT_TYPE DROP
2025-06-25 05:21:45.167 E           OBJECT_TYPE PROCEDURE
2025-06-25 05:21:45.174 E           DDL_EVENT DROP PROCEDURE
2025-06-25 05:21:45.182 E           OBJECT_NAME SP_EXISTENT
2025-06-25 05:21:45.192 E         - ID 46
2025-06-25 05:21:45.206 E         + ID 42
2025-06-25 05:21:45.229 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:45.237 E           EVENT_TYPE DROP
2025-06-25 05:21:45.244 E           OBJECT_TYPE PROCEDURE
2025-06-25 05:21:45.253 E           DDL_EVENT DROP PROCEDURE
2025-06-25 05:21:45.265 E           OBJECT_NAME SP_EXISTENT
2025-06-25 05:21:45.275 E         - ID 47
2025-06-25 05:21:45.296 E         + ID 43
2025-06-25 05:21:45.310 E           DDL_TRIGGER_NAME DROP_PROCEDURE_AFTER
2025-06-25 05:21:45.323 E           EVENT_TYPE DROP
2025-06-25 05:21:45.332 E           OBJECT_TYPE PROCEDURE
2025-06-25 05:21:45.339 E           DDL_EVENT DROP PROCEDURE
2025-06-25 05:21:45.347 E           OBJECT_NAME SP_EXISTENT
2025-06-25 05:21:45.359 E         - ID 48
2025-06-25 05:21:45.373 E         + ID 44
2025-06-25 05:21:45.387 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:45.394 E           EVENT_TYPE DROP
2025-06-25 05:21:45.404 E           OBJECT_TYPE PROCEDURE
2025-06-25 05:21:45.413 E           DDL_EVENT DROP PROCEDURE
2025-06-25 05:21:45.419 E           OBJECT_NAME SP_EXISTENT
2025-06-25 05:21:45.424 E         - ID 49
2025-06-25 05:21:45.439 E         + ID 45
2025-06-25 05:21:45.452 E           DDL_TRIGGER_NAME DROP_FUNCTION_BEFORE
2025-06-25 05:21:45.459 E           EVENT_TYPE DROP
2025-06-25 05:21:45.466 E           OBJECT_TYPE FUNCTION
2025-06-25 05:21:45.472 E           DDL_EVENT DROP FUNCTION
2025-06-25 05:21:45.481 E           OBJECT_NAME FN_EXISTENT
2025-06-25 05:21:45.490 E         - ID 50
2025-06-25 05:21:45.496 E         + ID 46
2025-06-25 05:21:45.503 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:45.509 E           EVENT_TYPE DROP
2025-06-25 05:21:45.515 E           OBJECT_TYPE FUNCTION
2025-06-25 05:21:45.523 E           DDL_EVENT DROP FUNCTION
2025-06-25 05:21:45.533 E           OBJECT_NAME FN_EXISTENT
2025-06-25 05:21:45.541 E         - ID 51
2025-06-25 05:21:45.547 E         + ID 47
2025-06-25 05:21:45.554 E           DDL_TRIGGER_NAME DROP_FUNCTION_AFTER
2025-06-25 05:21:45.563 E           EVENT_TYPE DROP
2025-06-25 05:21:45.570 E           OBJECT_TYPE FUNCTION
2025-06-25 05:21:45.578 E           DDL_EVENT DROP FUNCTION
2025-06-25 05:21:45.586 E           OBJECT_NAME FN_EXISTENT
2025-06-25 05:21:45.593 E         - ID 52
2025-06-25 05:21:45.601 E         + ID 48
2025-06-25 05:21:45.608 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:45.615 E           EVENT_TYPE DROP
2025-06-25 05:21:45.621 E           OBJECT_TYPE FUNCTION
2025-06-25 05:21:45.626 E           DDL_EVENT DROP FUNCTION
2025-06-25 05:21:45.636 E           OBJECT_NAME FN_EXISTENT
2025-06-25 05:21:45.646 E         - ID 53
2025-06-25 05:21:45.655 E         + ID 49
2025-06-25 05:21:45.664 E           DDL_TRIGGER_NAME DROP_PACKAGE_BODY_BEFORE
2025-06-25 05:21:45.672 E           EVENT_TYPE DROP
2025-06-25 05:21:45.679 E           OBJECT_TYPE PACKAGE BODY
2025-06-25 05:21:45.687 E           DDL_EVENT DROP PACKAGE BODY
2025-06-25 05:21:45.697 E           OBJECT_NAME PG_EXISTENT
2025-06-25 05:21:45.705 E         - ID 54
2025-06-25 05:21:45.718 E         + ID 50
2025-06-25 05:21:45.728 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:45.733 E           EVENT_TYPE DROP
2025-06-25 05:21:45.738 E           OBJECT_TYPE PACKAGE BODY
2025-06-25 05:21:45.743 E           DDL_EVENT DROP PACKAGE BODY
2025-06-25 05:21:45.749 E           OBJECT_NAME PG_EXISTENT
2025-06-25 05:21:45.754 E         - ID 55
2025-06-25 05:21:45.777 E         + ID 51
2025-06-25 05:21:45.793 E           DDL_TRIGGER_NAME DROP_PACKAGE_BODY_AFTER
2025-06-25 05:21:45.806 E           EVENT_TYPE DROP
2025-06-25 05:21:45.815 E           OBJECT_TYPE PACKAGE BODY
2025-06-25 05:21:45.824 E           DDL_EVENT DROP PACKAGE BODY
2025-06-25 05:21:45.831 E           OBJECT_NAME PG_EXISTENT
2025-06-25 05:21:45.843 E         - ID 56
2025-06-25 05:21:45.856 E         + ID 52
2025-06-25 05:21:45.871 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:45.883 E           EVENT_TYPE DROP
2025-06-25 05:21:45.893 E           OBJECT_TYPE PACKAGE BODY
2025-06-25 05:21:45.900 E           DDL_EVENT DROP PACKAGE BODY
2025-06-25 05:21:45.908 E           OBJECT_NAME PG_EXISTENT
2025-06-25 05:21:45.915 E         + ID 53
2025-06-25 05:21:45.920 E         + DDL_TRIGGER_NAME ALTER_TABLE_BEFORE
2025-06-25 05:21:45.926 E         + EVENT_TYPE ALTER
2025-06-25 05:21:45.931 E         + OBJECT_TYPE TABLE
2025-06-25 05:21:45.936 E         + DDL_EVENT ALTER TABLE
2025-06-25 05:21:45.941 E         + OBJECT_NAME T_EXISTENT
2025-06-25 05:21:45.945 E         + ID 54
2025-06-25 05:21:45.950 E         + DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:45.960 E         + EVENT_TYPE ALTER
2025-06-25 05:21:45.972 E         + OBJECT_TYPE TABLE
2025-06-25 05:21:45.984 E         + DDL_EVENT ALTER TABLE
2025-06-25 05:21:45.993 E         + OBJECT_NAME T_EXISTENT
2025-06-25 05:21:46.001 E         + ID 55
2025-06-25 05:21:46.008 E         + DDL_TRIGGER_NAME ALTER_TABLE_AFTER
2025-06-25 05:21:46.015 E         + EVENT_TYPE ALTER
2025-06-25 05:21:46.023 E         + OBJECT_TYPE TABLE
2025-06-25 05:21:46.032 E         + DDL_EVENT ALTER TABLE
2025-06-25 05:21:46.040 E         + OBJECT_NAME T_EXISTENT
2025-06-25 05:21:46.047 E         + ID 56
2025-06-25 05:21:46.054 E         + DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:46.060 E         + EVENT_TYPE ALTER
2025-06-25 05:21:46.066 E         + OBJECT_TYPE TABLE
2025-06-25 05:21:46.076 E         + DDL_EVENT ALTER TABLE
2025-06-25 05:21:46.090 E         + OBJECT_NAME T_EXISTENT
2025-06-25 05:21:46.100 E           ID 57
2025-06-25 05:21:46.108 E           DDL_TRIGGER_NAME ALTER_TABLE_BEFORE
2025-06-25 05:21:46.114 E           EVENT_TYPE ALTER
2025-06-25 05:21:46.121 E           OBJECT_TYPE TABLE
2025-06-25 05:21:46.126 E           DDL_EVENT ALTER TABLE
2025-06-25 05:21:46.130 E           OBJECT_NAME T_EXISTENT
2025-06-25 05:21:46.134 E           ID 58
2025-06-25 05:21:46.139 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:46.143 E           EVENT_TYPE ALTER
2025-06-25 05:21:46.148 E           OBJECT_TYPE TABLE
2025-06-25 05:21:46.152 E           DDL_EVENT ALTER TABLE
2025-06-25 05:21:46.157 E           OBJECT_NAME T_EXISTENT
2025-06-25 05:21:46.162 E           ID 59
2025-06-25 05:21:46.166 E           DDL_TRIGGER_NAME ALTER_TABLE_AFTER
2025-06-25 05:21:46.171 E           EVENT_TYPE ALTER
2025-06-25 05:21:46.175 E           OBJECT_TYPE TABLE
2025-06-25 05:21:46.180 E           DDL_EVENT ALTER TABLE
2025-06-25 05:21:46.191 E           OBJECT_NAME T_EXISTENT
2025-06-25 05:21:46.197 E           ID 60
2025-06-25 05:21:46.204 E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:46.210 E           EVENT_TYPE ALTER
2025-06-25 05:21:46.215 E           OBJECT_TYPE TABLE
2025-06-25 05:21:46.220 E           DDL_EVENT ALTER TABLE
2025-06-25 05:21:46.225 E           OBJECT_NAME T_EXISTENT
2025-06-25 05:21:46.231 E         - ID 61
2025-06-25 05:21:46.236 E         - DDL_TRIGGER_NAME ALTER_TABLE_BEFORE
2025-06-25 05:21:46.242 E         - EVENT_TYPE ALTER
2025-06-25 05:21:46.247 E         - OBJECT_TYPE TABLE
2025-06-25 05:21:46.253 E         - DDL_EVENT ALTER TABLE
2025-06-25 05:21:46.259 E         - OBJECT_NAME T_EXISTENT
2025-06-25 05:21:46.266 E         - ID 62
2025-06-25 05:21:46.276 E         - DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
2025-06-25 05:21:46.283 E         - EVENT_TYPE ALTER
2025-06-25 05:21:46.290 E         - OBJECT_TYPE TABLE
2025-06-25 05:21:46.294 E         - DDL_EVENT ALTER TABLE
2025-06-25 05:21:46.299 E         - OBJECT_NAME T_EXISTENT
2025-06-25 05:21:46.303 E         - ID 63
2025-06-25 05:21:46.308 E         - DDL_TRIGGER_NAME ALTER_TABLE_AFTER
2025-06-25 05:21:46.312 E         - EVENT_TYPE ALTER
2025-06-25 05:21:46.316 E         - OBJECT_TYPE TABLE
2025-06-25 05:21:46.321 E         - DDL_EVENT ALTER TABLE
2025-06-25 05:21:46.326 E         - OBJECT_NAME T_EXISTENT
2025-06-25 05:21:46.331 E         - ID 64
2025-06-25 05:21:46.343 E         - DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
2025-06-25 05:21:46.355 E         - EVENT_TYPE ALTER
2025-06-25 05:21:46.363 E         - OBJECT_TYPE TABLE
2025-06-25 05:21:46.371 E         - DDL_EVENT ALTER TABLE
2025-06-25 05:21:46.377 E         - OBJECT_NAME T_EXISTENT
2025-06-25 05:21:46.383 E         - Records affected: 64
2025-06-25 05:21:46.403 E         + Records affected: 60
2025-06-25 05:21:46.424
2025-06-25 05:21:46.434 tests/bugs/gh_4203_test.py:697: AssertionError
2025-06-25 05:21:46.443 ---------------------------- Captured stdout setup -----------------------------
2025-06-25 05:21:46.451 Creating db: localhost:/var/tmp/qa_2024/test_11398/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
3 #text
act = <firebird.qa.plugin.Action pytest object at [hex]>
capsys = <_pytest.capture.CaptureFixture pytest object at [hex]>

    @pytest.mark.version('>=6.0')
    def test_1(act: Action, capsys):
    
        # Scan line-by-line through databases.conf, find line starting with REQUIRED_ALIAS and extract name of file that
        # must be created in the $(dir_sampleDb)/qa/ folder. This name will be used further as target database (tmp_fdb).
        # NOTE: we have to SKIP lines which are commented out, i.e. if they starts with '#':
        p_required_alias_ptn =  re.compile( '^(?!#)((^|\\s+)' + REQUIRED_ALIAS + ')\\s*=\\s*\\$\\(dir_sampleDb\\)/qa/', re.IGNORECASE )
        fname_in_dbconf = None
    
        with open(act.home_dir/'databases.conf', 'r') as f:
            for line in f:
                if p_required_alias_ptn.search(line):
                    # If databases.conf contains line like this:
                    #     tmp_4203_alias = $(dir_sampleDb)/qa/tmp_qa_4203.fdb
                    # - then we extract filename: 'tmp_qa_4203.fdb' (see below):
                    fname_in_dbconf = Path(line.split('=')[1].strip()).name
                    break
    
        # if 'fname_in_dbconf' remains undefined here then propably REQUIRED_ALIAS not equals to specified in the databases.conf!
        #
        assert fname_in_dbconf
    
        check_sql = f"""
            -- DO NOT: set bail on; -- we have to drop database at final point!
            set list on;
            rollback;
            create database '{REQUIRED_ALIAS}';
            commit;
            connect '{REQUIRED_ALIAS}' user {act.db.user};
            select mon$sec_database from mon$database; -- must be: 'Self'
            commit;
    
            create mapping mp_existent using plugin Srp from any user to user;
            create global mapping mg_existent using plugin Srp from any user to user;
            create user u_existent password '123';
            create role r_existent;
            create domain d_existent as int;
            create sequence g_existent;
            create exception e_existent 'foo';
    
            create collation cn_existent for utf8 from unicode;
    
            recreate table log_ddl_triggers_activity (
                id int generated by default as identity constraint pk_log_ddl_triggers_activity primary key
                ,ddl_trigger_name varchar(64)
                ,event_type varchar(25) not null
                ,object_type varchar(25) not null
                ,ddl_event varchar(25) not null
                ,object_name varchar(64) not null
                ,dts timestamp default 'now'
            );
    
            create table t_existent (
                id int primary key
                ,pid int
                ,f01_existent int
                ,f02_existent int
                ,f03_existent int
                ,constraint t_existent_fk foreign key(pid) references t_existent(id) on delete cascade
            );
            create index t_existent_f01 on t_existent(f01_existent);
            create view v_existent as select * from t_existent;
            set term ^;
            create trigger tg_existent for t_existent before insert as
            begin
            end
            ^
            create procedure sp_existent as
            begin
            end
            ^
            create function fn_existent returns int as
            begin
              return 1;
            end
            ^
            create package pg_existent as
            begin
                procedure p;
                function f returns int;
            end
            ^
            create package body pg_existent as
            begin
                procedure p as
                begin
                end
                function f returns int as
                begin
                    return 1;
                end
            end
            ^
            create package pg_empty as
            begin
                procedure p;
                function f returns int;
            end
            ^
            commit
            ^
    
            execute block as
                declare v_lf char(1) = x'0A';
            begin
                rdb$set_context('USER_SESSION', 'SKIP_DDL_TRIGGER', '1');
    
                for
                    with
                    a as (
                        select 'ANY DDL STATEMENT' x from rdb$database union all
                        select 'ALTER TABLE' from rdb$database union all
                        select 'DROP MAPPING' from rdb$database union all
                        select 'DROP TABLE' from rdb$database union all
                        select 'DROP PROCEDURE' from rdb$database union all
                        select 'DROP FUNCTION' from rdb$database union all
                        select 'DROP TRIGGER' from rdb$database union all
                        select 'DROP EXCEPTION' from rdb$database union all
                        select 'DROP VIEW' from rdb$database union all
                        select 'DROP DOMAIN' from rdb$database union all
                        select 'DROP ROLE' from rdb$database union all
                        select 'DROP SEQUENCE' from rdb$database union all
                        select 'DROP USER' from rdb$database union all
                        select 'DROP INDEX' from rdb$database union all
                        select 'DROP COLLATION' from rdb$database union all
                        select 'DROP PACKAGE' from rdb$database union all
                        select 'DROP PACKAGE BODY' from rdb$database
                    )
                    ,e as (
                        select 'before' w from rdb$database union all select 'after' from rdb$database
                    )
                    ,t as (
                        select upper(trim(replace(trim(a.x),' ','_')) || iif(e.w='before', '_before', '_after')) as trg_name, a.x, e.w
                        from e, a
                    )
    
                    select
                           'create trigger trg_' || t.trg_name
                        || ' active ' || t.w || ' ' || trim(t.x) || ' as '
                        || :v_lf
                        || 'begin'
                        || :v_lf
                        || q'!    if (rdb$get_context('USER_SESSION', 'SKIP_DDL_TRIGGER') is null) then!'
                        || :v_lf
                        || '        insert into log_ddl_triggers_activity(ddl_trigger_name, event_type, object_type, ddl_event, object_name) values('
                        || :v_lf
                        || q'!'!' || trim(t.trg_name) || q'!'!'
                        || :v_lf
                        || q'!, rdb$get_context('DDL_TRIGGER', 'EVENT_TYPE')!'
                        || :v_lf
                        || q'!, rdb$get_context('DDL_TRIGGER', 'OBJECT_TYPE')!'
                        || :v_lf
                        || q'!, rdb$get_context('DDL_TRIGGER', 'DDL_EVENT')!'
                        || :v_lf
                        || q'!, rdb$get_context('DDL_TRIGGER', 'OBJECT_NAME')!'
                        || :v_lf
                        || ');'
                        || :v_lf
                        || ' end'
                        as sttm
                    from t
                    as cursor c
                do begin
                     execute statement(c.sttm) with autonomous transaction;
                end
    
                rdb$set_context('USER_SESSION', 'SKIP_DDL_TRIGGER', null);
            end
            ^
            commit
            ^
            set term ;^
    
            --#####################################################################
    
            drop mapping if exists mp_existent;
            drop mapping if exists mp_non_existent;
            drop global mapping if exists mg_existent;
            drop global mapping if exists mg_non_existent;
            drop user if exists u_existent;
            drop user if exists u_non_existent;
            drop role if exists r_existent;
            drop role if exists r_non_existent;
            drop domain if exists d_existent;
            drop domain if exists d_non_existent;
            drop sequence if exists g_existent;
            drop sequence if exists g_non_existent;
            drop collation if exists cn_existent;
            drop collation if exists cn_non_existent;
            drop index if exists t_existent_f01;
    
            -- failed before https://github.com/FirebirdSQL/firebird/commit/a04784d5020326bdd42817eb0c9022b93d364f4a
            drop index if exists t_non_existent_f01;
    
            drop view if exists v_existent;
            drop view if exists v_non_existent;
            drop trigger if exists tg_existent;
            drop trigger if exists tg_non_existent;
            drop procedure if exists sp_existent;
            drop procedure if exists sp_non_existent;
            drop function if exists fn_existent;
            drop function if exists fn_non_existent;
            drop package body if exists pg_existent;
    
            -- failed before https://github.com/FirebirdSQL/firebird/commit/252a675c2adb95aca4fecb42d7433b39f669c20a
            drop package body if exists pg_non_existent;
    
            -- must be logged because column 'f01_existent' DOES exist:
            alter table t_existent
                 drop if exists f01_existent
            ;
    
            -- must NOT be logged because column 'g01_non_existent' does NOT exist:
            alter table t_existent
                 drop if exists g01_non_existent
            ;
    
            -- must be logged because at least one column ('f02_existent') DOES exist:
            alter table t_existent
                 drop if exists g01_non_existent
                ,drop if exists g02_non_existent
                ,drop if exists f02_existent
            ;
    
            commit;
    
            set count on;
            select
                id
                ,ddl_trigger_name
                ,event_type
                ,object_type
                ,ddl_event
                ,object_name
            from log_ddl_triggers_activity
            order by id;
            commit;
    
            connect '{REQUIRED_ALIAS}' user {act.db.user};
            drop database;
            quit;
        """
    
        expected_stdout = f"""
            MON$SEC_DATABASE Self
    
            ID 1
            DDL_TRIGGER_NAME DROP_MAPPING_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE MAPPING
            DDL_EVENT DROP MAPPING
            OBJECT_NAME MP_EXISTENT
            ID 2
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE MAPPING
            DDL_EVENT DROP MAPPING
            OBJECT_NAME MP_EXISTENT
            ID 3
            DDL_TRIGGER_NAME DROP_MAPPING_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE MAPPING
            DDL_EVENT DROP MAPPING
            OBJECT_NAME MP_EXISTENT
            ID 4
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE MAPPING
            DDL_EVENT DROP MAPPING
            OBJECT_NAME MP_EXISTENT
            ID 5
            DDL_TRIGGER_NAME DROP_MAPPING_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE MAPPING
            DDL_EVENT DROP MAPPING
            OBJECT_NAME MG_EXISTENT
            ID 6
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE MAPPING
            DDL_EVENT DROP MAPPING
            OBJECT_NAME MG_EXISTENT
            ID 7
            DDL_TRIGGER_NAME DROP_MAPPING_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE MAPPING
            DDL_EVENT DROP MAPPING
            OBJECT_NAME MG_EXISTENT
            ID 8
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE MAPPING
            DDL_EVENT DROP MAPPING
            OBJECT_NAME MG_EXISTENT
            ID 9
            DDL_TRIGGER_NAME DROP_USER_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE USER
            DDL_EVENT DROP USER
            OBJECT_NAME U_EXISTENT
            ID 10
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE USER
            DDL_EVENT DROP USER
            OBJECT_NAME U_EXISTENT
            ID 11
            DDL_TRIGGER_NAME DROP_USER_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE USER
            DDL_EVENT DROP USER
            OBJECT_NAME U_EXISTENT
            ID 12
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE USER
            DDL_EVENT DROP USER
            OBJECT_NAME U_EXISTENT
            ID 13
            DDL_TRIGGER_NAME DROP_USER_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE USER
            DDL_EVENT DROP USER
            OBJECT_NAME U_NON_EXISTENT
            ID 14
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE USER
            DDL_EVENT DROP USER
            OBJECT_NAME U_NON_EXISTENT
            ID 15
            DDL_TRIGGER_NAME DROP_USER_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE USER
            DDL_EVENT DROP USER
            OBJECT_NAME U_NON_EXISTENT
            ID 16
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE USER
            DDL_EVENT DROP USER
            OBJECT_NAME U_NON_EXISTENT
            ID 17
            DDL_TRIGGER_NAME DROP_ROLE_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE ROLE
            DDL_EVENT DROP ROLE
            OBJECT_NAME R_EXISTENT
            ID 18
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE ROLE
            DDL_EVENT DROP ROLE
            OBJECT_NAME R_EXISTENT
            ID 19
            DDL_TRIGGER_NAME DROP_ROLE_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE ROLE
            DDL_EVENT DROP ROLE
            OBJECT_NAME R_EXISTENT
            ID 20
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE ROLE
            DDL_EVENT DROP ROLE
            OBJECT_NAME R_EXISTENT
            ID 21
            DDL_TRIGGER_NAME DROP_DOMAIN_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE DOMAIN
            DDL_EVENT DROP DOMAIN
            OBJECT_NAME D_EXISTENT
            ID 22
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE DOMAIN
            DDL_EVENT DROP DOMAIN
            OBJECT_NAME D_EXISTENT
            ID 23
            DDL_TRIGGER_NAME DROP_DOMAIN_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE DOMAIN
            DDL_EVENT DROP DOMAIN
            OBJECT_NAME D_EXISTENT
            ID 24
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE DOMAIN
            DDL_EVENT DROP DOMAIN
            OBJECT_NAME D_EXISTENT
            ID 25
            DDL_TRIGGER_NAME DROP_SEQUENCE_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE SEQUENCE
            DDL_EVENT DROP SEQUENCE
            OBJECT_NAME G_EXISTENT
            ID 26
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE SEQUENCE
            DDL_EVENT DROP SEQUENCE
            OBJECT_NAME G_EXISTENT
            ID 27
            DDL_TRIGGER_NAME DROP_SEQUENCE_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE SEQUENCE
            DDL_EVENT DROP SEQUENCE
            OBJECT_NAME G_EXISTENT
            ID 28
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE SEQUENCE
            DDL_EVENT DROP SEQUENCE
            OBJECT_NAME G_EXISTENT
            ID 29
            DDL_TRIGGER_NAME DROP_COLLATION_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE COLLATION
            DDL_EVENT DROP COLLATION
            OBJECT_NAME CN_EXISTENT
            ID 30
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE COLLATION
            DDL_EVENT DROP COLLATION
            OBJECT_NAME CN_EXISTENT
            ID 31
            DDL_TRIGGER_NAME DROP_COLLATION_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE COLLATION
            DDL_EVENT DROP COLLATION
            OBJECT_NAME CN_EXISTENT
            ID 32
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE COLLATION
            DDL_EVENT DROP COLLATION
            OBJECT_NAME CN_EXISTENT
            ID 33
            DDL_TRIGGER_NAME DROP_INDEX_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE INDEX
            DDL_EVENT DROP INDEX
            OBJECT_NAME T_EXISTENT_F01
            ID 34
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE INDEX
            DDL_EVENT DROP INDEX
            OBJECT_NAME T_EXISTENT_F01
            ID 35
            DDL_TRIGGER_NAME DROP_INDEX_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE INDEX
            DDL_EVENT DROP INDEX
            OBJECT_NAME T_EXISTENT_F01
            ID 36
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE INDEX
            DDL_EVENT DROP INDEX
            OBJECT_NAME T_EXISTENT_F01
            ID 37
            DDL_TRIGGER_NAME DROP_VIEW_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE VIEW
            DDL_EVENT DROP VIEW
            OBJECT_NAME V_EXISTENT
            ID 38
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE VIEW
            DDL_EVENT DROP VIEW
            OBJECT_NAME V_EXISTENT
            ID 39
            DDL_TRIGGER_NAME DROP_VIEW_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE VIEW
            DDL_EVENT DROP VIEW
            OBJECT_NAME V_EXISTENT
            ID 40
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE VIEW
            DDL_EVENT DROP VIEW
            OBJECT_NAME V_EXISTENT
            ID 41
            DDL_TRIGGER_NAME DROP_TRIGGER_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE TRIGGER
            DDL_EVENT DROP TRIGGER
            OBJECT_NAME TG_EXISTENT
            ID 42
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE TRIGGER
            DDL_EVENT DROP TRIGGER
            OBJECT_NAME TG_EXISTENT
            ID 43
            DDL_TRIGGER_NAME DROP_TRIGGER_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE TRIGGER
            DDL_EVENT DROP TRIGGER
            OBJECT_NAME TG_EXISTENT
            ID 44
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE TRIGGER
            DDL_EVENT DROP TRIGGER
            OBJECT_NAME TG_EXISTENT
            ID 45
            DDL_TRIGGER_NAME DROP_PROCEDURE_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE PROCEDURE
            DDL_EVENT DROP PROCEDURE
            OBJECT_NAME SP_EXISTENT
            ID 46
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE PROCEDURE
            DDL_EVENT DROP PROCEDURE
            OBJECT_NAME SP_EXISTENT
            ID 47
            DDL_TRIGGER_NAME DROP_PROCEDURE_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE PROCEDURE
            DDL_EVENT DROP PROCEDURE
            OBJECT_NAME SP_EXISTENT
            ID 48
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE PROCEDURE
            DDL_EVENT DROP PROCEDURE
            OBJECT_NAME SP_EXISTENT
            ID 49
            DDL_TRIGGER_NAME DROP_FUNCTION_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE FUNCTION
            DDL_EVENT DROP FUNCTION
            OBJECT_NAME FN_EXISTENT
            ID 50
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE FUNCTION
            DDL_EVENT DROP FUNCTION
            OBJECT_NAME FN_EXISTENT
            ID 51
            DDL_TRIGGER_NAME DROP_FUNCTION_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE FUNCTION
            DDL_EVENT DROP FUNCTION
            OBJECT_NAME FN_EXISTENT
            ID 52
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE FUNCTION
            DDL_EVENT DROP FUNCTION
            OBJECT_NAME FN_EXISTENT
            ID 53
            DDL_TRIGGER_NAME DROP_PACKAGE_BODY_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE PACKAGE BODY
            DDL_EVENT DROP PACKAGE BODY
            OBJECT_NAME PG_EXISTENT
            ID 54
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE DROP
            OBJECT_TYPE PACKAGE BODY
            DDL_EVENT DROP PACKAGE BODY
            OBJECT_NAME PG_EXISTENT
            ID 55
            DDL_TRIGGER_NAME DROP_PACKAGE_BODY_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE PACKAGE BODY
            DDL_EVENT DROP PACKAGE BODY
            OBJECT_NAME PG_EXISTENT
            ID 56
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE DROP
            OBJECT_TYPE PACKAGE BODY
            DDL_EVENT DROP PACKAGE BODY
            OBJECT_NAME PG_EXISTENT
            ID 57
            DDL_TRIGGER_NAME ALTER_TABLE_BEFORE
            EVENT_TYPE ALTER
            OBJECT_TYPE TABLE
            DDL_EVENT ALTER TABLE
            OBJECT_NAME T_EXISTENT
            ID 58
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE ALTER
            OBJECT_TYPE TABLE
            DDL_EVENT ALTER TABLE
            OBJECT_NAME T_EXISTENT
            ID 59
            DDL_TRIGGER_NAME ALTER_TABLE_AFTER
            EVENT_TYPE ALTER
            OBJECT_TYPE TABLE
            DDL_EVENT ALTER TABLE
            OBJECT_NAME T_EXISTENT
            ID 60
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE ALTER
            OBJECT_TYPE TABLE
            DDL_EVENT ALTER TABLE
            OBJECT_NAME T_EXISTENT
            ID 61
            DDL_TRIGGER_NAME ALTER_TABLE_BEFORE
            EVENT_TYPE ALTER
            OBJECT_TYPE TABLE
            DDL_EVENT ALTER TABLE
            OBJECT_NAME T_EXISTENT
            ID 62
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
            EVENT_TYPE ALTER
            OBJECT_TYPE TABLE
            DDL_EVENT ALTER TABLE
            OBJECT_NAME T_EXISTENT
            ID 63
            DDL_TRIGGER_NAME ALTER_TABLE_AFTER
            EVENT_TYPE ALTER
            OBJECT_TYPE TABLE
            DDL_EVENT ALTER TABLE
            OBJECT_NAME T_EXISTENT
            ID 64
            DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
            EVENT_TYPE ALTER
            OBJECT_TYPE TABLE
            DDL_EVENT ALTER TABLE
            OBJECT_NAME T_EXISTENT
    
            Records affected: 64
        """
    
        act.expected_stdout = expected_stdout
    
        act.isql(switches=['-q', act.db.db_path, '-user', act.db.user], input = check_sql, credentials = False, connect_db = False, combine_output = True, io_enc = locale.getpreferredencoding())
    
>       assert act.clean_stdout == act.clean_expected_stdout # and act.clean_stderr == act.clean_expected_stderr
E       assert   
E           MON$SEC_DATABASE Self
E         + Statement failed, SQLSTATE = 42000
E         + unsuccessful metadata update
E         + -CREATE MAPPING MG_EXISTENT failed
E         + -CREATE MAPPING MG_EXISTENT failed
E         + -Dynamic SQL Error
E         + -SQL error code = -504
E         + -CHARACTER SET "UTF8" is not defined
E           ID 1
E           DDL_TRIGGER_NAME DROP_MAPPING_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE MAPPING
E           DDL_EVENT DROP MAPPING
E           OBJECT_NAME MP_EXISTENT
E           ID 2
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE MAPPING
E           DDL_EVENT DROP MAPPING
E           OBJECT_NAME MP_EXISTENT
E           ID 3
E           DDL_TRIGGER_NAME DROP_MAPPING_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE MAPPING
E           DDL_EVENT DROP MAPPING
E           OBJECT_NAME MP_EXISTENT
E           ID 4
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE MAPPING
E           DDL_EVENT DROP MAPPING
E           OBJECT_NAME MP_EXISTENT
E           ID 5
E         - DDL_TRIGGER_NAME DROP_MAPPING_BEFORE
E         + DDL_TRIGGER_NAME DROP_USER_BEFORE
E           EVENT_TYPE DROP
E         - OBJECT_TYPE MAPPING
E         - DDL_EVENT DROP MAPPING
E         + OBJECT_TYPE USER
E         + DDL_EVENT DROP USER
E         - OBJECT_NAME MG_EXISTENT
E         + OBJECT_NAME U_EXISTENT
E           ID 6
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E           EVENT_TYPE DROP
E         - OBJECT_TYPE MAPPING
E         - DDL_EVENT DROP MAPPING
E         + OBJECT_TYPE USER
E         + DDL_EVENT DROP USER
E         - OBJECT_NAME MG_EXISTENT
E         + OBJECT_NAME U_EXISTENT
E           ID 7
E         - DDL_TRIGGER_NAME DROP_MAPPING_AFTER
E         + DDL_TRIGGER_NAME DROP_USER_AFTER
E           EVENT_TYPE DROP
E         - OBJECT_TYPE MAPPING
E         - DDL_EVENT DROP MAPPING
E         + OBJECT_TYPE USER
E         + DDL_EVENT DROP USER
E         - OBJECT_NAME MG_EXISTENT
E         + OBJECT_NAME U_EXISTENT
E           ID 8
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E           EVENT_TYPE DROP
E         - OBJECT_TYPE MAPPING
E         - DDL_EVENT DROP MAPPING
E         + OBJECT_TYPE USER
E         + DDL_EVENT DROP USER
E         - OBJECT_NAME MG_EXISTENT
E         + OBJECT_NAME U_EXISTENT
E           ID 9
E           DDL_TRIGGER_NAME DROP_USER_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE USER
E           DDL_EVENT DROP USER
E         - OBJECT_NAME U_EXISTENT
E         + OBJECT_NAME U_NON_EXISTENT
E           ID 10
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE USER
E           DDL_EVENT DROP USER
E         - OBJECT_NAME U_EXISTENT
E         + OBJECT_NAME U_NON_EXISTENT
E           ID 11
E           DDL_TRIGGER_NAME DROP_USER_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE USER
E           DDL_EVENT DROP USER
E         - OBJECT_NAME U_EXISTENT
E         + OBJECT_NAME U_NON_EXISTENT
E           ID 12
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE USER
E           DDL_EVENT DROP USER
E         - OBJECT_NAME U_EXISTENT
E         + OBJECT_NAME U_NON_EXISTENT
E           ID 13
E         - DDL_TRIGGER_NAME DROP_USER_BEFORE
E         - EVENT_TYPE DROP
E         - OBJECT_TYPE USER
E         - DDL_EVENT DROP USER
E         - OBJECT_NAME U_NON_EXISTENT
E         - ID 14
E         - DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E         - EVENT_TYPE DROP
E         - OBJECT_TYPE USER
E         - DDL_EVENT DROP USER
E         - OBJECT_NAME U_NON_EXISTENT
E         - ID 15
E         - DDL_TRIGGER_NAME DROP_USER_AFTER
E         - EVENT_TYPE DROP
E         - OBJECT_TYPE USER
E         - DDL_EVENT DROP USER
E         - OBJECT_NAME U_NON_EXISTENT
E         - ID 16
E         - DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E         - EVENT_TYPE DROP
E         - OBJECT_TYPE USER
E         - DDL_EVENT DROP USER
E         - OBJECT_NAME U_NON_EXISTENT
E         - ID 17
E           DDL_TRIGGER_NAME DROP_ROLE_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE ROLE
E           DDL_EVENT DROP ROLE
E           OBJECT_NAME R_EXISTENT
E         - ID 18
E         + ID 14
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE ROLE
E           DDL_EVENT DROP ROLE
E           OBJECT_NAME R_EXISTENT
E         - ID 19
E         + ID 15
E           DDL_TRIGGER_NAME DROP_ROLE_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE ROLE
E           DDL_EVENT DROP ROLE
E           OBJECT_NAME R_EXISTENT
E         - ID 20
E         + ID 16
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE ROLE
E           DDL_EVENT DROP ROLE
E           OBJECT_NAME R_EXISTENT
E         - ID 21
E         + ID 17
E           DDL_TRIGGER_NAME DROP_DOMAIN_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE DOMAIN
E           DDL_EVENT DROP DOMAIN
E           OBJECT_NAME D_EXISTENT
E         - ID 22
E         + ID 18
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE DOMAIN
E           DDL_EVENT DROP DOMAIN
E           OBJECT_NAME D_EXISTENT
E         - ID 23
E         + ID 19
E           DDL_TRIGGER_NAME DROP_DOMAIN_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE DOMAIN
E           DDL_EVENT DROP DOMAIN
E           OBJECT_NAME D_EXISTENT
E         - ID 24
E         + ID 20
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE DOMAIN
E           DDL_EVENT DROP DOMAIN
E           OBJECT_NAME D_EXISTENT
E         - ID 25
E         + ID 21
E           DDL_TRIGGER_NAME DROP_SEQUENCE_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE SEQUENCE
E           DDL_EVENT DROP SEQUENCE
E           OBJECT_NAME G_EXISTENT
E         - ID 26
E         + ID 22
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE SEQUENCE
E           DDL_EVENT DROP SEQUENCE
E           OBJECT_NAME G_EXISTENT
E         - ID 27
E         + ID 23
E           DDL_TRIGGER_NAME DROP_SEQUENCE_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE SEQUENCE
E           DDL_EVENT DROP SEQUENCE
E           OBJECT_NAME G_EXISTENT
E         - ID 28
E         + ID 24
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE SEQUENCE
E           DDL_EVENT DROP SEQUENCE
E           OBJECT_NAME G_EXISTENT
E         - ID 29
E         + ID 25
E           DDL_TRIGGER_NAME DROP_COLLATION_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE COLLATION
E           DDL_EVENT DROP COLLATION
E           OBJECT_NAME CN_EXISTENT
E         - ID 30
E         + ID 26
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE COLLATION
E           DDL_EVENT DROP COLLATION
E           OBJECT_NAME CN_EXISTENT
E         - ID 31
E         + ID 27
E           DDL_TRIGGER_NAME DROP_COLLATION_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE COLLATION
E           DDL_EVENT DROP COLLATION
E           OBJECT_NAME CN_EXISTENT
E         - ID 32
E         + ID 28
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE COLLATION
E           DDL_EVENT DROP COLLATION
E           OBJECT_NAME CN_EXISTENT
E         - ID 33
E         + ID 29
E           DDL_TRIGGER_NAME DROP_INDEX_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE INDEX
E           DDL_EVENT DROP INDEX
E           OBJECT_NAME T_EXISTENT_F01
E         - ID 34
E         + ID 30
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE INDEX
E           DDL_EVENT DROP INDEX
E           OBJECT_NAME T_EXISTENT_F01
E         - ID 35
E         + ID 31
E           DDL_TRIGGER_NAME DROP_INDEX_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE INDEX
E           DDL_EVENT DROP INDEX
E           OBJECT_NAME T_EXISTENT_F01
E         - ID 36
E         + ID 32
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE INDEX
E           DDL_EVENT DROP INDEX
E           OBJECT_NAME T_EXISTENT_F01
E         - ID 37
E         + ID 33
E           DDL_TRIGGER_NAME DROP_VIEW_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE VIEW
E           DDL_EVENT DROP VIEW
E           OBJECT_NAME V_EXISTENT
E         - ID 38
E         + ID 34
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE VIEW
E           DDL_EVENT DROP VIEW
E           OBJECT_NAME V_EXISTENT
E         - ID 39
E         + ID 35
E           DDL_TRIGGER_NAME DROP_VIEW_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE VIEW
E           DDL_EVENT DROP VIEW
E           OBJECT_NAME V_EXISTENT
E         - ID 40
E         + ID 36
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE VIEW
E           DDL_EVENT DROP VIEW
E           OBJECT_NAME V_EXISTENT
E         - ID 41
E         + ID 37
E           DDL_TRIGGER_NAME DROP_TRIGGER_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE TRIGGER
E           DDL_EVENT DROP TRIGGER
E           OBJECT_NAME TG_EXISTENT
E         - ID 42
E         + ID 38
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE TRIGGER
E           DDL_EVENT DROP TRIGGER
E           OBJECT_NAME TG_EXISTENT
E         - ID 43
E         + ID 39
E           DDL_TRIGGER_NAME DROP_TRIGGER_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE TRIGGER
E           DDL_EVENT DROP TRIGGER
E           OBJECT_NAME TG_EXISTENT
E         - ID 44
E         + ID 40
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE TRIGGER
E           DDL_EVENT DROP TRIGGER
E           OBJECT_NAME TG_EXISTENT
E         - ID 45
E         + ID 41
E           DDL_TRIGGER_NAME DROP_PROCEDURE_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE PROCEDURE
E           DDL_EVENT DROP PROCEDURE
E           OBJECT_NAME SP_EXISTENT
E         - ID 46
E         + ID 42
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE PROCEDURE
E           DDL_EVENT DROP PROCEDURE
E           OBJECT_NAME SP_EXISTENT
E         - ID 47
E         + ID 43
E           DDL_TRIGGER_NAME DROP_PROCEDURE_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE PROCEDURE
E           DDL_EVENT DROP PROCEDURE
E           OBJECT_NAME SP_EXISTENT
E         - ID 48
E         + ID 44
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE PROCEDURE
E           DDL_EVENT DROP PROCEDURE
E           OBJECT_NAME SP_EXISTENT
E         - ID 49
E         + ID 45
E           DDL_TRIGGER_NAME DROP_FUNCTION_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE FUNCTION
E           DDL_EVENT DROP FUNCTION
E           OBJECT_NAME FN_EXISTENT
E         - ID 50
E         + ID 46
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE FUNCTION
E           DDL_EVENT DROP FUNCTION
E           OBJECT_NAME FN_EXISTENT
E         - ID 51
E         + ID 47
E           DDL_TRIGGER_NAME DROP_FUNCTION_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE FUNCTION
E           DDL_EVENT DROP FUNCTION
E           OBJECT_NAME FN_EXISTENT
E         - ID 52
E         + ID 48
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE FUNCTION
E           DDL_EVENT DROP FUNCTION
E           OBJECT_NAME FN_EXISTENT
E         - ID 53
E         + ID 49
E           DDL_TRIGGER_NAME DROP_PACKAGE_BODY_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE PACKAGE BODY
E           DDL_EVENT DROP PACKAGE BODY
E           OBJECT_NAME PG_EXISTENT
E         - ID 54
E         + ID 50
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E           EVENT_TYPE DROP
E           OBJECT_TYPE PACKAGE BODY
E           DDL_EVENT DROP PACKAGE BODY
E           OBJECT_NAME PG_EXISTENT
E         - ID 55
E         + ID 51
E           DDL_TRIGGER_NAME DROP_PACKAGE_BODY_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE PACKAGE BODY
E           DDL_EVENT DROP PACKAGE BODY
E           OBJECT_NAME PG_EXISTENT
E         - ID 56
E         + ID 52
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E           EVENT_TYPE DROP
E           OBJECT_TYPE PACKAGE BODY
E           DDL_EVENT DROP PACKAGE BODY
E           OBJECT_NAME PG_EXISTENT
E         + ID 53
E         + DDL_TRIGGER_NAME ALTER_TABLE_BEFORE
E         + EVENT_TYPE ALTER
E         + OBJECT_TYPE TABLE
E         + DDL_EVENT ALTER TABLE
E         + OBJECT_NAME T_EXISTENT
E         + ID 54
E         + DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E         + EVENT_TYPE ALTER
E         + OBJECT_TYPE TABLE
E         + DDL_EVENT ALTER TABLE
E         + OBJECT_NAME T_EXISTENT
E         + ID 55
E         + DDL_TRIGGER_NAME ALTER_TABLE_AFTER
E         + EVENT_TYPE ALTER
E         + OBJECT_TYPE TABLE
E         + DDL_EVENT ALTER TABLE
E         + OBJECT_NAME T_EXISTENT
E         + ID 56
E         + DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E         + EVENT_TYPE ALTER
E         + OBJECT_TYPE TABLE
E         + DDL_EVENT ALTER TABLE
E         + OBJECT_NAME T_EXISTENT
E           ID 57
E           DDL_TRIGGER_NAME ALTER_TABLE_BEFORE
E           EVENT_TYPE ALTER
E           OBJECT_TYPE TABLE
E           DDL_EVENT ALTER TABLE
E           OBJECT_NAME T_EXISTENT
E           ID 58
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E           EVENT_TYPE ALTER
E           OBJECT_TYPE TABLE
E           DDL_EVENT ALTER TABLE
E           OBJECT_NAME T_EXISTENT
E           ID 59
E           DDL_TRIGGER_NAME ALTER_TABLE_AFTER
E           EVENT_TYPE ALTER
E           OBJECT_TYPE TABLE
E           DDL_EVENT ALTER TABLE
E           OBJECT_NAME T_EXISTENT
E           ID 60
E           DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E           EVENT_TYPE ALTER
E           OBJECT_TYPE TABLE
E           DDL_EVENT ALTER TABLE
E           OBJECT_NAME T_EXISTENT
E         - ID 61
E         - DDL_TRIGGER_NAME ALTER_TABLE_BEFORE
E         - EVENT_TYPE ALTER
E         - OBJECT_TYPE TABLE
E         - DDL_EVENT ALTER TABLE
E         - OBJECT_NAME T_EXISTENT
E         - ID 62
E         - DDL_TRIGGER_NAME ANY_DDL_STATEMENT_BEFORE
E         - EVENT_TYPE ALTER
E         - OBJECT_TYPE TABLE
E         - DDL_EVENT ALTER TABLE
E         - OBJECT_NAME T_EXISTENT
E         - ID 63
E         - DDL_TRIGGER_NAME ALTER_TABLE_AFTER
E         - EVENT_TYPE ALTER
E         - OBJECT_TYPE TABLE
E         - DDL_EVENT ALTER TABLE
E         - OBJECT_NAME T_EXISTENT
E         - ID 64
E         - DDL_TRIGGER_NAME ANY_DDL_STATEMENT_AFTER
E         - EVENT_TYPE ALTER
E         - OBJECT_TYPE TABLE
E         - DDL_EVENT ALTER TABLE
E         - OBJECT_NAME T_EXISTENT
E         - Records affected: 64
E         + Records affected: 60

tests/bugs/gh_4203_test.py:697: AssertionError
Full history of outcomes and elapsed time, ms:
NN SNAP_INFO CS_outcome SS_outcome CS_run_time SS_run_time CS_run_beg CS_run_end SS_run_beg SS_run_end
1 6.0.0.877 2025.06.26 8e38f P P 1640 2116 2025.06.27 01:28:41.140 2025.06.27 01:28:42.780 2025.06.26 22:54:54.059 2025.06.26 22:54:56.175
2 6.0.0.876 2025.06.25 b1bec P P 1586 1996 2025.06.26 01:32:32.740 2025.06.26 01:32:34.326 2025.06.25 22:56:44.026 2025.06.25 22:56:46.022
3 6.0.0.863 2025.06.24 c3c20 F F 1704 2078 2025.06.25 01:32:44.070 2025.06.25 01:32:45.774 2025.06.24 22:56:47.832 2025.06.24 22:56:49.910
4 6.0.0.858 2025.06.23 8d6f7 F F 1590 2010 2025.06.24 01:33:15.320 2025.06.24 01:33:16.910 2025.06.23 22:56:47.858 2025.06.23 22:56:49.868
5 6.0.0.849 2025.06.20 7b79c F F 1628 1671 2025.06.21 01:44:41.359 2025.06.21 01:44:42.987 2025.06.20 23:05:20.414 2025.06.20 23:05:22.085
6 6.0.0.848 2025.06.19 c483c F F 1612 1690 2025.06.20 01:41:00.755 2025.06.20 01:41:02.367 2025.06.19 23:02:27.230 2025.06.19 23:02:28.920
7 6.0.0.845 2025.06.18 22b12 F F 1593 2072 2025.06.19 01:49:26.131 2025.06.19 01:49:27.724 2025.06.18 23:04:52.723 2025.06.18 23:04:54.795
8 6.0.0.843 2025.06.16 995f4 F F 1737 1445 2025.06.18 01:47:45.963 2025.06.18 01:47:47.700 2025.06.17 23:06:57.670 2025.06.17 23:06:59.115
9 6.0.0.840 2025.06.14 29bca F F 1653 2034 2025.06.16 01:39:27.454 2025.06.16 01:39:29.107 2025.06.15 22:59:53.908 2025.06.15 22:59:55.942
10 6.0.0.838 2025.06.13 0e28a F F 1920 1973 2025.06.14 01:51:59.352 2025.06.14 01:52:01.272 2025.06.13 23:06:45.303 2025.06.13 23:06:47.276
11 6.0.0.835 2025.06.12 2cf29 F F 1720 2204 2025.06.13 01:52:43.386 2025.06.13 01:52:45.106 2025.06.12 23:11:06.079 2025.06.12 23:11:08.283
12 6.0.0.834 2025.06.11 e889f F F 1610 2038 2025.06.12 01:47:26.073 2025.06.12 01:47:27.683 2025.06.11 23:07:22.681 2025.06.11 23:07:24.719
13 6.0.0.800 2025.06.10 1f226 P P 1702 2048 2025.06.11 00:13:25.337 2025.06.11 00:13:27.039 2025.06.10 22:05:16.911 2025.06.10 22:05:18.959
14 6.0.0.799 2025.06.07 be644 P P 1770 1567 2025.06.10 00:13:34.584 2025.06.10 00:13:36.354 2025.06.09 22:04:53.588 2025.06.09 22:04:55.155
15 6.0.0.797 2025.06.06 303e8 P P 2133 1712 2025.06.07 00:17:11.617 2025.06.07 00:17:13.750 2025.06.06 22:03:53.095 2025.06.06 22:03:54.807
16 6.0.0.795 2025.05.29 7a71a P P 1655 1665 2025.06.06 00:13:31.033 2025.06.06 00:13:32.688 2025.06.05 22:03:04.949 2025.06.05 22:03:06.614
17 6.0.0.792 2025.05.28 b4327 P P 2707 1615 2025.05.29 00:23:59.028 2025.05.29 00:24:01.735 2025.05.28 22:04:33.256 2025.05.28 22:04:34.871
18 6.0.0.791 2025.05.27 02db8 P P 1536 1461 2025.05.28 00:22:19.522 2025.05.28 00:22:21.058 2025.05.27 22:04:15.044 2025.05.27 22:04:16.505
19 6.0.0.789 2025.05.21 64051 P P 1620 1670 2025.05.25 00:16:48.159 2025.05.25 00:16:49.779 2025.05.24 22:03:38.550 2025.05.24 22:03:40.220
20 6.0.0.787 2025.05.20 230ad P P 1797 1596 2025.05.21 00:12:59.486 2025.05.21 00:13:01.283 2025.05.20 22:02:41.728 2025.05.20 22:02:43.324
21 6.0.0.783 2025.05.12 37320 P P 1721 1388 2025.05.19 11:47:12.953 2025.05.19 11:47:14.674 2025.05.19 09:53:58.082 2025.05.19 09:53:59.470
22 6.0.0.779 2025.05.11 136fa P P 2557 1598 2025.05.12 00:09:42.805 2025.05.12 00:09:45.362 2025.05.11 22:02:06.681 2025.05.11 22:02:08.279
23 6.0.0.778 2025.05.07 d735e P P 2580 1643 2025.05.08 00:10:04.746 2025.05.08 00:10:07.326 2025.05.07 22:01:20.967 2025.05.07 22:01:22.610
24 6.0.0.776 2025.05.06 007cd P P 1442 1309 2025.05.07 00:05:44.984 2025.05.07 00:05:46.426 2025.05.06 22:00:57.984 2025.05.06 22:00:59.293
25 6.0.0.770 2025.05.05 82c4a P P 1822 1534 2025.05.06 00:04:36.799 2025.05.06 00:04:38.621 2025.05.05 22:00:52.800 2025.05.05 22:00:54.334
26 6.0.0.767 2025.05.01 cdd29 P P 1549 1520 2025.05.02 00:02:14.494 2025.05.02 00:02:16.043 2025.05.01 22:00:39.394 2025.05.01 22:00:40.914
27 6.0.0.762 2025.04.30 5cb15 P P 1598 1520 2025.04.30 23:58:20.804 2025.04.30 23:58:22.402 2025.04.30 21:59:53.010 2025.04.30 21:59:54.530
28 6.0.0.755 2025.04.29 739c6 P P 1544 1533 2025.04.30 00:00:38.007 2025.04.30 00:00:39.551 2025.04.29 22:00:44.138 2025.04.29 22:00:45.671
29 6.0.0.753 2025.04.27 29ab3 P P 1555 1585 2025.04.28 00:02:39.835 2025.04.28 00:02:41.390 2025.04.27 22:00:22.612 2025.04.27 22:00:24.197
30 6.0.0.745 2025.04.21 78ad8 P P 1708 1583 2025.04.25 23:59:13.775 2025.04.25 23:59:15.483 2025.04.25 22:01:48.814 2025.04.25 22:01:50.397
31 6.0.0.744 2025.04.19 e883a P P 2211 1533 2025.04.20 00:01:17.194 2025.04.20 00:01:19.405 2025.04.19 22:00:51.512 2025.04.19 22:00:53.045
32 6.0.0.742 2025.04.17 abc3b P P 1800 1487 2025.04.19 00:02:59.047 2025.04.19 00:03:00.847 2025.04.18 22:00:51.138 2025.04.18 22:00:52.625
33 6.0.0.737 2025.04.16 fe52b P P 1702 1349 2025.04.17 00:00:51.118 2025.04.17 00:00:52.820 2025.04.16 22:00:40.569 2025.04.16 22:00:41.918
34 6.0.0.736 2025.04.14 3e6be P P 1644 1511 2025.04.14 23:44:00.759 2025.04.14 23:44:02.403 2025.04.14 21:56:51.564 2025.04.14 21:56:53.075
35 6.0.0.735 2025.04.13 6635c P P 1699 1435 2025.04.13 23:45:47.659 2025.04.13 23:45:49.358 2025.04.13 21:57:32.267 2025.04.13 21:57:33.702
36 6.0.0.734 2025.04.12 12f3f P P 2055 1489 2025.04.12 23:44:50.077 2025.04.12 23:44:52.132 2025.04.12 21:56:55.400 2025.04.12 21:56:56.889
37 6.0.0.730 2025.04.11 240b8 P P 1525 1296 2025.04.11 23:46:31.093 2025.04.11 23:46:32.618 2025.04.11 21:56:30.664 2025.04.11 21:56:31.960
38 6.0.0.726 2025.04.10 d79c6 P P 1757 1538 2025.04.10 23:45:18.676 2025.04.10 23:45:20.433 2025.04.10 21:56:41.175 2025.04.10 21:56:42.713
39 6.0.0.725 2025.04.09 a2b05 P P 1773 1564 2025.04.09 23:46:05.202 2025.04.09 23:46:06.975 2025.04.09 21:57:47.539 2025.04.09 21:57:49.103
40 6.0.0.722 2025.04.08 a8b86 P P 2219 1541 2025.04.09 00:00:23.586 2025.04.09 00:00:25.805 2025.04.08 22:00:35.444 2025.04.08 22:00:36.985
41 6.0.0.719 2025.04.06 90fd9 P P 1944 1832 2025.04.06 23:57:51.233 2025.04.06 23:57:53.177 2025.04.06 22:00:15.888 2025.04.06 22:00:17.720
42 6.0.0.717 2025.04.04 53d70 P P 1598 1620 2025.04.04 23:53:49.928 2025.04.04 23:53:51.526 2025.04.04 21:59:47.543 2025.04.04 21:59:49.163
43 6.0.0.716 2025.04.03 fc636 P P 2413 1751 2025.04.03 23:58:37.678 2025.04.03 23:58:40.091 2025.04.03 22:00:14.945 2025.04.03 22:00:16.696
44 6.0.0.715 2025.04.02 907ed P P 1664 1503 2025.04.02 23:57:45.611 2025.04.02 23:57:47.275 2025.04.02 22:00:50.542 2025.04.02 22:00:52.045
45 6.0.0.710 2025.04.01 40651 P P 2400 1402 2025.04.01 23:57:09.286 2025.04.01 23:57:11.686 2025.04.01 22:00:00.483 2025.04.01 22:00:01.885
46 6.0.0.708 2025.03.31 cb069 P P 1562 1440 2025.03.31 23:49:06.272 2025.03.31 23:49:07.834 2025.03.31 21:57:30.551 2025.03.31 21:57:31.991
47 6.0.0.707 2025.03.28 4bd4f P P 1614 1546 2025.03.30 23:47:36.441 2025.03.30 23:47:38.055 2025.03.30 21:57:45.836 2025.03.30 21:57:47.382
48 6.0.0.698 2025.03.26 d72a7 P P 1400 1207 2025.03.28 00:07:40.363 2025.03.28 00:07:41.763 2025.03.27 22:00:17.999 2025.03.27 22:00:19.206
49 6.0.0.693 2025.03.24 0b559 P P 1833 1298 2025.03.24 23:55:19.650 2025.03.24 23:55:21.483 2025.03.24 21:59:07.724 2025.03.24 21:59:09.022
50 6.0.0.687 2025.03.22 730aa P P 2449 1513 2025.03.24 00:06:20.382 2025.03.24 00:06:22.831 2025.03.23 22:02:39.666 2025.03.23 22:02:41.179
51 6.0.0.686 2025.03.20 71bf6 P P 2652 1549 2025.03.21 00:10:53.710 2025.03.21 00:10:56.362 2025.03.20 22:03:59.662 2025.03.20 22:04:01.211
52 6.0.0.685 2025.03.19 a8577 P P 2363 1432 2025.03.20 00:10:34.594 2025.03.20 00:10:36.957 2025.03.19 22:02:33.601 2025.03.19 22:02:35.033
53 6.0.0.680 2025.03.18 90d29 P P 931 465 2025.03.19 10:35:21.624 2025.03.19 10:35:22.555 2025.03.19 08:51:54.167 2025.03.19 08:51:54.632
54 6.0.0.677 2025.03.16 c0a60 P P 721 499 2025.03.17 00:03:08.867 2025.03.17 00:03:09.588 2025.03.16 22:02:46.297 2025.03.16 22:02:46.796
55 6.0.0.676 2025.03.15 3034f P P 969 441 2025.03.16 15:37:04.761 2025.03.16 15:37:05.730 2025.03.16 13:57:03.701 2025.03.16 13:57:04.142
56 6.0.0.673 2025.03.13 40f5b P P 742 540 2025.03.14 00:02:25.786 2025.03.14 00:02:26.528 2025.03.13 22:01:51.647 2025.03.13 22:01:52.187
57 6.0.0.671 2025.03.12 a4fff P P 755 450 2025.03.13 00:06:09.589 2025.03.13 00:06:10.344 2025.03.12 22:03:23.267 2025.03.12 22:03:23.717
58 6.0.0.663 2025.03.11 daad2 P P 713 512 2025.03.12 00:03:43.647 2025.03.12 00:03:44.360 2025.03.11 22:03:13.334 2025.03.11 22:03:13.846
59 6.0.0.661 2025.03.07 b9869 P P 723 564 2025.03.10 23:44:58.407 2025.03.10 23:44:59.130 2025.03.10 21:59:02.170 2025.03.10 21:59:02.734
60 6.0.0.660 2025.03.04 a6700 P P 652 574 2025.03.06 23:53:54.011 2025.03.06 23:53:54.663 2025.03.06 22:00:24.778 2025.03.06 22:00:25.352
61 6.0.0.658 2025.03.03 f15f8 P P 629 526 2025.03.03 23:48:27.194 2025.03.03 23:48:27.823 2025.03.03 21:59:06.172 2025.03.03 21:59:06.698
62 6.0.0.656 2025.02.27 25fb4 P P 787 507 2025.03.03 00:13:14.640 2025.03.03 00:13:15.427 2025.03.02 22:04:54.272 2025.03.02 22:04:54.779
63 6.0.0.655 2025.02.25 6e3e0 P P 687 467 2025.02.26 23:53:16.646 2025.02.26 23:53:17.333 2025.02.26 21:59:55.289 2025.02.26 21:59:55.756
64 6.0.0.654 2025.02.24 b7141 P P 753 473 2025.02.24 23:54:57.162 2025.02.24 23:54:57.915 2025.02.24 22:00:32.094 2025.02.24 22:00:32.567
65 6.0.0.652 2025.02.22 22662 P P 906 456 2025.02.24 07:11:49.372 2025.02.24 07:11:50.278 2025.02.24 00:16:16.271 2025.02.24 00:16:16.727
66 6.0.0.647 2025.02.21 9fccb P P 665 467 2025.02.21 23:55:31.612 2025.02.21 23:55:32.277 2025.02.21 22:04:10.981 2025.02.21 22:04:11.448
67 6.0.0.640 2025.02.19 9b8ac P P 1311 473 2025.02.19 23:55:07.154 2025.02.19 23:55:08.465 2025.02.19 21:59:45.086 2025.02.19 21:59:45.559
68 6.0.0.639 2025.02.18 201a4 P P 704 479 2025.02.18 23:48:37.106 2025.02.18 23:48:37.810 2025.02.18 21:59:31.548 2025.02.18 21:59:32.027
69 6.0.0.637 2025.02.12 6d0f5 P P 692 551 2025.02.14 00:04:28.359 2025.02.14 00:04:29.051 2025.02.13 22:02:24.385 2025.02.13 22:02:24.936
70 6.0.0.636 2025.02.11 0424f P P 1349 497 2025.02.12 00:01:48.098 2025.02.12 00:01:49.447 2025.02.11 22:02:01.088 2025.02.11 22:02:01.585
71 6.0.0.635 2025.02.10 f640f P P 773 561 2025.02.11 00:00:15.830 2025.02.11 00:00:16.603 2025.02.10 22:02:46.133 2025.02.10 22:02:46.694
72 6.0.0.629 2025.02.07 194f9 P P 806 518 2025.02.07 23:58:40.044 2025.02.07 23:58:40.850 2025.02.07 22:01:48.836 2025.02.07 22:01:49.354
73 6.0.0.628 2025.02.06 859d5 P P 1349 675 2025.02.07 00:13:23.919 2025.02.07 00:13:25.268 2025.02.06 22:07:46.678 2025.02.06 22:07:47.353
74 6.0.0.621 2025.02.05 34fe7 P P 1234 583 2025.02.06 00:11:28.074 2025.02.06 00:11:29.308 2025.02.05 22:08:04.091 2025.02.05 22:08:04.674
75 6.0.0.609 2025.02.04 76d57 P P 748 585 2025.02.05 00:04:07.067 2025.02.05 00:04:07.815 2025.02.04 22:07:35.706 2025.02.04 22:07:36.291
76 6.0.0.607 2025.02.03 1985b P P 720 516 2025.02.04 00:03:32.123 2025.02.04 00:03:32.843 2025.02.03 22:07:42.578 2025.02.03 22:07:43.094
77 6.0.0.601 2025.02.01 6af07 P P 700 493 2025.02.01 23:57:11.226 2025.02.01 23:57:11.926 2025.02.01 22:01:13.619 2025.02.01 22:01:14.112
78 6.0.0.600 2025.01.27 188de P P 1417 467 2025.01.28 00:04:35.646 2025.01.28 00:04:37.063 2025.01.27 22:02:00.712 2025.01.27 22:02:01.179
79 6.0.0.599 2025.01.25 ba588 P P 835 564 2025.01.26 00:04:02.308 2025.01.26 00:04:03.143 2025.01.25 22:02:26.399 2025.01.25 22:02:26.963
80 6.0.0.598 2025.01.23 ddbc3 P P 696 494 2025.01.25 00:03:50.839 2025.01.25 00:03:51.535 2025.01.24 22:01:30.274 2025.01.24 22:01:30.768
81 6.0.0.595 2025.01.22 e62f3 P P 1312 457 2025.01.22 23:55:39.830 2025.01.22 23:55:41.142 2025.01.22 22:00:21.759 2025.01.22 22:00:22.216
82 6.0.0.594 2025.01.21 47fb6 P P 1152 476 2025.01.21 23:52:28.706 2025.01.21 23:52:29.858 2025.01.21 22:00:10.745 2025.01.21 22:00:11.221
83 6.0.0.590 2025.01.20 9dc1e P P 1323 582 2025.01.21 00:00:18.562 2025.01.21 00:00:19.885 2025.01.20 22:01:34.364 2025.01.20 22:01:34.946
84 6.0.0.588 2025.01.19 b1c4e P P 612 514 2025.01.19 23:55:51.402 2025.01.19 23:55:52.014 2025.01.19 22:01:30.181 2025.01.19 22:01:30.695
85 6.0.0.587 2025.01.18 63e6e P P 860 503 2025.01.19 00:01:09.047 2025.01.19 00:01:09.907 2025.01.18 22:02:18.449 2025.01.18 22:02:18.952
86 6.0.0.585 2025.01.16 2d6bb P P 727 522 2025.01.17 23:53:23.790 2025.01.17 23:53:24.517 2025.01.17 22:00:44.415 2025.01.17 22:00:44.937
87 6.0.0.584 2025.01.15 a0aa2 P P 708 507 2025.01.15 23:58:59.067 2025.01.15 23:58:59.775 2025.01.15 22:01:52.111 2025.01.15 22:01:52.618
88 6.0.0.581 2025.01.14 21e9e P P 649 519 2025.01.14 23:59:37.439 2025.01.14 23:59:38.088 2025.01.14 22:01:23.383 2025.01.14 22:01:23.902
89 6.0.0.577 2025.01.13 7e293 P P 693 483 2025.01.14 00:01:38.522 2025.01.14 00:01:39.215 2025.01.13 22:01:28.225 2025.01.13 22:01:28.708
90 6.0.0.576 2025.01.12 05898 P P 704 524 2025.01.12 23:57:13.923 2025.01.12 23:57:14.627 2025.01.12 22:00:45.606 2025.01.12 22:00:46.130
91 6.0.0.573 2025.01.10 c20f3 P P 730 507 2025.01.10 23:57:13.969 2025.01.10 23:57:14.699 2025.01.10 22:01:19.989 2025.01.10 22:01:20.496
92 6.0.0.571 2024.12.31 81bba P P 614 366 2024.12.31 23:36:50.312 2024.12.31 23:36:50.926 2024.12.31 21:51:01.389 2024.12.31 21:51:01.755
93 6.0.0.570 2024.12.30 c3c8d P P 1226 355 2024.12.30 23:36:41.704 2024.12.30 23:36:42.930 2024.12.30 21:51:08.226 2024.12.30 21:51:08.581
94 6.0.0.565 2024.12.28 5fc59 P P 673 366 2024.12.30 12:13:58.441 2024.12.30 12:13:59.114 2024.12.30 10:59:42.413 2024.12.30 10:59:42.779
95 6.0.0.564 2024.12.26 12514 P P 593 361 2024.12.26 23:37:22.606 2024.12.26 23:37:23.199 2024.12.26 21:51:01.346 2024.12.26 21:51:01.707
96 6.0.0.560 2024.12.25 fa83e P P 1281 350 2024.12.25 23:27:26.854 2024.12.25 23:27:28.135 2024.12.25 21:50:58.447 2024.12.25 21:50:58.797
97 6.0.0.559 2024.12.23 cc800 P P 1135 352 2024.12.24 23:29:35.075 2024.12.24 23:29:36.210 2024.12.24 21:51:22.680 2024.12.24 21:51:23.032
98 6.0.0.556 2024.12.22 a0404 P P 683 366 2024.12.22 23:38:12.140 2024.12.22 23:38:12.823 2024.12.22 21:51:11.202 2024.12.22 21:51:11.568
99 6.0.0.555 2024.12.19 6990a P P 603 373 2024.12.21 12:49:51.321 2024.12.21 12:49:51.924 2024.12.21 11:36:01.992 2024.12.21 11:36:02.365
100 6.0.0.553 2024.12.17 d1f8a P P 1168 338 2024.12.17 23:29:39.275 2024.12.17 23:29:40.443 2024.12.17 21:51:41.723 2024.12.17 21:51:42.061
101 6.0.0.552 2024.12.11 85e25 P P 1037 352 2024.12.15 23:37:36.742 2024.12.15 23:37:37.779 2024.12.15 21:51:25.039 2024.12.15 21:51:25.391
102 6.0.0.550 2024.12.10 b37ac P P 1348 331 2024.12.10 23:31:01.999 2024.12.10 23:31:03.347 2024.12.10 21:52:29.210 2024.12.10 21:52:29.541
103 6.0.0.548 2024.12.08 2cc77 P P 1080 387 2024.12.08 23:25:04.434 2024.12.08 23:25:05.514 2024.12.08 21:50:35.169 2024.12.08 21:50:35.556
104 6.0.0.544 2024.12.05 96943 P P 1086 358 2024.12.05 23:30:00.234 2024.12.05 23:30:01.320 2024.12.05 21:53:24.023 2024.12.05 21:53:24.381
105 6.0.0.543 2024.12.03 30b77 P P 639 358 2024.12.03 23:30:54.981 2024.12.03 23:30:55.620 2024.12.03 21:52:10.353 2024.12.03 21:52:10.711
106 6.0.0.540 2024.12.02 4a1f4 P P 1188 347 2024.12.02 23:29:25.407 2024.12.02 23:29:26.595 2024.12.02 21:51:31.792 2024.12.02 21:51:32.139
107 6.0.0.539 2024.11.28 1f283 P P 1254 342 2024.11.29 23:40:02.487 2024.11.29 23:40:03.741 2024.11.29 21:51:56.304 2024.11.29 21:51:56.646
108 6.0.0.535 2024.11.26 77b95 P P 1113 333 2024.11.26 23:20:23.134 2024.11.26 23:20:24.247 2024.11.26 21:49:59.427 2024.11.26 21:49:59.760
109 6.0.0.534 2024.11.25 e9584 P P 1209 389 2024.11.25 23:21:46.782 2024.11.25 23:21:47.991 2024.11.25 21:50:37.270 2024.11.25 21:50:37.659
110 6.0.0.533 2024.11.17 933ac P P 652 356 2024.11.22 09:31:09.931 2024.11.22 09:31:10.583 2024.11.22 08:19:58.794 2024.11.22 08:19:59.150
111 6.0.0.532 2024.11.16 9e263 P P 1136 349 2024.11.16 23:13:06.758 2024.11.16 23:13:07.894 2024.11.16 21:50:33.774 2024.11.16 21:50:34.123
112 6.0.0.530 2024.11.15 49804 P P 1104 359 2024.11.16 01:20:19.749 2024.11.16 01:20:20.853 2024.11.15 23:50:05.185 2024.11.15 23:50:05.544
113 6.0.0.528 2024.11.14 9625b P P 1179 389 2024.11.15 01:22:56.595 2024.11.15 01:22:57.774 2024.11.14 23:51:09.958 2024.11.14 23:51:10.347
114 6.0.0.526 2024.11.12 65b80 P P 784 382 2024.11.14 01:22:08.908 2024.11.14 01:22:09.692 2024.11.13 23:50:40.260 2024.11.13 23:50:40.642
115 6.0.0.523 2024.11.08 8ca23 P P 573 345 2024.11.11 01:19:09.464 2024.11.11 01:19:10.037 2024.11.10 23:49:48.035 2024.11.10 23:49:48.380
116 6.0.0.520 2024.11.07 4eefa P P 1107 370 2024.11.08 01:17:04.234 2024.11.08 01:17:05.341 2024.11.07 23:49:34.293 2024.11.07 23:49:34.663
117 6.0.0.516 2024.11.04 b0c36 P P 737 348 2024.11.05 01:16:24.126 2024.11.05 01:16:24.863 2024.11.04 23:49:28.705 2024.11.04 23:49:29.053
118 6.0.0.515 2024.10.30 d53f3 P P 1106 418 2024.11.04 01:18:18.278 2024.11.04 01:18:19.384 2024.11.03 23:49:48.065 2024.11.03 23:49:48.483
119 6.0.0.512 2024.10.29 833ef P P 1112 367 2024.10.30 01:20:39.894 2024.10.30 01:20:41.006 2024.10.29 23:51:01.562 2024.10.29 23:51:01.929
120 6.0.0.511 2024.10.26 c4bc9 P P 1135 371 2024.10.29 01:20:54.073 2024.10.29 01:20:55.208 2024.10.28 23:50:39.085 2024.10.28 23:50:39.456
121 6.0.0.509 2024.10.25 3aedb P P 1283 378 2024.10.26 01:29:38.273 2024.10.26 01:29:39.556 2024.10.25 23:52:51.078 2024.10.25 23:52:51.456
122 6.0.0.508 2024.10.24 a8f5b P P 1359 372 2024.10.25 01:24:15.102 2024.10.25 01:24:16.461 2024.10.24 23:51:35.358 2024.10.24 23:51:35.730
123 6.0.0.502 2024.10.22 6bfd7 P P 1173 388 2024.10.23 01:23:53.125 2024.10.23 01:23:54.298 2024.10.22 23:51:16.539 2024.10.22 23:51:16.927
124 6.0.0.500 2024.10.21 be565 P P 706 357 2024.10.22 17:34:17.417 2024.10.22 17:34:18.123 2024.10.22 16:20:51.599 2024.10.22 16:20:51.956
125 6.0.0.499 2024.10.19 6214b P P 1193 375 2024.10.20 01:25:10.449 2024.10.20 01:25:11.642 2024.10.19 23:52:07.025 2024.10.19 23:52:07.400
126 6.0.0.498 2024.10.18 591a7 P P 1082 399 2024.10.19 01:22:38.839 2024.10.19 01:22:39.921 2024.10.18 23:50:49.644 2024.10.18 23:50:50.043
127 6.0.0.494 2024.10.17 cf5a4 P P 1207 374 2024.10.18 01:23:26.141 2024.10.18 01:23:27.348 2024.10.17 23:52:06.645 2024.10.17 23:52:07.019
128 6.0.0.491 2024.10.14 dc5fb P P 683 389 2024.10.15 01:20:12.593 2024.10.15 01:20:13.276 2024.10.14 23:50:14.599 2024.10.14 23:50:14.988
129 6.0.0.489 2024.10.11 2ba59 P P 1184 366 2024.10.12 01:25:50.353 2024.10.12 01:25:51.537 2024.10.11 23:51:46.262 2024.10.11 23:51:46.628
130 6.0.0.488 2024.10.09 1c93e P P 1345 369 2024.10.10 01:33:36.865 2024.10.10 01:33:38.210 2024.10.09 23:53:54.776 2024.10.09 23:53:55.145
131 6.0.0.487 2024.10.06 065a3 P P 1233 401 2024.10.07 01:32:56.081 2024.10.07 01:32:57.314 2024.10.06 23:54:01.389 2024.10.06 23:54:01.790
132 6.0.0.485 2024.10.04 e95c1 P P 1161 416 2024.10.05 01:34:48.925 2024.10.05 01:34:50.086 2024.10.04 23:53:29.365 2024.10.04 23:53:29.781
133 6.0.0.483 2024.10.02 5e5ae P P 1168 369 2024.10.03 01:30:39.781 2024.10.03 01:30:40.949 2024.10.02 23:53:17.427 2024.10.02 23:53:17.796
134 6.0.0.478 2024.09.30 b5010 P P 645 363 2024.10.01 01:26:28.567 2024.10.01 01:26:29.212 2024.09.30 23:52:52.426 2024.09.30 23:52:52.789
135 6.0.0.474 2024.09.26 e4efb P P 1188 375 2024.09.30 01:26:09.145 2024.09.30 01:26:10.333 2024.09.29 23:52:03.905 2024.09.29 23:52:04.280
136 6.0.0.471 2024.09.24 01b51 P P 1180 416 2024.09.25 23:29:05.385 2024.09.25 23:29:06.565 2024.09.25 21:52:20.357 2024.09.25 21:52:20.773
137 6.0.0.470 2024.09.23 77cc0 P P 1204 404 2024.09.23 23:27:56.301 2024.09.23 23:27:57.505 2024.09.23 21:52:35.676 2024.09.23 21:52:36.080
138 6.0.0.467 2024.09.21 ea0b8 P P 645 385 2024.09.22 23:26:18.257 2024.09.22 23:26:18.902 2024.09.22 21:51:47.225 2024.09.22 21:51:47.610
139 6.0.0.466 2024.09.20 32dc6 P P 810 432 2024.09.20 23:25:16.364 2024.09.20 23:25:17.174 2024.09.20 21:51:50.135 2024.09.20 21:51:50.567
140 6.0.0.461 2024.09.17 2c895 P P 969 375 2024.09.17 23:59:22.372 2024.09.17 23:59:23.341 2024.09.17 22:07:05.013 2024.09.17 22:07:05.388
141 6.0.0.460 2024.09.11 3c253 P P 815 647 2024.09.16 23:59:44.046 2024.09.16 23:59:44.861 2024.09.16 22:08:39.580 2024.09.16 22:08:40.227
142 6.0.0.457 2024.09.09 fdc6f P P 1561 698 2024.09.10 00:21:13.372 2024.09.10 00:21:14.933 2024.09.09 22:14:25.972 2024.09.09 22:14:26.670
143 6.0.0.455 2024.09.07 500d8 P P 1352 764 2024.09.08 00:17:36.693 2024.09.08 00:17:38.045 2024.09.07 22:13:24.033 2024.09.07 22:13:24.797
144 6.0.0.454 2024.09.05 4d70f P P 929 705 2024.09.06 00:00:08.513 2024.09.06 00:00:09.442 2024.09.05 22:10:33.960 2024.09.05 22:10:34.665
145 6.0.0.452 2024.09.04 9ff9c P P 1302 608 2024.09.05 00:00:19.089 2024.09.05 00:00:20.391 2024.09.04 22:08:24.621 2024.09.04 22:08:25.229
146 6.0.0.450 2024.09.02 27124 P P 1039 730 2024.09.04 00:59:51.623 2024.09.04 00:59:52.662 2024.09.03 22:31:47.336 2024.09.03 22:31:48.066
147 6.0.0.447 2024.09.01 056ec P P 1435 2085 2024.09.02 00:22:21.306 2024.09.02 00:22:22.741 2024.09.01 22:14:05.093 2024.09.01 22:14:07.178
148 6.0.0.446 2024.08.30 fe1b2 P P 1480 2778 2024.09.01 00:26:31.586 2024.09.01 00:26:33.066 2024.08.31 22:25:41.019 2024.08.31 22:25:43.797
149 6.0.0.444 2024.08.28 785d4 P P 2194 1445 2024.08.30 00:37:59.695 2024.08.30 00:38:01.889 2024.08.29 22:29:08.718 2024.08.29 22:29:10.163
150 6.0.0.442 2024.08.21 4a68f P P 3073 3197 2024.08.28 02:00:55.730 2024.08.28 02:00:58.803 2024.08.27 22:48:18.169 2024.08.27 22:48:21.366
151 6.0.0.441 2024.08.20 75042 P P 2549 1766 2024.08.21 00:09:49.637 2024.08.21 00:09:52.186 2024.08.20 22:13:54.971 2024.08.20 22:13:56.737
152 6.0.0.438 2024.08.16 088b5 P P 1999 1029 2024.08.18 23:31:08.529 2024.08.18 23:31:10.528 2024.08.18 21:57:32.911 2024.08.18 21:57:33.940
153 6.0.0.437 2024.08.14 3c88b P P 2223 1083 2024.08.15 23:29:16.290 2024.08.15 23:29:18.513 2024.08.15 21:57:15.039 2024.08.15 21:57:16.122
154 6.0.0.432 2024.08.11 e82ac P P 2073 1040 2024.08.12 23:28:31.041 2024.08.12 23:28:33.114 2024.08.12 21:56:52.799 2024.08.12 21:56:53.839
155 6.0.0.431 2024.08.09 de5a7 P P 2176 1033 2024.08.09 23:29:32.825 2024.08.09 23:29:35.001 2024.08.09 21:57:35.725 2024.08.09 21:57:36.758
156 6.0.0.428 2024.08.08 9191b P P 2300 1030 2024.08.08 23:29:04.365 2024.08.08 23:29:06.665 2024.08.08 21:57:17.203 2024.08.08 21:57:18.233
157 6.0.0.423 2024.08.07 33b41 P P 1424 1028 2024.08.08 09:20:21.982 2024.08.08 09:20:23.406 2024.08.08 08:04:50.865 2024.08.08 08:04:51.893
158 6.0.0.421 2024.08.06 ed60d P P 1836 876 2024.08.06 23:13:28.998 2024.08.06 23:13:30.834 2024.08.06 21:53:36.566 2024.08.06 21:53:37.442
159 6.0.0.419 2024.08.05 3505a P P 990 889 2024.08.05 23:15:34.250 2024.08.05 23:15:35.240 2024.08.05 21:53:41.481 2024.08.05 21:53:42.370
160 6.0.0.409 2024.08.02 ec18f P P 1705 924 2024.08.04 23:18:50.016 2024.08.04 23:18:51.721 2024.08.04 21:54:27.119 2024.08.04 21:54:28.043
161 6.0.0.406 2024.08.01 b20be P P 1808 912 2024.08.01 23:17:47.689 2024.08.01 23:17:49.497 2024.08.01 21:53:57.549 2024.08.01 21:53:58.461
162 6.0.0.405 2024.07.31 a62ac P P 1177 924 2024.07.31 23:16:34.971 2024.07.31 23:16:36.148 2024.07.31 21:53:47.309 2024.07.31 21:53:48.233
163 6.0.0.403 2024.07.29 30f03 P P 1621 813 2024.07.29 23:16:09.357 2024.07.29 23:16:10.978 2024.07.29 21:53:30.759 2024.07.29 21:53:31.572
164 6.0.0.401 2024.07.26 24e41 P P 1659 848 2024.07.26 23:13:36.622 2024.07.26 23:13:38.281 2024.07.26 21:53:26.803 2024.07.26 21:53:27.651
165 6.0.0.400 2024.07.24 5bb78 P P 1014 870 2024.07.24 23:13:09.852 2024.07.24 23:13:10.866 2024.07.24 21:53:39.585 2024.07.24 21:53:40.455
166 6.0.0.398 2024.07.23 85b18 P P 1243 916 2024.07.23 23:19:44.298 2024.07.23 23:19:45.541 2024.07.23 21:58:40.903 2024.07.23 21:58:41.819
167 6.0.0.397 2024.07.22 c734c P P 1665 871 2024.07.22 23:13:13.369 2024.07.22 23:13:15.034 2024.07.22 21:53:41.605 2024.07.22 21:53:42.476
168 6.0.0.396 2024.07.13 cf952 P P 1619 848 2024.07.21 23:14:07.986 2024.07.21 23:14:09.605 2024.07.21 21:53:24.406 2024.07.21 21:53:25.254
169 6.0.0.395 2024.07.10 845f4 P P 2006 873 2024.07.12 23:14:38.987 2024.07.12 23:14:40.993 2024.07.12 21:53:00.402 2024.07.12 21:53:01.275
170 6.0.0.392 2024.07.09 ea301 P P 1961 890 2024.07.09 23:11:03.376 2024.07.09 23:11:05.337 2024.07.09 21:52:37.013 2024.07.09 21:52:37.903
171 6.0.0.391 2024.07.08 7d50c P P 1714 887 2024.07.08 23:12:24.299 2024.07.08 23:12:26.013 2024.07.08 21:53:25.200 2024.07.08 21:53:26.087
172 6.0.0.389 2024.07.05 cc71c P P 1860 886 2024.07.05 23:15:25.780 2024.07.05 23:15:27.640 2024.07.05 21:53:15.558 2024.07.05 21:53:16.444
173 6.0.0.388 2024.06.30 e5700 P P 1576 897 2024.06.30 23:12:43.617 2024.06.30 23:12:45.193 2024.06.30 21:53:44.074 2024.06.30 21:53:44.971
174 6.0.0.387 2024.06.27 7c28a P P 1844 906 2024.06.27 23:11:53.285 2024.06.27 23:11:55.129 2024.06.27 21:53:36.524 2024.06.27 21:53:37.430
175 6.0.0.386 2024.06.23 7c57f P P 1581 861 2024.06.23 23:09:22.372 2024.06.23 23:09:23.953 2024.06.23 21:52:26.740 2024.06.23 21:52:27.601
176 6.0.0.384 2024.06.21 24d99 P P 1586 929 2024.06.21 23:13:20.429 2024.06.21 23:13:22.015 2024.06.21 21:53:15.370 2024.06.21 21:53:16.299
177 6.0.0.374 2024.06.13 0097d P P 1547 840 2024.06.20 23:11:37.153 2024.06.20 23:11:38.700 2024.06.20 21:52:52.959 2024.06.20 21:52:53.799
178 6.0.0.373 2024.06.09 363f0 P P 1243 887 2024.06.13 13:24:23.141 2024.06.13 13:24:24.384 2024.06.13 12:16:16.230 2024.06.13 12:16:17.117
179 6.0.0.371 2024.06.08 f7130 P P 1220 838 2024.06.11 22:11:59.720 2024.06.11 22:12:00.940 2024.06.11 21:11:20.224 2024.06.11 21:11:21.062
180 6.0.0.366 2024.05.30 ab2c9 P P 1998 818 2024.06.12 09:16:32.762 2024.06.12 09:16:34.760 2024.06.12 07:45:54.512 2024.06.12 07:45:55.330
181 6.0.0.363 2024.05.27 06703 P P 1102 800 2024.06.12 14:18:00.895 2024.06.12 14:18:01.997 2024.06.12 13:14:53.012 2024.06.12 13:14:53.812
182 6.0.0.359 2024.05.23 9cb11 P P 1100 868 2024.06.12 12:10:29.843 2024.06.12 12:10:30.943 2024.06.12 11:06:58.337 2024.06.12 11:06:59.205
183 6.0.0.358 2024.05.21 995dd P P 1039 813 2024.06.12 16:53:58.234 2024.06.12 16:53:59.273 2024.06.12 15:51:45.634 2024.06.12 15:51:46.447
184 6.0.0.357 2024.05.18 bf6c4 P P 1026 750 2024.06.12 21:30:19.220 2024.06.12 21:30:20.246 2024.06.12 20:28:00.461 2024.06.12 20:28:01.211
185 6.0.0.356 2024.05.17 eab06 P P 1093 810 2024.06.13 05:36:44.862 2024.06.13 05:36:45.955 2024.06.13 04:34:22.867 2024.06.13 04:34:23.677
186 6.0.0.355 2024.05.16 8dd6e P P 1171 795 2024.06.13 07:44:01.842 2024.06.13 07:44:03.013 2024.06.13 06:42:03.852 2024.06.13 06:42:04.647
187 6.0.0.354 2024.05.15 d3adc P P 1102 865 2024.06.13 10:49:26.798 2024.06.13 10:49:27.900 2024.06.13 09:41:49.784 2024.06.13 09:41:50.649
188 6.0.0.351 2024.05.14 2e3e0 P P 1066 898 2024.06.13 16:03:15.542 2024.06.13 16:03:16.608 2024.06.13 14:54:38.555 2024.06.13 14:54:39.453

Elapsed time, ms. Chart for last 150 runs:

Last commits information (all timestamps in UTC):