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 10595e5b46b branch-3.0: [fix](nereids)fix unstable
test_correlated_filter_removed case #48520 (#48659)
10595e5b46b is described below
commit 10595e5b46b91cf7808210d39ee5f777adede8dd
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon Mar 10 12:21:25 2025 +0800
branch-3.0: [fix](nereids)fix unstable test_correlated_filter_removed case
#48520 (#48659)
Cherry-picked from #48520
Co-authored-by: starocean999 <[email protected]>
---
.../subquery/test_correlated_filter_removed.groovy | 16 ++++++++--------
1 file changed, 8 insertions(+), 8 deletions(-)
diff --git
a/regression-test/suites/nereids_p0/subquery/test_correlated_filter_removed.groovy
b/regression-test/suites/nereids_p0/subquery/test_correlated_filter_removed.groovy
index 2a3b5124048..0d3fff194a2 100644
---
a/regression-test/suites/nereids_p0/subquery/test_correlated_filter_removed.groovy
+++
b/regression-test/suites/nereids_p0/subquery/test_correlated_filter_removed.groovy
@@ -17,9 +17,9 @@
suite("test_correlated_filter_removed") {
multi_sql """
- drop table if exists
table_6_undef_partitions2_keys3_properties4_distributed_by5;
+ drop table if exists table_6_test_correlated_filter_removed;
- create table
table_6_undef_partitions2_keys3_properties4_distributed_by5 (
+ create table table_6_test_correlated_filter_removed (
col_int_undef_signed int/*agg_type_placeholder*/ ,
col_varchar_10__undef_signed varchar(10)/*agg_type_placeholder*/ ,
pk int/*agg_type_placeholder*/
@@ -27,11 +27,11 @@ suite("test_correlated_filter_removed") {
distributed by hash(pk) buckets 10
properties("replication_num" = "1");
- insert into
table_6_undef_partitions2_keys3_properties4_distributed_by5(pk,col_int_undef_signed,col_varchar_10__undef_signed)
values
(0,null,'think'),(1,null,''),(2,2,''),(3,null,'r'),(4,null,null),(5,8,'here');
+ insert into
table_6_test_correlated_filter_removed(pk,col_int_undef_signed,col_varchar_10__undef_signed)
values
(0,null,'think'),(1,null,''),(2,2,''),(3,null,'r'),(4,null,null),(5,8,'here');
- drop table if exists
table_100_undef_partitions2_keys3_properties4_distributed_by5;
+ drop table if exists table_100_test_correlated_filter_removed;
- create table
table_100_undef_partitions2_keys3_properties4_distributed_by5 (
+ create table table_100_test_correlated_filter_removed (
col_int_undef_signed int/*agg_type_placeholder*/ ,
col_varchar_10__undef_signed varchar(10)/*agg_type_placeholder*/ ,
pk int/*agg_type_placeholder*/
@@ -39,15 +39,15 @@ suite("test_correlated_filter_removed") {
distributed by hash(pk) buckets 10
properties("replication_num" = "1");
- insert into
table_100_undef_partitions2_keys3_properties4_distributed_by5(pk,col_int_undef_signed,col_varchar_10__undef_signed)
values
(0,null,''),(1,null,''),(2,null,''),(3,0,null),(4,7,null),(5,9,'d'),(6,9,null),(7,null,null),(8,null,null),(9,null,''),(10,null,'are'),(11,null,'were'),(12,2,''),(13,null,'one'),(14,null,'ok'),(15,null,'your'),(16,null,''),(17,null,null),(18,4,''),(19,null,null),(20,null,null),(21,null,null),(22,3,''),(23,null,null),(24,8,''),(25,2,'I''m'),(26,nul
[...]
+ insert into
table_100_test_correlated_filter_removed(pk,col_int_undef_signed,col_varchar_10__undef_signed)
values
(0,null,''),(1,null,''),(2,null,''),(3,0,null),(4,7,null),(5,9,'d'),(6,9,null),(7,null,null),(8,null,null),(9,null,''),(10,null,'are'),(11,null,'were'),(12,2,''),(13,null,'one'),(14,null,'ok'),(15,null,'your'),(16,null,''),(17,null,null),(18,4,''),(19,null,null),(20,null,null),(21,null,null),(22,3,''),(23,null,null),(24,8,''),(25,2,'I''m'),(26,null,'e'),(27,3,'will'),
[...]
"""
sql """
SELECT *
- FROM table_6_undef_partitions2_keys3_properties4_distributed_by5 AS t1
+ FROM table_6_test_correlated_filter_removed AS t1
WHERE t1.`pk` + 2 IN
(SELECT 1
- FROM table_100_undef_partitions2_keys3_properties4_distributed_by5
AS t2
+ FROM table_100_test_correlated_filter_removed AS t2
WHERE t1.col_int_undef_signed is NULL
AND t1.col_int_undef_signed is NOT NULL) ;
"""
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
