Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

xml文件审核,pg插件报错 #2356

Open
hasa1K opened this issue Apr 16, 2024 · 0 comments
Open

xml文件审核,pg插件报错 #2356

hasa1K opened this issue Apr 16, 2024 · 0 comments
Assignees
Labels
bug Something isn't working
Milestone

Comments

@hasa1K
Copy link
Collaborator

hasa1K commented Apr 16, 2024

版本信息(Version)

v3 86cd961

问题描述(Describe)

使用pg数据源对xml进行文件审核,发生报错

截图或日志(Log)

页面表现:
image
sqled.log日志:
time="2024-04-15T18:25:51+08:00" level=error msg="fail to call plugin interface [Parse], error: rpc error: code = Unknown desc = syntax error at or near "`"" plugin=PostgreSQL plugin_version=2 session_id=GEeoeRpbQOqVB9L8K6t2 thread_id=GPO

排查过程

后端进行xml解析时,会将sql中的字段名和表名加上反引号
image
将解析之后的sql,放入pg中执行,同样出现该问题
image

如何复现(To Reproduce)

  1. 添加pg数据源
  2. 使用pg数据源,进行xml文件审核

实现方案

变更影响面

@hasa1K hasa1K added the bug Something isn't working label Apr 16, 2024
@ColdWaterLW ColdWaterLW added this to the 3.2404.0 milestone Apr 16, 2024
@ColdWaterLW ColdWaterLW assigned hasa1K and unassigned ColdWaterLW Apr 16, 2024
@ColdWaterLW ColdWaterLW modified the milestones: 3.2404.0, 3.2405.0 Apr 22, 2024
@ColdWaterLW ColdWaterLW modified the milestones: v3.2405.0, v3.2406.0 May 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants