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 4ad64b3c1dd support parse alter profile(#20395) (#32036)
4ad64b3c1dd is described below
commit 4ad64b3c1dde2962ed0bdc0d1acd947aa48beeed
Author: Skitii <[email protected]>
AuthorDate: Mon Jul 8 14:58:41 2024 +0800
support parse alter profile(#20395) (#32036)
Co-authored-by: 黄后盛 <[email protected]>
---
test/it/parser/src/main/resources/case/ddl/alter-profile.xml | 2 ++
test/it/parser/src/main/resources/sql/supported/ddl/alter-profile.xml | 2 ++
2 files changed, 4 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 15a93fc6453..da5a12cfa08 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
@@ -28,4 +28,6 @@
<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" />
+ <alter-profile sql-case-id="alter_profile_limit_password_rollover_time" />
+ <alter-profile sql-case-id="alter_profile_limit_inactive_account_time" />
</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 863c755a8ab..61d6028cb88 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
@@ -28,4 +28,6 @@
<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-case id="alter_profile_limit_password_rollover_time" value="ALTER
PROFILE usr_prof LIMIT PASSWORD_ROLLOVER_TIME 2" db-types="Oracle" />
+ <sql-case id="alter_profile_limit_inactive_account_time" value="ALTER
PROFILE app_user2 LIMIT INACTIVE_ACCOUNT_TIME 30" db-types="Oracle" />
</sql-cases>
