This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch branch-3.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.1 by this push:
new 00ae56b6854 branch-3.1: [fix](test) Fix ttl partition compensate mv
not be chosen stable by cbo #53330 (#53471)
00ae56b6854 is described below
commit 00ae56b68541326d64c3022abf81fce41cc01b83
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Sat Jul 19 09:34:40 2025 +0800
branch-3.1: [fix](test) Fix ttl partition compensate mv not be chosen
stable by cbo #53330 (#53471)
Cherry-picked from #53330
Co-authored-by: seawinde <[email protected]>
---
.../unioin_rewrite_grace_big.out | Bin 3997 -> 4063 bytes
.../unioin_rewrite_grace_big.groovy | 13 +++++++++----
2 files changed, 9 insertions(+), 4 deletions(-)
diff --git
a/regression-test/data/nereids_rules_p0/mv/union_rewrite_grace_big/unioin_rewrite_grace_big.out
b/regression-test/data/nereids_rules_p0/mv/union_rewrite_grace_big/unioin_rewrite_grace_big.out
index 1e718b4e612..489e7d4706b 100644
Binary files
a/regression-test/data/nereids_rules_p0/mv/union_rewrite_grace_big/unioin_rewrite_grace_big.out
and
b/regression-test/data/nereids_rules_p0/mv/union_rewrite_grace_big/unioin_rewrite_grace_big.out
differ
diff --git
a/regression-test/suites/nereids_rules_p0/mv/union_rewrite_grace_big/unioin_rewrite_grace_big.groovy
b/regression-test/suites/nereids_rules_p0/mv/union_rewrite_grace_big/unioin_rewrite_grace_big.groovy
index 55394292d0b..5f6c7fcf62f 100644
---
a/regression-test/suites/nereids_rules_p0/mv/union_rewrite_grace_big/unioin_rewrite_grace_big.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/union_rewrite_grace_big/unioin_rewrite_grace_big.groovy
@@ -323,7 +323,12 @@ suite("union_rewrite_grace_big") {
"""
sql """
insert into lineitem_static values
- (1, 2, 3, 4, 5.5, 6.5, 7.5, 8.5, 'o', 'k', '${today_str}', '${today_str}',
'${today_str}', 'a', 'b', 'yyyyyyyyy');
+ (1, 2, 3, 4, 5.5, 6.5, 7.5, 8.5, 'o', 'k', '${today_str}', '${today_str}',
'${today_str}', 'a', 'b', 'yyyyyyyyy'),
+ (1, 2, 3, 4, 5.5, 6.5, 7.5, 8.5, 'o', 'k', '${today_str}', '${today_str}',
'${today_str}', 'a', 'b', 'yyyyyyyyy'),
+ (2, 2, 3, 4, 5.5, 6.5, 7.5, 8.5, 'o', 'k', '${today_str}', '${today_str}',
'${today_str}', 'a', 'b', 'yyyyyyyyy'),
+ (2, 2, 3, 4, 5.5, 6.5, 7.5, 8.5, 'o', 'k', '${today_str}', '${today_str}',
'${today_str}', 'a', 'b', 'yyyyyyyyy'),
+ (3, 2, 3, 4, 5.5, 6.5, 7.5, 8.5, 'o', 'k', '${today_str}', '${today_str}',
'${today_str}', 'a', 'b', 'yyyyyyyyy'),
+ (4, 2, 3, 4, 5.5, 6.5, 7.5, 8.5, 'o', 'k', '${today_str}', '${today_str}',
'${today_str}', 'a', 'b', 'yyyyyyyyy');
"""
multi_sql """
@@ -336,7 +341,7 @@ suite("union_rewrite_grace_big") {
select l_shipdate, o_orderdate, l_partkey,
l_suppkey, sum(o_totalprice) as sum_total
from lineitem_static
- left join orders on l_orderkey = o_orderkey and l_shipdate = o_orderdate
+ left join orders on l_orderkey = o_orderkey
group by
l_shipdate,
o_orderdate,
@@ -346,7 +351,7 @@ suite("union_rewrite_grace_big") {
def query_ttl_all_partition_sql = """
select l_shipdate, o_orderdate, l_partkey, l_suppkey, sum(o_totalprice) as
sum_total
from lineitem_static
- left join orders on l_orderkey = o_orderkey and l_shipdate = o_orderdate
+ left join orders on l_orderkey = o_orderkey
group by
l_shipdate,
o_orderdate,
@@ -356,7 +361,7 @@ suite("union_rewrite_grace_big") {
def query_ttl_partition_sql = """
select l_shipdate, o_orderdate, l_partkey, l_suppkey, sum(o_totalprice) as
sum_total
from lineitem_static
- left join orders on l_orderkey = o_orderkey and l_shipdate = o_orderdate
+ left join orders on l_orderkey = o_orderkey
where (l_shipdate>= '2023-10-18' and l_shipdate <= '2023-10-19')
group by
l_shipdate,
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
