This is an automated email from the ASF dual-hosted git repository.
chengzhang 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 53ec1a73020 Add oracle sql test (#27601)
53ec1a73020 is described below
commit 53ec1a7302081bfc58a20ea9ad7a6b3ad938ff47
Author: niu niu <[email protected]>
AuthorDate: Tue Aug 1 11:37:41 2023 +0800
Add oracle sql test (#27601)
* Add oracle sql test
* Fix code
---
test/it/parser/src/main/resources/case/ddl/alter-database.xml | 1 +
test/it/parser/src/main/resources/case/ddl/alter-diskgroup.xml | 2 ++
test/it/parser/src/main/resources/case/ddl/alter-index.xml | 8 ++++++++
.../src/main/resources/sql/supported/ddl/alter-database.xml | 1 +
.../src/main/resources/sql/supported/ddl/alter-diskgroup.xml | 2 ++
.../parser/src/main/resources/sql/supported/ddl/alter-index.xml | 2 ++
6 files changed, 16 insertions(+)
diff --git a/test/it/parser/src/main/resources/case/ddl/alter-database.xml
b/test/it/parser/src/main/resources/case/ddl/alter-database.xml
index 93818e5213d..3fe32ccd853 100644
--- a/test/it/parser/src/main/resources/case/ddl/alter-database.xml
+++ b/test/it/parser/src/main/resources/case/ddl/alter-database.xml
@@ -85,4 +85,5 @@
<alter-database sql-case-id="alter_database_create3" />
<alter-database sql-case-id="alter_database_modify_name" />
<alter-database sql-case-id="alter_database_set_options" />
+ <alter-database
sql-case-id="alter_database_enable_block_change_tracking_using_file" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/ddl/alter-diskgroup.xml
b/test/it/parser/src/main/resources/case/ddl/alter-diskgroup.xml
index 164b8eb0c24..a159e34e11a 100644
--- a/test/it/parser/src/main/resources/case/ddl/alter-diskgroup.xml
+++ b/test/it/parser/src/main/resources/case/ddl/alter-diskgroup.xml
@@ -44,4 +44,6 @@
<alter-diskgroup
sql-case-id="alter_diskgroup_resize_disks_in_failgroup_size_g" />
<alter-diskgroup
sql-case-id="alter_diskgroup_add_template_attribute_unprotected_coarse" />
<alter-diskgroup
sql-case-id="alter_diskgroup_modify_template_attribute_fine" />
+ <alter-diskgroup
sql-case-id="alter_diskgroup_modify_file_attribute_hot_mirrorhot" />
+ <alter-diskgroup sql-case-id="alter_diskgroup_modify_usergroup_add_member"
/>
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/ddl/alter-index.xml
b/test/it/parser/src/main/resources/case/ddl/alter-index.xml
index f8c91003c3d..92a457fb918 100644
--- a/test/it/parser/src/main/resources/case/ddl/alter-index.xml
+++ b/test/it/parser/src/main/resources/case/ddl/alter-index.xml
@@ -134,6 +134,14 @@
<index name="q1_sales_by_region_locix" start-index="12"
stop-index="35" />
</alter-index>
+ <alter-index sql-case-id="alter_index_rename_subpartition_to">
+ <index name="scuba" start-index="12" stop-index="16" />
+ </alter-index>
+
+ <alter-index sql-case-id="alter_index_modify_default_attributes_initrans">
+ <index name="prod_idx" start-index="12" stop-index="19" />
+ </alter-index>
+
<alter-index sql-case-id="alter_index_alter_column" />
<alter-index sql-case-id="alter_index_with_schema" />
<alter-index sql-case-id="alter_index_set_tablespace" />
diff --git
a/test/it/parser/src/main/resources/sql/supported/ddl/alter-database.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/alter-database.xml
index 8e9e3efac5a..7775221c8e8 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/alter-database.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/alter-database.xml
@@ -85,4 +85,5 @@
<sql-case id="alter_database_create3" value="ALTER DATABASE db1 CREATE
DATAFILE '03.dbf' as NEW" db-types="Oracle" />
<sql-case id="alter_database_modify_name" value="ALTER DATABASE db1 Modify
Name = db2" db-types="SQLServer" />
<sql-case id="alter_database_set_options" value="ALTER DATABASE db1 SET
CHANGE_TRACKING = ON (AUTO_CLEANUP = ON, CHANGE_RETENTION = 2 DAYS)"
db-types="SQLServer" />
+ <sql-case id="alter_database_enable_block_change_tracking_using_file"
value="ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE 'new_location'"
db-types="Oracle" />
</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/ddl/alter-diskgroup.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/alter-diskgroup.xml
index f736f7794a7..d1b2b70c5f8 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/alter-diskgroup.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/alter-diskgroup.xml
@@ -44,4 +44,6 @@
<sql-case id="alter_diskgroup_resize_disks_in_failgroup_size_g"
value="ALTER DISKGROUP data1 RESIZE DISKS IN FAILGROUP failgrp1 SIZE 100G"
db-types="Oracle" />
<sql-case id="alter_diskgroup_add_template_attribute_unprotected_coarse"
value="ALTER DISKGROUP dgroup_01 ADD TEMPLATE template_01 ATTRIBUTES
(UNPROTECTED COARSE)" db-types="Oracle" />
<sql-case id="alter_diskgroup_modify_template_attribute_fine" value="ALTER
DISKGROUP dgroup_01 MODIFY TEMPLATE template_01 ATTRIBUTES (FINE)"
db-types="Oracle" />
+ <sql-case id="alter_diskgroup_modify_file_attribute_hot_mirrorhot"
value="ALTER DISKGROUP data MODIFY FILE
'+data/orcl/datafile/users.259.679156903' ATTRIBUTE (HOT MIRRORHOT)"
db-types="Oracle" />
+ <sql-case id="alter_diskgroup_modify_usergroup_add_member" value="ALTER
DISKGROUP data MODIFY USERGROUP 'test_grp2' ADD MEMBER 'oracle2'"
db-types="Oracle" />
</sql-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/ddl/alter-index.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/alter-index.xml
index 61ca83518d0..74acfc84b47 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/alter-index.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/alter-index.xml
@@ -48,6 +48,8 @@
<sql-case id="alter_index_parameters2" value="ALTER INDEX po_xmlindex_ix
PARAMETERS('DROP_GROUP GROUP po_item')" db-types="Oracle" />
<sql-case id="alter_index_parameters3" value="ALTER INDEX po_xmlindex_ix
PARAMETERS('PARAM myparam')" db-types="Oracle" />
<sql-case id="alter_index_modify_default_attributes_tablespace"
value="ALTER INDEX q1_sales_by_region_locix MODIFY DEFAULT ATTRIBUTES
TABLESPACE tbs_4" db-types="Oracle" />
+ <sql-case id="alter_index_rename_subpartition_to" value="ALTER INDEX scuba
RENAME SUBPARTITION sys_subp3254 TO bcd_types" db-types="Oracle" />
+ <sql-case id="alter_index_modify_default_attributes_initrans" value="ALTER
INDEX prod_idx MODIFY DEFAULT ATTRIBUTES INITRANS 5" db-types="Oracle" />
<sql-case id="alter_index_set_tablespace" value="ALTER INDEX distributors
SET TABLESPACE fasttablespace" db-types="PostgreSQL,openGauss" />
<sql-case id="alter_index_alter_column" value="ALTER INDEX t_order_idx
ALTER COLUMN 3 SET STATISTICS 1000" db-types="PostgreSQL,openGauss" />
<sql-case id="alter_index_with_schema" value="ALTER INDEX
public.t_order_idx ALTER COLUMN 3 SET STATISTICS 1000"
db-types="PostgreSQL,openGauss" />
