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   
    MSG                             start
    WHO_AM_I                        SYSDBA
    WHATS_MY_ROLE                   NONE
    USER_NAME                       TMP_4468_JUNIOR
    SEC_ADMIN                       <false>
    RDB_ADMIN                       <false>
    RDB_ADM_GRANT_OPTION            <null>
    MSG                             start
    WHO_AM_I                        SYSDBA
    WHATS_MY_ROLE                   NONE
    USER_NAME                       TMP_4468_SENIOR
    SEC_ADMIN                       <true>
    RDB_ADMIN                       <false>
    RDB_ADM_GRANT_OPTION            <null>
    Records affected: 2
    MSG                             point-1
    WHO_AM_I                        SYSDBA
    WHATS_MY_ROLE                   NONE
    USER_NAME                       TMP_4468_JUNIOR
    SEC_ADMIN                       <false>
    RDB_ADMIN                       <false>
    RDB_ADM_GRANT_OPTION            <null>
    MSG                             point-1
    WHO_AM_I                        SYSDBA
    WHATS_MY_ROLE                   NONE
    USER_NAME                       TMP_4468_SENIOR
    SEC_ADMIN                       <true>
    RDB_ADMIN                       <true>
    RDB_ADM_GRANT_OPTION            0
    Records affected: 2
    MSG                             point-2
    WHO_AM_I                        TMP_4468_SENIOR
    WHATS_MY_ROLE                   RDB$ADMIN
    USER_NAME                       TMP_4468_JUNIOR
    SEC_ADMIN                       <false>
    RDB_ADMIN                       <false>
    RDB_ADM_GRANT_OPTION            <null>
    MSG                             point-2
    WHO_AM_I                        TMP_4468_SENIOR
    WHATS_MY_ROLE                   RDB$ADMIN
    USER_NAME                       TMP_4468_SENIOR
    SEC_ADMIN                       <true>
    RDB_ADMIN                       <true>
    RDB_ADM_GRANT_OPTION            0
    Records affected: 2
    MSG                             point-3
    WHO_AM_I                        TMP_4468_SENIOR
    WHATS_MY_ROLE                   RDB$ADMIN
    USER_NAME                       TMP_4468_JUNIOR
    SEC_ADMIN                       <true>
    RDB_ADMIN                       <false>
    RDB_ADM_GRANT_OPTION            <null>
    MSG                             point-3
    WHO_AM_I                        TMP_4468_SENIOR
    WHATS_MY_ROLE                   RDB$ADMIN
    USER_NAME                       TMP_4468_SENIOR
    SEC_ADMIN                       <true>
    RDB_ADMIN                       <true>
    RDB_ADM_GRANT_OPTION            0
    Records affected: 2
    MSG                             point-4
    WHO_AM_I                        TMP_4468_SENIOR
    WHATS_MY_ROLE                   RDB$ADMIN
    USER_NAME                       TMP_4468_JUNIOR
    SEC_ADMIN                       <true>
    RDB_ADMIN                       <true>
    RDB_ADM_GRANT_OPTION            0
    MSG                             point-4
    WHO_AM_I                        TMP_4468_SENIOR
    WHATS_MY_ROLE                   RDB$ADMIN
    USER_NAME                       TMP_4468_SENIOR
    SEC_ADMIN                       <true>
    RDB_ADMIN                       <true>
    RDB_ADM_GRANT_OPTION            0
    Records affected: 2
    MSG                             point-5
    WHO_AM_I                        TMP_4468_SENIOR
    WHATS_MY_ROLE                   RDB$ADMIN
    USER_NAME                       TMP_4468_JUNIOR
    SEC_ADMIN                       <false>
    RDB_ADMIN                       <true>
    RDB_ADM_GRANT_OPTION            0
    MSG                             point-5
    WHO_AM_I                        TMP_4468_SENIOR
    WHATS_MY_ROLE                   RDB$ADMIN
    USER_NAME                       TMP_4468_SENIOR
    SEC_ADMIN                       <true>
    RDB_ADMIN                       <true>
    RDB_ADM_GRANT_OPTION            0
    Records affected: 2
    MSG                             point-6
    WHO_AM_I                        TMP_4468_SENIOR
    WHATS_MY_ROLE                   RDB$ADMIN
    USER_NAME                       TMP_4468_JUNIOR
    SEC_ADMIN                       <false>
    RDB_ADMIN                       <false>
    RDB_ADM_GRANT_OPTION            <null>
    MSG                             point-6
    WHO_AM_I                        TMP_4468_SENIOR
    WHATS_MY_ROLE                   RDB$ADMIN
    USER_NAME                       TMP_4468_SENIOR
    SEC_ADMIN                       <true>
    RDB_ADMIN                       <true>
    RDB_ADM_GRANT_OPTION            0
    Records affected: 2
    MSG                             point-7
    WHO_AM_I                        TMP_4468_SENIOR
    WHATS_MY_ROLE                   RDB$ADMIN
    USER_NAME                       TMP_4468_SENIOR
    SEC_ADMIN                       <false>
    RDB_ADMIN                       <true>
    RDB_ADM_GRANT_OPTION            0
    Records affected: 1
    Statement failed, SQLSTATE = 28000
    delete record
  - -no permission for DELETE access to TABLE PLG
  + -no permission for DELETE access to TABLE "PLG$SRP"."PLG$SRP_VIEW"
    MSG                             point-8
    WHO_AM_I                        TMP_4468_SENIOR
    WHATS_MY_ROLE                   RDB$ADMIN
    USER_NAME                       TMP_4468_SENIOR
    SEC_ADMIN                       <false>
    RDB_ADMIN                       <true>
    RDB_ADM_GRANT_OPTION            0
    Records affected: 1
    MSG                             finish
    WHO_AM_I                        TMP_4468_SENIOR
    WHATS_MY_ROLE                   RDB$ADMIN
    USER_NAME                       TMP_4468_SENIOR
    SEC_ADMIN                       <false>
    RDB_ADMIN                       <true>
    RDB_ADM_GRANT_OPTION            0
    Records affected: 1

LOG DETAILS:

