"F"-serie (SS): len=45, 6.0.0.1850 2026.03.23 b8c59810 - 6.0.0.2009 2026.06.11 36d66955
assert   
    select
    r.relationname,
    c.countryname
    from
    relations r
    join countries c on (c.countryid = r.countryid)
    where
    c.countryname like 'N%'
    order by
    r.relationname desc
    Select Expression
    ....-> Sort record length: N, key length: M
  + ........-> Nested Loop Join (inner)
  - ........-> Filter
  + ............-> Filter
  - ............-> Hash Join (inner) (keys: 1, total key length: 4)
  - ................-> Table "PUBLIC"."RELATIONS" as "R" Full Scan
  - ................-> Record Buffer (record length: 81)
  - ....................-> Filter
  - ........................-> Table "PUBLIC"."COUNTRIES" as "C" Access By ID
  + ................-> Table "PUBLIC"."COUNTRIES" as "C" Access By ID
  - ............................-> Bitmap
  + ....................-> Bitmap
  - ................................-> Index "PUBLIC"."I_COUNTRYNAME" Range Scan (full match)
  + .........

[...SKIPPED...]

ELATIONS" as "R" Access By ID
2026-05-10 02:41:15.889 E         + ....................-> Bitmap
2026-05-10 02:41:15.889 E         + ........................-> Index "PUBLIC"."FK_RELATIONS_COUNTRIES" Range Scan (full match)
2026-05-10 02:41:15.889 E           RELATIONNAME : University Leiden
2026-05-10 02:41:15.889 E           COUNTRYNAME : NETHERLANDS
2026-05-10 02:41:15.889 E           RELATIONNAME : University Delft
2026-05-10 02:41:15.889 E           COUNTRYNAME : NETHERLANDS
2026-05-10 02:41:15.889 E           RELATIONNAME : University Amsterdam
2026-05-10 02:41:15.889 E           COUNTRYNAME : NETHERLANDS
2026-05-10 02:41:15.889
2026-05-10 02:41:15.889 tests\functional\arno\optimizer\test_opt_inner_join_05.py:427: AssertionError
2026-05-10 02:41:15.889 ---------------------------- Captured stdout setup ----------------------------
2026-05-10 02:41:15.889 Creating db: localhost:R:\Temp\qa\fbqa\test_11920\test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]