"F"-serie (SS): len=60, 6.0.0.1819 2026.03.12 61354aef - 6.0.0.2033 2026.06.25 3427fbc3
assert   
    PLAN SORT ("PUBLIC"."V_TEST" "B" INDEX ("PUBLIC"."BALANCES_BALANCEDATE_ORGACCOUNT"))
  - PLAN SORT ("PUBLIC"."V_TEST" "B" INDEX ("PUBLIC"."FK_BALANCES_ORGACCOUNTS", "PUBLIC"."BALANCES_BALANCEDATE_DESC"))
  + PLAN ("PUBLIC"."V_TEST" "B" ORDER "PUBLIC"."BALANCES_BALANCEDATE_DESC" INDEX ("PUBLIC"."FK_BALANCES_ORGACCOUNTS"))

LOG DETAILS:

2026-05-16 02:41:45.158
2026-05-16 02:41:45.158 act = <firebird.qa.plugin.Action object at [hex]>
2026-05-16 02:41:45.158
2026-05-16 02:41:45.158     @pytest.mark.version('>=3.0.4')
2026-05-16 02:41:45.158     def test_1(act: Action):
2026-05-16 02:41:45.158         act.expected_stdout = expected_stdout_4x if act.is_version('<5') else expected_stdout_5x if act.is_version('<6') else expected_stdout_6x
2026-05-16 02:41:45.158         act.execute(combine_output = True)
2026-05-16 02:41:45.158 >       assert act.clean_stdout == act.clean_expected_stdout
2026-05-16 02:41:45.158 E       assert
2026-05-16 02:41:45.158 E           PLAN SORT ("PUBLIC"."V_TEST" "B" INDEX ("PUBLIC"."BALANCES_BALANCEDATE_ORGACCOUNT"))
2026-05-16 02:41:45.158 E         - PLAN SORT ("PUBLIC"."V_TEST" "B" INDEX ("PUBLIC"."FK_BALANCES_ORGACCOUNTS", "PUBLIC"."BALANCES_BALANCEDATE_DESC"))
2026-05-16 02:41:45.158 E         + PLAN ("PUBLIC"."V_TEST" "B" ORDER "PUBLIC"."BALANCES_BALANCEDATE_DESC" INDEX ("PUBLIC"."FK_BALANCES_ORGACCOUNTS"))
2026-05-16 02:41:45.158
2026-05-16 02:41:45.158 tests\bugs\core_5481_test.py:105: AssertionError
2026-05-16 02:41:45.158 ---------------------------- Captured stdout setup ----------------------------
2026-05-16 02:41:45.158 Creating db: localhost:R:\Temp\qa\fbqa\test_11119\test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]