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/13 10:56:34 UTC
(shardingsphere) branch master updated: add more SQL test case (#29020)
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 b9453244211 add more SQL test case (#29020)
b9453244211 is described below
commit b94532442117b204c809db871ff0c0170aaae2b1
Author: +7 <ch...@gmail.com>
AuthorDate: Mon Nov 13 18:56:27 2023 +0800
add more SQL test case (#29020)
---
.../src/main/resources/case/ddl/create-materialized-view.xml | 1 +
.../resources/sql/supported/ddl/create-materialized-view.xml | 10 ++++++++++
2 files changed, 11 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 20e6f11f159..1224d0d80eb 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
@@ -24,4 +24,5 @@
<create-materialized-view sql-case-id="create_materialized_view_with_data" />
<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" />
</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 1db36d160a4..2febdf2bb01 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
@@ -33,4 +33,14 @@
SUM(SH.SALES.AMOUNT_SOLD) M1, COUNT(SH.SALES.AMOUNT_SOLD) M2, COUNT(*) M3 FROM SH.SALES, SH.CUSTOMERS
WHERE SH.CUSTOMERS.CUST_ID = SH.SALES.CUST_ID AND (SH.SALES.CUST_ID IN (1012, 1010, 1005))
GROUP BY SH.SALES.PROD_ID, SH.CUSTOMERS.CUST_ID;" db-types="Oracle" />
+ <sql-case id="create_materialized_view_with_refresh_fast_disable_query_rewrite" value="CREATE MATERIALIZED VIEW SH.CUST_MV
+ REFRESH FAST WITH ROWID
+ DISABLE QUERY REWRITE AS
+ SELECT SH.SALES.PROD_ID C1, SH.CUSTOMERS.CUST_ID C2,
+ SUM(SH.SALES.AMOUNT_SOLD) M1,
+ COUNT(SH.SALES.AMOUNT_SOLD) M2,
+ COUNT(*) M3
+ 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-cases>