[ 问题咨询 ] 数据库无法正常查询 提示脱敏异常

[ZhouMin-]

问题描述

数据库可以正常连接查询无法查询

报错信息:

[2020-10-29 16:17:45,074][DummyThread-7:139798316215880][task_id:default][inception.py:181][INFO]- {'ID': 1, 'statement': 'select * from area limit 100', 'errlevel': 1, 'query_tree': 'None', 'errmsg': "Identifier 'work' is keyword in MySQL.\n"}

[2020-10-29 16:17:45,074][DummyThread-7:139798316215880][task_id:default][inception.py:182][ERROR]- 打印日志: {'ID': 1, 'statement': 'select * from area limit 100', 'errlevel': 1, 'query_tree': 'None', 'errmsg': "Identifier 'work' is keyword in MySQL.\n"}
[2020-10-29 16:17:45,075][DummyThread-7:139798316215880][task_id:default][data_masking.py:37][WARNING]- 数据脱敏异常，错误信息：Traceback (most recent call last):

File "/septnet/data/Archery-1.7.8/sql/utils/data_masking.py", line 32, in data_masking
query_tree = inception_engine.query_print(instance=instance, db_name=db_name, sql=sql)
File "/septnet/data/Archery-1.7.8/sql/engines/inception.py", line 189, in query_print
raise RuntimeError(f"Inception Error: {print_info['errmsg']}")
RuntimeError: Inception Error: Identifier 'work' is keyword in MySQL.

Inception 错误如何解决

版本信息

• 应用版本/分支：Release v1.7.8
• 部署方式：手工部署

[hhyo]

#145
脱敏是有限的功能，可以配置inception相关参数，或者关闭脱敏校验

[hhyo]

hhyo/inception#12