This is an automated email from the ASF dual-hosted git repository.
jakevin pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 47578c0fc9c [fix](Nereids) fix toSql of date literal (#25243)
47578c0fc9c is described below
commit 47578c0fc9c92264fbc4b111946d4a27cc58a0b3
Author: 谢健 <jianx...@gmail.com>
AuthorDate: Wed Oct 11 13:04:05 2023 +0800
[fix](Nereids) fix toSql of date literal (#25243)
toSql should return '2023-2-1 ' for DateLiteral 2023-2-1
---
.../trees/expressions/literal/DateLiteral.java | 2 +-
.../trees/expressions/literal/DateTimeLiteral.java | 2 +-
.../nereids/rules/expression/FoldConstantTest.java | 68 +++++++++++-----------
.../rules/SimplifyComparisonPredicateSqlTest.java | 8 +--
.../nereids_tpcds_shape_sf100_p0/shape/query12.out | 2 +-
.../nereids_tpcds_shape_sf100_p0/shape/query16.out | 2 +-
.../nereids_tpcds_shape_sf100_p0/shape/query20.out | 2 +-
.../nereids_tpcds_shape_sf100_p0/shape/query21.out | 2 +-
.../nereids_tpcds_shape_sf100_p0/shape/query32.out | 2 +-
.../nereids_tpcds_shape_sf100_p0/shape/query37.out | 2 +-
.../nereids_tpcds_shape_sf100_p0/shape/query40.out | 2 +-
.../nereids_tpcds_shape_sf100_p0/shape/query5.out | 6 +-
.../nereids_tpcds_shape_sf100_p0/shape/query58.out | 6 +-
.../nereids_tpcds_shape_sf100_p0/shape/query77.out | 12 ++--
.../nereids_tpcds_shape_sf100_p0/shape/query80.out | 6 +-
.../nereids_tpcds_shape_sf100_p0/shape/query82.out | 2 +-
.../nereids_tpcds_shape_sf100_p0/shape/query83.out | 6 +-
.../nereids_tpcds_shape_sf100_p0/shape/query92.out | 2 +-
.../nereids_tpcds_shape_sf100_p0/shape/query94.out | 2 +-
.../nereids_tpcds_shape_sf100_p0/shape/query95.out | 2 +-
.../nereids_tpcds_shape_sf100_p0/shape/query98.out | 2 +-
.../data/nereids_tpch_shape_sf1000_p0/shape/q1.out | 2 +-
.../nereids_tpch_shape_sf1000_p0/shape/q10.out | 2 +-
.../nereids_tpch_shape_sf1000_p0/shape/q12.out | 2 +-
.../nereids_tpch_shape_sf1000_p0/shape/q14.out | 2 +-
.../nereids_tpch_shape_sf1000_p0/shape/q15.out | 4 +-
.../shape/q20-rewrite.out | 2 +-
.../nereids_tpch_shape_sf1000_p0/shape/q20.out | 2 +-
.../data/nereids_tpch_shape_sf1000_p0/shape/q3.out | 4 +-
.../data/nereids_tpch_shape_sf1000_p0/shape/q4.out | 2 +-
.../data/nereids_tpch_shape_sf1000_p0/shape/q5.out | 2 +-
.../data/nereids_tpch_shape_sf1000_p0/shape/q6.out | 2 +-
.../data/nereids_tpch_shape_sf1000_p0/shape/q7.out | 2 +-
.../data/nereids_tpch_shape_sf1000_p0/shape/q8.out | 2 +-
34 files changed, 85 insertions(+), 85 deletions(-)
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/literal/DateLiteral.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/literal/DateLiteral.java
index b40a04041e9..c6552778c81 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/literal/DateLiteral.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/literal/DateLiteral.java
@@ -306,7 +306,7 @@ public class DateLiteral extends Literal {
@Override
public String toSql() {
- return toString();
+ return String.format("'%s'", toString());
}
@Override
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/literal/DateTimeLiteral.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/literal/DateTimeLiteral.java
index 1bf2ac7e736..36131db238f 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/literal/DateTimeLiteral.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/literal/DateTimeLiteral.java
@@ -181,7 +181,7 @@ public class DateTimeLiteral extends DateLiteral {
@Override
public String toSql() {
- return toString();
+ return String.format("'%s'", toString());
}
@Override
diff --git
a/fe/fe-core/src/test/java/org/apache/doris/nereids/rules/expression/FoldConstantTest.java
b/fe/fe-core/src/test/java/org/apache/doris/nereids/rules/expression/FoldConstantTest.java
index 2e94abc3167..9b469c98e14 100644
---
a/fe/fe-core/src/test/java/org/apache/doris/nereids/rules/expression/FoldConstantTest.java
+++
b/fe/fe-core/src/test/java/org/apache/doris/nereids/rules/expression/FoldConstantTest.java
@@ -308,11 +308,11 @@ class FoldConstantTest extends
ExpressionRewriteTestHelper {
VarcharLiteral format = new VarcharLiteral("%Y-%m-%d");
String[] answer = {
- "2000-01-30", "1999-12-01", "2029-12-31", "1969-12-31",
- "2002-06-30", "1997-06-30", "2000-07-28", "1999-06-04",
- "2000-01-30", "1999-12-01",
+ "'2000-01-30'", "'1999-12-01'", "'2029-12-31'", "'1969-12-31'",
+ "'2002-06-30'", "'1997-06-30'", "'2000-07-28'", "'1999-06-04'",
+ "'2000-01-30'", "'1999-12-01'",
"1999", "4", "12", "6", "31", "365", "31",
- "'1999-12-31'", "1999-12-27", "1999-12-31"
+ "'1999-12-31'", "'1999-12-27'", "'1999-12-31'"
};
int answerIdx = 0;
@@ -348,12 +348,12 @@ class FoldConstantTest extends
ExpressionRewriteTestHelper {
VarcharLiteral format = new VarcharLiteral("%Y-%m-%d");
String[] answer = {
- "2000-01-30 23:59:59", "1999-12-01 23:59:59", "2029-12-31
23:59:59", "1969-12-31 23:59:59",
- "2002-06-30 23:59:59", "1997-06-30 23:59:59", "2000-01-30
23:59:59", "1999-12-01 23:59:59",
- "2000-01-02 05:59:59", "1999-12-30 17:59:59", "2000-01-01
00:29:59",
- "1999-12-31 23:29:59", "2000-01-01 00:00:29", "1999-12-31
23:59:29",
+ "'2000-01-30 23:59:59'", "'1999-12-01 23:59:59'", "'2029-12-31
23:59:59'", "'1969-12-31 23:59:59'",
+ "'2002-06-30 23:59:59'", "'1997-06-30 23:59:59'", "'2000-01-30
23:59:59'", "'1999-12-01 23:59:59'",
+ "'2000-01-02 05:59:59'", "'1999-12-30 17:59:59'", "'2000-01-01
00:29:59'",
+ "'1999-12-31 23:29:59'", "'2000-01-01 00:00:29'", "'1999-12-31
23:59:29'",
"1999", "4", "12", "6", "31", "365", "31", "23", "59", "59",
- "'1999-12-31'", "1999-12-27", "1999-12-31", "1999-12-31",
"730484", "1999-12-31"
+ "'1999-12-31'", "'1999-12-27'", "'1999-12-31'",
"'1999-12-31'", "730484", "'1999-12-31'"
};
int answerIdx = 0;
@@ -403,10 +403,10 @@ class FoldConstantTest extends
ExpressionRewriteTestHelper {
VarcharLiteral format = new VarcharLiteral("%Y-%m-%d");
String[] answer = {
- "2000-01-30", "1999-12-01", "2029-12-31", "1969-12-31",
- "2002-06-30", "1997-06-30", "2000-01-30", "1999-12-01",
+ "'2000-01-30'", "'1999-12-01'", "'2029-12-31'", "'1969-12-31'",
+ "'2002-06-30'", "'1997-06-30'", "'2000-01-30'", "'1999-12-01'",
"1999", "4", "12", "6", "31", "365", "31",
- "'1999-12-31'", "1999-12-27", "1999-12-31"
+ "'1999-12-31'", "'1999-12-27'", "'1999-12-31'"
};
int answerIdx = 0;
@@ -440,12 +440,12 @@ class FoldConstantTest extends
ExpressionRewriteTestHelper {
VarcharLiteral format = new VarcharLiteral("%Y-%m-%d");
String[] answer = {
- "2000-01-30 23:59:59", "1999-12-01 23:59:59", "2029-12-31
23:59:59", "1969-12-31 23:59:59",
- "2002-06-30 23:59:59", "1997-06-30 23:59:59", "2000-01-30
23:59:59", "1999-12-01 23:59:59",
- "2000-01-02 05:59:59", "1999-12-30 17:59:59", "2000-01-01
00:29:59",
- "1999-12-31 23:29:59", "2000-01-01 00:00:29", "1999-12-31
23:59:29", "1999-12-31 23:59:59",
+ "'2000-01-30 23:59:59'", "'1999-12-01 23:59:59'", "'2029-12-31
23:59:59'", "'1969-12-31 23:59:59'",
+ "'2002-06-30 23:59:59'", "'1997-06-30 23:59:59'", "'2000-01-30
23:59:59'", "'1999-12-01 23:59:59'",
+ "'2000-01-02 05:59:59'", "'1999-12-30 17:59:59'", "'2000-01-01
00:29:59'",
+ "'1999-12-31 23:29:59'", "'2000-01-01 00:00:29'", "'1999-12-31
23:59:29'", "'1999-12-31 23:59:59'",
"1999", "4", "12", "6", "31", "365", "31", "23", "59", "59",
- "'1999-12-31'", "1999-12-27", "1999-12-31", "1999-12-31",
"730484", "1999-12-31", "1999-12-31"
+ "'1999-12-31'", "'1999-12-27'", "'1999-12-31'",
"'1999-12-31'", "730484", "'1999-12-31'", "'1999-12-31'"
};
int answerIdx = 0;
@@ -528,14 +528,14 @@ class FoldConstantTest extends
ExpressionRewriteTestHelper {
String[] tags = {"year", "month", "day", "hour", "minute", "second"};
String[] answer = {
- "2001-01-01 00:00:00", "2001-01-01 00:00:00", "2001-12-01
00:00:00", "2001-12-01 00:00:00",
- "2001-12-31 00:00:00", "2001-12-31 00:00:00", "2001-12-31
01:00:00", "2001-12-31 01:00:00",
- "2001-12-31 01:01:00", "2001-12-31 01:01:00", "2001-12-31
01:01:01", "2001-12-31 01:01:01",
- "2001-01-01 00:00:00", "2001-01-01 00:00:00", "2001-01-01
00:00:00",
- "2001-04-01 00:00:00", "2001-04-01 00:00:00", "2001-04-01
00:00:00",
- "2001-07-01 00:00:00", "2001-07-01 00:00:00", "2001-07-01
00:00:00",
- "2001-10-01 00:00:00", "2001-10-01 00:00:00", "2001-10-01
00:00:00",
- "2001-01-15 00:00:00", "2001-02-12 00:00:00", "2001-03-12
00:00:00",
+ "'2001-01-01 00:00:00'", "'2001-01-01 00:00:00'", "'2001-12-01
00:00:00'", "'2001-12-01 00:00:00'",
+ "'2001-12-31 00:00:00'", "'2001-12-31 00:00:00'", "'2001-12-31
01:00:00'", "'2001-12-31 01:00:00'",
+ "'2001-12-31 01:01:00'", "'2001-12-31 01:01:00'", "'2001-12-31
01:01:01'", "'2001-12-31 01:01:01'",
+ "'2001-01-01 00:00:00'", "'2001-01-01 00:00:00'", "'2001-01-01
00:00:00'",
+ "'2001-04-01 00:00:00'", "'2001-04-01 00:00:00'", "'2001-04-01
00:00:00'",
+ "'2001-07-01 00:00:00'", "'2001-07-01 00:00:00'", "'2001-07-01
00:00:00'",
+ "'2001-10-01 00:00:00'", "'2001-10-01 00:00:00'", "'2001-10-01
00:00:00'",
+ "'2001-01-15 00:00:00'", "'2001-02-12 00:00:00'", "'2001-03-12
00:00:00'",
};
int answerIdx = 0;
@@ -561,7 +561,7 @@ class FoldConstantTest extends ExpressionRewriteTestHelper {
@Test
void testDateConstructFunction() {
String[] answer = {
- "2001-07-19", "6411-08-17", "0000-01-01", "'1977-06-03
17:57:24'",
+ "'2001-07-19'", "'6411-08-17'", "'0000-01-01'", "'1977-06-03
17:57:24'",
"'1977-06-03'", "1008909293", "1008864000"
};
int answerIdx = 0;
@@ -594,7 +594,7 @@ class FoldConstantTest extends ExpressionRewriteTestHelper {
@Test
void testFoldNestedExpression() {
- assertRewriteExpression("makedate(year('2010-04-10'),
dayofyear('2010-04-11'))", "2010-04-11");
+ assertRewriteExpression("makedate(year('2010-04-10'),
dayofyear('2010-04-11'))", "'2010-04-11'");
assertRewriteExpression("null in ('d', null)", "NULL");
assertRewriteExpression("null not in ('d', null)", "NULL");
assertRewriteExpression("'a' in ('d', null)", "NULL");
@@ -608,13 +608,13 @@ class FoldConstantTest extends
ExpressionRewriteTestHelper {
@Test
void testFoldCastStringToDate() {
- assertRewriteExpression("cast('2021-01-01' as date)", "2021-01-01");
- assertRewriteExpression("cast('20210101' as date)", "2021-01-01");
- assertRewriteExpression("cast('2021-01-01T00:00:00' as date)",
"2021-01-01");
- assertRewriteExpression("cast('2021-01-01' as datetime)", "2021-01-01
00:00:00");
- assertRewriteExpression("cast('20210101' as datetime)", "2021-01-01
00:00:00");
- assertRewriteExpression("cast('2021-01-01T00:00:00' as datetime)",
"2021-01-01 00:00:00");
- assertRewriteExpression("cast ('2022-12-02 22:23:24.999999' as
datetimev2(3))", "2022-12-02 22:23:25.000");
+ assertRewriteExpression("cast('2021-01-01' as date)", "'2021-01-01'");
+ assertRewriteExpression("cast('20210101' as date)", "'2021-01-01'");
+ assertRewriteExpression("cast('2021-01-01T00:00:00' as date)",
"'2021-01-01'");
+ assertRewriteExpression("cast('2021-01-01' as datetime)", "'2021-01-01
00:00:00'");
+ assertRewriteExpression("cast('20210101' as datetime)", "'2021-01-01
00:00:00'");
+ assertRewriteExpression("cast('2021-01-01T00:00:00' as datetime)",
"'2021-01-01 00:00:00'");
+ assertRewriteExpression("cast ('2022-12-02 22:23:24.999999' as
datetimev2(3))", "'2022-12-02 22:23:25.000'");
}
@Test
diff --git
a/fe/fe-core/src/test/java/org/apache/doris/nereids/rules/expression/rules/SimplifyComparisonPredicateSqlTest.java
b/fe/fe-core/src/test/java/org/apache/doris/nereids/rules/expression/rules/SimplifyComparisonPredicateSqlTest.java
index 4201da388b1..0eddbb11c0d 100644
---
a/fe/fe-core/src/test/java/org/apache/doris/nereids/rules/expression/rules/SimplifyComparisonPredicateSqlTest.java
+++
b/fe/fe-core/src/test/java/org/apache/doris/nereids/rules/expression/rules/SimplifyComparisonPredicateSqlTest.java
@@ -57,7 +57,7 @@ class SimplifyComparisonPredicateSqlTest extends
TestWithFeService implements Me
.rewrite()
.matches(
logicalFilter()
- .when(f -> f.getConjuncts().stream().anyMatch(e ->
e.toSql().equals("(a < 2023-06-16 00:00:00)")))
+ .when(f -> f.getConjuncts().stream().anyMatch(e ->
e.toSql().equals("(a < '2023-06-16 00:00:00')")))
.when(f -> f.getConjuncts().stream().anyMatch(e ->
e.toSql().equals("(b < 111.12)")))
);
@@ -66,7 +66,7 @@ class SimplifyComparisonPredicateSqlTest extends
TestWithFeService implements Me
.rewrite()
.matches(
logicalFilter()
- .when(f ->
f.getConjuncts().stream().anyMatch(e -> e.toSql().equals("(a <= 2023-06-16
00:00:00)")))
+ .when(f ->
f.getConjuncts().stream().anyMatch(e -> e.toSql().equals("(a <= '2023-06-16
00:00:00')")))
.when(f ->
f.getConjuncts().stream().anyMatch(e -> e.toSql().equals("(b <= 111.11)")))
);
@@ -82,7 +82,7 @@ class SimplifyComparisonPredicateSqlTest extends
TestWithFeService implements Me
.rewrite()
.matches(
logicalFilter()
- .when(f ->
f.getConjuncts().stream().anyMatch(e -> e.toSql().equals("(a > 2023-06-16
00:00:00)")))
+ .when(f ->
f.getConjuncts().stream().anyMatch(e -> e.toSql().equals("(a > '2023-06-16
00:00:00')")))
.when(f ->
f.getConjuncts().stream().anyMatch(e -> e.toSql().equals("(b > 111.11)")))
);
@@ -91,7 +91,7 @@ class SimplifyComparisonPredicateSqlTest extends
TestWithFeService implements Me
.rewrite()
.matches(
logicalFilter()
- .when(f ->
f.getConjuncts().stream().anyMatch(e -> e.toSql().equals("(a >= 2023-06-16
00:00:00)")))
+ .when(f ->
f.getConjuncts().stream().anyMatch(e -> e.toSql().equals("(a >= '2023-06-16
00:00:00')")))
.when(f ->
f.getConjuncts().stream().anyMatch(e -> e.toSql().equals("(b >= 111.12)")))
);
}
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query12.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query12.out
index 08c4fb6fff0..c1f36374be3 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query12.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query12.out
@@ -19,7 +19,7 @@ PhysicalResultSink
--------------------------------PhysicalOlapScan[web_sales]
------------------------------PhysicalDistribute
--------------------------------PhysicalProject
-----------------------------------filter((date_dim.d_date <= 1998-05-06) and
(date_dim.d_date >= 1998-04-06))
+----------------------------------filter((date_dim.d_date <= '1998-05-06') and
(date_dim.d_date >= '1998-04-06'))
------------------------------------PhysicalOlapScan[date_dim]
--------------------------PhysicalDistribute
----------------------------PhysicalProject
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query16.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query16.out
index 7609d52b1b5..18b3bffdae2 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query16.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query16.out
@@ -29,7 +29,7 @@ PhysicalResultSink
------------------------------------PhysicalOlapScan[customer_address]
----------------------------PhysicalDistribute
------------------------------PhysicalProject
---------------------------------filter((date_dim.d_date <= 2002-05-31) and
(date_dim.d_date >= 2002-04-01))
+--------------------------------filter((date_dim.d_date <= '2002-05-31') and
(date_dim.d_date >= '2002-04-01'))
----------------------------------PhysicalOlapScan[date_dim]
----------------------PhysicalDistribute
------------------------PhysicalProject
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query20.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query20.out
index 9f7938f325b..ac753d9b077 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query20.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query20.out
@@ -19,7 +19,7 @@ PhysicalResultSink
--------------------------------PhysicalOlapScan[catalog_sales]
------------------------------PhysicalDistribute
--------------------------------PhysicalProject
-----------------------------------filter((date_dim.d_date <= 2002-02-25) and
(date_dim.d_date >= 2002-01-26))
+----------------------------------filter((date_dim.d_date <= '2002-02-25') and
(date_dim.d_date >= '2002-01-26'))
------------------------------------PhysicalOlapScan[date_dim]
--------------------------PhysicalDistribute
----------------------------PhysicalProject
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query21.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query21.out
index c94c8bc0fc7..cbc9beeca21 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query21.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query21.out
@@ -19,7 +19,7 @@ PhysicalResultSink
------------------------------PhysicalOlapScan[item]
----------------------PhysicalDistribute
------------------------PhysicalProject
---------------------------filter((date_dim.d_date <= 2002-03-29) and
(date_dim.d_date >= 2002-01-28))
+--------------------------filter((date_dim.d_date <= '2002-03-29') and
(date_dim.d_date >= '2002-01-28'))
----------------------------PhysicalOlapScan[date_dim]
--------------------PhysicalDistribute
----------------------PhysicalProject
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query32.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query32.out
index 7e5fa70c52e..51b789a35f0 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query32.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query32.out
@@ -22,6 +22,6 @@ PhysicalResultSink
----------------------------------PhysicalOlapScan[item]
--------------------------PhysicalDistribute
----------------------------PhysicalProject
-------------------------------filter((date_dim.d_date <= 1999-04-07) and
(date_dim.d_date >= 1999-01-07))
+------------------------------filter((date_dim.d_date <= '1999-04-07') and
(date_dim.d_date >= '1999-01-07'))
--------------------------------PhysicalOlapScan[date_dim]
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query37.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query37.out
index c18e9805b4a..1debda4ceed 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query37.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query37.out
@@ -24,6 +24,6 @@ PhysicalResultSink
--------------------------------PhysicalOlapScan[item]
------------------------PhysicalDistribute
--------------------------PhysicalProject
-----------------------------filter((date_dim.d_date <= 1999-04-22) and
(date_dim.d_date >= 1999-02-21))
+----------------------------filter((date_dim.d_date <= '1999-04-22') and
(date_dim.d_date >= '1999-02-21'))
------------------------------PhysicalOlapScan[date_dim]
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query40.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query40.out
index 04c0b53f0db..50ce711030e 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query40.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query40.out
@@ -23,7 +23,7 @@ PhysicalResultSink
--------------------------------PhysicalOlapScan[item]
------------------------PhysicalDistribute
--------------------------PhysicalProject
-----------------------------filter((date_dim.d_date <= 2001-05-02) and
(date_dim.d_date >= 2001-03-03))
+----------------------------filter((date_dim.d_date <= '2001-05-02') and
(date_dim.d_date >= '2001-03-03'))
------------------------------PhysicalOlapScan[date_dim]
------------------PhysicalDistribute
--------------------PhysicalProject
diff --git a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query5.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query5.out
index 7ef6edcb689..58cbdf6bfd3 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query5.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query5.out
@@ -25,7 +25,7 @@ PhysicalResultSink
--------------------------------------PhysicalProject
----------------------------------------PhysicalOlapScan[store_returns]
----------------------------------PhysicalDistribute
-------------------------------------filter((date_dim.d_date <= 2000-09-02) and
(date_dim.d_date >= 2000-08-19))
+------------------------------------filter((date_dim.d_date <= '2000-09-02')
and (date_dim.d_date >= '2000-08-19'))
--------------------------------------PhysicalOlapScan[date_dim]
--------------------------------PhysicalDistribute
----------------------------------PhysicalOlapScan[store]
@@ -44,7 +44,7 @@ PhysicalResultSink
--------------------------------------PhysicalProject
----------------------------------------PhysicalOlapScan[catalog_returns]
----------------------------------PhysicalDistribute
-------------------------------------filter((date_dim.d_date <= 2000-09-02) and
(date_dim.d_date >= 2000-08-19))
+------------------------------------filter((date_dim.d_date <= '2000-09-02')
and (date_dim.d_date >= '2000-08-19'))
--------------------------------------PhysicalOlapScan[date_dim]
--------------------------------PhysicalDistribute
----------------------------------PhysicalOlapScan[catalog_page]
@@ -65,7 +65,7 @@ PhysicalResultSink
------------------------------------------PhysicalOlapScan[web_sales]
------------------------------------------PhysicalOlapScan[web_returns]
----------------------------------PhysicalDistribute
-------------------------------------filter((date_dim.d_date <= 2000-09-02) and
(date_dim.d_date >= 2000-08-19))
+------------------------------------filter((date_dim.d_date <= '2000-09-02')
and (date_dim.d_date >= '2000-08-19'))
--------------------------------------PhysicalOlapScan[date_dim]
--------------------------------PhysicalDistribute
----------------------------------PhysicalOlapScan[web_site]
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query58.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query58.out
index 03ce5bd8559..4f3eab55f9f 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query58.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query58.out
@@ -30,7 +30,7 @@ PhysicalResultSink
------------------------------------------PhysicalAssertNumRows
--------------------------------------------PhysicalDistribute
----------------------------------------------PhysicalProject
-------------------------------------------------filter((date_dim.d_date =
2001-03-24))
+------------------------------------------------filter((date_dim.d_date =
'2001-03-24'))
--------------------------------------------------PhysicalOlapScan[date_dim]
------------------------PhysicalDistribute
--------------------------PhysicalProject
@@ -60,7 +60,7 @@ PhysicalResultSink
--------------------------------------------PhysicalAssertNumRows
----------------------------------------------PhysicalDistribute
------------------------------------------------PhysicalProject
---------------------------------------------------filter((date_dim.d_date =
2001-03-24))
+--------------------------------------------------filter((date_dim.d_date =
'2001-03-24'))
----------------------------------------------------PhysicalOlapScan[date_dim]
--------------------------PhysicalDistribute
----------------------------PhysicalProject
@@ -89,7 +89,7 @@ PhysicalResultSink
--------------------------------------------PhysicalAssertNumRows
----------------------------------------------PhysicalDistribute
------------------------------------------------PhysicalProject
---------------------------------------------------filter((date_dim.d_date =
2001-03-24))
+--------------------------------------------------filter((date_dim.d_date =
'2001-03-24'))
----------------------------------------------------PhysicalOlapScan[date_dim]
--------------------------PhysicalDistribute
----------------------------PhysicalProject
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query77.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query77.out
index 3a469872740..d09617fa068 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query77.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query77.out
@@ -21,7 +21,7 @@ PhysicalResultSink
------------------------------------hashJoin[INNER_JOIN]
hashCondition=((store_sales.ss_sold_date_sk =
date_dim.d_date_sk))otherCondition=()
--------------------------------------PhysicalOlapScan[store_sales]
--------------------------------------PhysicalDistribute
-----------------------------------------filter((date_dim.d_date <= 1998-09-04)
and (date_dim.d_date >= 1998-08-05))
+----------------------------------------filter((date_dim.d_date <=
'1998-09-04') and (date_dim.d_date >= '1998-08-05'))
------------------------------------------PhysicalOlapScan[date_dim]
------------------------------------PhysicalDistribute
--------------------------------------PhysicalOlapScan[store]
@@ -34,7 +34,7 @@ PhysicalResultSink
------------------------------------hashJoin[INNER_JOIN]
hashCondition=((store_returns.sr_returned_date_sk =
date_dim.d_date_sk))otherCondition=()
--------------------------------------PhysicalOlapScan[store_returns]
--------------------------------------PhysicalDistribute
-----------------------------------------filter((date_dim.d_date <= 1998-09-04)
and (date_dim.d_date >= 1998-08-05))
+----------------------------------------filter((date_dim.d_date <=
'1998-09-04') and (date_dim.d_date >= '1998-08-05'))
------------------------------------------PhysicalOlapScan[date_dim]
------------------------------------PhysicalDistribute
--------------------------------------PhysicalOlapScan[store]
@@ -48,7 +48,7 @@ PhysicalResultSink
----------------------------------hashJoin[INNER_JOIN]
hashCondition=((catalog_sales.cs_sold_date_sk =
date_dim.d_date_sk))otherCondition=()
------------------------------------PhysicalOlapScan[catalog_sales]
------------------------------------PhysicalDistribute
---------------------------------------filter((date_dim.d_date <= 1998-09-04)
and (date_dim.d_date >= 1998-08-05))
+--------------------------------------filter((date_dim.d_date <= '1998-09-04')
and (date_dim.d_date >= '1998-08-05'))
----------------------------------------PhysicalOlapScan[date_dim]
------------------------PhysicalDistribute
--------------------------PhysicalProject
@@ -59,7 +59,7 @@ PhysicalResultSink
------------------------------------hashJoin[INNER_JOIN]
hashCondition=((catalog_returns.cr_returned_date_sk =
date_dim.d_date_sk))otherCondition=()
--------------------------------------PhysicalOlapScan[catalog_returns]
--------------------------------------PhysicalDistribute
-----------------------------------------filter((date_dim.d_date <= 1998-09-04)
and (date_dim.d_date >= 1998-08-05))
+----------------------------------------filter((date_dim.d_date <=
'1998-09-04') and (date_dim.d_date >= '1998-08-05'))
------------------------------------------PhysicalOlapScan[date_dim]
--------------------PhysicalProject
----------------------hashJoin[LEFT_OUTER_JOIN]
hashCondition=((ws.wp_web_page_sk = wr.wp_web_page_sk))otherCondition=()
@@ -72,7 +72,7 @@ PhysicalResultSink
------------------------------------hashJoin[INNER_JOIN]
hashCondition=((web_sales.ws_sold_date_sk =
date_dim.d_date_sk))otherCondition=()
--------------------------------------PhysicalOlapScan[web_sales]
--------------------------------------PhysicalDistribute
-----------------------------------------filter((date_dim.d_date <= 1998-09-04)
and (date_dim.d_date >= 1998-08-05))
+----------------------------------------filter((date_dim.d_date <=
'1998-09-04') and (date_dim.d_date >= '1998-08-05'))
------------------------------------------PhysicalOlapScan[date_dim]
------------------------------------PhysicalDistribute
--------------------------------------PhysicalOlapScan[web_page]
@@ -85,7 +85,7 @@ PhysicalResultSink
------------------------------------hashJoin[INNER_JOIN]
hashCondition=((web_returns.wr_returned_date_sk =
date_dim.d_date_sk))otherCondition=()
--------------------------------------PhysicalOlapScan[web_returns]
--------------------------------------PhysicalDistribute
-----------------------------------------filter((date_dim.d_date <= 1998-09-04)
and (date_dim.d_date >= 1998-08-05))
+----------------------------------------filter((date_dim.d_date <=
'1998-09-04') and (date_dim.d_date >= '1998-08-05'))
------------------------------------------PhysicalOlapScan[date_dim]
------------------------------------PhysicalDistribute
--------------------------------------PhysicalOlapScan[web_page]
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query80.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query80.out
index 3f7b1c8148d..f25f72e1786 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query80.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query80.out
@@ -23,7 +23,7 @@ PhysicalResultSink
--------------------------------------hashJoin[INNER_JOIN]
hashCondition=((store_sales.ss_sold_date_sk =
date_dim.d_date_sk))otherCondition=()
----------------------------------------PhysicalOlapScan[store_sales]
----------------------------------------PhysicalDistribute
-------------------------------------------filter((date_dim.d_date <=
1998-09-27) and (date_dim.d_date >= 1998-08-28))
+------------------------------------------filter((date_dim.d_date <=
'1998-09-27') and (date_dim.d_date >= '1998-08-28'))
--------------------------------------------PhysicalOlapScan[date_dim]
--------------------------------------PhysicalDistribute
----------------------------------------filter((item.i_current_price > 50.00))
@@ -46,7 +46,7 @@ PhysicalResultSink
--------------------------------------hashJoin[INNER_JOIN]
hashCondition=((catalog_sales.cs_sold_date_sk =
date_dim.d_date_sk))otherCondition=()
----------------------------------------PhysicalOlapScan[catalog_sales]
----------------------------------------PhysicalDistribute
-------------------------------------------filter((date_dim.d_date <=
1998-09-27) and (date_dim.d_date >= 1998-08-28))
+------------------------------------------filter((date_dim.d_date <=
'1998-09-27') and (date_dim.d_date >= '1998-08-28'))
--------------------------------------------PhysicalOlapScan[date_dim]
--------------------------------------PhysicalDistribute
----------------------------------------filter((item.i_current_price > 50.00))
@@ -71,7 +71,7 @@ PhysicalResultSink
------------------------------------------hashJoin[INNER_JOIN]
hashCondition=((web_sales.ws_sold_date_sk =
date_dim.d_date_sk))otherCondition=()
--------------------------------------------PhysicalOlapScan[web_sales]
--------------------------------------------PhysicalDistribute
-----------------------------------------------filter((date_dim.d_date <=
1998-09-27) and (date_dim.d_date >= 1998-08-28))
+----------------------------------------------filter((date_dim.d_date <=
'1998-09-27') and (date_dim.d_date >= '1998-08-28'))
------------------------------------------------PhysicalOlapScan[date_dim]
------------------------------------------PhysicalDistribute
--------------------------------------------filter((promotion.p_channel_tv =
'N'))
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query82.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query82.out
index b706b5bba24..8932f8bde1d 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query82.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query82.out
@@ -24,6 +24,6 @@ PhysicalResultSink
--------------------------------PhysicalOlapScan[item]
------------------------PhysicalDistribute
--------------------------PhysicalProject
-----------------------------filter((date_dim.d_date <= 1999-09-07) and
(date_dim.d_date >= 1999-07-09))
+----------------------------filter((date_dim.d_date <= '1999-09-07') and
(date_dim.d_date >= '1999-07-09'))
------------------------------PhysicalOlapScan[date_dim]
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query83.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query83.out
index f80f0bd9cac..35b51af2346 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query83.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query83.out
@@ -30,7 +30,7 @@ PhysicalResultSink
------------------------------------------PhysicalOlapScan[date_dim]
----------------------------------------PhysicalDistribute
------------------------------------------PhysicalProject
---------------------------------------------filter(d_date IN (2001-06-06,
2001-09-02, 2001-11-11))
+--------------------------------------------filter(d_date IN ('2001-06-06',
'2001-09-02', '2001-11-11'))
----------------------------------------------PhysicalOlapScan[date_dim]
------------hashJoin[INNER_JOIN] hashCondition=((sr_items.item_id =
wr_items.item_id))otherCondition=()
--------------PhysicalProject
@@ -55,7 +55,7 @@ PhysicalResultSink
--------------------------------------------PhysicalOlapScan[date_dim]
------------------------------------------PhysicalDistribute
--------------------------------------------PhysicalProject
-----------------------------------------------filter(d_date IN (2001-06-06,
2001-09-02, 2001-11-11))
+----------------------------------------------filter(d_date IN ('2001-06-06',
'2001-09-02', '2001-11-11'))
------------------------------------------------PhysicalOlapScan[date_dim]
--------------------------PhysicalDistribute
----------------------------PhysicalProject
@@ -84,6 +84,6 @@ PhysicalResultSink
--------------------------------------------PhysicalOlapScan[date_dim]
------------------------------------------PhysicalDistribute
--------------------------------------------PhysicalProject
-----------------------------------------------filter(d_date IN (2001-06-06,
2001-09-02, 2001-11-11))
+----------------------------------------------filter(d_date IN ('2001-06-06',
'2001-09-02', '2001-11-11'))
------------------------------------------------PhysicalOlapScan[date_dim]
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query92.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query92.out
index b8e9891e4f1..5ae2cf3a124 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query92.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query92.out
@@ -22,6 +22,6 @@ PhysicalResultSink
----------------------------------PhysicalOlapScan[item]
--------------------------PhysicalDistribute
----------------------------PhysicalProject
-------------------------------filter((date_dim.d_date <= 2002-05-27) and
(date_dim.d_date >= 2002-02-26))
+------------------------------filter((date_dim.d_date <= '2002-05-27') and
(date_dim.d_date >= '2002-02-26'))
--------------------------------PhysicalOlapScan[date_dim]
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query94.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query94.out
index 48693b405c9..55ed7698184 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query94.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query94.out
@@ -29,7 +29,7 @@ PhysicalResultSink
------------------------------------PhysicalOlapScan[customer_address]
----------------------------PhysicalDistribute
------------------------------PhysicalProject
---------------------------------filter((date_dim.d_date <= 2000-04-01) and
(date_dim.d_date >= 2000-02-01))
+--------------------------------filter((date_dim.d_date <= '2000-04-01') and
(date_dim.d_date >= '2000-02-01'))
----------------------------------PhysicalOlapScan[date_dim]
--------------------------PhysicalDistribute
----------------------------PhysicalProject
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query95.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query95.out
index 8044a1c9604..863e429dd40 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query95.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query95.out
@@ -44,7 +44,7 @@ PhysicalCteAnchor ( cteId=CTEId#0 )
--------------------------------------PhysicalOlapScan[customer_address]
------------------------------PhysicalDistribute
--------------------------------PhysicalProject
-----------------------------------filter((date_dim.d_date <= 1999-04-02) and
(date_dim.d_date >= 1999-02-01))
+----------------------------------filter((date_dim.d_date <= '1999-04-02') and
(date_dim.d_date >= '1999-02-01'))
------------------------------------PhysicalOlapScan[date_dim]
----------------------------PhysicalDistribute
------------------------------PhysicalProject
diff --git
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query98.out
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query98.out
index ee9ef5c16e4..649950b8ec8 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query98.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query98.out
@@ -19,7 +19,7 @@ PhysicalResultSink
--------------------------------PhysicalOlapScan[store_sales]
------------------------------PhysicalDistribute
--------------------------------PhysicalProject
-----------------------------------filter((date_dim.d_date <= 2002-06-19) and
(date_dim.d_date >= 2002-05-20))
+----------------------------------filter((date_dim.d_date <= '2002-06-19') and
(date_dim.d_date >= '2002-05-20'))
------------------------------------PhysicalOlapScan[date_dim]
--------------------------PhysicalDistribute
----------------------------PhysicalProject
diff --git a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q1.out
b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q1.out
index 7740edd76cc..6d8f63d340c 100644
--- a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q1.out
+++ b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q1.out
@@ -8,6 +8,6 @@ PhysicalResultSink
----------PhysicalDistribute
------------hashAgg[LOCAL]
--------------PhysicalProject
-----------------filter((lineitem.l_shipdate <= 1998-09-02))
+----------------filter((lineitem.l_shipdate <= '1998-09-02'))
------------------PhysicalOlapScan[lineitem]
diff --git a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q10.out
b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q10.out
index 504b076849a..fd3241032ea 100644
--- a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q10.out
+++ b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q10.out
@@ -20,7 +20,7 @@ PhysicalResultSink
----------------------------PhysicalOlapScan[customer]
--------------------------PhysicalDistribute
----------------------------PhysicalProject
-------------------------------filter((orders.o_orderdate < 1994-01-01) and
(orders.o_orderdate >= 1993-10-01))
+------------------------------filter((orders.o_orderdate < '1994-01-01') and
(orders.o_orderdate >= '1993-10-01'))
--------------------------------PhysicalOlapScan[orders]
----------------------PhysicalDistribute
------------------------PhysicalProject
diff --git a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q12.out
b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q12.out
index 3f7f5677881..be65011c30b 100644
--- a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q12.out
+++ b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q12.out
@@ -12,6 +12,6 @@ PhysicalResultSink
------------------PhysicalProject
--------------------PhysicalOlapScan[orders]
------------------PhysicalProject
---------------------filter((lineitem.l_commitdate < lineitem.l_receiptdate)
and (lineitem.l_receiptdate < 1995-01-01) and (lineitem.l_receiptdate >=
1994-01-01) and (lineitem.l_shipdate < lineitem.l_commitdate) and l_shipmode IN
('MAIL', 'SHIP'))
+--------------------filter((lineitem.l_commitdate < lineitem.l_receiptdate)
and (lineitem.l_receiptdate < '1995-01-01') and (lineitem.l_receiptdate >=
'1994-01-01') and (lineitem.l_shipdate < lineitem.l_commitdate) and l_shipmode
IN ('MAIL', 'SHIP'))
----------------------PhysicalOlapScan[lineitem]
diff --git a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q14.out
b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q14.out
index 1760d9b6758..640f9267301 100644
--- a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q14.out
+++ b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q14.out
@@ -11,6 +11,6 @@ PhysicalResultSink
----------------PhysicalOlapScan[part]
--------------PhysicalDistribute
----------------PhysicalProject
-------------------filter((lineitem.l_shipdate < 1995-10-01) and
(lineitem.l_shipdate >= 1995-09-01))
+------------------filter((lineitem.l_shipdate < '1995-10-01') and
(lineitem.l_shipdate >= '1995-09-01'))
--------------------PhysicalOlapScan[lineitem]
diff --git a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q15.out
b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q15.out
index d8dd2f9de41..3cd7e267b21 100644
--- a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q15.out
+++ b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q15.out
@@ -15,7 +15,7 @@ PhysicalResultSink
--------------------PhysicalDistribute
----------------------hashAgg[LOCAL]
------------------------PhysicalProject
---------------------------filter((lineitem.l_shipdate < 1996-04-01) and
(lineitem.l_shipdate >= 1996-01-01))
+--------------------------filter((lineitem.l_shipdate < '1996-04-01') and
(lineitem.l_shipdate >= '1996-01-01'))
----------------------------PhysicalOlapScan[lineitem]
----------------PhysicalDistribute
------------------hashAgg[GLOBAL]
@@ -26,6 +26,6 @@ PhysicalResultSink
----------------------------PhysicalDistribute
------------------------------hashAgg[LOCAL]
--------------------------------PhysicalProject
-----------------------------------filter((lineitem.l_shipdate < 1996-04-01)
and (lineitem.l_shipdate >= 1996-01-01))
+----------------------------------filter((lineitem.l_shipdate < '1996-04-01')
and (lineitem.l_shipdate >= '1996-01-01'))
------------------------------------PhysicalOlapScan[lineitem]
diff --git
a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q20-rewrite.out
b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q20-rewrite.out
index 91e1da666d3..127efb417a1 100644
--- a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q20-rewrite.out
+++ b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q20-rewrite.out
@@ -14,7 +14,7 @@ PhysicalResultSink
----------------------PhysicalDistribute
------------------------hashAgg[LOCAL]
--------------------------PhysicalProject
-----------------------------filter((lineitem.l_shipdate < 1995-01-01) and
(lineitem.l_shipdate >= 1994-01-01))
+----------------------------filter((lineitem.l_shipdate < '1995-01-01') and
(lineitem.l_shipdate >= '1994-01-01'))
------------------------------PhysicalOlapScan[lineitem]
------------------PhysicalDistribute
--------------------hashJoin[LEFT_SEMI_JOIN]
hashCondition=((partsupp.ps_partkey = part.p_partkey))otherCondition=()
diff --git a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q20.out
b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q20.out
index 98434f09763..038762cfd7d 100644
--- a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q20.out
+++ b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q20.out
@@ -13,7 +13,7 @@ PhysicalResultSink
--------------------PhysicalDistribute
----------------------hashAgg[LOCAL]
------------------------PhysicalProject
---------------------------filter((lineitem.l_shipdate < 1995-01-01) and
(lineitem.l_shipdate >= 1994-01-01))
+--------------------------filter((lineitem.l_shipdate < '1995-01-01') and
(lineitem.l_shipdate >= '1994-01-01'))
----------------------------PhysicalOlapScan[lineitem]
------------------PhysicalDistribute
--------------------hashJoin[LEFT_SEMI_JOIN]
hashCondition=((partsupp.ps_partkey = part.p_partkey))otherCondition=()
diff --git a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q3.out
b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q3.out
index d4af45578fb..9de8eece12e 100644
--- a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q3.out
+++ b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q3.out
@@ -8,14 +8,14 @@ PhysicalResultSink
----------PhysicalProject
------------hashJoin[INNER_JOIN] hashCondition=((lineitem.l_orderkey =
orders.o_orderkey))otherCondition=()
--------------PhysicalProject
-----------------filter((lineitem.l_shipdate > 1995-03-15))
+----------------filter((lineitem.l_shipdate > '1995-03-15'))
------------------PhysicalOlapScan[lineitem]
--------------PhysicalDistribute
----------------PhysicalProject
------------------hashJoin[INNER_JOIN] hashCondition=((customer.c_custkey =
orders.o_custkey))otherCondition=()
--------------------PhysicalDistribute
----------------------PhysicalProject
-------------------------filter((orders.o_orderdate < 1995-03-15))
+------------------------filter((orders.o_orderdate < '1995-03-15'))
--------------------------PhysicalOlapScan[orders]
--------------------PhysicalDistribute
----------------------PhysicalProject
diff --git a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q4.out
b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q4.out
index 5155b3d85d3..9ed7b052c9a 100644
--- a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q4.out
+++ b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q4.out
@@ -13,6 +13,6 @@ PhysicalResultSink
--------------------filter((lineitem.l_commitdate < lineitem.l_receiptdate))
----------------------PhysicalOlapScan[lineitem]
------------------PhysicalProject
---------------------filter((orders.o_orderdate < 1993-10-01) and
(orders.o_orderdate >= 1993-07-01))
+--------------------filter((orders.o_orderdate < '1993-10-01') and
(orders.o_orderdate >= '1993-07-01'))
----------------------PhysicalOlapScan[orders]
diff --git a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q5.out
b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q5.out
index 0835f630e33..6a67fb0e890 100644
--- a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q5.out
+++ b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q5.out
@@ -30,7 +30,7 @@ PhysicalResultSink
----------------------------------------filter((region.r_name = 'ASIA'))
------------------------------------------PhysicalOlapScan[region]
------------------------PhysicalProject
---------------------------filter((orders.o_orderdate < 1995-01-01) and
(orders.o_orderdate >= 1994-01-01))
+--------------------------filter((orders.o_orderdate < '1995-01-01') and
(orders.o_orderdate >= '1994-01-01'))
----------------------------PhysicalOlapScan[orders]
------------------PhysicalDistribute
--------------------PhysicalProject
diff --git a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q6.out
b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q6.out
index 71385b8a5fd..7976f47c6b4 100644
--- a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q6.out
+++ b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q6.out
@@ -5,6 +5,6 @@ PhysicalResultSink
----PhysicalDistribute
------hashAgg[LOCAL]
--------PhysicalProject
-----------filter((lineitem.l_discount <= 0.07) and (lineitem.l_discount >=
0.05) and (lineitem.l_quantity < 24.00) and (lineitem.l_shipdate < 1995-01-01)
and (lineitem.l_shipdate >= 1994-01-01))
+----------filter((lineitem.l_discount <= 0.07) and (lineitem.l_discount >=
0.05) and (lineitem.l_quantity < 24.00) and (lineitem.l_shipdate <
'1995-01-01') and (lineitem.l_shipdate >= '1994-01-01'))
------------PhysicalOlapScan[lineitem]
diff --git a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q7.out
b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q7.out
index c1c28159100..3b3e31a9df4 100644
--- a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q7.out
+++ b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q7.out
@@ -19,7 +19,7 @@ PhysicalResultSink
------------------------PhysicalProject
--------------------------hashJoin[INNER_JOIN]
hashCondition=((supplier.s_suppkey = lineitem.l_suppkey))otherCondition=()
----------------------------PhysicalProject
-------------------------------filter((lineitem.l_shipdate <= 1996-12-31) and
(lineitem.l_shipdate >= 1995-01-01))
+------------------------------filter((lineitem.l_shipdate <= '1996-12-31') and
(lineitem.l_shipdate >= '1995-01-01'))
--------------------------------PhysicalOlapScan[lineitem]
----------------------------PhysicalDistribute
------------------------------hashJoin[INNER_JOIN]
hashCondition=((supplier.s_nationkey = n1.n_nationkey))otherCondition=()
diff --git a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q8.out
b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q8.out
index 5e96e7b598c..176d1b64a65 100644
--- a/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q8.out
+++ b/regression-test/data/nereids_tpch_shape_sf1000_p0/shape/q8.out
@@ -22,7 +22,7 @@ PhysicalResultSink
----------------------------------hashJoin[INNER_JOIN]
hashCondition=((orders.o_custkey = customer.c_custkey))otherCondition=()
------------------------------------PhysicalDistribute
--------------------------------------PhysicalProject
-----------------------------------------filter((orders.o_orderdate <=
1996-12-31) and (orders.o_orderdate >= 1995-01-01))
+----------------------------------------filter((orders.o_orderdate <=
'1996-12-31') and (orders.o_orderdate >= '1995-01-01'))
------------------------------------------PhysicalOlapScan[orders]
------------------------------------PhysicalDistribute
--------------------------------------hashJoin[INNER_JOIN]
hashCondition=((customer.c_nationkey = n1.n_nationkey))otherCondition=()
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
