This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/datafusion.git
The following commit(s) were added to refs/heads/main by this push:
new 619123a8a7 Revert "chore: revert tests (#18065)" (#18255)
619123a8a7 is described below
commit 619123a8a7dc31857baf34dbea5ff60f1ff73ea5
Author: Khanh Duong <[email protected]>
AuthorDate: Fri Oct 24 15:29:15 2025 +0900
Revert "chore: revert tests (#18065)" (#18255)
## Which issue does this PR close?
- Relates #18062
- Relates #18065
## Rationale for this change
We disabled these tests because CI was failing on main.
The test: `current_date() = cast(now() as date)` was added in #18034
requires `now` to use configured timezone, but it is only available
after #18017.
Since #18017 has been merged, these tests should be enable.
## What changes are included in this PR?
This reverts commit a65a2cbd6070b392ff7ed5ccd2aa0accaf42177a.
## Are these changes tested?
Yes.
## Are there any user-facing changes?
No.
---
.../test_files/current_date_timezone.slt | 84 +++++++++++-----------
1 file changed, 41 insertions(+), 43 deletions(-)
diff --git a/datafusion/sqllogictest/test_files/current_date_timezone.slt
b/datafusion/sqllogictest/test_files/current_date_timezone.slt
index b30373acfa..1b9c3cddee 100644
--- a/datafusion/sqllogictest/test_files/current_date_timezone.slt
+++ b/datafusion/sqllogictest/test_files/current_date_timezone.slt
@@ -19,64 +19,62 @@
## current_date with timezone tests
##########
-# CI Fails https://github.com/apache/datafusion/issues/18062
-
# Test 1: Verify current_date is consistent within the same query (default UTC)
-# query B
-# SELECT current_date() = current_date();
-# ----
-# true
+query B
+SELECT current_date() = current_date();
+----
+true
# Test 2: Verify alias 'today' works the same as current_date
-# query B
-# SELECT current_date() = today();
-# ----
-# true
+query B
+SELECT current_date() = today();
+----
+true
# Test 3: Set timezone to +05:00 and verify current_date is still stable
-# statement ok
-# SET datafusion.execution.time_zone = '+05:00';
+statement ok
+SET datafusion.execution.time_zone = '+05:00';
-# query B
-# SELECT current_date() = current_date();
-# ----
-# true
+query B
+SELECT current_date() = current_date();
+----
+true
-# Test 4: Verify current_date matches cast(now() as date) in the same timezone
-# query B
-# SELECT current_date() = cast(now() as date);
-# ----
-# true
+#Test 4: Verify current_date matches cast(now() as date) in the same timezone
+query B
+SELECT current_date() = cast(now() as date);
+----
+true
# Test 5: Test with negative offset timezone
-# statement ok
-# SET datafusion.execution.time_zone = '-08:00';
+statement ok
+SET datafusion.execution.time_zone = '-08:00';
-# query B
-# SELECT current_date() = today();
-# ----
-# true
+query B
+SELECT current_date() = today();
+----
+true
# Test 6: Test with named timezone (America/New_York)
-# statement ok
-# SET datafusion.execution.time_zone = 'America/New_York';
+statement ok
+SET datafusion.execution.time_zone = 'America/New_York';
-# query B
-# SELECT current_date() = current_date();
-# ----
-# true
+query B
+SELECT current_date() = current_date();
+----
+true
# Test 7: Verify date type is preserved
-# query T
-# SELECT arrow_typeof(current_date());
-# ----
-# Date32
+query T
+SELECT arrow_typeof(current_date());
+----
+Date32
# Test 8: Reset to UTC
-# statement ok
-# SET datafusion.execution.time_zone = '+00:00';
+statement ok
+SET datafusion.execution.time_zone = '+00:00';
-# query B
-# SELECT current_date() = today();
-# ----
-# true
+query B
+SELECT current_date() = today();
+----
+true
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
