This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 bb0f5efca8e [fix](nereids)fix unstable test_correlated_filter_removed
case (#48520)
bb0f5efca8e is described below
commit bb0f5efca8eee4446e155bcf212050f0ba20d45a
Author: starocean999 <li...@selectdb.com>
AuthorDate: Wed Mar 5 10:02:46 2025 +0800
[fix](nereids)fix unstable test_correlated_filter_removed case (#48520)
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg:
https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR
should merge into -->
---
.../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: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
