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   
  + Statement failed, SQLSTATE = 42000
  + unsuccessful metadata update
  + -REVOKE failed
  + -SYSDBA is not grantor of ROLE on ROLE_8462 to SYSDBA.
  + RDB$USER                        SYSDBA
  + RDB$GRANTOR                     TMP$8462
  + RDB$PRIVILEGE                   M
  + RDB$GRANT_OPTION                0
  + RDB$RELATION_NAME               ROLE_8462
  + RDB$FIELD_NAME                  <null>
  + RDB$USER_TYPE                   8
  + RDB$OBJECT_TYPE                 13
  - Records affected: 0
  + Records affected: 1

LOG DETAILS:

2025-04-18 10:06:12.423
2025-04-18 10:06:12.423 act = <firebird.qa.plugin.Action object at [hex]>
2025-04-18 10:06:12.424 tmp_user = <firebird.qa.plugin.User object at [hex]>
2025-04-18 10:06:12.424 tmp_role = <firebird.qa.plugin.Role object at [hex]>
2025-04-18 10:06:12.424
2025-04-18 10:06:12.424     @pytest.mark.version('>=4.0.6')
2025-04-18 10:06:12.424     def test_1(act: Action, tmp_user: User, tmp_role: Role):
2025-04-18 10:06:12.424
2025-04-18 10:06:12.424         test_sql = f"""
2025-04-18 10:06:12.424             set list on;
2025-04-18 10:06:12.424             set term ^;
2025-04-18 10:06:12.424             execute block as
2025-04-18 10:06:12.424             begin
2025-04-18 10:06:12.424                 execute statement 'drop role {tmp_role.name}';
2025-04-18 10:06:12.424             when any do
2025-04-18 10:06:12.424                 begin
2025-04-18 10:06:12.424                     --- nop ---
2025-04-18 10:06:12.424                 end
2025-04-18 10:06:12.424             end
2025-04-18 10:06:12.424             ^
2025-04-18 10:06:12.424             set term ;^
2025-04-18 10:06:12.424             commit;
2025-04-18 10:06:12.424
2025-04-18 10:06:12.425             grant RDB$ADMIN to {tmp_user.name};
2025-04-18 10:06:12.425
2025-04-18 10:06:12.425             commit;
2025-04-18 10:06:12.425             connect '{act.db.dsn}' user {tmp_user.name} password '{tmp_user.password}' role rdb$admin;
2025-04-18 10:06:12.425
2025-04-18 10:06:12.425             create role {tmp_role.name};
2025-04-18 10:06:12.425             grant {tmp_role.name} to {act.db.user};
2025-04-18 10:06:12.425
2025-04-18 10:06:12.425             commit;
2025-04-18 10:06:12.425             connect '{act.db.dsn}' user {act.db.user} password '{act.db.password}';
2025-04-18 10:06:12.425
2025-04-18 10:06:12.425             set count on;
2025-04-18 10:06:12.425
2025-04-18 10:06:12.425             --select * from rdb$user_privileges p where p.rdb$relation_name = upper('{tmp_role.name}');
2025-04-18 10:06:12.425             revoke {tmp_role.name} from {act.db.user};
2025-04-18 10:06:12.425             commit;
2025-04-18 10:06:12.425             select * from rdb$user_privileges p where p.rdb$relation_name = upper('{tmp_role.name}');
2025-04-18 10:06:12.425         """
2025-04-18 10:06:12.425
2025-04-18 10:06:12.425         expected_stdout = """
2025-04-18 10:06:12.425             Records affected: 0
2025-04-18 10:06:12.426         """
2025-04-18 10:06:12.426         act.expected_stdout = expected_stdout
2025-04-18 10:06:12.426         act.isql(input = test_sql, combine_output=True)
2025-04-18 10:06:12.426 >       assert act.clean_stdout == act.clean_expected_stdout
2025-04-18 10:06:12.426 E       assert
2025-04-18 10:06:12.426 E         + Statement failed, SQLSTATE = 42000
2025-04-18 10:06:12.426 E         + unsuccessful metadata update
2025-04-18 10:06:12.426 E         + -REVOKE failed
2025-04-18 10:06:12.426 E         + -SYSDBA is not grantor of ROLE on ROLE_8462 to SYSDBA.
2025-04-18 10:06:12.426 E         + RDB$USER                        SYSDBA
2025-04-18 10:06:12.426 E         + RDB$GRANTOR                     TMP$8462
2025-04-18 10:06:12.426 E         + RDB$PRIVILEGE                   M
2025-04-18 10:06:12.426 E         + RDB$GRANT_OPTION                0
2025-04-18 10:06:12.426 E         + RDB$RELATION_NAME               ROLE_8462
2025-04-18 10:06:12.426 E         + RDB$FIELD_NAME                  <null>
2025-04-18 10:06:12.426 E         + RDB$USER_TYPE                   8
2025-04-18 10:06:12.426 E         + RDB$OBJECT_TYPE                 13
2025-04-18 10:06:12.426 E         - Records affected: 0
2025-04-18 10:06:12.426 E         + Records affected: 1
2025-04-18 10:06:12.427
2025-04-18 10:06:12.427 tests\bugs\gh_8462_test.py:65: AssertionError
2025-04-18 10:06:12.427 ---------------------------- Captured stdout setup ----------------------------
2025-04-18 10:06:12.427 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_11712\test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
2025-04-18 10:06:12.427 CREATE user: TMP$8462 PLUGIN: Srp
2025-04-18 10:06:12.427 CREATE role: ROLE_8462
2025-04-18 10:06:12.427 -------------------------- Captured stdout teardown ---------------------------
2025-04-18 10:06:12.427 DROP role: ROLE_8462
2025-04-18 10:06:12.427 DROP user: TMP$8462 PLUGIN: Srp
3 #text
act = <firebird.qa.plugin.Action pytest object at [hex]>
tmp_user = <firebird.qa.plugin.User pytest object at [hex]>
tmp_role = <firebird.qa.plugin.Role pytest object at [hex]>

    @pytest.mark.version('>=4.0.6')
    def test_1(act: Action, tmp_user: User, tmp_role: Role):
    
        test_sql = f"""
            set list on;
            set term ^;
            execute block as
            begin
                execute statement 'drop role {tmp_role.name}';
            when any do
                begin
                    --- nop ---
                end
            end
            ^
            set term ;^
            commit;
    
            grant RDB$ADMIN to {tmp_user.name};
    
            commit;
            connect '{act.db.dsn}' user {tmp_user.name} password '{tmp_user.password}' role rdb$admin;
    
            create role {tmp_role.name};
            grant {tmp_role.name} to {act.db.user};
    
            commit;
            connect '{act.db.dsn}' user {act.db.user} password '{act.db.password}';
    
            set count on;
    
            --select * from rdb$user_privileges p where p.rdb$relation_name = upper('{tmp_role.name}');
            revoke {tmp_role.name} from {act.db.user};
            commit;
            select * from rdb$user_privileges p where p.rdb$relation_name = upper('{tmp_role.name}');
        """
    
        expected_stdout = """
            Records affected: 0
        """
        act.expected_stdout = expected_stdout
        act.isql(input = test_sql, combine_output=True)
