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