This is an automated email from the ASF dual-hosted git repository.
morrysnow 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 ec0d2ce3345 [fix](test) Fix ttl partition compensate mv not be chosen
stable by cbo (#53330)
ec0d2ce3345 is described below
commit ec0d2ce3345d82e9f67447a1abf3dd95d5befab0
Author: seawinde <[email protected]>
AuthorDate: Thu Jul 17 19:27:25 2025 +0800
[fix](test) Fix ttl partition compensate mv not be chosen stable by cbo
(#53330)
---
.../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 8086152cf30..689c9dd8912 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]
