assert   
    point-0: a_num: 1, a_txt: W -- before select from VIEW
    point-1: a_num: 1, a_txt: W -- after select first 1 xnum from VIEW, result: xnum_selected_at_p1 = 1
  - point-2: a_num: 1, a_txt: W -- after delete from VIEW, result: row_count = 1
  + point-2: a_num: 0, a_txt: W -- after delete from VIEW, result: row_count = 0
  - point-3: a_num: 1, a_txt: W -- select first 1 xnum from VIEW, result: xnum_selected_at_p3 = 1
  + point-3: a_num: 0, a_txt: W -- select first 1 xnum from VIEW, result: xnum_selected_at_p3 = null

LOG DETAILS:

2026-01-15 14:37:07.130
2026-01-15 14:37:07.138 act = <firebird.qa.plugin.Action object at [hex]>
2026-01-15 14:37:07.145
2026-01-15 14:37:07.152 @pytest.mark.version('>=3.0')
2026-01-15 14:37:07.159 def test_1(act: Action):
2026-01-15 14:37:07.166 act.expected_stdout = expected_stdout
2026-01-15 14:37:07.174 act.execute(combine_output = True)
2026-01-15 14:37:07.182 >       assert act.clean_stdout == act.clean_expected_stdout
2026-01-15 14:37:07.191 E       as

[...SKIPPED...]

fore select from VIEW
2026-01-15 14:37:07.205 E           point-1: a_num: 1, a_txt: W -- after select first 1 xnum from VIEW, result: xnum_selected_at_p1 = 1
2026-01-15 14:37:07.212 E         - point-2: a_num: 1, a_txt: W -- after delete from VIEW, result: row_count = 1
2026-01-15 14:37:07.227 E         + point-2: a_num: 0, a_txt: W -- after delete from VIEW, result: row_count = 0
2026-01-15 14:37:07.242 E         - point-3: a_num: 1, a_txt: W -- select first 1 xnum from VIEW, result: xnum_selected_at_p3 = 1
2026-01-15 14:37:07.254 E         + point-3: a_num: 0, a_txt: W -- select first 1 xnum from VIEW, result: xnum_selected_at_p3 = null
2026-01-15 14:37:07.266
2026-01-15 14:37:07.273 tests/bugs/gh_8794_test.py:140: AssertionError
2026-01-15 14:37:07.281 ---------------------------- Captured stdout setup -----------------------------
2026-01-15 14:37:07.288 Creating db: localhost:/var/tmp/qa_2024/test_11722/test.fdb [page_size=None, sql_dialect=None, charset='UTF8', user=SYSDBA, password=masterkey]