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 fca6fd585f5 Enhance Alter Java syntax and add other SQL test
statements (#27607)
fca6fd585f5 is described below
commit fca6fd585f5413b213dc89fde52f1f5f26be0e68
Author: niu niu <[email protected]>
AuthorDate: Tue Aug 1 18:15:53 2023 +0800
Enhance Alter Java syntax and add other SQL test statements (#27607)
---
.../dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4 | 2 +-
test/it/parser/src/main/resources/case/ddl/alter-database.xml | 1 +
test/it/parser/src/main/resources/case/ddl/alter-diskgroup.xml | 6 ++++++
test/it/parser/src/main/resources/case/ddl/alter-java.xml | 1 +
.../parser/src/main/resources/sql/supported/ddl/alter-database.xml | 1 +
.../parser/src/main/resources/sql/supported/ddl/alter-diskgroup.xml | 6 ++++++
test/it/parser/src/main/resources/sql/supported/ddl/alter-java.xml | 1 +
7 files changed, 17 insertions(+), 1 deletion(-)
diff --git
a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
index 10d0d126a90..93a1b72225f 100644
--- a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
+++ b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
@@ -2619,7 +2619,7 @@ zonemapRefreshClause
;
alterJava
- : ALTER JAVA (SOURCE | CLASS) objectName resolveClauses (COMPILE | RESOLVE
| invokerRightsClause)
+ : ALTER JAVA (SOURCE | CLASS) objectName resolveClauses? (COMPILE | RESOLVE
| invokerRightsClause)
;
resolveClauses
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 3fe32ccd853..5afc763521b 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
@@ -86,4 +86,5 @@
<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" />
+ <alter-database sql-case-id="alter_database_backup_controlfile_to" />
</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 a159e34e11a..c2700ef0783 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
@@ -46,4 +46,10 @@
<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"
/>
+ <alter-diskgroup sql-case-id="alter_diskgroup_add_volume_size_g" />
+ <alter-diskgroup sql-case-id="alter_diskgroup_resize_volume_size_g" />
+ <alter-diskgroup sql-case-id="alter_diskgroup_disable_volume" />
+ <alter-diskgroup sql-case-id="alter_diskgroup_enable_volume" />
+ <alter-diskgroup sql-case-id="alter_diskgroup_all_disable_volume_all" />
+ <alter-diskgroup sql-case-id="alter_diskgroup_drop_volume" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/case/ddl/alter-java.xml
b/test/it/parser/src/main/resources/case/ddl/alter-java.xml
index 24460773385..9fc64fcebdd 100644
--- a/test/it/parser/src/main/resources/case/ddl/alter-java.xml
+++ b/test/it/parser/src/main/resources/case/ddl/alter-java.xml
@@ -18,4 +18,5 @@
<sql-parser-test-cases>
<alter-java sql-case-id="alter_java" />
+ <alter-java sql-case-id="alter_java_source_compile" />
</sql-parser-test-cases>
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 7775221c8e8..e98fa86462d 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
@@ -86,4 +86,5 @@
<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-case id="alter_database_backup_controlfile_to" value="ALTER DATABASE
BACKUP CONTROLFILE TO '/oracle/dbs/cf_backup.f'" 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 d1b2b70c5f8..714e364e96f 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
@@ -46,4 +46,10 @@
<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-case id="alter_diskgroup_add_volume_size_g" value="ALTER DISKGROUP
data ADD VOLUME volume1 SIZE 10G" db-types="Oracle" />
+ <sql-case id="alter_diskgroup_resize_volume_size_g" value="ALTER DISKGROUP
data RESIZE VOLUME volume1 SIZE 15G" db-types="Oracle" />
+ <sql-case id="alter_diskgroup_disable_volume" value="ALTER DISKGROUP data
DISABLE VOLUME volume1" db-types="Oracle" />
+ <sql-case id="alter_diskgroup_enable_volume" value="ALTER DISKGROUP data
ENABLE VOLUME volume1" db-types="Oracle" />
+ <sql-case id="alter_diskgroup_all_disable_volume_all" value="ALTER
DISKGROUP ALL DISABLE VOLUME ALL" db-types="Oracle" />
+ <sql-case id="alter_diskgroup_drop_volume" value="ALTER DISKGROUP data
DROP VOLUME volume1" db-types="Oracle" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/ddl/alter-java.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/alter-java.xml
index 72446dc1076..ed42249e1ae 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/alter-java.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/alter-java.xml
@@ -18,4 +18,5 @@
<sql-cases>
<sql-case id="alter_java" value="ALTER JAVA CLASS "Agent"
RESOLVER (("/usr/bin/bfile_dir/*" pm)(* public)) RESOLVE;"
db-types="Oracle" />
+ <sql-case id="alter_java_source_compile" value="ALTER JAVA SOURCE
jsource_1 COMPILE" db-types="Oracle" />
</sql-cases>
