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

审核包含--类型注释的SQL文件,解析出的SQL显示错误 #2343

Closed
winfredLIN opened this issue Apr 10, 2024 · 2 comments
Closed
Assignees
Labels
bug Something isn't working wontfix This will not be worked on

Comments

@winfredLIN
Copy link
Collaborator

winfredLIN commented Apr 10, 2024

版本信息(Version)

SQLE Version: 5070852

问题描述(Describe)

当审核的SQL文件中包含注释,审核无法正确的对--类型的注释与SQL语句进行正确的分割,导致SQL语句显示错误,页面未展示换行符,会让用户误以为SQL语句是一行.参考文档:https://dev.mysql.com/doc/refman/8.3/en/comments.html

截图或日志(Log)

image

image

如何复现(To Reproduce)

  1. 审核以下SQL,即可复现
    -- test
    INSERT INTO test (id, name)
    VALUES (788, 'test_788');
    

实现方案

变更影响面

@winfredLIN winfredLIN added the bug Something isn't working label Apr 10, 2024
@ColdWaterLW ColdWaterLW added this to the 3.2404.0 milestone Apr 10, 2024
@ColdWaterLW ColdWaterLW modified the milestones: 3.2404.0, 3.2405.0 Apr 22, 2024
@winfredLIN
Copy link
Collaborator Author

winfredLIN commented Apr 29, 2024

@taolx0 taolx0 removed their assignment May 8, 2024
@taolx0 taolx0 changed the title 审核包含--类型注释的SQL文件,解析出的SQL变为注释 审核包含--类型注释的SQL文件,解析出的SQL显示错误 May 8, 2024
@ColdWaterLW ColdWaterLW removed this from the 3.2405.0 milestone May 14, 2024
@Gygkimo95
Copy link
Collaborator

列表那里是因为空间展示问题做了让步处理(不会保留格式),在详情里里面是正常展示的,暂时不处理
img_v3_02as_988cc80d-af5c-4251-b67e-8b614ad5310g

@ColdWaterLW ColdWaterLW added the wontfix This will not be worked on label May 14, 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 wontfix This will not be worked on
Projects
None yet
Development

No branches or pull requests

5 participants