You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2023/11/17 03:24:55 UTC
(shardingsphere) branch master updated: add more SQL test case for create-materialized-view (#29061)
This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 130abc9746b add more SQL test case for create-materialized-view (#29061)
130abc9746b is described below
commit 130abc9746b8bd4e1a047d7069952964241ce77c
Author: +7 <ch...@gmail.com>
AuthorDate: Fri Nov 17 11:24:48 2023 +0800
add more SQL test case for create-materialized-view (#29061)
---
.../src/main/resources/case/ddl/create-materialized-view.xml | 1 +
.../resources/sql/supported/ddl/create-materialized-view.xml | 11 +++++++++++
2 files changed, 12 insertions(+)
diff --git a/test/it/parser/src/main/resources/case/ddl/create-materialized-view.xml b/test/it/parser/src/main/resources/case/ddl/create-materialized-view.xml
index 1224d0d80eb..81c7cfd2f9e 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-materialized-view.xml
+++ b/test/it/parser/src/main/resources/case/ddl/create-materialized-view.xml
@@ -25,4 +25,5 @@
<create-materialized-view sql-case-id="create_materialized_view_with_refresh_fast" />
<create-materialized-view sql-case-id="create_materialized_view_with_refresh_fast_query_rewrite" />
<create-materialized-view sql-case-id="create_materialized_view_with_refresh_fast_disable_query_rewrite" />
+ <create-materialized-view sql-case-id="create_materialized_view_with_tablespace_parallel_build_immediate" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/ddl/create-materialized-view.xml b/test/it/parser/src/main/resources/sql/supported/ddl/create-materialized-view.xml
index 2febdf2bb01..e45c17d1788 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/create-materialized-view.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/create-materialized-view.xml
@@ -43,4 +43,15 @@
FROM SH.SALES, SH.CUSTOMERS
WHERE SH.CUSTOMERS.CUST_ID = SH.SALES.CUST_ID
GROUP BY SH.SALES.PROD_ID, SH.CUSTOMERS.CUST_ID;" db-types="Oracle" />
+ <sql-case id="create_materialized_view_with_tablespace_parallel_build_immediate" value="CREATE MATERIALIZED VIEW sales_by_month_by_state
+ TABLESPACE example
+ PARALLEL 4
+ BUILD IMMEDIATE
+ REFRESH COMPLETE
+ ENABLE QUERY REWRITE
+ AS SELECT t.calendar_month_desc, c.cust_state_province,
+ SUM(s.amount_sold) AS sum_sales
+ FROM times t, sales s, customers c
+ WHERE s.time_id = t.time_id AND s.cust_id = c.cust_id
+ GROUP BY t.calendar_month_desc, c.cust_state_province;" db-types="Oracle" />
</sql-cases>