This is an automated email from the ASF dual-hosted git repository.
zhenchen pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/calcite.git
The following commit(s) were added to refs/heads/main by this push:
new 245f2f8c2a Included cases for [CALCITE-6828]
245f2f8c2a is described below
commit 245f2f8c2ada730123cae7a51d5aac8e7bb7eccb
Author: Zhen Chen <[email protected]>
AuthorDate: Thu Feb 26 14:00:36 2026 +0800
Included cases for [CALCITE-6828]
---
core/src/test/resources/sql/misc.iq | 5 -----
core/src/test/resources/sql/operator.iq | 4 +---
2 files changed, 1 insertion(+), 8 deletions(-)
diff --git a/core/src/test/resources/sql/misc.iq
b/core/src/test/resources/sql/misc.iq
index aa73ca9a08..05697b8118 100644
--- a/core/src/test/resources/sql/misc.iq
+++ b/core/src/test/resources/sql/misc.iq
@@ -2143,7 +2143,6 @@ EnumerableAggregate(group=[{}], C=[COUNT()])
EnumerableValues(tuples=[[]])
!plan
-!if (fixed.calcite6828) {
# [CALCITE-1659] Simplifying CAST('YYYY-MM-DD hh:mm:ss.SSS' as TIMESTAMP)
# should round the sub-second fraction
select TIMESTAMP '2016-02-26 19:06:00.123456789',
@@ -2165,9 +2164,6 @@ select TIMESTAMP '2016-02-26 19:06:00.123456789',
EnumerableValues(tuples=[[{ 2016-02-26 19:06:00.123, 2016-02-26 19:06:00,
2016-02-26 19:06:00, 2016-02-26 19:06:00.1, 2016-02-26 19:06:00.12, 2016-02-26
19:06:00.123, 2016-02-26 19:06:00.123, 2016-02-26 19:06:00.123 }]])
!plan
-!}
-
-!if (fixed.calcite6828) {
# [CALCITE-1664] CAST('<string>' as TIMESTAMP) adds part of sub-second
fraction to the value
select
TIMESTAMP '2016-02-26 19:06:00.12345678',
@@ -2184,7 +2180,6 @@ select
!ok
-!}
# TIMESTAMPDIFF with 'flag' literal as time unit argument
SELECT TIMESTAMPDIFF(quarter, TIMESTAMP '2008-12-25', TIMESTAMP '2008-09-25');
+--------+
diff --git a/core/src/test/resources/sql/operator.iq
b/core/src/test/resources/sql/operator.iq
index c0c9d0b422..33731a08c4 100644
--- a/core/src/test/resources/sql/operator.iq
+++ b/core/src/test/resources/sql/operator.iq
@@ -276,7 +276,6 @@ order by 1,2;
!ok
-!if (fixed.calcite6828) {
# FLOOR and CEIL of TIME
select v,
case when b then 'ceil' else 'floor' end as op,
@@ -298,9 +297,8 @@ order by 1,2;
| 12:34:56.7 | floor | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 |
12:34:56.7 | 12:00:00.0 | 12:34:00.0 | 12:34:56.0 |
+------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+
(2 rows)
-!ok
-!}
+!ok
select "T"."X"[1] as x1 from (VALUES (ROW(ROW(3, 7), ROW(4, 8)))) as T(x, y);