nocfbot-0021-Enable-JIT-PREV-NEXT-tests.txt

From 79f32ee6991e3cbf5bea0e51099e9613c13f5ec0 Mon Sep 17 00:00:00 2001
From: Henson Choi <assam258@gmail.com>
Date: Mon, 6 Apr 2026 09:48:54 +0900
Subject: [PATCH 21/40] Enable JIT compilation for PREV/NEXT navigation tests
 in RPR

---
 src/test/regress/expected/rpr.out | 2 ++
 src/test/regress/sql/rpr.sql      | 2 ++
 2 files changed, 4 insertions(+)

diff --git a/src/test/regress/expected/rpr.out b/src/test/regress/expected/rpr.out
index de6ce4fba8a..5a460e9bd52 100644
--- a/src/test/regress/expected/rpr.out
+++ b/src/test/regress/expected/rpr.out
@@ -2156,6 +2156,7 @@ SELECT match_first, match_last, match_len FROM result WHERE match_len > 0;
 -- JIT PREV/NEXT navigation test: 100K rows with PREV in DEFINE.
 -- Exercises EEOP_RPR_NAV_SET/RESTORE JIT code paths (has_rpr_nav reload)
 -- at scale. V-shape: price rises then falls, repeated across partition.
+SET jit = on;
 SET jit_above_cost = 0;
 WITH data AS (
  SELECT i, abs(50000 - i) AS price
@@ -2184,6 +2185,7 @@ FROM result WHERE match_len > 0;
 (1 row)
 
 RESET jit_above_cost;
+RESET jit;
 --
 -- IGNORE NULLS
 --
diff --git a/src/test/regress/sql/rpr.sql b/src/test/regress/sql/rpr.sql
index b3bbc8254c4..e417789eb2b 100644
--- a/src/test/regress/sql/rpr.sql
+++ b/src/test/regress/sql/rpr.sql
@@ -1087,6 +1087,7 @@ SELECT match_first, match_last, match_len FROM result WHERE match_len > 0;
 -- JIT PREV/NEXT navigation test: 100K rows with PREV in DEFINE.
 -- Exercises EEOP_RPR_NAV_SET/RESTORE JIT code paths (has_rpr_nav reload)
 -- at scale. V-shape: price rises then falls, repeated across partition.
+SET jit = on;
 SET jit_above_cost = 0;
 WITH data AS (
  SELECT i, abs(50000 - i) AS price
@@ -1110,6 +1111,7 @@ result AS (
 SELECT count(*) AS matched_rows, max(match_len) AS longest_match
 FROM result WHERE match_len > 0;
 RESET jit_above_cost;
+RESET jit;
 
 --
 -- IGNORE NULLS
-- 
2.50.1 (Apple Git-155)