This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 1958bd3bd32 branch-3.0: [test](nereids) add test case for continuous
filter or project in plan #40176 #54872 (#55142)
1958bd3bd32 is described below
commit 1958bd3bd32f95c7815052035bac23b5f54cbe7e
Author: yujun <[email protected]>
AuthorDate: Sun Aug 24 15:40:03 2025 +0800
branch-3.0: [test](nereids) add test case for continuous filter or project
in plan #40176 #54872 (#55142)
cherry pick from #54872
---
.../test_physical_translator.out | Bin 0 -> 823 bytes
.../test_physical_translator.groovy | 51 +++++++++++++++++++++
2 files changed, 51 insertions(+)
diff --git
a/regression-test/data/nereids_p0/physical_translator/test_physical_translator.out
b/regression-test/data/nereids_p0/physical_translator/test_physical_translator.out
new file mode 100644
index 00000000000..d5166d53ce7
Binary files /dev/null and
b/regression-test/data/nereids_p0/physical_translator/test_physical_translator.out
differ
diff --git
a/regression-test/suites/nereids_p0/physical_translator/test_physical_translator.groovy
b/regression-test/suites/nereids_p0/physical_translator/test_physical_translator.groovy
new file mode 100644
index 00000000000..3e5001a5ea3
--- /dev/null
+++
b/regression-test/suites/nereids_p0/physical_translator/test_physical_translator.groovy
@@ -0,0 +1,51 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("test_physical_translator") {
+ def tbl = "tbl_test_physical_translator"
+ sql 'SET enable_nereids_planner=true'
+ sql 'SET runtime_filter_mode=OFF'
+ sql 'SET enable_fallback_to_original_planner=false'
+ sql "SET ignore_shape_nodes='PhysicalDistribute'"
+ sql "SET detail_shape_nodes='PhysicalProject'"
+ sql 'SET disable_nereids_rules=PRUNE_EMPTY_PARTITION'
+ sql "drop table if exists ${tbl} force"
+ sql "create table ${tbl} (a int, b int) properties('replication_num' =
'1')"
+ sql "insert into ${tbl} values(1, 10), (200, 300)"
+
+ def sql1 = """
+ SELECT a, x as k1, x as k2 FROM (SELECT a, random(100) as x FROM
${tbl}) t
+ """
+
+ explainAndOrderResult "continue_project", sql1
+ explain {
+ sql sql1
+ contains "VSELECT"
+ }
+
+ def sql2 = """
+ select * from (select a + 2 as x from ${tbl} where b > 10 limit 100)s
where x > 5 and x < 10000
+ """
+
+ explainAndOrderResult "continue_filter", sql2
+ explain {
+ sql sql2
+ contains "VSELECT"
+ }
+
+ sql "drop table if exists ${tbl} force"
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
