This is an automated email from the ASF dual-hosted git repository.
hellostephen 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 e85f8393039 [fix](case) Fix `different_serialize_cloud` case (#59555)
e85f8393039 is described below
commit e85f83930399f431a3976e987800a5ba97a135fa
Author: deardeng <[email protected]>
AuthorDate: Tue Jan 6 14:11:21 2026 +0800
[fix](case) Fix `different_serialize_cloud` case (#59555)
### What problem does this PR solve?
Fix
```
createMV("create materialized view mv1_1 as select
k1,bitmap_intersect(to_bitmap(k2)) from d_table group by k1;")
^^^^^^^^^^^^^^^^^^^^^^^^^^ERROR LINE^^^^^^^^^^^^^^^^^^^^^^^^^^
Exception:
java.sql.SQLException: errCode = 2, detailMessage = Duplicate column name
'k1'
```
---
.../cloud_p0/different_serialize/different_serialize.groovy | 12 ++++++------
1 file changed, 6 insertions(+), 6 deletions(-)
diff --git
a/regression-test/suites/cloud_p0/different_serialize/different_serialize.groovy
b/regression-test/suites/cloud_p0/different_serialize/different_serialize.groovy
index 9433c97e130..df452fe8446 100644
---
a/regression-test/suites/cloud_p0/different_serialize/different_serialize.groovy
+++
b/regression-test/suites/cloud_p0/different_serialize/different_serialize.groovy
@@ -37,12 +37,12 @@ suite ("different_serialize_cloud") {
sql "insert into d_table select 2,2,2,'b';"
sql "insert into d_table select 3,3,null,'c';"
- createMV("create materialized view mv1_1 as select
k1,bitmap_intersect(to_bitmap(k2)) from d_table group by k1;")
- createMV("create materialized view mv1 as select k1,bitmap_agg(k2) from
d_table group by k1;")
- createMV("create materialized view mv2 as select k1,map_agg(k2,k3) from
d_table group by k1;")
- createMV("create materialized view mv3 as select k1,array_agg(k2) from
d_table group by k1;")
- createMV("create materialized view mv4 as select k1,collect_list(k2,3)
from d_table group by k1;")
- createMV("create materialized view mv5 as select k1,collect_set(k2,3) from
d_table group by k1;")
+ createMV("create materialized view mv1_1 as select k1 as k1_view,
bitmap_intersect(to_bitmap(k2)) from d_table group by k1;")
+ createMV("create materialized view mv1 as select k1 as k1_mv1_view,
bitmap_agg(k2) from d_table group by k1;")
+ createMV("create materialized view mv2 as select k1 as k1_mv2_view,
map_agg(k2,k3) from d_table group by k1;")
+ createMV("create materialized view mv3 as select k1 as k1_mv3_view,
array_agg(k2) from d_table group by k1;")
+ createMV("create materialized view mv4 as select k1 as k1_mv4_view,
collect_list(k2,3) from d_table group by k1;")
+ createMV("create materialized view mv5 as select k1 as k1_mv5_view,
collect_set(k2,3) from d_table group by k1;")
sql "insert into d_table select -4,4,-4,'d';"
sql "insert into d_table(k4,k2) values('d',4);"
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
