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-05 09:29:37.887
2025-10-05 09:29:37.902 act = <firebird.qa.plugin.Action object at [hex]>
2025-10-05 09:29:37.920
2025-10-05 09:29:37.934 @pytest.mark.version('>=3.0')
2025-10-05 09:29:37.950 def test_1(act: Action):
2025-10-05 09:29:37.968 act.expected_stdout = expected_stdout
2025-10-05 09:29:37.986 act.execute(combine_output = True)
2025-10-05 09:29:38.007 >       assert act.clean_stdout == act.clean_expected_stdout
2025-10-05 09:29:38.022 E       assert
2025-10-05 09:29:38.034 E         - Statement failed, SQLSTATE = 42000
2025-10-05 09:29:38.058 E         + Statement failed, SQLSTATE = 08001
2025-10-05 09:29:38.074 E           Dynamic SQL Error
2025-10-05 09:29:38.083 E           -SQL error code = -204
2025-10-05 09:29:38.094 E           -alias B conflicts with an alias in the same statement
2025-10-05 09:29:38.112 E         - Statement failed, SQLSTATE = 42000
2025-10-05 09:29:38.143 E         + Statement failed, SQLSTATE = 08001
2025-10-05 09:29:38.179 E           Dynamic SQL Error
2025-10-05 09:29:38.191 E           -SQL error code = -204
2025-10-05 09:29:38.209 E           -alias T2 conflicts with an alias in the same statement
2025-10-05 09:29:38.224
2025-10-05 09:29:38.239 tests/bugs/gh_8739_test.py:72: AssertionError
2025-10-05 09:29:38.256 ---------------------------- Captured stdout setup -----------------------------
2025-10-05 09:29:38.273 Creating db: localhost:/var/tmp/qa_2024/test_11719/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]