2025-06-27 05:15:12.079
2025-06-27 05:15:12.083 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-27 05:15:12.087 tmp_senior = <firebird.qa.plugin.User object at [hex]>
2025-06-27 05:15:12.092 tmp_junior = <firebird.qa.plugin.User object at [hex]>
2025-06-27 05:15:12.097
2025-06-27 05:15:12.103 @pytest.mark.version('>=3.0')
2025-06-27 05:15:12.114 def test_1(act: Action, tmp_senior: User, tmp_junior: User):
2025-06-27 05:15:12.126
2025-06-27 05:15:12.136 test_sql = f"""
2025-06-27 05:15:12.145 set wng off;
2025-06-27 05:15:12.152 set list on;
2025-06-27 05:15:12.158 set count on;
2025-06-27 05:15:12.165
2025-06-27 05:15:12.171 -- ::: NB ::: Name of PLG-* depends on value of UserManager = Srp or Legacy_UserManager.
2025-06-27 05:15:12.178 -- For 'Srp' it will be 'PLG$SRP_VIEW', for Legacy_UserManager -- PLG$VIEW_USERS.
2025-06-27 05:15:12.184 -- Because of this, section 'substitution' has been added in order to ignore rest part of line
2025-06-27 05:15:12.190 -- after words 'TABLE PLG'.
2025-06-27 05:15:12.200 -- Also, text in message about deletion fault differs in case of UserManager setting:
2025-06-27 05:15:12.209 -- 'find/delete record error' - for Legacy_UserManager
2025-06-27 05:15:12.219 -- 'delete record error' = for Srp
2025-06-27 05:15:12.229 -- This is minor bug in Legacy_UserManager but it will be remain 'as is', see letter from Alex 03-jun-2015 19:51.
2025-06-27 05:15:12.240 recreate view v_users as
2025-06-27 05:15:12.247 select
2025-06-27 05:15:12.252 current_user who_am_i
2025-06-27 05:15:12.257 ,current_role whats_my_role
2025-06-27 05:15:12.262 ,u.sec$user_name user_name
2025-06-27 05:15:12.266 ,u.sec$admin sec_admin
2025-06-27 05:15:12.270 ,g.rdb$privilege is not null as rdb_admin
2025-06-27 05:15:12.275 ,g.rdb$grant_option rdb_adm_grant_option
2025-06-27 05:15:12.279 from rdb$database
2025-06-27 05:15:12.284 left join sec$users u on u.sec$user_name in ( upper('{tmp_senior.name}'), upper('{tmp_junior.name}') )
2025-06-27 05:15:12.289 left join rdb$user_privileges g on u.sec$user_name = g.rdb$user and g.rdb$privilege = upper('m') and g.rdb$relation_name = upper('rdb$admin')
2025-06-27 05:15:12.293 order by user_name
2025-06-27 05:15:12.297 ;
2025-06-27 05:15:12.301 commit;
2025-06-27 05:15:12.306
2025-06-27 05:15:12.310 grant select on v_users to public;
2025-06-27 05:15:12.314 commit;
2025-06-27 05:15:12.319
2025-06-27 05:15:12.326 select 'start' msg, v.* from v_users v;
2025-06-27 05:15:12.338 commit;
2025-06-27 05:15:12.348
2025-06-27 05:15:12.356 revoke all on all from {tmp_senior.name};
2025-06-27 05:15:12.364 grant rdb$admin to {tmp_senior.name}; -- this is also mandatory: it gives him admin role in ($dsn) database
2025-06-27 05:15:12.370 commit;
2025-06-27 05:15:12.382
2025-06-27 05:15:12.390 select 'point-1' msg, v.* from v_users v;
2025-06-27 05:15:12.396 commit;
2025-06-27 05:15:12.402
2025-06-27 05:15:12.408 -- When '{tmp_senior.name}' connects to database ($dsn), there is no way for engine to recognize that this user
2025-06-27 05:15:12.414 -- has been granted with admin role in 'CREATE USER ... GRANT ADMIN ROLE' statement. So, user has to specify
2025-06-27 05:15:12.420 -- `role 'RDB$ADMIN'` in order to connect as ADMIN.
2025-06-27 05:15:12.427 -- But with RDB$ADMIN only he can create objects in THAT database (tables etc), but not other USERS!
2025-06-27 05:15:12.435 -- Thats why he should also be granted with admin role in 'CREATE USER ...' - see above.
2025-06-27 05:15:12.445 connect '{act.db.dsn}' user '{tmp_senior.name}' password '{tmp_senior.password}' role 'RDB$ADMIN';
2025-06-27 05:15:12.456 commit;
2025-06-27 05:15:12.464
2025-06-27 05:15:12.471 -- Users are stored in Security DB,  *not* in "this" database!
2025-06-27 05:15:12.479 -- So, following statement will pass only if '{tmp_senior.name}' has been granted by 'admin role'
2025-06-27 05:15:12.486 -- in his own 'create user' phase:
2025-06-27 05:15:12.496 create or alter user {tmp_junior.name} password '{tmp_junior.password}' revoke admin role;
2025-06-27 05:15:12.505 commit;
2025-06-27 05:15:12.512
2025-06-27 05:15:12.519 select 'point-2' msg, v.* from v_users v;
2025-06-27 05:15:12.525
2025-06-27 05:15:12.531 alter user {tmp_junior.name} grant admin role;
2025-06-27 05:15:12.536 commit;
2025-06-27 05:15:12.541
2025-06-27 05:15:12.550 select 'point-3' msg, v.* from v_users v;
2025-06-27 05:15:12.561
2025-06-27 05:15:12.569 grant rdb$admin to {tmp_junior.name};
2025-06-27 05:15:12.576 commit;
2025-06-27 05:15:12.583
2025-06-27 05:15:12.593 select 'point-4' msg, v.* from v_users v;
2025-06-27 05:15:12.601
2025-06-27 05:15:12.608 alter user {tmp_junior.name} revoke admin role;
2025-06-27 05:15:12.615 commit;
2025-06-27 05:15:12.621
2025-06-27 05:15:12.632 select 'point-5' msg, v.* from v_users v;
2025-06-27 05:15:12.641 commit;
2025-06-27 05:15:12.648
2025-06-27 05:15:12.655 revoke rdb$admin from {tmp_junior.name};
2025-06-27 05:15:12.667 commit;
2025-06-27 05:15:12.677
2025-06-27 05:15:12.682 select 'point-6' msg, v.* from v_users v;
2025-06-27 05:15:12.692 commit;
2025-06-27 05:15:12.702
2025-06-27 05:15:12.714 -- User removes admin role from himself:
2025-06-27 05:15:12.725
2025-06-27 05:15:12.736 /****************************************
2025-06-27 05:15:12.744 -- 1. This will FAIL:
2025-06-27 05:15:12.751 -- -REVOKE failed
2025-06-27 05:15:12.756 -- -{tmp_senior.name} is not grantor of Role on RDB$ADMIN to {tmp_senior.name}.
2025-06-27 05:15:12.761 revoke rdb$admin from {tmp_senior.name};
2025-06-27 05:15:12.766 commit;
2025-06-27 05:15:12.771 *******************************************/
2025-06-27 05:15:12.775
2025-06-27 05:15:12.779 -- 2 This will PASS, and it MUST be so (see letter from Alex, 03-jun-2015 19:46)
2025-06-27 05:15:12.784 alter user {tmp_senior.name} revoke admin role;
2025-06-27 05:15:12.788 commit;
2025-06-27 05:15:12.793
2025-06-27 05:15:12.797 select 'point-7' msg, v.* from v_users v;
2025-06-27 05:15:12.802 commit;
2025-06-27 05:15:12.808
2025-06-27 05:15:12.813 -- And after previous action he can not drop himself because now he is NOT member of admin role:
2025-06-27 05:15:12.818 -- Statement failed, SQLSTATE = 28000
2025-06-27 05:15:12.823 -- find/delete record error
2025-06-27 05:15:12.831 -- -no permission for DELETE access to TABLE PLG$VIEW_USERS
2025-06-27 05:15:12.841 drop user {tmp_senior.name};
2025-06-27 05:15:12.850 commit;
2025-06-27 05:15:12.857
2025-06-27 05:15:12.863 select 'point-8' msg, v.* from v_users v;
2025-06-27 05:15:12.869 commit;
2025-06-27 05:15:12.875
2025-06-27 05:15:12.881 -- Trying reconnect with role RDB$ADMIN:
2025-06-27 05:15:12.887 connect '{act.db.dsn}' user '{tmp_senior.name}' password '{tmp_senior.password}' role 'RDB$ADMIN';
2025-06-27 05:15:12.892 commit;
2025-06-27 05:15:12.898
2025-06-27 05:15:12.908 select 'finish' msg, v.* from v_users v;
2025-06-27 05:15:12.917 commit;
2025-06-27 05:15:12.925 """
2025-06-27 05:15:12.932
2025-06-27 05:15:12.938 expected_out = f"""
2025-06-27 05:15:12.945 MSG                             start
2025-06-27 05:15:12.951 WHO_AM_I                        {act.db.user}
2025-06-27 05:15:12.958 WHATS_MY_ROLE                   NONE
2025-06-27 05:15:12.964 USER_NAME                       {tmp_junior.name}
2025-06-27 05:15:12.968 SEC_ADMIN                       <false>
2025-06-27 05:15:12.974 RDB_ADMIN                       <false>
2025-06-27 05:15:12.979 RDB_ADM_GRANT_OPTION            <null>
2025-06-27 05:15:12.985 MSG                             start
2025-06-27 05:15:12.990 WHO_AM_I                        {act.db.user}
2025-06-27 05:15:12.996 WHATS_MY_ROLE                   NONE
2025-06-27 05:15:13.002 USER_NAME                       {tmp_senior.name}
2025-06-27 05:15:13.008 SEC_ADMIN                       <true>
2025-06-27 05:15:13.014 RDB_ADMIN                       <false>
2025-06-27 05:15:13.021 RDB_ADM_GRANT_OPTION            <null>
2025-06-27 05:15:13.025 Records affected: 2
2025-06-27 05:15:13.030 MSG                             point-1
2025-06-27 05:15:13.035 WHO_AM_I                        {act.db.user}
2025-06-27 05:15:13.039 WHATS_MY_ROLE                   NONE
2025-06-27 05:15:13.046 USER_NAME                       {tmp_junior.name}
2025-06-27 05:15:13.056 SEC_ADMIN                       <false>
2025-06-27 05:15:13.064 RDB_ADMIN                       <false>
2025-06-27 05:15:13.071 RDB_ADM_GRANT_OPTION            <null>
2025-06-27 05:15:13.078 MSG                             point-1
2025-06-27 05:15:13.084 WHO_AM_I                        {act.db.user}
2025-06-27 05:15:13.089 WHATS_MY_ROLE                   NONE
2025-06-27 05:15:13.094 USER_NAME                       {tmp_senior.name}
2025-06-27 05:15:13.099 SEC_ADMIN                       <true>
2025-06-27 05:15:13.104 RDB_ADMIN                       <true>
2025-06-27 05:15:13.111 RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:13.119 Records affected: 2
2025-06-27 05:15:13.129 MSG                             point-2
2025-06-27 05:15:13.137 WHO_AM_I                        {tmp_senior.name}
2025-06-27 05:15:13.149 WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:13.161 USER_NAME                       {tmp_junior.name}
2025-06-27 05:15:13.173 SEC_ADMIN                       <false>
2025-06-27 05:15:13.185 RDB_ADMIN                       <false>
2025-06-27 05:15:13.197 RDB_ADM_GRANT_OPTION            <null>
2025-06-27 05:15:13.206 MSG                             point-2
2025-06-27 05:15:13.214 WHO_AM_I                        {tmp_senior.name}
2025-06-27 05:15:13.221 WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:13.227 USER_NAME                       {tmp_senior.name}
2025-06-27 05:15:13.233 SEC_ADMIN                       <true>
2025-06-27 05:15:13.238 RDB_ADMIN                       <true>
2025-06-27 05:15:13.244 RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:13.250 Records affected: 2
2025-06-27 05:15:13.256 MSG                             point-3
2025-06-27 05:15:13.264 WHO_AM_I                        {tmp_senior.name}
2025-06-27 05:15:13.275 WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:13.285 USER_NAME                       {tmp_junior.name}
2025-06-27 05:15:13.296 SEC_ADMIN                       <true>
2025-06-27 05:15:13.305 RDB_ADMIN                       <false>
2025-06-27 05:15:13.314 RDB_ADM_GRANT_OPTION            <null>
2025-06-27 05:15:13.326 MSG                             point-3
2025-06-27 05:15:13.337 WHO_AM_I                        {tmp_senior.name}
2025-06-27 05:15:13.346 WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:13.357 USER_NAME                       {tmp_senior.name}
2025-06-27 05:15:13.366 SEC_ADMIN                       <true>
2025-06-27 05:15:13.374 RDB_ADMIN                       <true>
2025-06-27 05:15:13.383 RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:13.394 Records affected: 2
2025-06-27 05:15:13.406 MSG                             point-4
2025-06-27 05:15:13.418 WHO_AM_I                        {tmp_senior.name}
2025-06-27 05:15:13.427 WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:13.436 USER_NAME                       {tmp_junior.name}
2025-06-27 05:15:13.443 SEC_ADMIN                       <true>
2025-06-27 05:15:13.451 RDB_ADMIN                       <true>
2025-06-27 05:15:13.458 RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:13.464 MSG                             point-4
2025-06-27 05:15:13.470 WHO_AM_I                        {tmp_senior.name}
2025-06-27 05:15:13.475 WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:13.488 USER_NAME                       {tmp_senior.name}
2025-06-27 05:15:13.498 SEC_ADMIN                       <true>
2025-06-27 05:15:13.510 RDB_ADMIN                       <true>
2025-06-27 05:15:13.520 RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:13.528 Records affected: 2
2025-06-27 05:15:13.535 MSG                             point-5
2025-06-27 05:15:13.543 WHO_AM_I                        {tmp_senior.name}
2025-06-27 05:15:13.551 WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:13.557 USER_NAME                       {tmp_junior.name}
2025-06-27 05:15:13.566 SEC_ADMIN                       <false>
2025-06-27 05:15:13.575 RDB_ADMIN                       <true>
2025-06-27 05:15:13.581 RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:13.592 MSG                             point-5
2025-06-27 05:15:13.600 WHO_AM_I                        {tmp_senior.name}
2025-06-27 05:15:13.609 WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:13.620 USER_NAME                       {tmp_senior.name}
2025-06-27 05:15:13.630 SEC_ADMIN                       <true>
2025-06-27 05:15:13.637 RDB_ADMIN                       <true>
2025-06-27 05:15:13.644 RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:13.650 Records affected: 2
2025-06-27 05:15:13.660 MSG                             point-6
2025-06-27 05:15:13.669 WHO_AM_I                        {tmp_senior.name}
2025-06-27 05:15:13.676 WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:13.683 USER_NAME                       {tmp_junior.name}
2025-06-27 05:15:13.689 SEC_ADMIN                       <false>
2025-06-27 05:15:13.694 RDB_ADMIN                       <false>
2025-06-27 05:15:13.700 RDB_ADM_GRANT_OPTION            <null>
2025-06-27 05:15:13.706 MSG                             point-6
2025-06-27 05:15:13.714 WHO_AM_I                        {tmp_senior.name}
2025-06-27 05:15:13.726 WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:13.738 USER_NAME                       {tmp_senior.name}
2025-06-27 05:15:13.749 SEC_ADMIN                       <true>
2025-06-27 05:15:13.758 RDB_ADMIN                       <true>
2025-06-27 05:15:13.768 RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:13.777 Records affected: 2
2025-06-27 05:15:13.785 MSG                             point-7
2025-06-27 05:15:13.792 WHO_AM_I                        {tmp_senior.name}
2025-06-27 05:15:13.798 WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:13.807 USER_NAME                       {tmp_senior.name}
2025-06-27 05:15:13.817 SEC_ADMIN                       <false>
2025-06-27 05:15:13.825 RDB_ADMIN                       <true>
2025-06-27 05:15:13.832 RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:13.838 Records affected: 1
2025-06-27 05:15:13.843 Statement failed, SQLSTATE = 28000
2025-06-27 05:15:13.848 delete record
2025-06-27 05:15:13.855 -no permission for DELETE access to TABLE PLG
2025-06-27 05:15:13.865 MSG                             point-8
2025-06-27 05:15:13.877 WHO_AM_I                        {tmp_senior.name}
2025-06-27 05:15:13.886 WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:13.892 USER_NAME                       {tmp_senior.name}
2025-06-27 05:15:13.898 SEC_ADMIN                       <false>
2025-06-27 05:15:13.904 RDB_ADMIN                       <true>
2025-06-27 05:15:13.911 RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:13.917 Records affected: 1
2025-06-27 05:15:13.928 MSG                             finish
2025-06-27 05:15:13.937 WHO_AM_I                        {tmp_senior.name}
2025-06-27 05:15:13.945 WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:13.950 USER_NAME                       {tmp_senior.name}
2025-06-27 05:15:13.956 SEC_ADMIN                       <false>
2025-06-27 05:15:13.962 RDB_ADMIN                       <true>
2025-06-27 05:15:13.968 RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:13.980 Records affected: 1
2025-06-27 05:15:13.992 """
2025-06-27 05:15:14.000
2025-06-27 05:15:14.007 act.expected_stdout = expected_out # expected_5x if act.is_version('<6') else expected_6x
2025-06-27 05:15:14.013 act.isql(switches = ['-q'], input = test_sql, combine_output = True, io_enc = locale.getpreferredencoding())
2025-06-27 05:15:14.019 >       assert act.clean_stdout == act.clean_expected_stdout
2025-06-27 05:15:14.024 E       assert
2025-06-27 05:15:14.030 E           MSG                             start
2025-06-27 05:15:14.036 E           WHO_AM_I                        SYSDBA
2025-06-27 05:15:14.043 E           WHATS_MY_ROLE                   NONE
2025-06-27 05:15:14.049 E           USER_NAME                       TMP_4468_JUNIOR
2025-06-27 05:15:14.061 E           SEC_ADMIN                       <false>
2025-06-27 05:15:14.073 E           RDB_ADMIN                       <false>
2025-06-27 05:15:14.081 E           RDB_ADM_GRANT_OPTION            <null>
2025-06-27 05:15:14.087 E           MSG                             start
2025-06-27 05:15:14.093 E           WHO_AM_I                        SYSDBA
2025-06-27 05:15:14.099 E           WHATS_MY_ROLE                   NONE
2025-06-27 05:15:14.105 E           USER_NAME                       TMP_4468_SENIOR
2025-06-27 05:15:14.112 E           SEC_ADMIN                       <true>
2025-06-27 05:15:14.118 E           RDB_ADMIN                       <false>
2025-06-27 05:15:14.126 E           RDB_ADM_GRANT_OPTION            <null>
2025-06-27 05:15:14.133 E           Records affected: 2
2025-06-27 05:15:14.139 E           MSG                             point-1
2025-06-27 05:15:14.144 E           WHO_AM_I                        SYSDBA
2025-06-27 05:15:14.156 E           WHATS_MY_ROLE                   NONE
2025-06-27 05:15:14.169 E           USER_NAME                       TMP_4468_JUNIOR
2025-06-27 05:15:14.179 E           SEC_ADMIN                       <false>
2025-06-27 05:15:14.191 E           RDB_ADMIN                       <false>
2025-06-27 05:15:14.200 E           RDB_ADM_GRANT_OPTION            <null>
2025-06-27 05:15:14.208 E           MSG                             point-1
2025-06-27 05:15:14.214 E           WHO_AM_I                        SYSDBA
2025-06-27 05:15:14.219 E           WHATS_MY_ROLE                   NONE
2025-06-27 05:15:14.224 E           USER_NAME                       TMP_4468_SENIOR
2025-06-27 05:15:14.230 E           SEC_ADMIN                       <true>
2025-06-27 05:15:14.235 E           RDB_ADMIN                       <true>
2025-06-27 05:15:14.240 E           RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:14.244 E           Records affected: 2
2025-06-27 05:15:14.249 E           MSG                             point-2
2025-06-27 05:15:14.254 E           WHO_AM_I                        TMP_4468_SENIOR
2025-06-27 05:15:14.259 E           WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:14.269 E           USER_NAME                       TMP_4468_JUNIOR
2025-06-27 05:15:14.277 E           SEC_ADMIN                       <false>
2025-06-27 05:15:14.286 E           RDB_ADMIN                       <false>
2025-06-27 05:15:14.293 E           RDB_ADM_GRANT_OPTION            <null>
2025-06-27 05:15:14.298 E           MSG                             point-2
2025-06-27 05:15:14.304 E           WHO_AM_I                        TMP_4468_SENIOR
2025-06-27 05:15:14.310 E           WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:14.315 E           USER_NAME                       TMP_4468_SENIOR
2025-06-27 05:15:14.320 E           SEC_ADMIN                       <true>
2025-06-27 05:15:14.324 E           RDB_ADMIN                       <true>
2025-06-27 05:15:14.330 E           RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:14.341 E           Records affected: 2
2025-06-27 05:15:14.349 E           MSG                             point-3
2025-06-27 05:15:14.355 E           WHO_AM_I                        TMP_4468_SENIOR
2025-06-27 05:15:14.361 E           WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:14.366 E           USER_NAME                       TMP_4468_JUNIOR
2025-06-27 05:15:14.370 E           SEC_ADMIN                       <true>
2025-06-27 05:15:14.375 E           RDB_ADMIN                       <false>
2025-06-27 05:15:14.382 E           RDB_ADM_GRANT_OPTION            <null>
2025-06-27 05:15:14.388 E           MSG                             point-3
2025-06-27 05:15:14.395 E           WHO_AM_I                        TMP_4468_SENIOR
2025-06-27 05:15:14.401 E           WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:14.407 E           USER_NAME                       TMP_4468_SENIOR
2025-06-27 05:15:14.414 E           SEC_ADMIN                       <true>
2025-06-27 05:15:14.421 E           RDB_ADMIN                       <true>
2025-06-27 05:15:14.435 E           RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:14.446 E           Records affected: 2
2025-06-27 05:15:14.454 E           MSG                             point-4
2025-06-27 05:15:14.462 E           WHO_AM_I                        TMP_4468_SENIOR
2025-06-27 05:15:14.473 E           WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:14.481 E           USER_NAME                       TMP_4468_JUNIOR
2025-06-27 05:15:14.487 E           SEC_ADMIN                       <true>
2025-06-27 05:15:14.493 E           RDB_ADMIN                       <true>
2025-06-27 05:15:14.499 E           RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:14.505 E           MSG                             point-4
2025-06-27 05:15:14.510 E           WHO_AM_I                        TMP_4468_SENIOR
2025-06-27 05:15:14.519 E           WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:14.528 E           USER_NAME                       TMP_4468_SENIOR
2025-06-27 05:15:14.537 E           SEC_ADMIN                       <true>
2025-06-27 05:15:14.549 E           RDB_ADMIN                       <true>
2025-06-27 05:15:14.561 E           RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:14.570 E           Records affected: 2
2025-06-27 05:15:14.579 E           MSG                             point-5
2025-06-27 05:15:14.589 E           WHO_AM_I                        TMP_4468_SENIOR
2025-06-27 05:15:14.599 E           WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:14.610 E           USER_NAME                       TMP_4468_JUNIOR
2025-06-27 05:15:14.620 E           SEC_ADMIN                       <false>
2025-06-27 05:15:14.628 E           RDB_ADMIN                       <true>
2025-06-27 05:15:14.636 E           RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:14.642 E           MSG                             point-5
2025-06-27 05:15:14.653 E           WHO_AM_I                        TMP_4468_SENIOR
2025-06-27 05:15:14.664 E           WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:14.675 E           USER_NAME                       TMP_4468_SENIOR
2025-06-27 05:15:14.684 E           SEC_ADMIN                       <true>
2025-06-27 05:15:14.692 E           RDB_ADMIN                       <true>
2025-06-27 05:15:14.698 E           RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:14.705 E           Records affected: 2
2025-06-27 05:15:14.717 E           MSG                             point-6
2025-06-27 05:15:14.727 E           WHO_AM_I                        TMP_4468_SENIOR
2025-06-27 05:15:14.734 E           WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:14.745 E           USER_NAME                       TMP_4468_JUNIOR
2025-06-27 05:15:14.754 E           SEC_ADMIN                       <false>
2025-06-27 05:15:14.760 E           RDB_ADMIN                       <false>
2025-06-27 05:15:14.767 E           RDB_ADM_GRANT_OPTION            <null>
2025-06-27 05:15:14.774 E           MSG                             point-6
2025-06-27 05:15:14.779 E           WHO_AM_I                        TMP_4468_SENIOR
2025-06-27 05:15:14.785 E           WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:14.791 E           USER_NAME                       TMP_4468_SENIOR
2025-06-27 05:15:14.796 E           SEC_ADMIN                       <true>
2025-06-27 05:15:14.802 E           RDB_ADMIN                       <true>
2025-06-27 05:15:14.812 E           RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:14.821 E           Records affected: 2
2025-06-27 05:15:14.832 E           MSG                             point-7
2025-06-27 05:15:14.844 E           WHO_AM_I                        TMP_4468_SENIOR
2025-06-27 05:15:14.852 E           WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:14.862 E           USER_NAME                       TMP_4468_SENIOR
2025-06-27 05:15:14.869 E           SEC_ADMIN                       <false>
2025-06-27 05:15:14.875 E           RDB_ADMIN                       <true>
2025-06-27 05:15:14.881 E           RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:14.885 E           Records affected: 1
2025-06-27 05:15:14.890 E           Statement failed, SQLSTATE = 28000
2025-06-27 05:15:14.895 E           delete record
2025-06-27 05:15:14.902 E         - -no permission for DELETE access to TABLE PLG
2025-06-27 05:15:14.912 E         + -no permission for DELETE access to TABLE "PLG$SRP"."PLG$SRP_VIEW"
2025-06-27 05:15:14.928 E           MSG                             point-8
2025-06-27 05:15:14.935 E           WHO_AM_I                        TMP_4468_SENIOR
2025-06-27 05:15:14.942 E           WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:14.947 E           USER_NAME                       TMP_4468_SENIOR
2025-06-27 05:15:14.953 E           SEC_ADMIN                       <false>
2025-06-27 05:15:14.965 E           RDB_ADMIN                       <true>
2025-06-27 05:15:14.974 E           RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:14.980 E           Records affected: 1
2025-06-27 05:15:14.985 E           MSG                             finish
2025-06-27 05:15:14.990 E           WHO_AM_I                        TMP_4468_SENIOR
2025-06-27 05:15:15.000 E           WHATS_MY_ROLE                   RDB$ADMIN
2025-06-27 05:15:15.008 E           USER_NAME                       TMP_4468_SENIOR
2025-06-27 05:15:15.021 E           SEC_ADMIN                       <false>
2025-06-27 05:15:15.028 E           RDB_ADMIN                       <true>
2025-06-27 05:15:15.034 E           RDB_ADM_GRANT_OPTION            0
2025-06-27 05:15:15.043 E           Records affected: 1
2025-06-27 05:15:15.051
2025-06-27 05:15:15.058 tests/bugs/core_4468_test.py:291: AssertionError
2025-06-27 05:15:15.063 ---------------------------- Captured stdout setup -----------------------------
2025-06-27 05:15:15.067 Creating db: localhost:/var/tmp/qa_2024/test_1862/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
2025-06-27 05:15:15.072 CREATE user: TMP_4468_SENIOR PLUGIN: Srp
2025-06-27 05:15:15.076 CREATE user: TMP_4468_JUNIOR PLUGIN: Srp
2025-06-27 05:15:15.083 --------------------------- Captured stdout teardown ---------------------------
2025-06-27 05:15:15.095 DROP user: TMP_4468_JUNIOR PLUGIN: Srp
2025-06-27 05:15:15.105 DROP user: TMP_4468_SENIOR PLUGIN: Srp
3 #text
act = <firebird.qa.plugin.Action pytest object at [hex]>
tmp_senior = <firebird.qa.plugin.User pytest object at [hex]>
tmp_junior = <firebird.qa.plugin.User pytest object at [hex]>

    @pytest.mark.version('>=3.0')
    def test_1(act: Action, tmp_senior: User, tmp_junior: User):
    
        test_sql = f"""
            set wng off;
            set list on;
            set count on;
    
            -- ::: NB ::: Name of PLG-* depends on value of UserManager = Srp or Legacy_UserManager.
            -- For 'Srp' it will be 'PLG$SRP_VIEW', for Legacy_UserManager -- PLG$VIEW_USERS.
            -- Because of this, section 'substitution' has been added in order to ignore rest part of line
            -- after words 'TABLE PLG'.
            -- Also, text in message about deletion fault differs in case of UserManager setting:
            -- 'find/delete record error' - for Legacy_UserManager
            -- 'delete record error' = for Srp
            -- This is minor bug in Legacy_UserManager but it will be remain 'as is', see letter from Alex 03-jun-2015 19:51.
            recreate view v_users as
            select
                 current_user who_am_i
                ,current_role whats_my_role
                ,u.sec$user_name user_name
                ,u.sec$admin sec_admin
                ,g.rdb$privilege is not null as rdb_admin
                ,g.rdb$grant_option rdb_adm_grant_option
            from rdb$database
            left join sec$users u on u.sec$user_name in ( upper('{tmp_senior.name}'), upper('{tmp_junior.name}') )
            left join rdb$user_privileges g on u.sec$user_name = g.rdb$user and g.rdb$privilege = upper('m') and g.rdb$relation_name = upper('rdb$admin')
            order by user_name
            ;
            commit;
    
            grant select on v_users to public;
            commit;
    
            select 'start' msg, v.* from v_users v;
            commit;
    
            revoke all on all from {tmp_senior.name};
            grant rdb$admin to {tmp_senior.name}; -- this is also mandatory: it gives him admin role in ($dsn) database
            commit;
    
            select 'point-1' msg, v.* from v_users v;
            commit;
    
            -- When '{tmp_senior.name}' connects to database ($dsn), there is no way for engine to recognize that this user
            -- has been granted with admin role in 'CREATE USER ... GRANT ADMIN ROLE' statement. So, user has to specify
            -- `role 'RDB$ADMIN'` in order to connect as ADMIN.
            -- But with RDB$ADMIN only he can create objects in THAT database (tables etc), but not other USERS!
            -- Thats why he should also be granted with admin role in 'CREATE USER ...' - see above.
            connect '{act.db.dsn}' user '{tmp_senior.name}' password '{tmp_senior.password}' role 'RDB$ADMIN';
            commit;
    
            -- Users are stored in Security DB,  *not* in "this" database!
            -- So, following statement will pass only if '{tmp_senior.name}' has been granted by 'admin role'
            -- in his own 'create user' phase:
            create or alter user {tmp_junior.name} password '{tmp_junior.password}' revoke admin role;
            commit;
    
            select 'point-2' msg, v.* from v_users v;
    
            alter user {tmp_junior.name} grant admin role;
            commit;
    
            select 'point-3' msg, v.* from v_users v;
    
            grant rdb$admin to {tmp_junior.name};
            commit;
    
            select 'point-4' msg, v.* from v_users v;
    
            alter user {tmp_junior.name} revoke admin role;
            commit;
    
            select 'point-5' msg, v.* from v_users v;
            commit;
    
            revoke rdb$admin from {tmp_junior.name};
            commit;
    
            select 'point-6' msg, v.* from v_users v;
            commit;
    
            -- User removes admin role from himself:
    
            /****************************************
            -- 1. This will FAIL:
            -- -REVOKE failed
            -- -{tmp_senior.name} is not grantor of Role on RDB$ADMIN to {tmp_senior.name}.
            revoke rdb$admin from {tmp_senior.name};
            commit;
            *******************************************/
    
            -- 2 This will PASS, and it MUST be so (see letter from Alex, 03-jun-2015 19:46)
            alter user {tmp_senior.name} revoke admin role;
            commit;
    
            select 'point-7' msg, v.* from v_users v;
            commit;
    
            -- And after previous action he can not drop himself because now he is NOT member of admin role:
            -- Statement failed, SQLSTATE = 28000
            -- find/delete record error
            -- -no permission for DELETE access to TABLE PLG$VIEW_USERS
            drop user {tmp_senior.name};
            commit;
    
            select 'point-8' msg, v.* from v_users v;
            commit;
    
            -- Trying reconnect with role RDB$ADMIN:
            connect '{act.db.dsn}' user '{tmp_senior.name}' password '{tmp_senior.password}' role 'RDB$ADMIN';
            commit;
    
            select 'finish' msg, v.* from v_users v;
            commit;
        """
    
        expected_out = f"""
            MSG                             start
            WHO_AM_I                        {act.db.user}
            WHATS_MY_ROLE                   NONE
            USER_NAME                       {tmp_junior.name}
            SEC_ADMIN                       <false>
            RDB_ADMIN                       <false>
            RDB_ADM_GRANT_OPTION            <null>
            MSG                             start
            WHO_AM_I                        {act.db.user}
            WHATS_MY_ROLE                   NONE
            USER_NAME                       {tmp_senior.name}
            SEC_ADMIN                       <true>
            RDB_ADMIN                       <false>
            RDB_ADM_GRANT_OPTION            <null>
            Records affected: 2
            MSG                             point-1
            WHO_AM_I                        {act.db.user}
            WHATS_MY_ROLE                   NONE
            USER_NAME                       {tmp_junior.name}
            SEC_ADMIN                       <false>
            RDB_ADMIN                       <false>
            RDB_ADM_GRANT_OPTION            <null>
            MSG                             point-1
            WHO_AM_I                        {act.db.user}
            WHATS_MY_ROLE                   NONE
            USER_NAME                       {tmp_senior.name}
            SEC_ADMIN                       <true>
            RDB_ADMIN                       <true>
            RDB_ADM_GRANT_OPTION            0
            Records affected: 2
            MSG                             point-2
            WHO_AM_I                        {tmp_senior.name}
            WHATS_MY_ROLE                   RDB$ADMIN
            USER_NAME                       {tmp_junior.name}
            SEC_ADMIN                       <false>
            RDB_ADMIN                       <false>
            RDB_ADM_GRANT_OPTION            <null>
            MSG                             point-2
            WHO_AM_I                        {tmp_senior.name}
            WHATS_MY_ROLE                   RDB$ADMIN
            USER_NAME                       {tmp_senior.name}
            SEC_ADMIN                       <true>
            RDB_ADMIN                       <true>
            RDB_ADM_GRANT_OPTION            0
            Records affected: 2
            MSG                             point-3
            WHO_AM_I                        {tmp_senior.name}
            WHATS_MY_ROLE                   RDB$ADMIN
            USER_NAME                       {tmp_junior.name}
            SEC_ADMIN                       <true>
            RDB_ADMIN                       <false>
            RDB_ADM_GRANT_OPTION            <null>
            MSG                             point-3
            WHO_AM_I                        {tmp_senior.name}
            WHATS_MY_ROLE                   RDB$ADMIN
            USER_NAME                       {tmp_senior.name}
            SEC_ADMIN                       <true>
            RDB_ADMIN                       <true>
            RDB_ADM_GRANT_OPTION            0
            Records affected: 2
            MSG                             point-4
            WHO_AM_I                        {tmp_senior.name}
            WHATS_MY_ROLE                   RDB$ADMIN
            USER_NAME                       {tmp_junior.name}
            SEC_ADMIN                       <true>
            RDB_ADMIN                       <true>
            RDB_ADM_GRANT_OPTION            0
            MSG                             point-4
            WHO_AM_I                        {tmp_senior.name}
            WHATS_MY_ROLE                   RDB$ADMIN
            USER_NAME                       {tmp_senior.name}
            SEC_ADMIN                       <true>
            RDB_ADMIN                       <true>
            RDB_ADM_GRANT_OPTION            0
            Records affected: 2
            MSG                             point-5
            WHO_AM_I                        {tmp_senior.name}
            WHATS_MY_ROLE                   RDB$ADMIN
            USER_NAME                       {tmp_junior.name}
            SEC_ADMIN                       <false>
            RDB_ADMIN                       <true>
            RDB_ADM_GRANT_OPTION            0
            MSG                             point-5
            WHO_AM_I                        {tmp_senior.name}
            WHATS_MY_ROLE                   RDB$ADMIN
            USER_NAME                       {tmp_senior.name}
            SEC_ADMIN                       <true>
            RDB_ADMIN                       <true>
            RDB_ADM_GRANT_OPTION            0
            Records affected: 2
            MSG                             point-6
            WHO_AM_I                        {tmp_senior.name}
            WHATS_MY_ROLE                   RDB$ADMIN
            USER_NAME                       {tmp_junior.name}
            SEC_ADMIN                       <false>
            RDB_ADMIN                       <false>
            RDB_ADM_GRANT_OPTION            <null>
            MSG                             point-6
            WHO_AM_I                        {tmp_senior.name}
            WHATS_MY_ROLE                   RDB$ADMIN
            USER_NAME                       {tmp_senior.name}
            SEC_ADMIN                       <true>
            RDB_ADMIN                       <true>
            RDB_ADM_GRANT_OPTION            0
            Records affected: 2
            MSG                             point-7
            WHO_AM_I                        {tmp_senior.name}
            WHATS_MY_ROLE                   RDB$ADMIN
            USER_NAME                       {tmp_senior.name}
            SEC_ADMIN                       <false>
            RDB_ADMIN                       <true>
            RDB_ADM_GRANT_OPTION            0
            Records affected: 1
            Statement failed, SQLSTATE = 28000
            delete record
            -no permission for DELETE access to TABLE PLG
            MSG                             point-8
            WHO_AM_I                        {tmp_senior.name}
            WHATS_MY_ROLE                   RDB$ADMIN
            USER_NAME                       {tmp_senior.name}
            SEC_ADMIN                       <false>
            RDB_ADMIN                       <true>
            RDB_ADM_GRANT_OPTION            0
            Records affected: 1
            MSG                             finish
            WHO_AM_I                        {tmp_senior.name}
            WHATS_MY_ROLE                   RDB$ADMIN
            USER_NAME                       {tmp_senior.name}
            SEC_ADMIN                       <false>
            RDB_ADMIN                       <true>
            RDB_ADM_GRANT_OPTION            0
            Records affected: 1
        """
    
        act.expected_stdout = expected_out # expected_5x if act.is_version('<6') else expected_6x
        act.isql(switches = ['-q'], input = test_sql, combine_output = True, io_enc = locale.getpreferredencoding())
