revert-0005-remove-exclude-ties-tests.patch
application/octet-stream
Filename: revert-0005-remove-exclude-ties-tests.patch
Type: application/octet-stream
Part: 5
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 0005
Subject: Remove EXCLUDE TIES window tests unrelated to row pattern recognition
| File | + | − |
|---|---|---|
| src/test/regress/expected/window.out | 0 | 36 |
| src/test/regress/sql/window.sql | 0 | 8 |
From d8b60976ddb1c6b9c24c6e153ef51c28c61d476e Mon Sep 17 00:00:00 2001
From: Henson Choi <assam258@gmail.com>
Date: Sun, 28 Jun 2026 13:30:23 +0900
Subject: [PATCH] Remove EXCLUDE TIES window tests unrelated to row pattern
recognition
These nth_value/last_value frame tests exercise exclusion accounting that
already exists on the base branch and pass without RPR, so they don't
cover RPR-specific behavior; drop them to keep the RPR diff minimal.
---
src/test/regress/expected/window.out | 36 ----------------------------
src/test/regress/sql/window.sql | 8 -------
2 files changed, 44 deletions(-)
diff --git a/src/test/regress/expected/window.out b/src/test/regress/expected/window.out
index dd887c6b925..90d9f953b81 100644
--- a/src/test/regress/expected/window.out
+++ b/src/test/regress/expected/window.out
@@ -1037,42 +1037,6 @@ FROM tenk1 WHERE unique1 < 10;
7 | 7 | 3
(10 rows)
-SELECT nth_value(unique1,2) over (ORDER BY four rows between current row and 3 following exclude ties),
- unique1, four
-FROM tenk1 WHERE unique1 < 10;
- nth_value | unique1 | four
------------+---------+------
- 5 | 0 | 0
- 5 | 8 | 0
- 5 | 4 | 0
- 6 | 5 | 1
- 6 | 9 | 1
- 6 | 1 | 1
- 3 | 6 | 2
- 3 | 2 | 2
- | 3 | 3
- | 7 | 3
-(10 rows)
-
-SELECT last_value(unique1) over (ORDER BY four rows between 1 following and 2 following exclude ties),
- unique1, four
-FROM tenk1 WHERE unique1 < 12 ORDER BY four, unique1;
- last_value | unique1 | four
-------------+---------+------
- 1 | 0 | 0
- | 4 | 0
- 5 | 8 | 0
- 6 | 1 | 1
- | 5 | 1
- 10 | 9 | 1
- 3 | 2 | 2
- | 6 | 2
- 7 | 10 | 2
- | 3 | 3
- | 7 | 3
- | 11 | 3
-(12 rows)
-
SELECT sum(unique1) over (rows between 2 preceding and 1 preceding),
unique1, four
FROM tenk1 WHERE unique1 < 10;
diff --git a/src/test/regress/sql/window.sql b/src/test/regress/sql/window.sql
index 31fece7fb8a..5ac3a486e16 100644
--- a/src/test/regress/sql/window.sql
+++ b/src/test/regress/sql/window.sql
@@ -235,14 +235,6 @@ SELECT last_value(unique1) over (ORDER BY four rows between current row and 2 fo
unique1, four
FROM tenk1 WHERE unique1 < 10;
-SELECT nth_value(unique1,2) over (ORDER BY four rows between current row and 3 following exclude ties),
- unique1, four
-FROM tenk1 WHERE unique1 < 10;
-
-SELECT last_value(unique1) over (ORDER BY four rows between 1 following and 2 following exclude ties),
- unique1, four
-FROM tenk1 WHERE unique1 < 12 ORDER BY four, unique1;
-
SELECT sum(unique1) over (rows between 2 preceding and 1 preceding),
unique1, four
FROM tenk1 WHERE unique1 < 10;
--
2.50.1 (Apple Git-155)