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

智能扫描导出文件用WPS查看异常换行优化 #2530

Closed
BugsGuru opened this issue Aug 8, 2024 · 1 comment · Fixed by #2521
Closed

智能扫描导出文件用WPS查看异常换行优化 #2530

BugsGuru opened this issue Aug 8, 2024 · 1 comment · Fixed by #2521
Assignees
@BugsGuru
Labels
bug Something isn't working publish-pre2 verified the issue all pr is verified
Milestone
v3.2408.0

Comments

@BugsGuru
Copy link
Collaborator

BugsGuru commented Aug 8, 2024 •
edited
Loading

描述（Describe）

智能扫描详情导出SQL的csv文件，使用WPS查看时异常换行。

截图或日志（Log）

img_v3_02dc_bc5cb120-52f0-4375-b3e7-cb8600e6813g

原因分析

Excel类工具单元格字符数存在上限（32767），达到这个上限就会导致换行。原始sql列内容会超过该限制。

优化方案

当字符数达到上限时，对列内容字符进行截取，并在末尾追加 ...标志。

变更影响面

受影响的模块或功能

智能扫描详情sql导出

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

版本兼容性

测试建议
@BugsGuru BugsGuru self-assigned this Aug 8, 2024
@BugsGuru BugsGuru mentioned this issue Aug 8, 2024
Merged
5 tasks
@ColdWaterLW ColdWaterLW added the bug Something isn't working label Aug 8, 2024
@ColdWaterLW ColdWaterLW added this to the v3.2408.0 milestone Aug 8, 2024
@hasa1K
Copy link
Contributor

hasa1K commented Aug 26, 2024

版本

sqle main-ee:3a655e65087af35075c0fffcb3863cb0da645aee

测试

准备手动修改数据库中的值，将sql_text字段存储的值长度超过32767
image

wps打开后，超过32767的部分用三个点替代了
image

@hasa1K hasa1K added the verified the issue all pr is verified label Aug 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@BugsGuru BugsGuru

Labels
bug Something isn't working publish-pre2 verified the issue all pr is verified
Projects
None yet
Milestone
v3.2408.0
Development

Successfully merging a pull request may close this issue.

truncate audit plan sql when exporting for Excel view actiontech/sqle
3 participants
@ColdWaterLW @hasa1K @BugsGuru