(shardingsphere) branch master updated: add more SQL test case for create-materialized-view-log (#29046)

[duanzhengqiang]

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 83c6214d5a6 add more SQL test case for create-materialized-view-log 
(#29046)
83c6214d5a6 is described below

commit 83c6214d5a6531c6d1b70eb3198c150375da1e6f
Author: +7 <chakk6...@gmail.com>
AuthorDate: Thu Nov 16 11:04:19 2023 +0800

    add more SQL test case for create-materialized-view-log (#29046)
---
 .../main/resources/case/ddl/create-materialized-view-log.xml  |  4 ++++
 .../sql/supported/ddl/create-materialized-view-log.xml        | 11 +++++++++++
 2 files changed, 15 insertions(+)

diff --git 
a/test/it/parser/src/main/resources/case/ddl/create-materialized-view-log.xml 
b/test/it/parser/src/main/resources/case/ddl/create-materialized-view-log.xml
index 71de1e31278..68c24f03f1d 100644
--- 
a/test/it/parser/src/main/resources/case/ddl/create-materialized-view-log.xml
+++ 
b/test/it/parser/src/main/resources/case/ddl/create-materialized-view-log.xml
@@ -23,4 +23,8 @@
     <create-materialized-view-log 
sql-case-id="create_materialized_view_log_with_table_schema" />
     <create-materialized-view-log 
sql-case-id="create_materialized_view_log_with_object_id" />
     <create-materialized-view-log 
sql-case-id="create_materialized_view_log_with_row_id" />
+    <create-materialized-view-log 
sql-case-id="create_materialized_view_log_with_multi_row_id_" />
+    <create-materialized-view-log 
sql-case-id="create_materialized_view_log_with_row_id_sequence_including_new" />
+    <create-materialized-view-log 
sql-case-id="create_materialized_view_log_with_row_id_multi_sequence" />
+
 </sql-parser-test-cases>
diff --git 
a/test/it/parser/src/main/resources/sql/supported/ddl/create-materialized-view-log.xml
 
b/test/it/parser/src/main/resources/sql/supported/ddl/create-materialized-view-log.xml
index 0baea22fa2a..2415b6236d2 100644
--- 
a/test/it/parser/src/main/resources/sql/supported/ddl/create-materialized-view-log.xml
+++ 
b/test/it/parser/src/main/resources/sql/supported/ddl/create-materialized-view-log.xml
@@ -28,4 +28,15 @@
     INCLUDING NEW VALUES;" db-types="Oracle" />
     <sql-case id="create_materialized_view_log_with_object_id" value="CREATE 
MATERIALIZED VIEW LOG ON oe.categories_tab_sys WITH OBJECT ID;" 
db-types="Oracle" />
     <sql-case id="create_materialized_view_log_with_row_id" value="CREATE 
MATERIALIZED VIEW LOG ON sales WITH ROWID;" db-types="Oracle" />
+    <sql-case id="create_materialized_view_log_with_multi_row_id_" 
value="CREATE MATERIALIZED VIEW LOG ON products WITH SEQUENCE, ROWID
+    (prod_id, prod_name, prod_desc, prod_subcategory, prod_subcategory_desc,
+    prod_category, prod_category_desc, prod_weight_class, prod_unit_of_measure,
+    prod_pack_size, supplier_id, prod_status, prod_list_price, prod_min_price)
+    INCLUDING NEW VALUES;" db-types="Oracle" />
+    <sql-case 
id="create_materialized_view_log_with_row_id_sequence_including_new" 
value="CREATE MATERIALIZED VIEW LOG ON product_information
+    WITH ROWID, SEQUENCE (list_price, min_price, category_id), PRIMARY KEY
+    INCLUDING NEW VALUES;" db-types="Oracle" />
+    <sql-case id="create_materialized_view_log_with_row_id_multi_sequence" 
value="CREATE MATERIALIZED VIEW LOG ON sales
+    WITH ROWID, SEQUENCE(amount_sold, time_id, prod_id)
+    INCLUDING NEW VALUES;" db-types="Oracle" />
 </sql-cases>