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 4dd9d4e1dcf [enhance](mtmv) change mysql table type of mtmv to table
(#38797) (#39166)
4dd9d4e1dcf is described below
commit 4dd9d4e1dcf9453893e05c74051ad5185e9eb2c7
Author: zhangdong <[email protected]>
AuthorDate: Sat Aug 10 18:20:48 2024 +0800
[enhance](mtmv) change mysql table type of mtmv to table (#38797) (#39166)
pick: https://github.com/apache/doris/pull/38797
---
.../src/main/java/org/apache/doris/catalog/TableIf.java | 2 +-
regression-test/suites/mtmv_p0/test_build_mtmv.groovy | 15 +++++++++++++++
2 files changed, 16 insertions(+), 1 deletion(-)
diff --git a/fe/fe-core/src/main/java/org/apache/doris/catalog/TableIf.java
b/fe/fe-core/src/main/java/org/apache/doris/catalog/TableIf.java
index a1016cbd5db..a3535c739cf 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/catalog/TableIf.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/catalog/TableIf.java
@@ -488,7 +488,6 @@ public interface TableIf {
return "SYSTEM VIEW";
case INLINE_VIEW:
case VIEW:
- case MATERIALIZED_VIEW:
return "VIEW";
case OLAP:
case MYSQL:
@@ -504,6 +503,7 @@ public interface TableIf {
case ES_EXTERNAL_TABLE:
case ICEBERG_EXTERNAL_TABLE:
case PAIMON_EXTERNAL_TABLE:
+ case MATERIALIZED_VIEW:
return "BASE TABLE";
default:
return null;
diff --git a/regression-test/suites/mtmv_p0/test_build_mtmv.groovy
b/regression-test/suites/mtmv_p0/test_build_mtmv.groovy
index 727cef978b4..717f614e3e5 100644
--- a/regression-test/suites/mtmv_p0/test_build_mtmv.groovy
+++ b/regression-test/suites/mtmv_p0/test_build_mtmv.groovy
@@ -101,6 +101,21 @@ suite("test_build_mtmv") {
logger.info("showDataResult: " + showDataResult.toString())
assertTrue(showDataResult.toString().contains("${mvName}"))
+ // show full tables
+ def showFullTablesResult = sql """SHOW FULL TABLES WHERE Table_type =
'BASE TABLE';"""
+ logger.info("showFullTablesResult: " + showFullTablesResult.toString())
+ assertTrue(showFullTablesResult.toString().contains("${mvName}"))
+
+ // views should not contains mtmv
+ def selectViewsResult = sql """ SELECT * from INFORMATION_SCHEMA.VIEWS;"""
+ logger.info("selectViewsResult: " + selectViewsResult.toString())
+ assertFalse(selectViewsResult.toString().contains("${mvName}"))
+
+ // views should not contains mtmv
+ def selectTablesResult = sql """ SELECT * from
INFORMATION_SCHEMA.TABLES;"""
+ logger.info("selectTablesResult: " + selectTablesResult.toString())
+ assertTrue(selectTablesResult.toString().contains("${mvName}"))
+
// if not exist
try {
sql """
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
