This is an automated email from the ASF dual-hosted git repository.

kxiao pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/branch-2.0 by this push:
     new a9dce3ee681 [fix](Nereids) fix some case error in nereids_syntax_p0 
(#25341)
a9dce3ee681 is described below

commit a9dce3ee681884d7f11d4b3236e45bcf9d6b2dd1
Author: 谢健 <jianx...@gmail.com>
AuthorDate: Fri Oct 13 15:17:45 2023 +0800

    [fix](Nereids) fix some case error in nereids_syntax_p0 (#25341)
---
 .../data/nereids_syntax_p0/push_filter_through_ptopn.out            | 6 +++---
 regression-test/suites/nereids_syntax_p0/advance_mv.groovy          | 4 ++--
 regression-test/suites/nereids_syntax_p0/function.groovy            | 2 +-
 3 files changed, 6 insertions(+), 6 deletions(-)

diff --git 
a/regression-test/data/nereids_syntax_p0/push_filter_through_ptopn.out 
b/regression-test/data/nereids_syntax_p0/push_filter_through_ptopn.out
index 05343ae859e..7f6d7959a6f 100644
--- a/regression-test/data/nereids_syntax_p0/push_filter_through_ptopn.out
+++ b/regression-test/data/nereids_syntax_p0/push_filter_through_ptopn.out
@@ -32,7 +32,7 @@ PhysicalResultSink
 -- !3 --
 PhysicalResultSink
 --PhysicalDistribute
-----filter((T.b = 2) and (rn <= 2))
+----filter((rn <= 2)(T.b = 2))
 ------PhysicalWindow
 --------PhysicalQuickSort
 ----------PhysicalPartitionTopN
@@ -42,9 +42,9 @@ PhysicalResultSink
 PhysicalResultSink
 --PhysicalDistribute
 ----PhysicalProject
-------filter((T.b = 2) and (rn <= 2))
+------filter((rn <= 2)(T.b = 2))
 --------PhysicalWindow
-----------PhysicalPartitionTopN
+----------PhysicalQuickSort
 ------------PhysicalDistribute
 --------------PhysicalPartitionTopN
 ----------------PhysicalProject
diff --git a/regression-test/suites/nereids_syntax_p0/advance_mv.groovy 
b/regression-test/suites/nereids_syntax_p0/advance_mv.groovy
index b3aa733c38c..17ee0e0d041 100644
--- a/regression-test/suites/nereids_syntax_p0/advance_mv.groovy
+++ b/regression-test/suites/nereids_syntax_p0/advance_mv.groovy
@@ -99,10 +99,10 @@ suite("advance_mv") {
     createMV("CREATE materialized VIEW mv2 AS SELECT abs(k1)+k2+1 tmp, 
sum(abs(k2+2)+k3+3) FROM ${tbName2} GROUP BY tmp;")
 
     explain {
-        sql("SELECT abs(k1)+k2+1 tmp, sum(abs(k2+2)+k3+3) from FROM ${tbName2} 
GROUP BY tmp;")
+        sql("SELECT abs(k1)+k2+1 tmp, sum(abs(k2+2)+k3+3) FROM ${tbName2} 
GROUP BY tmp;")
         contains "(mv2)"
     }
-    order_qt_select_star "SELECT abs(k1)+k2+1 tmp, sum(abs(k2+2)+k3+3) from 
FROM ${tbName2} GROUP BY tmp;"
+    order_qt_select_star "SELECT abs(k1)+k2+1 tmp, sum(abs(k2+2)+k3+3) FROM 
${tbName2} GROUP BY tmp;"
 
     sql "CREATE materialized VIEW mv3 AS SELECT abs(k1)+k2+1 tmp, 
abs(k2+2)+k3+3 FROM ${tbName2};"
     int max_try_secs2 = 60
diff --git a/regression-test/suites/nereids_syntax_p0/function.groovy 
b/regression-test/suites/nereids_syntax_p0/function.groovy
index 498273bad91..1efa58160ab 100644
--- a/regression-test/suites/nereids_syntax_p0/function.groovy
+++ b/regression-test/suites/nereids_syntax_p0/function.groovy
@@ -121,7 +121,7 @@ suite("nereids_function") {
     }
 
     test {
-        sql """select "1" == "123", "%%" == "%%" """
+        sql """select "1" = "123", "%%" = "%%" """
         result([[false, true]])
     }
     


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to