From 0dc79aa05d545e03f03e85a5ad61eb7771d64018 Mon Sep 17 00:00:00 2001 From: Henson Choi Date: Thu, 22 Oct 2026 15:41:02 +0900 Subject: [PATCH 6/6] Remove EXCLUDE TIES window tests unrelated to row pattern recognition This series added two queries to the window tests, for nth_value() and last_value() with EXCLUDE TIES, which cover existing window frame code and have nothing to do with row pattern recognition. --- 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 ae5569f4e62..112551c350b 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 cd0bc0f2631..e848557174b 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.54.0 (Apple Git-157)