>       assert act.clean_stdout == act.clean_expected_stdout
E       assert   
E           MSG                             start
E           WHO_AM_I                        SYSDBA
E           WHATS_MY_ROLE                   NONE
E           USER_NAME                       TMP_4468_JUNIOR
E           SEC_ADMIN                       <false>
E           RDB_ADMIN                       <false>
E           RDB_ADM_GRANT_OPTION            <null>
E           MSG                             start
E           WHO_AM_I                        SYSDBA
E           WHATS_MY_ROLE                   NONE
E           USER_NAME                       TMP_4468_SENIOR
E           SEC_ADMIN                       <true>
E           RDB_ADMIN                       <false>
E           RDB_ADM_GRANT_OPTION            <null>
E           Records affected: 2
E           MSG                             point-1
E           WHO_AM_I                        SYSDBA
E           WHATS_MY_ROLE                   NONE
E           USER_NAME                       TMP_4468_JUNIOR
E           SEC_ADMIN                       <false>
E           RDB_ADMIN                       <false>
E           RDB_ADM_GRANT_OPTION            <null>
E           MSG                             point-1
E           WHO_AM_I                        SYSDBA
E           WHATS_MY_ROLE                   NONE
E           USER_NAME                       TMP_4468_SENIOR
E           SEC_ADMIN                       <true>
E           RDB_ADMIN                       <true>
E           RDB_ADM_GRANT_OPTION            0
E           Records affected: 2
E           MSG                             point-2
E           WHO_AM_I                        TMP_4468_SENIOR
E           WHATS_MY_ROLE                   RDB$ADMIN
E           USER_NAME                       TMP_4468_JUNIOR
E           SEC_ADMIN                       <false>
E           RDB_ADMIN                       <false>
E           RDB_ADM_GRANT_OPTION            <null>
E           MSG                             point-2
E           WHO_AM_I                        TMP_4468_SENIOR
E           WHATS_MY_ROLE                   RDB$ADMIN
E           USER_NAME                       TMP_4468_SENIOR
E           SEC_ADMIN                       <true>
E           RDB_ADMIN                       <true>
E           RDB_ADM_GRANT_OPTION            0
E           Records affected: 2
E           MSG                             point-3
E           WHO_AM_I                        TMP_4468_SENIOR
E           WHATS_MY_ROLE                   RDB$ADMIN
E           USER_NAME                       TMP_4468_JUNIOR
E           SEC_ADMIN                       <true>
E           RDB_ADMIN                       <false>
E           RDB_ADM_GRANT_OPTION            <null>
E           MSG                             point-3
E           WHO_AM_I                        TMP_4468_SENIOR
E           WHATS_MY_ROLE                   RDB$ADMIN
E           USER_NAME                       TMP_4468_SENIOR
E           SEC_ADMIN                       <true>
E           RDB_ADMIN                       <true>
E           RDB_ADM_GRANT_OPTION            0
E           Records affected: 2
E           MSG                             point-4
E           WHO_AM_I                        TMP_4468_SENIOR
E           WHATS_MY_ROLE                   RDB$ADMIN
E           USER_NAME                       TMP_4468_JUNIOR
E           SEC_ADMIN                       <true>
E           RDB_ADMIN                       <true>
E           RDB_ADM_GRANT_OPTION            0
E           MSG                             point-4
E           WHO_AM_I                        TMP_4468_SENIOR
E           WHATS_MY_ROLE                   RDB$ADMIN
E           USER_NAME                       TMP_4468_SENIOR
E           SEC_ADMIN                       <true>
E           RDB_ADMIN                       <true>
E           RDB_ADM_GRANT_OPTION            0
E           Records affected: 2
E           MSG                             point-5
E           WHO_AM_I                        TMP_4468_SENIOR
E           WHATS_MY_ROLE                   RDB$ADMIN
E           USER_NAME                       TMP_4468_JUNIOR
E           SEC_ADMIN                       <false>
E           RDB_ADMIN                       <true>
E           RDB_ADM_GRANT_OPTION            0
E           MSG                             point-5
E           WHO_AM_I                        TMP_4468_SENIOR
E           WHATS_MY_ROLE                   RDB$ADMIN
E           USER_NAME                       TMP_4468_SENIOR
E           SEC_ADMIN                       <true>
E           RDB_ADMIN                       <true>
E           RDB_ADM_GRANT_OPTION            0
E           Records affected: 2
E           MSG                             point-6
E           WHO_AM_I                        TMP_4468_SENIOR
E           WHATS_MY_ROLE                   RDB$ADMIN
E           USER_NAME                       TMP_4468_JUNIOR
E           SEC_ADMIN                       <false>
E           RDB_ADMIN                       <false>
E           RDB_ADM_GRANT_OPTION            <null>
E           MSG                             point-6
E           WHO_AM_I                        TMP_4468_SENIOR
E           WHATS_MY_ROLE                   RDB$ADMIN
E           USER_NAME                       TMP_4468_SENIOR
E           SEC_ADMIN                       <true>
E           RDB_ADMIN                       <true>
E           RDB_ADM_GRANT_OPTION            0
E           Records affected: 2
E           MSG                             point-7
E           WHO_AM_I                        TMP_4468_SENIOR
E           WHATS_MY_ROLE                   RDB$ADMIN
E           USER_NAME                       TMP_4468_SENIOR
E           SEC_ADMIN                       <false>
E           RDB_ADMIN                       <true>
E           RDB_ADM_GRANT_OPTION            0
E           Records affected: 1
E           Statement failed, SQLSTATE = 28000
E           delete record
E         - -no permission for DELETE access to TABLE PLG
E         + -no permission for DELETE access to TABLE "PLG$SRP"."PLG$SRP_VIEW"
E           MSG                             point-8
E           WHO_AM_I                        TMP_4468_SENIOR
E           WHATS_MY_ROLE                   RDB$ADMIN
E           USER_NAME                       TMP_4468_SENIOR
E           SEC_ADMIN                       <false>
E           RDB_ADMIN                       <true>
E           RDB_ADM_GRANT_OPTION            0
E           Records affected: 1
E           MSG                             finish
E           WHO_AM_I                        TMP_4468_SENIOR
E           WHATS_MY_ROLE                   RDB$ADMIN
E           USER_NAME                       TMP_4468_SENIOR
E           SEC_ADMIN                       <false>
E           RDB_ADMIN                       <true>
E           RDB_ADM_GRANT_OPTION            0
E           Records affected: 1

