[Bug] DSS用户管理页面查询分页的时候提示错误

[yubingkun]

Search before asking

• 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({
"<script>",
"select distinct created_by as creator, username as username, create_time as joinTime,workspace_id as workspaceId " +
"from dss_workspace_user_role where workspace_id = #{workspaceId} ",
"and username=#{username} order by id desc",
"</script>"
})
这里没有order by id ,id字段不存在导致的。

Anything else

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

[6-archer-9]

这个bug 到现在还没修