This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.1 by this push:
new 3f7308baa56 [fix](regression) regression case: limit_push_down is
unstable (Branch-2.1) (#47895)
3f7308baa56 is described below
commit 3f7308baa562347a517d987bbf8d50aa845b29f0
Author: minghong <zhoumingh...@selectdb.com>
AuthorDate: Fri Feb 14 21:51:23 2025 +0800
[fix](regression) regression case: limit_push_down is unstable (Branch-2.1)
(#47895)
---
.../limit_push_down/limit_push_down.out | Bin 21141 -> 20873 bytes
.../limit_push_down/limit_push_down.groovy | 5 ++---
2 files changed, 2 insertions(+), 3 deletions(-)
diff --git
a/regression-test/data/nereids_rules_p0/limit_push_down/limit_push_down.out
b/regression-test/data/nereids_rules_p0/limit_push_down/limit_push_down.out
index 54b8a7a6b6c..049c62e39e9 100644
Binary files
a/regression-test/data/nereids_rules_p0/limit_push_down/limit_push_down.out and
b/regression-test/data/nereids_rules_p0/limit_push_down/limit_push_down.out
differ
diff --git
a/regression-test/suites/nereids_rules_p0/limit_push_down/limit_push_down.groovy
b/regression-test/suites/nereids_rules_p0/limit_push_down/limit_push_down.groovy
index 3aec22fa928..b7704ce691d 100644
---
a/regression-test/suites/nereids_rules_p0/limit_push_down/limit_push_down.groovy
+++
b/regression-test/suites/nereids_rules_p0/limit_push_down/limit_push_down.groovy
@@ -60,9 +60,8 @@ suite("limit_push_down") {
//`limit 1, agg & scalar agg join:
qt_limit_distinct """ explain shape plan SELECT distinct t1.id FROM t1
cross join t2 LIMIT 1; """
//`limit 1, agg & scalar agg left outer join:
- qt_limit_distinct """ explain shape plan SELECT distinct t1.id FROM t1
left outer join t2 on t1.id = t2.id LIMIT 1; """
- //`limit 1, agg & scalar agg right outer join:
- qt_limit_distinct """ explain shape plan SELECT distinct t1.id FROM t1
left outer join t2 on t1.id = t2.id LIMIT 1; """
+ qt_limit_distinct """ explain shape plan SELECT distinct t1.id FROM t1
left outer join[broadcast] t2 on t1.id = t2.id LIMIT 1; """
+
//`limit 1 offset 1, agg & scalar agg`:
qt_limit_offset_agg """ explain shape plan SELECT distinct t1.id c FROM t1
ORDER BY c LIMIT 1 OFFSET 1; """
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
