assert   
    1
    c2
    c3
    TRUE
    Statement failed, SQLSTATE = HY004
    SQL error code = -104
    -Datatypes are not comparable in expression COALESCE
    Statement failed, SQLSTATE = HY004
    SQL error code = -104
    -Datatypes are not comparable in expression COALESCE
    c7
    c8
    TRUE
    TRUE
    11
  - 12
  + Statement failed, SQLSTATE = HY004
  + SQL error code = -104
  + -Datatypes are not comparable in expression COALESCE

LOG DETAILS:

2024-08-09 15:25:07.371
2024-08-09 15:25:07.371 act = <firebird.qa.plugin.Action object at [hex]>
2024-08-09 15:25:07.371
2024-08-09 15:25:07.371     @pytest.mark.version('>=3.0.12')
2024-08-09 15:25:07.371     def test_1(act: Action):
2024-08-09 15:25:07.371         act.expected_stdout = expected_stdout
2024-08-09 15:25:07.371         act.execute(combine_output = True)
2024-08-09 15:25:07.371 >       assert act.clean_stdout == act.clean_expected_stdout
2024-08-09 15:25:07.371 E       assert
2024-08-09 15:25:07.372 E           1
2024-08-09 15

[...SKIPPED...]

 Statement failed, SQLSTATE = HY004
2024-08-09 15:25:07.372 E           SQL error code = -104
2024-08-09 15:25:07.372 E           -Datatypes are not comparable in expression COALESCE
2024-08-09 15:25:07.372 E           c7
2024-08-09 15:25:07.372 E           c8
2024-08-09 15:25:07.372 E           TRUE
2024-08-09 15:25:07.372 E           TRUE
2024-08-09 15:25:07.372 E           11
2024-08-09 15:25:07.372 E         - 12
2024-08-09 15:25:07.372 E         + Statement failed, SQLSTATE = HY004
2024-08-09 15:25:07.372 E         + SQL error code = -104
2024-08-09 15:25:07.372 E         + -Datatypes are not comparable in expression COALESCE
2024-08-09 15:25:07.372
2024-08-09 15:25:07.373 tests\bugs\gh_8178_test.py:77: AssertionError
2024-08-09 15:25:07.373 ---------------------------- Captured stdout setup ----------------------------
2024-08-09 15:25:07.373 Creating db: localhost:H:\QA\temp\qa2024.tmp\fbqa\test_11343\test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]