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

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


The following commit(s) were added to refs/heads/branch-3.0 by this push:
     new 90ddbb4643b [fix](test) fix regression (#42469)
90ddbb4643b is described below

commit 90ddbb4643bdb394dc96c67a8947e636de05b0a1
Author: feiniaofeiafei <53502832+feiniaofeia...@users.noreply.github.com>
AuthorDate: Fri Oct 25 16:01:25 2024 +0800

    [fix](test) fix regression (#42469)
    
    fix regression test
---
 regression-test/data/nereids_hint_tpcds_p0/shape/query41.out          | 2 +-
 .../data/nereids_rules_p0/infer_predicate/infer_intersect_except.out  | 4 ++--
 regression-test/data/nereids_tpcds_shape_sf1000_p0/shape/query41.out  | 2 +-
 .../data/nereids_tpcds_shape_sf100_p0/noStatsRfPrune/query41.out      | 2 +-
 .../data/nereids_tpcds_shape_sf100_p0/no_stats_shape/query41.out      | 2 +-
 .../data/nereids_tpcds_shape_sf100_p0/rf_prune/query41.out            | 2 +-
 regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query41.out   | 2 +-
 regression-test/data/nereids_tpcds_shape_sf10t_orc/shape/query41.out  | 2 +-
 .../data/new_shapes_p0/tpcds_sf100/noStatsRfPrune/query41.out         | 2 +-
 .../data/new_shapes_p0/tpcds_sf100/no_stats_shape/query41.out         | 2 +-
 regression-test/data/new_shapes_p0/tpcds_sf100/rf_prune/query41.out   | 2 +-
 regression-test/data/new_shapes_p0/tpcds_sf100/shape/query41.out      | 2 +-
 regression-test/data/new_shapes_p0/tpcds_sf1000/shape/query41.out     | 2 +-
 13 files changed, 14 insertions(+), 14 deletions(-)

diff --git a/regression-test/data/nereids_hint_tpcds_p0/shape/query41.out 
b/regression-test/data/nereids_hint_tpcds_p0/shape/query41.out
index 2dd4aadeae2..c27e19cc9f2 100644
--- a/regression-test/data/nereids_hint_tpcds_p0/shape/query41.out
+++ b/regression-test/data/nereids_hint_tpcds_p0/shape/query41.out
@@ -13,7 +13,7 @@ PhysicalResultSink
 --------------------filter((i1.i_manufact_id <= 744) and (i1.i_manufact_id >= 
704))
 ----------------------PhysicalOlapScan[item] apply RFs: RF0
 ------------------PhysicalProject
---------------------filter((ifnull(item_cnt, 0) > 0))
+--------------------filter((item_cnt > 0))
 ----------------------hashAgg[GLOBAL]
 ------------------------PhysicalDistribute[DistributionSpecHash]
 --------------------------hashAgg[LOCAL]
diff --git 
a/regression-test/data/nereids_rules_p0/infer_predicate/infer_intersect_except.out
 
b/regression-test/data/nereids_rules_p0/infer_predicate/infer_intersect_except.out
index 783f83efe61..2609ca5f4c9 100644
--- 
a/regression-test/data/nereids_rules_p0/infer_predicate/infer_intersect_except.out
+++ 
b/regression-test/data/nereids_rules_p0/infer_predicate/infer_intersect_except.out
@@ -58,10 +58,10 @@ PhysicalResultSink
 ----filter((infer_intersect_except1.a > 0))
 ------PhysicalOlapScan[infer_intersect_except1]
 ----PhysicalIntersect
-------filter((infer_intersect_except3.a = 1) and (infer_intersect_except3.b = 
'abc'))
---------PhysicalOlapScan[infer_intersect_except3]
 ------filter((infer_intersect_except2.b > 'ab'))
 --------PhysicalOlapScan[infer_intersect_except2]
+------filter((infer_intersect_except3.a = 1) and (infer_intersect_except3.b = 
'abc'))
+--------PhysicalOlapScan[infer_intersect_except3]
 
 -- !except_and_intersect_except_predicate_to_right --
 PhysicalResultSink
diff --git 
a/regression-test/data/nereids_tpcds_shape_sf1000_p0/shape/query41.out 
b/regression-test/data/nereids_tpcds_shape_sf1000_p0/shape/query41.out
index 2dd4aadeae2..c27e19cc9f2 100644
--- a/regression-test/data/nereids_tpcds_shape_sf1000_p0/shape/query41.out
+++ b/regression-test/data/nereids_tpcds_shape_sf1000_p0/shape/query41.out
@@ -13,7 +13,7 @@ PhysicalResultSink
 --------------------filter((i1.i_manufact_id <= 744) and (i1.i_manufact_id >= 
704))
 ----------------------PhysicalOlapScan[item] apply RFs: RF0
 ------------------PhysicalProject
---------------------filter((ifnull(item_cnt, 0) > 0))
+--------------------filter((item_cnt > 0))
 ----------------------hashAgg[GLOBAL]
 ------------------------PhysicalDistribute[DistributionSpecHash]
 --------------------------hashAgg[LOCAL]
diff --git 
a/regression-test/data/nereids_tpcds_shape_sf100_p0/noStatsRfPrune/query41.out 
b/regression-test/data/nereids_tpcds_shape_sf100_p0/noStatsRfPrune/query41.out
index d20341c931a..34081b60b90 100644
--- 
a/regression-test/data/nereids_tpcds_shape_sf100_p0/noStatsRfPrune/query41.out
+++ 
b/regression-test/data/nereids_tpcds_shape_sf100_p0/noStatsRfPrune/query41.out
@@ -13,7 +13,7 @@ PhysicalResultSink
 --------------------filter((i1.i_manufact_id <= 788) and (i1.i_manufact_id >= 
748))
 ----------------------PhysicalOlapScan[item] apply RFs: RF0
 ------------------PhysicalProject
---------------------filter((ifnull(item_cnt, 0) > 0))
+--------------------filter((item_cnt > 0))
 ----------------------hashAgg[GLOBAL]
 ------------------------PhysicalDistribute[DistributionSpecHash]
 --------------------------hashAgg[LOCAL]
diff --git 
a/regression-test/data/nereids_tpcds_shape_sf100_p0/no_stats_shape/query41.out 
b/regression-test/data/nereids_tpcds_shape_sf100_p0/no_stats_shape/query41.out
index d20341c931a..34081b60b90 100644
--- 
a/regression-test/data/nereids_tpcds_shape_sf100_p0/no_stats_shape/query41.out
+++ 
b/regression-test/data/nereids_tpcds_shape_sf100_p0/no_stats_shape/query41.out
@@ -13,7 +13,7 @@ PhysicalResultSink
 --------------------filter((i1.i_manufact_id <= 788) and (i1.i_manufact_id >= 
748))
 ----------------------PhysicalOlapScan[item] apply RFs: RF0
 ------------------PhysicalProject
---------------------filter((ifnull(item_cnt, 0) > 0))
+--------------------filter((item_cnt > 0))
 ----------------------hashAgg[GLOBAL]
 ------------------------PhysicalDistribute[DistributionSpecHash]
 --------------------------hashAgg[LOCAL]
diff --git 
a/regression-test/data/nereids_tpcds_shape_sf100_p0/rf_prune/query41.out 
b/regression-test/data/nereids_tpcds_shape_sf100_p0/rf_prune/query41.out
index d20341c931a..34081b60b90 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/rf_prune/query41.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/rf_prune/query41.out
@@ -13,7 +13,7 @@ PhysicalResultSink
 --------------------filter((i1.i_manufact_id <= 788) and (i1.i_manufact_id >= 
748))
 ----------------------PhysicalOlapScan[item] apply RFs: RF0
 ------------------PhysicalProject
---------------------filter((ifnull(item_cnt, 0) > 0))
+--------------------filter((item_cnt > 0))
 ----------------------hashAgg[GLOBAL]
 ------------------------PhysicalDistribute[DistributionSpecHash]
 --------------------------hashAgg[LOCAL]
diff --git 
a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query41.out 
b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query41.out
index d20341c931a..34081b60b90 100644
--- a/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query41.out
+++ b/regression-test/data/nereids_tpcds_shape_sf100_p0/shape/query41.out
@@ -13,7 +13,7 @@ PhysicalResultSink
 --------------------filter((i1.i_manufact_id <= 788) and (i1.i_manufact_id >= 
748))
 ----------------------PhysicalOlapScan[item] apply RFs: RF0
 ------------------PhysicalProject
---------------------filter((ifnull(item_cnt, 0) > 0))
+--------------------filter((item_cnt > 0))
 ----------------------hashAgg[GLOBAL]
 ------------------------PhysicalDistribute[DistributionSpecHash]
 --------------------------hashAgg[LOCAL]
diff --git 
a/regression-test/data/nereids_tpcds_shape_sf10t_orc/shape/query41.out 
b/regression-test/data/nereids_tpcds_shape_sf10t_orc/shape/query41.out
index fcabc86784c..ff9f83b15cc 100644
--- a/regression-test/data/nereids_tpcds_shape_sf10t_orc/shape/query41.out
+++ b/regression-test/data/nereids_tpcds_shape_sf10t_orc/shape/query41.out
@@ -13,7 +13,7 @@ PhysicalResultSink
 --------------------filter((i1.i_manufact_id <= 1010) and (i1.i_manufact_id >= 
970))
 ----------------------PhysicalOlapScan[item] apply RFs: RF0
 ------------------PhysicalProject
---------------------filter((ifnull(item_cnt, 0) > 0))
+--------------------filter((item_cnt > 0))
 ----------------------hashAgg[GLOBAL]
 ------------------------PhysicalDistribute[DistributionSpecHash]
 --------------------------hashAgg[LOCAL]
diff --git 
a/regression-test/data/new_shapes_p0/tpcds_sf100/noStatsRfPrune/query41.out 
b/regression-test/data/new_shapes_p0/tpcds_sf100/noStatsRfPrune/query41.out
index d20341c931a..34081b60b90 100644
--- a/regression-test/data/new_shapes_p0/tpcds_sf100/noStatsRfPrune/query41.out
+++ b/regression-test/data/new_shapes_p0/tpcds_sf100/noStatsRfPrune/query41.out
@@ -13,7 +13,7 @@ PhysicalResultSink
 --------------------filter((i1.i_manufact_id <= 788) and (i1.i_manufact_id >= 
748))
 ----------------------PhysicalOlapScan[item] apply RFs: RF0
 ------------------PhysicalProject
---------------------filter((ifnull(item_cnt, 0) > 0))
+--------------------filter((item_cnt > 0))
 ----------------------hashAgg[GLOBAL]
 ------------------------PhysicalDistribute[DistributionSpecHash]
 --------------------------hashAgg[LOCAL]
diff --git 
a/regression-test/data/new_shapes_p0/tpcds_sf100/no_stats_shape/query41.out 
b/regression-test/data/new_shapes_p0/tpcds_sf100/no_stats_shape/query41.out
index d20341c931a..34081b60b90 100644
--- a/regression-test/data/new_shapes_p0/tpcds_sf100/no_stats_shape/query41.out
+++ b/regression-test/data/new_shapes_p0/tpcds_sf100/no_stats_shape/query41.out
@@ -13,7 +13,7 @@ PhysicalResultSink
 --------------------filter((i1.i_manufact_id <= 788) and (i1.i_manufact_id >= 
748))
 ----------------------PhysicalOlapScan[item] apply RFs: RF0
 ------------------PhysicalProject
---------------------filter((ifnull(item_cnt, 0) > 0))
+--------------------filter((item_cnt > 0))
 ----------------------hashAgg[GLOBAL]
 ------------------------PhysicalDistribute[DistributionSpecHash]
 --------------------------hashAgg[LOCAL]
diff --git 
a/regression-test/data/new_shapes_p0/tpcds_sf100/rf_prune/query41.out 
b/regression-test/data/new_shapes_p0/tpcds_sf100/rf_prune/query41.out
index d20341c931a..34081b60b90 100644
--- a/regression-test/data/new_shapes_p0/tpcds_sf100/rf_prune/query41.out
+++ b/regression-test/data/new_shapes_p0/tpcds_sf100/rf_prune/query41.out
@@ -13,7 +13,7 @@ PhysicalResultSink
 --------------------filter((i1.i_manufact_id <= 788) and (i1.i_manufact_id >= 
748))
 ----------------------PhysicalOlapScan[item] apply RFs: RF0
 ------------------PhysicalProject
---------------------filter((ifnull(item_cnt, 0) > 0))
+--------------------filter((item_cnt > 0))
 ----------------------hashAgg[GLOBAL]
 ------------------------PhysicalDistribute[DistributionSpecHash]
 --------------------------hashAgg[LOCAL]
diff --git a/regression-test/data/new_shapes_p0/tpcds_sf100/shape/query41.out 
b/regression-test/data/new_shapes_p0/tpcds_sf100/shape/query41.out
index d20341c931a..34081b60b90 100644
--- a/regression-test/data/new_shapes_p0/tpcds_sf100/shape/query41.out
+++ b/regression-test/data/new_shapes_p0/tpcds_sf100/shape/query41.out
@@ -13,7 +13,7 @@ PhysicalResultSink
 --------------------filter((i1.i_manufact_id <= 788) and (i1.i_manufact_id >= 
748))
 ----------------------PhysicalOlapScan[item] apply RFs: RF0
 ------------------PhysicalProject
---------------------filter((ifnull(item_cnt, 0) > 0))
+--------------------filter((item_cnt > 0))
 ----------------------hashAgg[GLOBAL]
 ------------------------PhysicalDistribute[DistributionSpecHash]
 --------------------------hashAgg[LOCAL]
diff --git a/regression-test/data/new_shapes_p0/tpcds_sf1000/shape/query41.out 
b/regression-test/data/new_shapes_p0/tpcds_sf1000/shape/query41.out
index 2dd4aadeae2..c27e19cc9f2 100644
--- a/regression-test/data/new_shapes_p0/tpcds_sf1000/shape/query41.out
+++ b/regression-test/data/new_shapes_p0/tpcds_sf1000/shape/query41.out
@@ -13,7 +13,7 @@ PhysicalResultSink
 --------------------filter((i1.i_manufact_id <= 744) and (i1.i_manufact_id >= 
704))
 ----------------------PhysicalOlapScan[item] apply RFs: RF0
 ------------------PhysicalProject
---------------------filter((ifnull(item_cnt, 0) > 0))
+--------------------filter((item_cnt > 0))
 ----------------------hashAgg[GLOBAL]
 ------------------------PhysicalDistribute[DistributionSpecHash]
 --------------------------hashAgg[LOCAL]


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

Reply via email to