nocfbot-ignore-nulls-errmsg.txt

text/plain

Filename: nocfbot-ignore-nulls-errmsg.txt
Type: text/plain
Part: 0
Message: Re: Row pattern recognition
From c238d80cd76d57c7d1dbde864f70258f50494c1f Mon Sep 17 00:00:00 2001
From: Henson Choi <assam258@gmail.com>
Date: Thu, 25 Jun 2026 22:39:36 +0900
Subject: [PATCH v50] Adjust rpr_base expected output for refined IGNORE NULLS
 error

Commit 419ce13b701 refined the error reported when RESPECT/IGNORE NULLS
is used on a non-window function, changing it from "only window functions
accept RESPECT/IGNORE NULLS" to "RESPECT/IGNORE NULLS specified, but %s
is not a window function".  The rpr_base test was added before that
refinement and kept the old wording, so update its expected output to
match.  No behavior change.
---
 src/test/regress/expected/rpr_base.out | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/src/test/regress/expected/rpr_base.out b/src/test/regress/expected/rpr_base.out
index 33fcb40b1a8..7957595ad8b 100644
--- a/src/test/regress/expected/rpr_base.out
+++ b/src/test/regress/expected/rpr_base.out
@@ -2143,7 +2143,7 @@ SELECT count(*) OVER w FROM nt
   WINDOW w AS (PARTITION BY g ORDER BY id
     ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING INITIAL
     PATTERN (A+) DEFINE A AS PREV(val) IGNORE NULLS IS NULL);
-ERROR:  only window functions accept RESPECT/IGNORE NULLS
+ERROR:  RESPECT/IGNORE NULLS specified, but prev is not a window function
 LINE 4:     PATTERN (A+) DEFINE A AS PREV(val) IGNORE NULLS IS NULL)...
                                      ^
 -- Quoting does not escape: "prev" is nav, "PREV" is an ordinary name
-- 
2.50.1 (Apple Git-155)