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 2cb461c4db1 add more test case for Oracle CREATE TEMPORARY sql (#28997)
2cb461c4db1 is described below
commit 2cb461c4db12da28d266ce7e83bb06c0b8881b3a
Author: +7 <[email protected]>
AuthorDate: Fri Nov 10 09:48:18 2023 +0800
add more test case for Oracle CREATE TEMPORARY sql (#28997)
---
test/it/parser/src/main/resources/case/ddl/create-tablespace.xml | 5 +++++
.../src/main/resources/sql/supported/ddl/create-tablespace.xml | 5 +++++
2 files changed, 10 insertions(+)
diff --git a/test/it/parser/src/main/resources/case/ddl/create-tablespace.xml
b/test/it/parser/src/main/resources/case/ddl/create-tablespace.xml
index dc132120ac7..474213dfde1 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-tablespace.xml
+++ b/test/it/parser/src/main/resources/case/ddl/create-tablespace.xml
@@ -87,6 +87,11 @@
<create-tablespace
sql-case-id="create_tablespace_with_temporary_extent_autoallocate" />
<create-tablespace
sql-case-id="create_tablespace_with_temporary_extent_uniform_size" />
<create-tablespace
sql-case-id="create_tablespace_with_temporary_extent_uniform" />
+ <create-tablespace
sql-case-id="create_tablespace_with_temporary_tempfile_spec" />
+ <create-tablespace
sql-case-id="create_tablespace_with_temporary_tempfile_spec_group" />
+ <create-tablespace
sql-case-id="create_tablespace_with_temporary_tempfile_spec_extent_management"
/>
+ <create-tablespace
sql-case-id="create_tablespace_with_temporary_tempfile_spec_size_autoextend" />
+ <create-tablespace
sql-case-id="create_tablespace_with_temporary_tempfile_spec_size_autoextend_group"
/>
<create-tablespace sql-case-id="create_tablespace_with_undo_tablespace" />
<create-tablespace
sql-case-id="create_tablespace_with_undo_tablespace_spec" />
<create-tablespace
sql-case-id="create_tablespace_with_undo_tablespace_extent" />
diff --git
a/test/it/parser/src/main/resources/sql/supported/ddl/create-tablespace.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/create-tablespace.xml
index e5a13f7cd21..b447e4f742e 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/create-tablespace.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/create-tablespace.xml
@@ -95,6 +95,11 @@
<sql-case id="create_tablespace_with_temporary_extent" value="CREATE
TEMPORARY TABLESPACE test_space EXTENT MANAGEMENT LOCAL" db-types="Oracle" />
<sql-case id="create_tablespace_with_temporary_extent_autoallocate"
value="CREATE TEMPORARY TABLESPACE test_space EXTENT MANAGEMENT LOCAL
AUTOALLOCATE" db-types="Oracle" />
<sql-case id="create_tablespace_with_temporary_extent_uniform_size"
value="CREATE TEMPORARY TABLESPACE test_space EXTENT MANAGEMENT LOCAL UNIFORM
SIZE 5K" db-types="Oracle" />
+ <sql-case id="create_tablespace_with_temporary_tempfile_spec"
value="CREATE TEMPORARY TABLESPACE lmtemp TEMPFILE
'/u02/oracle/data/lmtemp01.dbf' SIZE 20M REUSE EXTENT MANAGEMENT LOCAL UNIFORM
SIZE 16M;" db-types="Oracle" />
+ <sql-case id="create_tablespace_with_temporary_tempfile_spec_group"
value="CREATE TEMPORARY TABLESPACE lmtemp3 TEMPFILE
'/u02/oracle/data/lmtemp301.dbf'SIZE 25M TABLESPACE GROUP group1;"
db-types="Oracle" />
+ <sql-case
id="create_tablespace_with_temporary_tempfile_spec_extent_management"
value="CREATE TEMPORARY TABLESPACE tbs_t1 TEMPFILE 'tbs_t1.f' SIZE 50m REUSE
AUTOEXTEND ON MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K;"
db-types="Oracle" />
+ <sql-case
id="create_tablespace_with_temporary_tempfile_spec_size_autoextend"
value="CREATE TEMPORARY TABLESPACE temp_demo TEMPFILE 'temp01.dbf' SIZE 5M
AUTOEXTEND ON;" db-types="Oracle" />
+ <sql-case
id="create_tablespace_with_temporary_tempfile_spec_size_autoextend_group"
value="CREATE TEMPORARY TABLESPACE tbs_temp_02 TEMPFILE 'temp02.dbf' SIZE 5M
AUTOEXTEND ON TABLESPACE GROUP tbs_grp_01;" db-types="Oracle" />
<sql-case id="create_tablespace_with_temporary_extent_uniform"
value="CREATE TEMPORARY TABLESPACE test_space EXTENT MANAGEMENT LOCAL UNIFORM"
db-types="Oracle" />
<sql-case id="create_tablespace_with_undo_tablespace" value="CREATE UNDO
TABLESPACE tablespaceName" db-types="Oracle" />
<sql-case id="create_tablespace_with_undo_tablespace_spec" value="CREATE
UNDO TABLESPACE tablespaceName DATATFILE file_specification" db-types="Oracle"
/>
