[shardingsphere] branch master updated: Add oracle alter profile test sql (#27952)

[duanzhengqiang]

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 b90afde4aad Add oracle alter profile test sql (#27952)
b90afde4aad is described below

commit b90afde4aadf3596aaf1c835a8a6ccb00c354d98
Author: niu niu <zihaoa...@aliyun.com>
AuthorDate: Mon Aug 7 12:23:31 2023 +0800

    Add oracle alter profile test sql (#27952)
---
 test/it/parser/src/main/resources/case/ddl/alter-profile.xml        | 6 ++++++
 .../parser/src/main/resources/sql/supported/ddl/alter-profile.xml   | 6 ++++++
 2 files changed, 12 insertions(+)

diff --git a/test/it/parser/src/main/resources/case/ddl/alter-profile.xml 
b/test/it/parser/src/main/resources/case/ddl/alter-profile.xml
index 1a0db3c6e8c..15a93fc6453 100644
--- a/test/it/parser/src/main/resources/case/ddl/alter-profile.xml
+++ b/test/it/parser/src/main/resources/case/ddl/alter-profile.xml
@@ -17,9 +17,15 @@
   -->
 
 <sql-parser-test-cases>
+    <alter-profile 
sql-case-id="alter_profile_limit_failed_login_attempts_password_lock_time1" />
+    <alter-profile 
sql-case-id="alter_profile_limit_failed_login_attempts_password_lock_time2" />
     <alter-profile sql-case-id="alter_profile_limit_idle_time" />
     <alter-profile 
sql-case-id="alter_profile_limit_password_reuse_time_password_reuse_max_unlimited"
 />
     <alter-profile sql-case-id="alter_profile_limit_password_verify_function" 
/>
     <alter-profile 
sql-case-id="alter_profile_limit_failed_login_attempts_password_lock_time" />
     <alter-profile 
sql-case-id="alter_profile_limit_password_reuse_time_default_password_reuse_max_unlimited"
 />
+    <alter-profile sql-case-id="alter_profile_limit_idle_time_default" />
+    <alter-profile sql-case-id="alter_profile_limit_session_per_user" />
+    <alter-profile 
sql-case-id="alter_profile_limit_password_file_time_password_grace_time" />
+    <alter-profile sql-case-id="alter_profile_limit_idle_time_unlimited" />
 </sql-parser-test-cases>
diff --git 
a/test/it/parser/src/main/resources/sql/supported/ddl/alter-profile.xml 
b/test/it/parser/src/main/resources/sql/supported/ddl/alter-profile.xml
index a051afc29af..863c755a8ab 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/alter-profile.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/alter-profile.xml
@@ -17,9 +17,15 @@
   -->
 
 <sql-cases>
+    <sql-case 
id="alter_profile_limit_failed_login_attempts_password_lock_time1" value="ALTER 
PROFILE prof LIMIT FAILED_LOGIN_ATTEMPTS 9 PASSWORD_LOCK_TIME 10;" 
db-types="Oracle" />
+    <sql-case 
id="alter_profile_limit_failed_login_attempts_password_lock_time2" value="ALTER 
PROFILE app_user LIMIT FAILED_LOGIN_ATTEMPTS 5 PASSWORD_LOCK_TIME 1" 
db-types="Oracle" />
     <sql-case id="alter_profile_limit_idle_time" value="ALTER PROFILE default 
LIMIT IDLE_TIME 2" db-types="Oracle" />
     <sql-case 
id="alter_profile_limit_password_reuse_time_password_reuse_max_unlimited" 
value="ALTER PROFILE new_profile LIMIT PASSWORD_REUSE_TIME 90 
PASSWORD_REUSE_MAX UNLIMITED" db-types="Oracle" />
     <sql-case id="alter_profile_limit_password_verify_function" value="ALTER 
PROFILE default LIMIT PASSWORD_VERIFY_FUNCTION verify_function_11G" 
db-types="Oracle" />
     <sql-case 
id="alter_profile_limit_failed_login_attempts_password_lock_time" value="ALTER 
PROFILE prof LIMIT FAILED_LOGIN_ATTEMPTS 9 PASSWORD_LOCK_TIME 10;" 
db-types="Oracle" />
     <sql-case 
id="alter_profile_limit_password_reuse_time_default_password_reuse_max_unlimited"
 value="ALTER PROFILE app_user LIMIT PASSWORD_REUSE_TIME DEFAULT 
PASSWORD_REUSE_MAX UNLIMITED;" db-types="Oracle" />
+    <sql-case id="alter_profile_limit_idle_time_default" value="ALTER PROFILE 
app_user LIMIT IDLE_TIME DEFAULT" db-types="Oracle" />
+    <sql-case id="alter_profile_limit_session_per_user" value="ALTER PROFILE 
app_user LIMIT SESSIONS_PER_USER 5" db-types="Oracle" />
+    <sql-case id="alter_profile_limit_password_file_time_password_grace_time" 
value="ALTER PROFILE app_user2 LIMIT PASSWORD_LIFE_TIME 90 PASSWORD_GRACE_TIME 
5" db-types="Oracle" />
+    <sql-case id="alter_profile_limit_idle_time_unlimited" value="ALTER 
PROFILE app_user2 LIMIT IDLE_TIME UNLIMITED" db-types="Oracle" />
 </sql-cases>