assert   
  - Statement failed, SQLSTATE = 42000
  + Statement failed, SQLSTATE = 08001
    Dynamic SQL Error
    -SQL error code = -204
    -alias B conflicts with an alias in the same statement
  - Statement failed, SQLSTATE = 42000
  + Statement failed, SQLSTATE = 08001
    Dynamic SQL Error
    -SQL error code = -204
    -alias T2 conflicts with an alias in the same statement

LOG DETAILS:

2025-09-28 17:33:52.082
2025-09-28 17:33:52.082 act = <firebird.qa.plugin.Action object at [hex]>
2025-09-28 17:33:52.082
2025-09-28 17:33:52.082     @pytest.mark.version('>=3.0')
2025-09-28 17:33:52.082     def test_1(act: Action):
2025-09-28 17:33:52.082         act.expected_stdout = expected_stdout
2025-09-28 17:33:52.083         act.execute(combine_output = True)
2025-09-28 17:33:52.083 >       assert act.clean_stdout == act.clean_expected_stdout
2025-09-28 17:33:52.083 E       assert
2025-09-28 17:33:52.083 E         - Statement failed, SQLSTATE = 42000
2025-09-28 17:33:52.083 E         + Statement failed, SQLSTATE = 08001
2025-09-28 17:33:52.083 E           Dynamic SQL Error
2025-09-28 17:33:52.083 E           -SQL error code = -204
2025-09-28 17:33:52.083 E           -alias B conflicts with an alias in the same statement
2025-09-28 17:33:52.083 E         - Statement failed, SQLSTATE = 42000
2025-09-28 17:33:52.083 E         + Statement failed, SQLSTATE = 08001
2025-09-28 17:33:52.083 E           Dynamic SQL Error
2025-09-28 17:33:52.083 E           -SQL error code = -204
2025-09-28 17:33:52.083 E           -alias T2 conflicts with an alias in the same statement
2025-09-28 17:33:52.083
2025-09-28 17:33:52.084 tests\bugs\gh_8739_test.py:72: AssertionError
2025-09-28 17:33:52.084 ---------------------------- Captured stdout setup ----------------------------
2025-09-28 17:33:52.084 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_11338\test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]