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 bb982faeb76 add create-diskgroup test SQL (#28907)
bb982faeb76 is described below
commit bb982faeb7610d371bbe7d50bcc204284a2d2210
Author: +7 <[email protected]>
AuthorDate: Wed Nov 1 08:49:02 2023 +0800
add create-diskgroup test SQL (#28907)
---
.../main/resources/case/ddl/create-diskgroup.xml | 6 ++++-
.../sql/supported/ddl/create-diskgroup.xml | 29 +++++++++++++++++++---
2 files changed, 31 insertions(+), 4 deletions(-)
diff --git a/test/it/parser/src/main/resources/case/ddl/create-diskgroup.xml
b/test/it/parser/src/main/resources/case/ddl/create-diskgroup.xml
index 5ac27b2f59f..9804dc93dfd 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-diskgroup.xml
+++ b/test/it/parser/src/main/resources/case/ddl/create-diskgroup.xml
@@ -17,5 +17,9 @@
-->
<sql-parser-test-cases>
- <create-diskgroup sql-case-id="create_diskgroup" />
+ <create-diskgroup sql-case-id="create_diskgroup_with_external_redundancy"
/>
+ <create-diskgroup sql-case-id="create_diskgroup_with_single_attribute" />
+ <create-diskgroup sql-case-id="create_diskgroup_with_multi_attribute" />
+ <create-diskgroup sql-case-id="create_diskgroup_with_multi_failgroup" />
+ <create-diskgroup sql-case-id="create_diskgroup_with_single_failgroup" />
</sql-parser-test-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/ddl/create-diskgroup.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/create-diskgroup.xml
index a638ba2af1f..190d65deadf 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/create-diskgroup.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/create-diskgroup.xml
@@ -17,7 +17,30 @@
-->
<sql-cases>
- <sql-case id="create_diskgroup" value="CREATE DISKGROUP dgroup_01
- EXTERNAL REDUNDANCY
- DISK '/devices/disks/c*';"
db-types="Oracle" />
+ <sql-case id="create_diskgroup_with_external_redundancy" value="CREATE
DISKGROUP dgroup_01
+
EXTERNAL REDUNDANCY
+
DISK '/devices/disks/c*';" db-types="Oracle" />
+ <sql-case id="create_diskgroup_with_single_attribute" value="CREATE
DISKGROUP data1 DISK '/dev/sd*'
+
ATTRIBUTE 'compatible.asm' = '11.2';" db-types="Oracle" />
+ <sql-case id="create_diskgroup_with_multi_attribute" value="CREATE
DISKGROUP data2 DISK '/dev/sd*'
+
ATTRIBUTE 'compatible.asm' = '11.2', 'compatible.rdbms' = '11.2',
+
'compatible.advm' = '11.2';" db-types="Oracle" />
+ <sql-case id="create_diskgroup_with_multi_failgroup" value="CREATE
DISKGROUP data NORMAL REDUNDANCY
+ FAILGROUP
controller1 DISK
+
'/devices/diska1',
+
'/devices/diska2',
+
'/devices/diska3',
+
'/devices/diska4'
+ FAILGROUP
controller2 DISK
+
'/devices/diskb1',
+
'/devices/diskb2',
+
'/devices/diskb3',
+
'/devices/diskb4'
+ ATTRIBUTE
'compatible.asm' = '11.2', 'compatible.rdbms' = '11.2',
+
'sector_size'='4096';" db-types="Oracle" />
+ <sql-case id="create_diskgroup_with_single_failgroup" value="CREATE
DISKGROUP ocr_data NORMAL REDUNDANCY
+ FAILGROUP fg1
DISK '/devices/diskg1'
+ FAILGROUP fg2
DISK '/devices/diskg2'
+ QUORUM
FAILGROUP fg3 DISK '/devices/diskg3'
+ ATTRIBUTE
'compatible.asm' = '11.2.0.0.0';" db-types="Oracle" />
</sql-cases>
