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 4660f7b2d65 add test case for create_materialized_view_log (#29088)
4660f7b2d65 is described below
commit 4660f7b2d65428a3132fc1844c73ed6eebd40fb5
Author: +7 <[email protected]>
AuthorDate: Mon Nov 20 08:53:20 2023 +0800
add test case for create_materialized_view_log (#29088)
---
.../src/main/resources/case/ddl/create-materialized-view-log.xml | 2 +-
.../resources/sql/supported/ddl/create-materialized-view-log.xml | 5 +++++
2 files changed, 6 insertions(+), 1 deletion(-)
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 68c24f03f1d..427c373a081 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
@@ -26,5 +26,5 @@
<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" />
-
+ <create-materialized-view-log
sql-case-id="create_materialized_view_log_with_pctfree_storage_purge_repeat" />
</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 2415b6236d2..7161a04d5e7 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
@@ -39,4 +39,9 @@
<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-case
id="create_materialized_view_log_with_pctfree_storage_purge_repeat"
value="CREATE MATERIALIZED VIEW LOG ON orders
+ PCTFREE 5
+ TABLESPACE example
+ STORAGE (INITIAL 10K)
+ PURGE REPEAT INTERVAL '5' DAY;" db-types="Oracle" />
</sql-cases>
