DataSphereStudio

DataSphereStudio copied to clipboard

Search before asking

• [X] I searched the issues and found no similar issues.

DSS Component

dss-framework

What happened + What you expected to happen

在工作空间管理页面->用户信息分页查询的时候提示失败。

{"method":null,"status":1,"message":"operation failed(操作失败)s！the reason(原因)：SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'dss.dss_workspace_user_role.id' which is not in SELECT list; this is incompatible with DISTINCT","data":{"errorMsg":{"serviceKind":"dss-framework-project-server","level":2,"port":9202,"errCode":0,"ip":"yubingkun","desc":"operation failed(操作失败)s！the reason(原因)：SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'dss.dss_workspace_user_role.id' which is not in SELECT list; this is incompatible with DISTINCT"}}}

Relevent platform

系统：windows； 浏览器：chrome

Reproduction script

发现是在DSS branch-1.1.0代码中DSSWorkspaceUserMapper。
@Select({ "" }) 这里没有order by id ,id字段不存在导致的。

Anything else

No response

Are you willing to submit a PR?

• [ ] Yes I am willing to submit a PR!