tests/bugs/core_4468_test.py:291: 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.884 2025.06.30 f7e5f P P 2972 1674 2025.07.01 00:46:04.604 2025.07.01 00:46:07.576 2025.06.30 21:47:37.769 2025.06.30 21:47:39.443
2 6.0.0.881 2025.06.27 7035d P P 3049 1913 2025.06.30 00:32:18.982 2025.06.30 00:32:22.031 2025.06.29 21:35:26.838 2025.06.29 21:35:28.751
3 6.0.0.877 2025.06.26 8e38f F F 3786 1650 2025.06.27 00:16:29.624 2025.06.27 00:16:33.410 2025.06.26 21:33:42.198 2025.06.26 21:33:43.848
4 6.0.0.876 2025.06.25 b1bec F F 2965 1778 2025.06.26 00:19:25.315 2025.06.26 00:19:28.280 2025.06.25 21:34:25.119 2025.06.25 21:34:26.897
5 6.0.0.863 2025.06.24 c3c20 F F 2924 1803 2025.06.25 00:20:37.091 2025.06.25 00:20:40.015 2025.06.24 21:33:41.780 2025.06.24 21:33:43.583
6 6.0.0.858 2025.06.23 8d6f7 F F 3189 1635 2025.06.24 00:20:04.894 2025.06.24 00:20:08.083 2025.06.23 21:34:17.951 2025.06.23 21:34:19.586
7 6.0.0.849 2025.06.20 7b79c F F 2766 1739 2025.06.21 00:30:22.656 2025.06.21 00:30:25.422 2025.06.20 21:37:42.054 2025.06.20 21:37:43.793
8 6.0.0.848 2025.06.19 c483c F F 3190 1759 2025.06.20 00:26:37.018 2025.06.20 00:26:40.208 2025.06.19 21:36:09.090 2025.06.19 21:36:10.849
9 6.0.0.845 2025.06.18 22b12 F F 3063 2028 2025.06.19 00:32:47.309 2025.06.19 00:32:50.372 2025.06.18 21:35:37.727 2025.06.18 21:35:39.755
10 6.0.0.843 2025.06.16 995f4 F F 2882 1876 2025.06.18 00:34:11.688 2025.06.18 00:34:14.570 2025.06.17 21:38:03.210 2025.06.17 21:38:05.086
11 6.0.0.840 2025.06.14 29bca F F 3037 1860 2025.06.16 00:23:35.573 2025.06.16 00:23:38.610 2025.06.15 21:34:35.920 2025.06.15 21:34:37.780
12 6.0.0.838 2025.06.13 0e28a F F 3127 1877 2025.06.14 00:35:27.570 2025.06.14 00:35:30.697 2025.06.13 21:35:37.726 2025.06.13 21:35:39.603
13 6.0.0.835 2025.06.12 2cf29 F F 3024 1912 2025.06.13 00:36:30.148 2025.06.13 00:36:33.172 2025.06.12 21:41:23.533 2025.06.12 21:41:25.445
14 6.0.0.834 2025.06.11 e889f F F 2889 1909 2025.06.12 00:33:23.513 2025.06.12 00:33:26.402 2025.06.11 21:37:14.118 2025.06.11 21:37:16.027
15 6.0.0.800 2025.06.10 1f226 P P 2461 1790 2025.06.10 23:34:41.662 2025.06.10 23:34:44.123 2025.06.10 21:36:26.497 2025.06.10 21:36:28.287
16 6.0.0.799 2025.06.07 be644 P P 4001 1741 2025.06.09 23:33:48.265 2025.06.09 23:33:52.266 2025.06.09 21:35:59.493 2025.06.09 21:36:01.234
17 6.0.0.797 2025.06.06 303e8 P P 4162 1618 2025.06.06 23:35:04.841 2025.06.06 23:35:09.003 2025.06.06 21:33:20.197 2025.06.06 21:33:21.815
18 6.0.0.795 2025.05.29 7a71a P P 4220 1676 2025.06.05 23:31:48.210 2025.06.05 23:31:52.430 2025.06.05 21:32:45.981 2025.06.05 21:32:47.657
19 6.0.0.792 2025.05.28 b4327 P P 2659 1686 2025.05.28 23:40:18.446 2025.05.28 23:40:21.105 2025.05.28 21:34:00.401 2025.05.28 21:34:02.087
20 6.0.0.791 2025.05.27 02db8 P P 4697 1716 2025.05.27 23:38:25.809 2025.05.27 23:38:30.506 2025.05.27 21:33:18.795 2025.05.27 21:33:20.511
21 6.0.0.789 2025.05.21 64051 P P 4335 1666 2025.05.24 23:35:26.522 2025.05.24 23:35:30.857 2025.05.24 21:33:09.449 2025.05.24 21:33:11.115
22 6.0.0.787 2025.05.20 230ad P P 2542 1643 2025.05.20 23:32:43.745 2025.05.20 23:32:46.287 2025.05.20 21:33:11.474 2025.05.20 21:33:13.117
23 6.0.0.783 2025.05.12 37320 P P 2942 1715 2025.05.19 11:12:04.129 2025.05.19 11:12:07.071 2025.05.19 09:24:35.544 2025.05.19 09:24:37.259
24 6.0.0.779 2025.05.11 136fa F F 4347 1819 2025.05.11 23:29:57.246 2025.05.11 23:30:01.593 2025.05.11 21:32:32.254 2025.05.11 21:32:34.073
25 6.0.0.778 2025.05.07 d735e F F 4187 1733 2025.05.07 23:29:04.062 2025.05.07 23:29:08.249 2025.05.07 21:32:35.803 2025.05.07 21:32:37.536
26 6.0.0.776 2025.05.06 007cd P P 4371 1807 2025.05.06 23:21:24.291 2025.05.06 23:21:28.662 2025.05.06 21:32:25.028 2025.05.06 21:32:26.835
27 6.0.0.770 2025.05.05 82c4a P P 4979 1874 2025.05.05 23:20:30.767 2025.05.05 23:20:35.746 2025.05.05 21:32:37.613 2025.05.05 21:32:39.487
28 6.0.0.767 2025.05.01 cdd29 P P 2960 1818 2025.05.01 23:19:06.322 2025.05.01 23:19:09.282 2025.05.01 21:32:29.862 2025.05.01 21:32:31.680
29 6.0.0.762 2025.04.30 5cb15 P P 4164 1786 2025.04.30 23:16:27.022 2025.04.30 23:16:31.186 2025.04.30 21:32:04.412 2025.04.30 21:32:06.198
30 6.0.0.755 2025.04.29 739c6 P P 4069 1817 2025.04.29 23:18:36.237 2025.04.29 23:18:40.306 2025.04.29 21:32:17.136 2025.04.29 21:32:18.953
31 6.0.0.753 2025.04.27 29ab3 P P 4893 1684 2025.04.27 23:18:36.125 2025.04.27 23:18:41.018 2025.04.27 21:32:14.619 2025.04.27 21:32:16.303
32 6.0.0.745 2025.04.21 78ad8 P P 4238 1802 2025.04.25 23:18:06.622 2025.04.25 23:18:10.860 2025.04.25 21:33:43.165 2025.04.25 21:33:44.967
33 6.0.0.744 2025.04.19 e883a P P 4281 1723 2025.04.19 23:19:29.181 2025.04.19 23:19:33.462 2025.04.19 21:32:24.694 2025.04.19 21:32:26.417
34 6.0.0.742 2025.04.17 abc3b P P 4497 1698 2025.04.18 23:20:20.977 2025.04.18 23:20:25.474 2025.04.18 21:32:26.443 2025.04.18 21:32:28.141
35 6.0.0.737 2025.04.16 fe52b P P 4339 1789 2025.04.16 23:19:47.538 2025.04.16 23:19:51.877 2025.04.16 21:32:22.027 2025.04.16 21:32:23.816
36 6.0.0.736 2025.04.14 3e6be P P 3911 1540 2025.04.14 23:05:58.368 2025.04.14 23:06:02.279 2025.04.14 21:30:52.230 2025.04.14 21:30:53.770
37 6.0.0.735 2025.04.13 6635c P P 3975 1669 2025.04.13 23:07:16.591 2025.04.13 23:07:20.566 2025.04.13 21:31:22.045 2025.04.13 21:31:23.714
38 6.0.0.734 2025.04.12 12f3f P P 3795 1523 2025.04.12 23:06:16.671 2025.04.12 23:06:20.466 2025.04.12 21:30:59.780 2025.04.12 21:31:01.303
39 6.0.0.730 2025.04.11 240b8 P P 2322 1557 2025.04.11 23:07:17.773 2025.04.11 23:07:20.095 2025.04.11 21:30:48.991 2025.04.11 21:30:50.548
40 6.0.0.726 2025.04.10 d79c6 P P 4110 1505 2025.04.10 23:06:58.925 2025.04.10 23:07:03.035 2025.04.10 21:30:55.508 2025.04.10 21:30:57.013
41 6.0.0.725 2025.04.09 a2b05 P P 4116 1599 2025.04.09 23:07:03.990 2025.04.09 23:07:08.106 2025.04.09 21:31:19.126 2025.04.09 21:31:20.725
42 6.0.0.722 2025.04.08 a8b86 P P 4500 1626 2025.04.08 23:17:34.750 2025.04.08 23:17:39.250 2025.04.08 21:32:20.630 2025.04.08 21:32:22.256
43 6.0.0.719 2025.04.06 90fd9 P P 2679 1715 2025.04.06 23:15:44.075 2025.04.06 23:15:46.754 2025.04.06 21:32:35.002 2025.04.06 21:32:36.717
44 6.0.0.717 2025.04.04 53d70 P P 4170 1894 2025.04.04 23:13:23.103 2025.04.04 23:13:27.273 2025.04.04 21:32:02.933 2025.04.04 21:32:04.827
45 6.0.0.716 2025.04.03 fc636 P P 4413 1741 2025.04.03 23:16:41.066 2025.04.03 23:16:45.479 2025.04.03 21:32:15.242 2025.04.03 21:32:16.983
46 6.0.0.715 2025.04.02 907ed P P 4192 1802 2025.04.02 23:16:29.602 2025.04.02 23:16:33.794 2025.04.02 21:32:34.330 2025.04.02 21:32:36.132
47 6.0.0.710 2025.04.01 40651 P P 4555 1783 2025.04.01 23:15:32.275 2025.04.01 23:15:36.830 2025.04.01 21:32:10.515 2025.04.01 21:32:12.298
48 6.0.0.708 2025.03.31 cb069 P P 3540 1653 2025.03.31 23:08:35.371 2025.03.31 23:08:38.911 2025.03.31 21:31:24.517 2025.03.31 21:31:26.170
49 6.0.0.707 2025.03.28 4bd4f P P 4152 1622 2025.03.30 23:08:02.029 2025.03.30 23:08:06.181 2025.03.30 21:31:19.293 2025.03.30 21:31:20.915
50 6.0.0.698 2025.03.26 d72a7 P P 4504 1428 2025.03.27 23:20:25.967 2025.03.27 23:20:30.471 2025.03.27 21:32:43.490 2025.03.27 21:32:44.918
51 6.0.0.693 2025.03.24 0b559 P P 4235 1317 2025.03.24 23:13:01.735 2025.03.24 23:13:05.970 2025.03.24 21:32:38.839 2025.03.24 21:32:40.156
52 6.0.0.687 2025.03.22 730aa P P 4738 1838 2025.03.23 23:22:38.089 2025.03.23 23:22:42.827 2025.03.23 21:32:36.868 2025.03.23 21:32:38.706
53 6.0.0.686 2025.03.20 71bf6 P P 4751 1832 2025.03.20 23:26:16.110 2025.03.20 23:26:20.861 2025.03.20 21:33:02.918 2025.03.20 21:33:04.750
54 6.0.0.685 2025.03.19 a8577 P P 4450 1680 2025.03.19 23:24:17.493 2025.03.19 23:24:21.943 2025.03.19 21:32:36.827 2025.03.19 21:32:38.507
55 6.0.0.680 2025.03.18 90d29 P P 1856 899 2025.03.19 09:59:20.761 2025.03.19 09:59:22.617 2025.03.19 08:22:18.115 2025.03.19 08:22:19.014
56 6.0.0.677 2025.03.16 c0a60 P P 1616 1045 2025.03.16 23:17:42.491 2025.03.16 23:17:44.107 2025.03.16 21:32:49.646 2025.03.16 21:32:50.691
57 6.0.0.676 2025.03.15 3034f P P 1879 923 2025.03.16 15:01:14.615 2025.03.16 15:01:16.494 2025.03.16 13:28:07.309 2025.03.16 13:28:08.232
58 6.0.0.673 2025.03.13 40f5b P P 1598 952 2025.03.13 23:16:48.596 2025.03.13 23:16:50.194 2025.03.13 21:32:24.150 2025.03.13 21:32:25.102
59 6.0.0.671 2025.03.12 a4fff P P 1946 917 2025.03.12 23:20:44.525 2025.03.12 23:20:46.471 2025.03.12 21:32:59.598 2025.03.12 21:33:00.515
60 6.0.0.663 2025.03.11 daad2 P P 2668 869 2025.03.11 23:18:42.120 2025.03.11 23:18:44.788 2025.03.11 21:33:12.523 2025.03.11 21:33:13.392
61 6.0.0.661 2025.03.07 b9869 P P 2061 904 2025.03.10 23:05:28.826 2025.03.10 23:05:30.887 2025.03.10 21:31:41.629 2025.03.10 21:31:42.533
62 6.0.0.660 2025.03.04 a6700 P P 2271 987 2025.03.06 23:11:51.647 2025.03.06 23:11:53.918 2025.03.06 21:32:01.550 2025.03.06 21:32:02.537
63 6.0.0.658 2025.03.03 f15f8 P P 2456 947 2025.03.03 23:07:37.951 2025.03.03 23:07:40.407 2025.03.03 21:31:41.884 2025.03.03 21:31:42.831
64 6.0.0.656 2025.02.27 25fb4 P P 2792 1102 2025.03.02 23:23:58.318 2025.03.02 23:24:01.110 2025.03.02 21:33:42.012 2025.03.02 21:33:43.114
65 6.0.0.655 2025.02.25 6e3e0 P P 1549 996 2025.02.26 23:10:21.225 2025.02.26 23:10:22.774 2025.02.26 21:31:47.209 2025.02.26 21:31:48.205
66 6.0.0.654 2025.02.24 b7141 P P 2500 898 2025.02.24 23:11:36.741 2025.02.24 23:11:39.241 2025.02.24 21:32:01.581 2025.02.24 21:32:02.479
67 6.0.0.652 2025.02.22 22662 P P 1864 976 2025.02.24 06:34:56.275 2025.02.24 06:34:58.139 2025.02.23 23:49:02.179 2025.02.23 23:49:03.155
68 6.0.0.647 2025.02.21 9fccb P P 2554 891 2025.02.21 23:14:18.690 2025.02.21 23:14:21.244 2025.02.21 21:35:38.030 2025.02.21 21:35:38.921
69 6.0.0.640 2025.02.19 9b8ac P P 2685 984 2025.02.19 23:10:59.941 2025.02.19 23:11:02.626 2025.02.19 21:32:30.683 2025.02.19 21:32:31.667
70 6.0.0.639 2025.02.18 201a4 P P 1451 971 2025.02.18 23:06:30.670 2025.02.18 23:06:32.121 2025.02.18 21:31:43.936 2025.02.18 21:31:44.907
71 6.0.0.637 2025.02.12 6d0f5 P P 1587 959 2025.02.13 23:17:34.136 2025.02.13 23:17:35.723 2025.02.13 21:32:33.189 2025.02.13 21:32:34.148
72 6.0.0.636 2025.02.11 0424f P P 1557 976 2025.02.11 23:16:15.623 2025.02.11 23:16:17.180 2025.02.11 21:32:04.425 2025.02.11 21:32:05.401
73 6.0.0.635 2025.02.10 f640f P P 2644 973 2025.02.10 23:15:38.998 2025.02.10 23:15:41.642 2025.02.10 21:32:50.771 2025.02.10 21:32:51.744
74 6.0.0.629 2025.02.07 194f9 P P 1577 1050 2025.02.07 23:14:23.893 2025.02.07 23:14:25.470 2025.02.07 21:32:22.687 2025.02.07 21:32:23.737
75 6.0.0.628 2025.02.06 859d5 P P 2996 930 2025.02.06 23:20:44.237 2025.02.06 23:20:47.233 2025.02.06 21:32:13.737 2025.02.06 21:32:14.667
76 6.0.0.621 2025.02.05 34fe7 P P 2584 1069 2025.02.05 23:21:41.317 2025.02.05 23:21:43.901 2025.02.05 21:32:21.388 2025.02.05 21:32:22.457
77 6.0.0.609 2025.02.04 76d57 P P 2709 986 2025.02.04 23:16:18.441 2025.02.04 23:16:21.150 2025.02.04 21:32:22.357 2025.02.04 21:32:23.343
78 6.0.0.607 2025.02.03 1985b P P 2552 980 2025.02.03 23:17:01.170 2025.02.03 23:17:03.722 2025.02.03 21:32:43.856 2025.02.03 21:32:44.836
79 6.0.0.601 2025.02.01 6af07 P P 1677 967 2025.02.01 23:13:29.319 2025.02.01 23:13:30.996 2025.02.01 21:32:00.333 2025.02.01 21:32:01.300
80 6.0.0.600 2025.01.27 188de P P 1615 921 2025.01.27 23:17:07.855 2025.01.27 23:17:09.470 2025.01.27 21:32:15.764 2025.01.27 21:32:16.685
81 6.0.0.599 2025.01.25 ba588 P P 2524 923 2025.01.25 23:17:58.113 2025.01.25 23:18:00.637 2025.01.25 21:32:36.862 2025.01.25 21:32:37.785
82 6.0.0.598 2025.01.23 ddbc3 P P 2317 838 2025.01.24 23:17:39.706 2025.01.24 23:17:42.023 2025.01.24 21:32:17.956 2025.01.24 21:32:18.794
83 6.0.0.595 2025.01.22 e62f3 P P 1467 901 2025.01.22 23:11:16.070 2025.01.22 23:11:17.537 2025.01.22 21:31:58.106 2025.01.22 21:31:59.007
84 6.0.0.594 2025.01.21 47fb6 P P 1381 952 2025.01.21 23:10:46.162 2025.01.21 23:10:47.543 2025.01.21 21:31:52.159 2025.01.21 21:31:53.111
85 6.0.0.590 2025.01.20 9dc1e P P 1519 831 2025.01.20 23:16:27.531 2025.01.20 23:16:29.050 2025.01.20 21:32:07.850 2025.01.20 21:32:08.681
86 6.0.0.588 2025.01.19 b1c4e P P 1468 993 2025.01.19 23:12:45.355 2025.01.19 23:12:46.823 2025.01.19 21:32:58.133 2025.01.19 21:32:59.126
87 6.0.0.587 2025.01.18 63e6e P P 2091 955 2025.01.18 23:15:22.297 2025.01.18 23:15:24.388 2025.01.18 21:32:46.229 2025.01.18 21:32:47.184
88 6.0.0.585 2025.01.16 2d6bb P P 1520 945 2025.01.17 23:10:18.610 2025.01.17 23:10:20.130 2025.01.17 21:31:48.485 2025.01.17 21:31:49.430
89 6.0.0.584 2025.01.15 a0aa2 P P 1430 1040 2025.01.15 23:14:34.036 2025.01.15 23:14:35.466 2025.01.15 21:32:33.720 2025.01.15 21:32:34.760
90 6.0.0.581 2025.01.14 21e9e P P 2772 1081 2025.01.14 23:15:24.806 2025.01.14 23:15:27.578 2025.01.14 21:32:11.917 2025.01.14 21:32:12.998
91 6.0.0.577 2025.01.13 7e293 P P 1524 864 2025.01.13 23:16:04.529 2025.01.13 23:16:06.053 2025.01.13 21:32:23.722 2025.01.13 21:32:24.586
92 6.0.0.576 2025.01.12 05898 P P 2724 989 2025.01.12 23:13:17.951 2025.01.12 23:13:20.675 2025.01.12 21:31:57.470 2025.01.12 21:31:58.459
93 6.0.0.573 2025.01.10 c20f3 P P 2766 975 2025.01.10 23:13:48.713 2025.01.10 23:13:51.479 2025.01.10 21:32:13.556 2025.01.10 21:32:14.531
94 6.0.0.571 2024.12.31 81bba P P 2341 623 2024.12.31 22:49:07.421 2024.12.31 22:49:09.762 2024.12.31 21:28:43.064 2024.12.31 21:28:43.687
95 6.0.0.570 2024.12.30 c3c8d P P 2322 705 2024.12.30 22:48:25.809 2024.12.30 22:48:28.131 2024.12.30 21:28:48.394 2024.12.30 21:28:49.099
96 6.0.0.565 2024.12.28 5fc59 P P 1289 642 2024.12.30 11:46:42.812 2024.12.30 11:46:44.101 2024.12.30 10:37:23.754 2024.12.30 10:37:24.396
97 6.0.0.564 2024.12.26 12514 P P 2436 655 2024.12.26 22:50:00.779 2024.12.26 22:50:03.215 2024.12.26 21:28:40.647 2024.12.26 21:28:41.302
98 6.0.0.560 2024.12.25 fa83e P P 2365 663 2024.12.25 22:49:48.547 2024.12.25 22:49:50.912 2024.12.25 21:28:48.505 2024.12.25 21:28:49.168
99 6.0.0.559 2024.12.23 cc800 P P 2400 640 2024.12.24 22:52:22.063 2024.12.24 22:52:24.463 2024.12.24 21:28:55.225 2024.12.24 21:28:55.865
100 6.0.0.556 2024.12.22 a0404 P P 2363 630 2024.12.22 22:50:35.182 2024.12.22 22:50:37.545 2024.12.22 21:29:01.914 2024.12.22 21:29:02.544
101 6.0.0.555 2024.12.19 6990a P P 1336 651 2024.12.21 12:23:03.912 2024.12.21 12:23:05.248 2024.12.21 11:04:01.169 2024.12.21 11:04:01.820
102 6.0.0.553 2024.12.17 d1f8a P P 2374 661 2024.12.17 22:51:34.562 2024.12.17 22:51:36.936 2024.12.17 21:29:08.318 2024.12.17 21:29:08.979
103 6.0.0.552 2024.12.11 85e25 P P 2411 657 2024.12.15 22:50:12.227 2024.12.15 22:50:14.638 2024.12.15 21:29:04.308 2024.12.15 21:29:04.965
104 6.0.0.550 2024.12.10 b37ac P P 2229 746 2024.12.10 22:53:22.018 2024.12.10 22:53:24.247 2024.12.10 21:29:24.582 2024.12.10 21:29:25.328
105 6.0.0.548 2024.12.08 2cc77 P P 2313 657 2024.12.08 22:47:38.086 2024.12.08 22:47:40.399 2024.12.08 21:28:38.468 2024.12.08 21:28:39.125
106 6.0.0.544 2024.12.05 96943 P P 2332 706 2024.12.05 22:52:44.146 2024.12.05 22:52:46.478 2024.12.05 21:29:45.934 2024.12.05 21:29:46.640
107 6.0.0.543 2024.12.03 30b77 P P 2416 760 2024.12.03 22:52:11.810 2024.12.03 22:52:14.226 2024.12.03 21:29:16.717 2024.12.03 21:29:17.477
108 6.0.0.540 2024.12.02 4a1f4 P P 2401 671 2024.12.02 22:46:21.603 2024.12.02 22:46:24.004 2024.12.02 21:28:43.226 2024.12.02 21:28:43.897
109 6.0.0.539 2024.11.28 1f283 P P 2418 668 2024.11.29 22:51:12.436 2024.11.29 22:51:14.854 2024.11.29 21:28:57.884 2024.11.29 21:28:58.552
110 6.0.0.535 2024.11.26 77b95 P P 2294 629 2024.11.26 22:43:20.827 2024.11.26 22:43:23.121 2024.11.26 21:28:02.482 2024.11.26 21:28:03.111
111 6.0.0.534 2024.11.25 e9584 P P 1196 690 2024.11.25 22:44:37.467 2024.11.25 22:44:38.663 2024.11.25 21:28:18.308 2024.11.25 21:28:18.998
112 6.0.0.533 2024.11.17 933ac P P 1329 673 2024.11.22 09:03:43.732 2024.11.22 09:03:45.061 2024.11.22 07:57:35.492 2024.11.22 07:57:36.165
113 6.0.0.532 2024.11.16 9e263 P P 2216 617 2024.11.16 22:40:24.655 2024.11.16 22:40:26.871 2024.11.16 21:28:19.477 2024.11.16 21:28:20.094
114 6.0.0.530 2024.11.15 49804 P P 2052 615 2024.11.16 00:43:57.207 2024.11.16 00:43:59.259 2024.11.15 23:28:04.092 2024.11.15 23:28:04.707
115 6.0.0.528 2024.11.14 9625b P P 2140 741 2024.11.15 00:45:15.290 2024.11.15 00:45:17.430 2024.11.14 23:28:29.408 2024.11.14 23:28:30.149
116 6.0.0.526 2024.11.12 65b80 P P 1214 706 2024.11.14 00:44:57.533 2024.11.14 00:44:58.747 2024.11.13 23:28:05.804 2024.11.13 23:28:06.510
117 6.0.0.523 2024.11.08 8ca23 P P 1175 681 2024.11.11 00:42:46.290 2024.11.11 00:42:47.465 2024.11.10 23:27:45.411 2024.11.10 23:27:46.092
118 6.0.0.520 2024.11.07 4eefa P P 2124 647 2024.11.08 00:41:24.510 2024.11.08 00:41:26.634 2024.11.07 23:27:49.356 2024.11.07 23:27:50.003
119 6.0.0.516 2024.11.04 b0c36 P P 2097 695 2024.11.05 00:40:54.607 2024.11.05 00:40:56.704 2024.11.04 23:27:46.184 2024.11.04 23:27:46.879
120 6.0.0.515 2024.10.30 d53f3 P P 1261 658 2024.11.04 00:42:13.389 2024.11.04 00:42:14.650 2024.11.03 23:27:50.713 2024.11.03 23:27:51.371
121 6.0.0.512 2024.10.29 833ef P P 1459 773 2024.10.30 00:44:03.396 2024.10.30 00:44:04.855 2024.10.29 23:28:32.037 2024.10.29 23:28:32.810
122 6.0.0.511 2024.10.26 c4bc9 P P 1282 709 2024.10.29 00:44:07.503 2024.10.29 00:44:08.785 2024.10.28 23:28:00.093 2024.10.28 23:28:00.802
123 6.0.0.509 2024.10.25 3aedb P P 1423 707 2024.10.26 00:49:54.473 2024.10.26 00:49:55.896 2024.10.25 23:29:01.778 2024.10.25 23:29:02.485
124 6.0.0.508 2024.10.24 a8f5b P P 1608 688 2024.10.25 00:45:58.328 2024.10.25 00:45:59.936 2024.10.24 23:28:42.482 2024.10.24 23:28:43.170
125 6.0.0.502 2024.10.22 6bfd7 P P 1408 692 2024.10.23 00:45:33.717 2024.10.23 00:45:35.125 2024.10.22 23:28:34.208 2024.10.22 23:28:34.900
126 6.0.0.500 2024.10.21 be565 P P 1384 681 2024.10.22 17:06:01.926 2024.10.22 17:06:03.310 2024.10.22 15:57:43.570 2024.10.22 15:57:44.251
127 6.0.0.499 2024.10.19 6214b P P 1287 683 2024.10.20 00:46:47.334 2024.10.20 00:46:48.621 2024.10.19 23:29:04.313 2024.10.19 23:29:04.996
128 6.0.0.498 2024.10.18 591a7 P P 1468 650 2024.10.19 00:44:56.977 2024.10.19 00:44:58.445 2024.10.18 23:28:16.673 2024.10.18 23:28:17.323
129 6.0.0.494 2024.10.17 cf5a4 P P 1277 695 2024.10.18 00:45:53.861 2024.10.18 00:45:55.138 2024.10.17 23:29:07.874 2024.10.17 23:29:08.569
130 6.0.0.491 2024.10.14 dc5fb P P 1283 672 2024.10.15 00:43:10.642 2024.10.15 00:43:11.925 2024.10.14 23:28:02.511 2024.10.14 23:28:03.183
131 6.0.0.489 2024.10.11 2ba59 P P 1528 659 2024.10.12 00:47:27.834 2024.10.12 00:47:29.362 2024.10.11 23:28:36.353 2024.10.11 23:28:37.012
132 6.0.0.488 2024.10.09 1c93e P P 2031 665 2024.10.10 00:53:38.320 2024.10.10 00:53:40.351 2024.10.09 23:29:41.372 2024.10.09 23:29:42.037
133 6.0.0.487 2024.10.06 065a3 P P 1752 812 2024.10.07 00:52:36.889 2024.10.07 00:52:38.641 2024.10.06 23:30:01.726 2024.10.06 23:30:02.538
134 6.0.0.485 2024.10.04 e95c1 P P 1407 698 2024.10.05 00:54:31.462 2024.10.05 00:54:32.869 2024.10.04 23:29:14.122 2024.10.04 23:29:14.820
135 6.0.0.483 2024.10.02 5e5ae P P 2410 736 2024.10.03 00:51:31.683 2024.10.03 00:51:34.093 2024.10.02 23:29:06.896 2024.10.02 23:29:07.632
136 6.0.0.478 2024.09.30 b5010 P P 2265 699 2024.10.01 00:48:39.617 2024.10.01 00:48:41.882 2024.09.30 23:28:55.530 2024.09.30 23:28:56.229
137 6.0.0.474 2024.09.26 e4efb P P 2441 728 2024.09.30 00:47:02.588 2024.09.30 00:47:05.029 2024.09.29 23:28:36.497 2024.09.29 23:28:37.225
138 6.0.0.471 2024.09.24 01b51 P P 2153 713 2024.09.25 22:48:58.308 2024.09.25 22:49:00.461 2024.09.25 21:28:34.234 2024.09.25 21:28:34.947
139 6.0.0.470 2024.09.23 77cc0 P P 2137 685 2024.09.23 22:48:30.016 2024.09.23 22:48:32.153 2024.09.23 21:28:47.717 2024.09.23 21:28:48.402
140 6.0.0.467 2024.09.21 ea0b8 P P 1472 689 2024.09.22 22:47:29.285 2024.09.22 22:47:30.757 2024.09.22 21:28:21.714 2024.09.22 21:28:22.403
141 6.0.0.466 2024.09.20 32dc6 P P 1341 708 2024.09.20 22:46:40.491 2024.09.20 22:46:41.832 2024.09.20 21:28:19.155 2024.09.20 21:28:19.863
142 6.0.0.461 2024.09.17 2c895 P P 1887 1108 2024.09.17 23:13:57.005 2024.09.17 23:13:58.892 2024.09.17 21:34:10.206 2024.09.17 21:34:11.314
143 6.0.0.460 2024.09.11 3c253 P P 2356 1279 2024.09.16 23:15:09.216 2024.09.16 23:15:11.572 2024.09.16 21:34:15.222 2024.09.16 21:34:16.501
144 6.0.0.457 2024.09.09 fdc6f P P 2895 1273 2024.09.09 23:30:11.131 2024.09.09 23:30:14.026 2024.09.09 21:35:34.479 2024.09.09 21:35:35.752
145 6.0.0.455 2024.09.07 500d8 P P 2772 1213 2024.09.07 23:27:23.361 2024.09.07 23:27:26.133 2024.09.07 21:35:51.588 2024.09.07 21:35:52.801
146 6.0.0.454 2024.09.05 4d70f P P 2463 1213 2024.09.05 23:15:17.198 2024.09.05 23:15:19.661 2024.09.05 21:34:49.914 2024.09.05 21:34:51.127
147 6.0.0.452 2024.09.04 9ff9c P P 1776 1227 2024.09.04 23:15:11.184 2024.09.04 23:15:12.960 2024.09.04 21:34:24.996 2024.09.04 21:34:26.223
148 6.0.0.450 2024.09.02 27124 P P 4044 1415 2024.09.04 00:02:24.306 2024.09.04 00:02:28.350 2024.09.03 21:46:28.143 2024.09.03 21:46:29.558
149 6.0.0.447 2024.09.01 056ec P P 2486 1240 2024.09.01 23:28:17.083 2024.09.01 23:28:19.569 2024.09.01 21:34:04.394 2024.09.01 21:34:05.634
150 6.0.0.446 2024.08.30 fe1b2 P P 2712 1599 2024.08.31 23:31:47.113 2024.08.31 23:31:49.825 2024.08.31 21:45:41.290 2024.08.31 21:45:42.889
151 6.0.0.444 2024.08.28 785d4 P P 2649 1604 2024.08.29 23:49:16.411 2024.08.29 23:49:19.060 2024.08.29 21:45:43.981 2024.08.29 21:45:45.585
152 6.0.0.442 2024.08.21 4a68f P P 6146 1793 2024.08.28 00:50:24.698 2024.08.28 00:50:30.844 2024.08.27 21:53:08.491 2024.08.27 21:53:10.284
153 6.0.0.441 2024.08.20 75042 P P 3142 1302 2024.08.20 23:21:38.075 2024.08.20 23:21:41.217 2024.08.20 21:35:22.883 2024.08.20 21:35:24.185
154 6.0.0.438 2024.08.16 088b5 P P 2382 888 2024.08.18 22:52:05.237 2024.08.18 22:52:07.619 2024.08.18 21:30:47.138 2024.08.18 21:30:48.026
155 6.0.0.437 2024.08.14 3c88b P P 2294 921 2024.08.15 22:50:44.785 2024.08.15 22:50:47.079 2024.08.15 21:30:44.735 2024.08.15 21:30:45.656
156 6.0.0.432 2024.08.11 e82ac P P 2442 977 2024.08.12 22:49:35.681 2024.08.12 22:49:38.123 2024.08.12 21:30:27.491 2024.08.12 21:30:28.468
157 6.0.0.431 2024.08.09 de5a7 P P 2562 922 2024.08.09 22:50:23.763 2024.08.09 22:50:26.325 2024.08.09 21:30:58.218 2024.08.09 21:30:59.140
158 6.0.0.428 2024.08.08 9191b P P 2057 928 2024.08.08 22:49:33.966 2024.08.08 22:49:36.023 2024.08.08 21:30:50.268 2024.08.08 21:30:51.196
159 6.0.0.423 2024.08.07 33b41 P P 1697 1024 2024.08.08 08:49:06.749 2024.08.08 08:49:08.446 2024.08.08 07:38:25.820 2024.08.08 07:38:26.844
160 6.0.0.421 2024.08.06 ed60d P P 1986 719 2024.08.06 22:37:52.098 2024.08.06 22:37:54.084 2024.08.06 21:28:30.936 2024.08.06 21:28:31.655
161 6.0.0.419 2024.08.05 3505a P P 2108 742 2024.08.05 22:40:04.150 2024.08.05 22:40:06.258 2024.08.05 21:28:41.836 2024.08.05 21:28:42.578
162 6.0.0.409 2024.08.02 ec18f P P 2176 890 2024.08.04 22:42:18.205 2024.08.04 22:42:20.381 2024.08.04 21:28:57.460 2024.08.04 21:28:58.350
163 6.0.0.406 2024.08.01 b20be P P 2148 842 2024.08.01 22:41:14.041 2024.08.01 22:41:16.189 2024.08.01 21:28:40.105 2024.08.01 21:28:40.947
164 6.0.0.405 2024.07.31 a62ac P P 2200 905 2024.07.31 22:40:44.769 2024.07.31 22:40:46.969 2024.07.31 21:28:45.622 2024.07.31 21:28:46.527
165 6.0.0.403 2024.07.29 30f03 P P 2196 865 2024.07.29 22:40:24.525 2024.07.29 22:40:26.721 2024.07.29 21:28:29.797 2024.07.29 21:28:30.662
166 6.0.0.401 2024.07.26 24e41 P P 2216 847 2024.07.26 22:37:46.554 2024.07.26 22:37:48.770 2024.07.26 21:28:27.036 2024.07.26 21:28:27.883
167 6.0.0.400 2024.07.24 5bb78 P P 2117 843 2024.07.24 22:37:51.025 2024.07.24 22:37:53.142 2024.07.24 21:28:31.607 2024.07.24 21:28:32.450
168 6.0.0.398 2024.07.23 85b18 P P 1168 827 2024.07.23 22:43:28.113 2024.07.23 22:43:29.281 2024.07.23 21:28:32.504 2024.07.23 21:28:33.331
169 6.0.0.397 2024.07.22 c734c P P 2084 862 2024.07.22 22:37:34.045 2024.07.22 22:37:36.129 2024.07.22 21:28:28.871 2024.07.22 21:28:29.733
170 6.0.0.396 2024.07.13 cf952 P P 2255 900 2024.07.21 22:37:30.505 2024.07.21 22:37:32.760 2024.07.21 21:28:14.762 2024.07.21 21:28:15.662
171 6.0.0.395 2024.07.10 845f4 P P 2306 907 2024.07.12 22:37:20.203 2024.07.12 22:37:22.509 2024.07.12 21:28:03.729 2024.07.12 21:28:04.636
172 6.0.0.392 2024.07.09 ea301 P P 2253 852 2024.07.09 22:35:05.241 2024.07.09 22:35:07.494 2024.07.09 21:28:03.130 2024.07.09 21:28:03.982
173 6.0.0.391 2024.07.08 7d50c P P 2023 812 2024.07.08 22:36:29.228 2024.07.08 22:36:31.251 2024.07.08 21:28:19.443 2024.07.08 21:28:20.255
174 6.0.0.389 2024.07.05 cc71c P P 2245 818 2024.07.05 22:37:13.269 2024.07.05 22:37:15.514 2024.07.05 21:28:12.954 2024.07.05 21:28:13.772
175 6.0.0.388 2024.06.30 e5700 P P 2179 828 2024.06.30 22:36:21.237 2024.06.30 22:36:23.416 2024.06.30 21:28:22.405 2024.06.30 21:28:23.233
176 6.0.0.387 2024.06.27 7c28a P P 2280 801 2024.06.27 22:36:24.265 2024.06.27 22:36:26.545 2024.06.27 21:28:28.025 2024.06.27 21:28:28.826
177 6.0.0.386 2024.06.23 7c57f P P 1198 786 2024.06.23 22:34:10.051 2024.06.23 22:34:11.249 2024.06.23 21:27:57.349 2024.06.23 21:27:58.135
178 6.0.0.384 2024.06.21 24d99 P P 2319 828 2024.06.21 22:37:04.772 2024.06.21 22:37:07.091 2024.06.21 21:27:58.096 2024.06.21 21:27:58.924
179 6.0.0.374 2024.06.13 0097d P P 2022 857 2024.06.20 22:37:01.193 2024.06.20 22:37:03.215 2024.06.20 21:28:01.968 2024.06.20 21:28:02.825
180 6.0.0.373 2024.06.09 363f0 P P 1452 868 2024.06.13 12:54:07.012 2024.06.13 12:54:08.464 2024.06.13 11:51:12.314 2024.06.13 11:51:13.182
181 6.0.0.371 2024.06.08 f7130 P P 1257 541 2024.06.11 21:45:40.334 2024.06.11 21:45:41.591 2024.06.11 20:49:34.995 2024.06.11 20:49:35.536
182 6.0.0.366 2024.05.30 ab2c9 P P 2551 850 2024.06.12 08:32:29.741 2024.06.12 08:32:32.292 2024.06.12 07:21:31.785 2024.06.12 07:21:32.635
183 6.0.0.363 2024.05.27 06703 P P 1264 780 2024.06.12 13:51:06.426 2024.06.12 13:51:07.690 2024.06.12 12:52:51.124 2024.06.12 12:52:51.904
184 6.0.0.359 2024.05.23 9cb11 P P 1433 552 2024.06.12 11:43:31.533 2024.06.12 11:43:32.966 2024.06.12 10:44:45.061 2024.06.12 10:44:45.613
185 6.0.0.358 2024.05.21 995dd P P 1268 572 2024.06.12 16:27:33.476 2024.06.12 16:27:34.744 2024.06.12 15:30:02.901 2024.06.12 15:30:03.473
186 6.0.0.357 2024.05.18 bf6c4 P P 1428 621 2024.06.12 21:03:49.153 2024.06.12 21:03:50.581 2024.06.12 20:06:27.191 2024.06.12 20:06:27.812
187 6.0.0.356 2024.05.17 eab06 P P 1180 738 2024.06.13 05:10:27.580 2024.06.13 05:10:28.760 2024.06.13 04:12:38.240 2024.06.13 04:12:38.978
188 6.0.0.355 2024.05.16 8dd6e P P 1384 881 2024.06.13 07:17:44.570 2024.06.13 07:17:45.954 2024.06.13 06:19:52.977 2024.06.13 06:19:53.858
189 6.0.0.354 2024.05.15 d3adc P P 1381 771 2024.06.13 10:19:44.938 2024.06.13 10:19:46.319 2024.06.13 09:16:28.884 2024.06.13 09:16:29.655
190 6.0.0.351 2024.05.14 2e3e0 P P 1553 824 2024.06.13 15:33:18.167 2024.06.13 15:33:19.720 2024.06.13 14:29:07.847 2024.06.13 14:29:08.671

Elapsed time, ms. Chart for last 150 runs:

Last commits information (all timestamps in UTC):