Skip to content

工作台使用SQL获取查询结果后再做筛选/排序动作报错 #486

Closed
Closed
工作台使用SQL获取查询结果后再做筛选/排序动作报错#486
Assignees
LordofAvernus
Labels
bugSomething isn't working
Milestone
v4.2506.0

Description

@LordofAvernus
LordofAvernus
opened on Jul 4, 2025

版本信息（Version）

v4.2505

问题描述（Describe）

工作台使用SQL获取查询结果后再做筛选/排序动作报错

截图或日志（Log）

image

如何复现（To Reproduce）

  • CB工作台执行SQL查询
    image
  • 对查询结果再次执行排序报错
    image
    image
  • 对查询结果再次执行筛选报错
    image
    image

问题原因

由于前端传递的参数是int.平台解析参数通过jaon.unmarshall解析转换成了float64,导致CB执行时候类型不匹配报错

解决方案

对预期为int的值强制转换为int

变更影响面

受影响的模块或功能

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

版本兼容性

测试建议

Activity

  1. LordofAvernus
    added this to the v4.2506.0 milestone on Jul 4, 2025

  2. LordofAvernus commented on Jul 4, 2025

    @LordofAvernus
    LordofAvernus
    on Jul 4, 2025
    CollaboratorAuthor

    自测：

    • 排序
      Image
    • 筛选
      Image
  3. LordofAvernus
    self-assigned this
    on Jul 4, 2025
  4. LordofAvernus
    added
    bugSomething isn't working
    on Jul 4, 2025

  5. LordofAvernus commented on Jul 4, 2025

    @LordofAvernus
    LordofAvernus
    on Jul 4, 2025
    CollaboratorAuthor
    • Oracle执行的SQL结束符为分号会导致筛选失败【优化】
      Image
  6. LordofAvernus
    closed this as completedon Jul 7, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions