assert   
  + set planonly;
  + select * from test t where x = 0 plan (t natural); -- 1
  + PLAN (T NATURAL)
  + select * from v_test1 v1; -- 2
  + PLAN (V1 T INDEX (TEST_X_ASC))
  + select * from v_test1 v2; -- 3
  + PLAN (V2 T INDEX (TEST_X_ASC))
  + select * from v_test1 v1 where v1.x = 0 plan (v1 natural); -- 4
  + PLAN (V1 T NATURAL)
  + select * from v_test2 v2 where v2.x = 0 plan (v2 natural); -- 5
  + PLAN (V2 T NATURAL)
  + select * from v_test1 v1 where v1.x = 0 PLAN (V1 INDEX (TEST_X_DESC)) ; -- 6
  + PLAN (V1 T INDEX (TEST_X_DESC))
  + select * from v_test2 v2 where v2.x = 0 PLAN (V2 INDEX (TEST_X_DESC)) ; -- 7
  + PLAN (V2 T INDEX (TEST_X_DESC))
  + select * from v_test1 v1 where v1.x = 50 and v1.y = 5000 PLAN (V1 INDEX (test_x_y)) ; -- 8
  + PLAN (V1 T INDEX (TEST_X_Y))
  + select * from v_test1 v2 where v2.x = 50 and v2.y = 5000 PLAN (V2 INDEX (test_y_x)) ; -- 9
  + PLAN (V2 T INDEX (TEST_Y_X))
  + select * from v_test1 v1 where v1.x + v1.y = 1000 PLAN (V1 INDEX (test_x_y)); -- 10
  +

[...SKIPPED...]

6-27 15:45:42.840 E         + select * from v_test3 v3 plan ( v3 index(test_x_y) );
2025-06-27 15:45:42.844 E         + PLAN (V3 T INDEX (TEST_X_Y))
2025-06-27 15:45:42.849 E         + -- NB: here optimizer will use index __NOT__ from view V3 DDL:
2025-06-27 15:45:42.854 E         + -- PLAN (V4 V_TEST3 T INDEX (TEST_X_ASC))
2025-06-27 15:45:42.858 E         + select * from v_test4 v4; -- 15
2025-06-27 15:45:42.863 E         + PLAN (V4 V_TEST3 T INDEX (TEST_X_ASC))
2025-06-27 15:45:42.867 E         + select * from v_test4 v4 PLAN (V4 V_TEST3 T INDEX (TEST_X_Y)); -- 16
2025-06-27 15:45:42.871 E         + PLAN (V4 V_TEST3 T INDEX (TEST_X_Y))
2025-06-27 15:45:42.876
2025-06-27 15:45:42.880 tests/bugs/core_0203_test.py:124: AssertionError
2025-06-27 15:45:42.886 ---------------------------- Captured stdout setup -----------------------------
2025-06-27 15:45:42.890 Creating db: localhost:/var/tmp/qa_2024/test_139/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]