本文内容来自 YashanDB 官网，原文内容请见 审计表 UNIFIED_AUDIT_TRAIL 出现 YAS-00220 utf8 sequence is wrong-YashanDB

-- 第一步：打开审计开关

SQL> ALTER SYSTEM SET UNIFIED_AUDITING = true;

Succeed.

-- 创建审计策略

CREATE AUDIT POLICY up2

ACTIONS DROP TABLE,DELETE ON sales.area,INSERT ON sales.area,UPDATE ON sales.area,ALL ON sales.sales_info;

AUDIT POLICY up2;

-- 第二步：执行操作被正常记录

SQL> conn sales/sales

Connected to:

YashanDB Server Enterprise Edition Release 23.2.7.100 x86_64 - Linux

SQL> UPDATE area SET DHQ='guangzhou' WHERE area_no='01';

1 row affected.

SQL> commit;

Succeed.

SQL> SELECT dbusername,event_timestamp,sql_text,object_schema

FROM UNIFIED_AUDIT_TRAIL

WHERE dbusername='SALES'; 2 3

DBUSERNAME EVENT_TIMESTAMP SQL_TEXT OBJECT_SCHEMA

---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- ----------------------------------------------------------------

SALES 2024-12-11 09:52:27.602837 UPDATE area SET DHQ='guangzhou' WHERE area_no='01' SALES

1 row fetched.

-- 第三步：其中 ' 广.' 为非正常中文字段，查看审计表出现报错

SQL> UPDATE area SET DHQ=' 广.' WHERE area_no='01';

1 row affected.

SQL> commit;

Succeed.

SQL> SELECT dbusername,event_timestamp,sql_text,object_schema

FROM UNIFIED_AUDIT_TRAIL

WHERE dbusername='SALES'; 2 3

DBUSERNAME EVENT_TIMESTAMP SQL_TEXT OBJECT_SCHEMA

---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- ----------------------------------------------------------------

SALES 2024-12-11 09:52:27.602837 UPDATE area SET DHQ='guangzhou' WHERE area_no='01' SALES

YAS-00220 utf8 sequence is wrong

-- 第四步：执行操作无法被正常记录

SQL> UPDATE area SET DHQ='guangzhou' WHERE area_no='01';

1 row affected.

SQL> commit;

Succeed.

SQL> SELECT dbusername,event_timestamp,sql_text,object_schema FROM UNIFIED_AUDIT_TRAIL WHERE dbusername='SALES';

DBUSERNAME EVENT_TIMESTAMP SQL_TEXT OBJECT_SCHEMA

---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- ----------------------------------------------------------------

SALES 2024-12-11 09:52:27.602837 UPDATE area SET DHQ='guangzhou' WHERE area_no='01' SALES

YAS-00220 utf8 sequence is wrong