>       assert act.clean_stdout == act.clean_expected_stdout
E       assert   
E         + Statement failed, SQLSTATE = 42000
E         + unsuccessful metadata update
E         + -REVOKE failed
E         + -SYSDBA is not grantor of ROLE on ROLE_8462 to SYSDBA.
E         + RDB$USER                        SYSDBA
E         + RDB$GRANTOR                     TMP$8462
E         + RDB$PRIVILEGE                   M
E         + RDB$GRANT_OPTION                0
E         + RDB$RELATION_NAME               ROLE_8462
E         + RDB$FIELD_NAME                  <null>
E         + RDB$USER_TYPE                   8
E         + RDB$OBJECT_TYPE                 13
E         - Records affected: 0
E         + Records affected: 1

tests\bugs\gh_8462_test.py:65: 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 5.0.3.1674 2025.06.27 3ee5c P P 1698 953 2025.06.28 11:12:06.372 2025.06.28 11:12:08.070 2025.06.28 10:10:43.102 2025.06.28 10:10:44.055
2 5.0.3.1657 2025.06.26 dcb8a P P 1715 942 2025.06.27 11:08:43.624 2025.06.27 11:08:45.339 2025.06.27 10:07:33.503 2025.06.27 10:07:34.445
3 5.0.3.1657 2025.06.20 8b4d2 P P 1649 939 2025.06.26 11:23:11.847 2025.06.26 11:23:13.496 2025.06.26 10:21:49.929 2025.06.26 10:21:50.868
4 5.0.3.1657 2025.06.19 4bd4c P P 1864 942 2025.06.20 05:27:25.951 2025.06.20 05:27:27.815 2025.06.20 04:26:08.585 2025.06.20 04:26:09.527
5 5.0.3.1657 2025.06.11 dae6f P P 1672 948 2025.06.19 10:58:53.337 2025.06.19 10:58:55.009 2025.06.19 09:57:32.746 2025.06.19 09:57:33.694
6 5.0.3.1657 2025.06.10 dbc92 P P 1776 957 2025.06.11 08:45:03.098 2025.06.11 08:45:04.874 2025.06.11 07:43:29.227 2025.06.11 07:43:30.184
7 5.0.3.1656 2025.06.05 00512 P P 1687 939 2025.06.10 10:00:33.368 2025.06.10 10:00:35.055 2025.06.10 08:58:34.962 2025.06.10 08:58:35.901
8 5.0.3.1656 2025.05.20 c4b11 P P 1683 940 2025.06.03 09:47:26.363 2025.06.03 09:47:28.046 2025.06.03 08:46:38.316 2025.06.03 08:46:39.256
9 5.0.3.1652 2025.05.13 f51c6 P P 1644 945 2025.05.21 06:28:24.923 2025.05.21 06:28:26.567 2025.05.21 05:27:53.934 2025.05.21 05:27:54.879
10 5.0.3.1651 2025.05.08 ee9d2 P E 1671 2408 2025.05.13 06:41:04.526 2025.05.13 06:41:06.197 2025.05.13 05:22:01.468 2025.05.13 05:22:03.876
11 5.0.3.1651 2025.05.04 3d914 P E 1663 2414 2025.05.09 04:30:07.777 2025.05.09 04:30:09.440 2025.05.09 03:10:59.323 2025.05.09 03:11:01.737
12 5.0.3.1651 2025.04.30 141ef P E 1729 2375 2025.05.02 04:37:44.129 2025.05.02 04:37:45.858 2025.05.02 03:18:52.545 2025.05.02 03:18:54.920
13 5.0.3.1650 2025.04.30 6253f P E 1640 2406 2025.05.01 04:36:47.499 2025.05.01 04:36:49.139 2025.05.01 03:17:48.921 2025.05.01 03:17:51.327
14 5.0.3.1650 2025.04.28 4cbff P E 1656 2393 2025.04.30 04:35:48.518 2025.04.30 04:35:50.174 2025.04.30 03:17:01.809 2025.04.30 03:17:04.202
15 5.0.3.1649 2025.04.21 5b2d0 P E 1694 2431 2025.04.26 10:09:46.634 2025.04.26 10:09:48.328 2025.04.26 08:50:02.002 2025.04.26 08:50:04.433
16 5.0.3.1648 2025.04.18 2f4c5 P P 1663 982 2025.04.20 04:21:01.130 2025.04.20 04:21:02.793 2025.04.20 03:19:27.638 2025.04.20 03:19:28.620
17 5.0.3.1635 2025.04.03 f6bd1 F E 1699 2440 2025.04.18 06:48:41.664 2025.04.18 06:48:43.363 2025.04.18 05:29:14.517 2025.04.18 05:29:16.957
18 5.0.3.1635 2025.03.31 22ec6 F E 1704 2251 2025.04.03 09:54:31.942 2025.04.03 09:54:33.646 2025.04.03 08:34:45.001 2025.04.03 08:34:47.252
19 5.0.3.1633 2025.03.28 3123a F E 1704 2234 2025.03.31 09:53:00.032 2025.03.31 09:53:01.736 2025.03.31 08:33:21.037 2025.03.31 08:33:23.271
20 5.0.3.1633 2025.03.27 e0fb8 F E 1778 2449 2025.03.28 10:24:40.295 2025.03.28 10:24:42.073 2025.03.28 09:01:15.289 2025.03.28 09:01:17.738
21 5.0.3.1631 2025.03.25 bda65 F F 1757 1072 2025.03.27 10:05:11.123 2025.03.27 10:05:12.880 2025.03.27 08:59:55.580 2025.03.27 08:59:56.652
22 5.0.3.1631 2025.03.21 1925b F F 1782 1090 2025.03.25 06:39:13.648 2025.03.25 06:39:15.430 2025.03.25 05:33:48.305 2025.03.25 05:33:49.395
23 5.0.3.1629 2025.03.18 506d7 F F 1727 1070 2025.03.20 09:39:30.868 2025.03.20 09:39:32.595 2025.03.20 08:33:55.122 2025.03.20 08:33:56.192
24 5.0.3.1628 2025.03.14 16d05 F F 1725 982 2025.03.18 09:33:38.722 2025.03.18 09:33:40.447 2025.03.18 08:29:37.474 2025.03.18 08:29:38.456
25 5.0.3.1627 2025.02.26 4e218 F F 1768 1067 2025.03.13 09:52:56.775 2025.03.13 09:52:58.543 2025.03.13 08:47:09.565 2025.03.13 08:47:10.632

Elapsed time, ms. Chart for last 25 runs:

Last commits information (all timestamps in UTC):