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.

Sign up for GitHub

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

Jump to bottom

oracle top sql 不支持生成指纹,导致SQL管控例外匹配失败 #2787

Open
taolx0 opened this issue Nov 29, 2024 · 0 comments
Open

oracle top sql 不支持生成指纹,导致SQL管控例外匹配失败 #2787

taolx0 opened this issue Nov 29, 2024 · 0 comments
Assignees
@ColdWaterLW
Labels
bug Something isn't working publish-rel
Milestone
v3.2412.0

Comments

@taolx0
Copy link
Contributor

taolx0 commented Nov 29, 2024 •
edited by LordofAvernus
Loading

版本信息（Version）

39357ce

问题描述（Describe）

oracle top sql 不支持生成指纹,导致SQL管控例外匹配失败

截图或日志（Log）

如何复现（To Reproduce）

问题原因

oracle top sql 不支持指纹

sqle/sqle/server/auditplan/task_type_oracle_topsql.go

Line 145 in b68ff29

Fingerprint: sql.SQLFullText,

解决方案

  • oracle top sql通过查询视图表获取结果，该视图表存在字段sql_id即为sql指纹
  1. oracle提供的sql_id的阅读性差，并且不容易自行修改（格式为13位字符：gngtvs38t0060）
  2. 变量和注释不同不会影响到sql_id的生成

image

  • 目前SQL指纹的功能特点，只有部分数据库实现(mysql/db2）
       部分数据库本体支持sql指纹的功能，例如oracle
       不支持的数据库需要提供专门实现sql指纹的方式,实现一个通用的根据sql获取指纹的接口方法
      （去除空格

变更影响面

受影响的模块或功能

外部引用的潜在问题或风险

版本兼容性

测试建议
@taolx0 taolx0 added the bug Something isn't working label Nov 29, 2024
@ColdWaterLW ColdWaterLW added this to the v3.2412.0 milestone Nov 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ColdWaterLW ColdWaterLW

Labels
bug Something isn't working publish-rel
Projects
None yet
Milestone
v3.2412.0
Development

No branches or pull requests
3 participants
@LordofAvernus @ColdWaterLW @taolx0