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-16 21:08:11.327
2025-09-16 21:08:11.339 act = <firebird.qa.plugin.Action object at [hex]>
2025-09-16 21:08:11.349
2025-09-16 21:08:11.357 @pytest.mark.version('>=3.0')
2025-09-16 21:08:11.364 def test_1(act: Action):
2025-09-16 21:08:11.370 act.expected_stdout = expected_stdout
2025-09-16 21:08:11.379 act.execute(combine_output = True)
2025-09-16 21:08:11.393 >       assert act.clean_stdout == act.clean_expected_stdout
2025-09-16 21:08:11.403 E       assert
2025-09-16 21:08:11.411 E         - Statement failed, SQLSTATE = 42000
2025-09-16 21:08:11.426 E         + Statement failed, SQLSTATE = 08001
2025-09-16 21:08:11.439 E           Dynamic SQL Error
2025-09-16 21:08:11.447 E           -SQL error code = -204
2025-09-16 21:08:11.458 E           -alias B conflicts with an alias in the same statement
2025-09-16 21:08:11.468 E         - Statement failed, SQLSTATE = 42000
2025-09-16 21:08:11.483 E         + Statement failed, SQLSTATE = 08001
2025-09-16 21:08:11.502 E           Dynamic SQL Error
2025-09-16 21:08:11.511 E           -SQL error code = -204
2025-09-16 21:08:11.519 E           -alias T2 conflicts with an alias in the same statement
2025-09-16 21:08:11.527
2025-09-16 21:08:11.534 tests/bugs/gh_8739_test.py:72: AssertionError
2025-09-16 21:08:11.545 ---------------------------- Captured stdout setup -----------------------------
2025-09-16 21:08:11.556 Creating db: localhost:/var/tmp/qa_2024/test_11323/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]