This is an automated email from the ASF dual-hosted git repository.
lihaopeng 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 49d503911e [MV](exec) disable create mv with select star (#22895)
49d503911e is described below
commit 49d503911e94887bf0748c58adef5253fd620605
Author: Pxl <[email protected]>
AuthorDate: Sun Aug 13 19:28:51 2023 +0800
[MV](exec) disable create mv with select star (#22895)
---
.../java/org/apache/doris/analysis/CreateMaterializedViewStmt.java | 5 +++++
regression-test/suites/mv_p0/group_check/group_check.groovy | 5 +++++
2 files changed, 10 insertions(+)
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/analysis/CreateMaterializedViewStmt.java
b/fe/fe-core/src/main/java/org/apache/doris/analysis/CreateMaterializedViewStmt.java
index 25dabac639..6de69386b0 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/analysis/CreateMaterializedViewStmt.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/analysis/CreateMaterializedViewStmt.java
@@ -208,6 +208,11 @@ public class CreateMaterializedViewStmt extends DdlStmt {
*/
for (int i = 0; i < selectList.getItems().size(); i++) {
SelectListItem selectListItem = selectList.getItems().get(i);
+
+ if (selectListItem.isStar()) {
+ throw new AnalysisException("The materialized view not support
select star");
+ }
+
Expr selectListItemExpr = selectListItem.getExpr();
if (!(selectListItemExpr instanceof SlotRef) &&
!(selectListItemExpr instanceof FunctionCallExpr)
&& !(selectListItemExpr instanceof ArithmeticExpr)) {
diff --git a/regression-test/suites/mv_p0/group_check/group_check.groovy
b/regression-test/suites/mv_p0/group_check/group_check.groovy
index 9762935e3b..91011d5181 100644
--- a/regression-test/suites/mv_p0/group_check/group_check.groovy
+++ b/regression-test/suites/mv_p0/group_check/group_check.groovy
@@ -47,6 +47,11 @@ suite ("group_check") {
exception "errCode = 2,"
}
+ test {
+ sql "create materialized view kgroup as select * from d_table where
k1=1;"
+ exception "errCode = 2,"
+ }
+
createMV ("create materialized view kgroup as select k1,k2,sum(k3) from
d_table group by k1,k2;")
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
