You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2023/09/05 06:11:56 UTC
[shardingsphere] branch master updated: Add oracle audit sql test (#28333)
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 5d558b60434 Add oracle audit sql test (#28333)
5d558b60434 is described below
commit 5d558b60434474ba54e7a413ca865202399e694e
Author: niu niu <zi...@aliyun.com>
AuthorDate: Tue Sep 5 14:11:49 2023 +0800
Add oracle audit sql test (#28333)
---
test/it/parser/src/main/resources/case/ddl/audit.xml | 4 ++++
test/it/parser/src/main/resources/sql/supported/ddl/audit.xml | 4 ++++
2 files changed, 8 insertions(+)
diff --git a/test/it/parser/src/main/resources/case/ddl/audit.xml b/test/it/parser/src/main/resources/case/ddl/audit.xml
index 9295e829bcc..d1784296d6a 100644
--- a/test/it/parser/src/main/resources/case/ddl/audit.xml
+++ b/test/it/parser/src/main/resources/case/ddl/audit.xml
@@ -156,4 +156,8 @@
<audit sql-case-id="audit_update_on_default" />
<audit sql-case-id="audit_execute_on_default" />
<audit sql-case-id="audit_read_on_default" />
+ <audit sql-case-id="audit_all_by_by_access" />
+ <audit sql-case-id="audit_all_on_default_by_access" />
+ <audit sql-case-id="audit_all_statements_by_by_access_whenever_successful" />
+ <audit sql-case-id="audit_all_statements_in_session_current" />
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/ddl/audit.xml b/test/it/parser/src/main/resources/sql/supported/ddl/audit.xml
index 1f5ffbc5cdb..ce24256d545 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/audit.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/audit.xml
@@ -156,4 +156,8 @@
<sql-case id="audit_update_on_default" value="AUDIT UPDATE ON DEFAULT" db-types="Oracle" />
<sql-case id="audit_execute_on_default" value="AUDIT EXECUTE ON DEFAULT" db-types="Oracle" />
<sql-case id="audit_read_on_default" value="AUDIT READ ON DEFAULT" db-types="Oracle" />
+ <sql-case id="audit_all_by_by_access" value="AUDIT ALL BY jward BY ACCESS" db-types="Oracle" />
+ <sql-case id="audit_all_on_default_by_access" value="AUDIT ALL ON DEFAULT BY ACCESS" db-types="Oracle" />
+ <sql-case id="audit_all_statements_by_by_access_whenever_successful" value="AUDIT ALL STATEMENTS BY jward, jsmith BY ACCESS WHENEVER SUCCESSFUL" db-types="Oracle" />
+ <sql-case id="audit_all_statements_in_session_current" value="AUDIT ALL STATEMENTS IN SESSION CURRENT" db-types="Oracle" />
</sql-cases>