Skip to content

Online报表左联SQL运行错误 #9220

@chivasan

Description

@chivasan
版本号:3.9.0
分支:main
问题描述:

继上次修复Online报表动态参数问题后,现原本能够预览的报表报错java.lang.ClassCastException,报表SQL
SELECT * FROM test_order_main a LEFT JOIN (SELECT order_id, COUNT(1) AS total FROM test_order_customer GROUP BY order_id) b ON a.id=b.order_id ORDER BY b.total DESC,设置如下图,现预览后台报表,无法得到正确数据集

Image
错误截图:
Image

附原issue:#9000

友情提示:

  • 未按格式要求发帖、描述过于简单的,会被直接删掉;
  • 描述问题请图文并茂,方便我们理解并快速定位问题;
  • 如果使用的不是master,请说明你使用的分支;

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions