[doris] branch master updated: [MV](exec) disable create mv with select star (#22895)

[lihaopeng]

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 <pxl...@qq.com>
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: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org