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-10-31 18:15:54.763
2025-10-31 18:15:54.777 act = <firebird.qa.plugin.Action object at [hex]>
2025-10-31 18:15:54.787
2025-10-31 18:15:54.798 @pytest.mark.version('>=3.0')
2025-10-31 18:15:54.807 def test_1(act: Action):
2025-10-31 18:15:54.814 act.expected_stdout = expected_stdout
2025-10-31 18:15:54.821 act.execute(combine_output = True)
2025-10-31 18:15:54.830 >       assert act.clean_stdout == act.clean_expected_stdout
2025-10-31 18:15:54.838 E       assert
2025-10-31 18:15:54.845 E         - Statement failed, SQLSTATE = 42000
2025-10-31 18:15:54.862 E         + Statement failed, SQLSTATE = 08001
2025-10-31 18:15:54.877 E           Dynamic SQL Error
2025-10-31 18:15:54.886 E           -SQL error code = -204
2025-10-31 18:15:54.894 E           -alias B conflicts with an alias in the same statement
2025-10-31 18:15:54.902 E         - Statement failed, SQLSTATE = 42000
2025-10-31 18:15:54.916 E         + Statement failed, SQLSTATE = 08001
2025-10-31 18:15:54.931 E           Dynamic SQL Error
2025-10-31 18:15:54.938 E           -SQL error code = -204
2025-10-31 18:15:54.945 E           -alias T2 conflicts with an alias in the same statement
2025-10-31 18:15:54.951
2025-10-31 18:15:54.957 tests/bugs/gh_8739_test.py:72: AssertionError
2025-10-31 18:15:54.964 ---------------------------- Captured stdout setup -----------------------------
2025-10-31 18:15:54.971 Creating db: localhost:/var/tmp/qa_2024/test_11598/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]