"F"-serie (CS): len=3, 3.0.14.33832 2026.01.16 a4367e94 - 3.0.14.33842 2026.04.16 807a6dcf
AssertionError: Init script FAILED: {act.clean_stdout=}
assert   
  + Statement failed, SQLSTATE = 23000
  + violation of FOREIGN KEY constraint "BAL_FK_INV" on table "BALANCE"
  + -Foreign key reference target does not exist
  + -Problematic key value is ("CARD_KEY" = 0)

LOG DETAILS:

2026-04-17 22:53:23.404
2026-04-17 22:53:23.409 act = <firebird.qa.plugin.Action object at [hex]>
2026-04-17 22:53:23.414 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2026-04-17 22:53:23.419
2026-04-17 22:53:23.424 @pytest.mark.version('>=3.0')
2026-04-17 22:53:23.428 def test_1(act: Action, capsys):
2026-04-17 22:53:23.433
2026-04-17 22:53:23.438 init_script = """
2026-04-17 22:53:23.443 set bail on;
2026-04-17 22:53:23.448 recreate sequence g;
2026-04-17 22:53:23.453 recreate table inv_card(id int not null, usr int);
2026-04-17 22:53:23.457 recreate table balance(
2026-04-17 22:53:23.462 id int not null
2026-04-1

[...SKIPPED...]

:23.802 act.isql(switches = ['-q'], input = init_script, combine_output = True)
2026-04-17 22:53:23.807 >       assert act.clean_stdout == '', 'Init script FAILED: {act.clean_stdout=}'
2026-04-17 22:53:23.811 E       AssertionError: Init script FAILED: {act.clean_stdout=}
2026-04-17 22:53:23.816 E       assert
2026-04-17 22:53:23.821 E         + Statement failed, SQLSTATE = 23000
2026-04-17 22:53:23.826 E         + violation of FOREIGN KEY constraint "BAL_FK_INV" on table "BALANCE"
2026-04-17 22:53:23.831 E         + -Foreign key reference target does not exist
2026-04-17 22:53:23.835 E         + -Problematic key value is ("CARD_KEY" = 0)
2026-04-17 22:53:23.840
2026-04-17 22:53:23.845 tests/bugs/gh_8488_test.py:116: AssertionError
2026-04-17 22:53:23.850 ---------------------------- Captured stdout setup -----------------------------
2026-04-17 22:53:23.855 Creating db: localhost:/var/tmp/qa_2024/test_11313/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]