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 <[email protected]>
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>
