diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-06-17 09:15:19 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-06-17 09:15:19 +0000 |
commit | 5ac403c53fc7e610ee679587187546a61e2e342b (patch) | |
tree | 819e7e322201cb0206e429e6590ae85f3676e68d /tests/fixtures | |
parent | Releasing debian version 25.0.3-1. (diff) | |
download | sqlglot-5ac403c53fc7e610ee679587187546a61e2e342b.tar.xz sqlglot-5ac403c53fc7e610ee679587187546a61e2e342b.zip |
Merging upstream version 25.1.0.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to '')
-rw-r--r-- | tests/fixtures/identity.sql | 1 | ||||
-rw-r--r-- | tests/fixtures/optimizer/simplify.sql | 3 |
2 files changed, 4 insertions, 0 deletions
diff --git a/tests/fixtures/identity.sql b/tests/fixtures/identity.sql index e31031d..4dc4aa1 100644 --- a/tests/fixtures/identity.sql +++ b/tests/fixtures/identity.sql @@ -872,3 +872,4 @@ SELECT name SELECT copy SELECT rollup SELECT unnest +SELECT * FROM a STRAIGHT_JOIN b diff --git a/tests/fixtures/optimizer/simplify.sql b/tests/fixtures/optimizer/simplify.sql index 87b42d1..6035ee6 100644 --- a/tests/fixtures/optimizer/simplify.sql +++ b/tests/fixtures/optimizer/simplify.sql @@ -1047,6 +1047,9 @@ x < CAST('2021-01-02' AS DATE) AND x >= CAST('2021-01-01' AS DATE); TIMESTAMP_TRUNC(x, YEAR) = CAST(CAST('2021-01-01 01:02:03' AS DATE) AS DATETIME); x < CAST('2022-01-01 00:00:00' AS DATETIME) AND x >= CAST('2021-01-01 00:00:00' AS DATETIME); +DATE_TRUNC('day', CAST(x AS DATE)) <= CAST('2021-01-01 01:02:03' AS TIMESTAMP); +CAST(x AS DATE) < CAST('2021-01-02 01:02:03' AS TIMESTAMP); + -------------------------------------- -- EQUALITY -------------------------------------- |