From 43a52bccf5bf17217a2734f4680c00a102f82cac Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 24 Dec 2023 08:49:59 +0100 Subject: Merging upstream version 20.4.0. Signed-off-by: Daniel Baumann --- tests/fixtures/optimizer/simplify.sql | 14 +++++++++++++- 1 file changed, 13 insertions(+), 1 deletion(-) (limited to 'tests/fixtures/optimizer/simplify.sql') diff --git a/tests/fixtures/optimizer/simplify.sql b/tests/fixtures/optimizer/simplify.sql index fbf5d2c..d3b03fb 100644 --- a/tests/fixtures/optimizer/simplify.sql +++ b/tests/fixtures/optimizer/simplify.sql @@ -696,6 +696,18 @@ x <> 1; NOT 1 <> x; x = 1; +x > CAST('2024-01-01' AS DATE) OR x > CAST('2023-12-31' AS DATE); +x > CAST('2023-12-31' AS DATE); + +CAST(x AS DATE) > CAST('2024-01-01' AS DATE) OR CAST(x AS DATE) > CAST('2023-12-31' AS DATE); +CAST(x AS DATE) > CAST('2023-12-31' AS DATE); + +FUN() > 0 OR FUN() > 1; +FUN() > 0; + +RAND() > 0 OR RAND() > 1; +RAND() > 0 OR RAND() > 1; + -------------------------------------- -- COALESCE -------------------------------------- @@ -835,7 +847,7 @@ DATE_TRUNC('quarter', x) = CAST('2021-01-02' AS DATE); DATE_TRUNC('quarter', x) = CAST('2021-01-02' AS DATE); DATE_TRUNC('year', x) <> CAST('2021-01-01' AS DATE); -x < CAST('2021-01-01' AS DATE) AND x >= CAST('2022-01-01' AS DATE); +FALSE; -- Always true, except for nulls DATE_TRUNC('year', x) <> CAST('2021-01-02' AS DATE); -- cgit v1.2.3