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/16 03:04:26 UTC
(shardingsphere) branch master updated: add more SQL test case for create-materialized-view-log (#29046)
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 <ch...@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>