This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-4.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-4.1 by this push:
new 52679ed239a [fix](regression) Add aliases in agg_sync_mv (#65336)
52679ed239a is described below
commit 52679ed239a12df010974a7cd36b03f5b103adb5
Author: shuke <[email protected]>
AuthorDate: Fri Jul 10 09:38:32 2026 +0800
[fix](regression) Add aliases in agg_sync_mv (#65336)
## Summary
Fix branch-4.1 P1 `nereids_syntax_p1/mv/aggregate/agg_sync_mv.groovy` by
adding explicit output aliases for stddev/variance family MV aggregate
expressions.
The failing TeamCity occurrence hit:
```text
Duplicate column name '__stddev_1'
```
when creating `mv_sync41` for `stddev_pop(kint)`. The suite creates
related sync MVs on the same table, so relying on generated aggregate
column names is brittle. This patch follows the existing sibling-case
style and makes the MV output names explicit.
## Testing
- [x] `git diff --check`
- [ ] Not run locally; no branch-4.1 regression cluster attached in this
session
---
.../suites/nereids_syntax_p1/mv/aggregate/agg_sync_mv.groovy | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)
diff --git
a/regression-test/suites/nereids_syntax_p1/mv/aggregate/agg_sync_mv.groovy
b/regression-test/suites/nereids_syntax_p1/mv/aggregate/agg_sync_mv.groovy
index 4b71d29ca53..bb359f1448f 100644
--- a/regression-test/suites/nereids_syntax_p1/mv/aggregate/agg_sync_mv.groovy
+++ b/regression-test/suites/nereids_syntax_p1/mv/aggregate/agg_sync_mv.groovy
@@ -381,7 +381,7 @@ suite("agg_sync_mv") {
qt_select_stddev """select id, stddev(kint) from agg_mv_test group by id
order by id;"""
sql """drop materialized view if exists mv_sync40 on agg_mv_test;"""
- createMV("""create materialized view mv_sync40 as select id as g2,
stddev(kint) from agg_mv_test group by id order by id;""")
+ createMV("""create materialized view mv_sync40 as select id as g2,
stddev(kint) as g2_stddev from agg_mv_test group by id order by id;""")
mv_rewrite_success("select id, stddev(kint) from agg_mv_test group by id
order by id;", "mv_sync40")
qt_select_stddev_mv """select id, stddev(kint) from agg_mv_test group by
id order by id;"""
@@ -393,7 +393,7 @@ suite("agg_sync_mv") {
qt_select_stddev_samp """select id, stddev_samp(kint) from agg_mv_test
group by id order by id;"""
sql """drop materialized view if exists mv_sync42 on agg_mv_test;"""
- createMV("""create materialized view mv_sync42 as select id as g4,
stddev_samp(kint) from agg_mv_test group by id order by id;""")
+ createMV("""create materialized view mv_sync42 as select id as g4,
stddev_samp(kint) as g4_stddev_samp from agg_mv_test group by id order by
id;""")
mv_rewrite_success("select id, stddev_samp(kint) from agg_mv_test group by
id order by id;", "mv_sync42")
qt_select_stddev_samp_mv """select id, stddev_samp(kint) from agg_mv_test
group by id order by id;"""
@@ -423,7 +423,7 @@ suite("agg_sync_mv") {
qt_select_variance """select id, variance(kint) from agg_mv_test group by
id order by id;"""
sql """drop materialized view if exists mv_sync47 on agg_mv_test;"""
- createMV("""create materialized view mv_sync47 as select id as s3,
variance(kint) from agg_mv_test group by id order by id;""")
+ createMV("""create materialized view mv_sync47 as select id as s3,
variance(kint) as s3_variance from agg_mv_test group by id order by id;""")
mv_rewrite_any_success("select id, variance(kint) from agg_mv_test group
by id order by id;", ["mv_sync47", "mv_sync48"])
qt_select_variance_mv """select id, variance(kint) from agg_mv_test group
by id order by id;"""
@@ -435,7 +435,7 @@ suite("agg_sync_mv") {
qt_select_variance_samp """select id, variance_samp(kint) from agg_mv_test
group by id order by id;"""
sql """drop materialized view if exists mv_sync49 on agg_mv_test;"""
- createMV("""create materialized view mv_sync49 as select id as s5,
variance_samp(kint) from agg_mv_test group by id order by id;""")
+ createMV("""create materialized view mv_sync49 as select id as s5,
variance_samp(kint) as s5_variance_samp from agg_mv_test group by id order by
id;""")
mv_rewrite_success("select id, variance_samp(kint) from agg_mv_test group
by id order by id;", "mv_sync49")
qt_select_variance_samp_mv """select id, variance_samp(kint) from
agg_mv_test group by id order by id;"""
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
