v50-0021-adjust-rpr_base-expected-output.patch
application/octet-stream
Filename: v50-0021-adjust-rpr_base-expected-output.patch
Type: application/octet-stream
Part: 0
Message:
Re: Row pattern recognition
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: format-patch
Series: patch v50-0021
Subject: Adjust rpr_base expected output for refined IGNORE NULLS error
| File | + | − |
|---|---|---|
| src/test/regress/expected/rpr_base.out | 1 | 1 |
From cd781ecbfbc2ff7cac2aad07c515081f6332ca7a Mon Sep 17 00:00:00 2001
From: Henson Choi <assam258@gmail.com>
Date: Thu, 25 Jun 2026 22:39:36 +0900
Subject: [PATCH] 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)