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 <[email protected]>
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>
