DataSphereStudio is a one stop data application development& management portal, covering scenarios including data exchange, desensitization/cleansing, analysis/mining, quality measurement, visualization, and task scheduling.
[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字段不存在导致的。
6-archer-9
commented
5 months ago
Search before asking
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?