assert   
  - PLAN JOIN (JOIN (TMP_SP1 NATURAL, T1 INDEX (TMP_TBL1_FLD2)), T2 INDEX (TMP_TBL2_FLD1), T3 INDEX (TMP_TBL3_FLD1))
  + PLAN JOIN (TMP_SP1 NATURAL, T1 INDEX (TMP_TBL1_FLD2), T2 INDEX (TMP_TBL2_FLD1), T3 INDEX (TMP_TBL3_FLD1))

LOG DETAILS:

2026-04-01 05:59:08.451
2026-04-01 05:59:08.451 act = <firebird.qa.plugin.Action object at [hex]>
2026-04-01 05:59:08.451
2026-04-01 05:59:08.451     @pytest.mark.version('>=5.0')
2026-04-01 05:59:08.451     def test_1(act: Action):
2026-04-01 05:59:08.451         act.expected_stdout = expected_stdout_5x if act.is_version('<6') else expected_stdout_6x
2026-04-01 05:59:08.451         act.execute(combine_output = True)
2026-04-01 05:59:08.451 >       assert act.clean_stdout == act.clean_expected_stdout
2026-04-01 05:59:08.451 E       assert
2026-04-01 05:59:08.451 E         - PLAN JOIN (JOIN (TMP_SP1 NATURAL, T1 INDEX (TMP_TBL1_FLD2)), T2 INDEX (TMP_TBL2_FLD1), T3 INDEX (TMP_TBL3_FLD1))
2026-04-01 05:59:08.451 E         + PLAN JOIN (TMP_SP1 NATURAL, T1 INDEX (TMP_TBL1_FLD2), T2 INDEX (TMP_TBL2_FLD1), T3 INDEX (TMP_TBL3_FLD1))
2026-04-01 05:59:08.451
2026-04-01 05:59:08.451 tests\bugs\gh_3812_test.py:84: AssertionError
2026-04-01 05:59:08.451 ---------------------------- Captured stdout setup ----------------------------
2026-04-01 05:59:08.451 Creating db: localhost:R:\Temp\qa\fbqa\test_11421\test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]