This is an automated email from the ASF dual-hosted git repository. kerwin pushed a commit to branch 3.1.3-prepare in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git
commit b46ced7af6f045dca0f976485630c5a580580df5 Author: calvin <[email protected]> AuthorDate: Tue Dec 20 17:54:47 2022 +0800 cherry-pick [Bug][DAO] Worked out the issue with throwing the sql exception. --- .../resources/org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml index d01d970ee1..3fbaf99e45 100644 --- a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml +++ b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml @@ -105,7 +105,8 @@ OR p.description LIKE concat('%', #{searchName}, '%') ) </if> - order by p.create_time desc + group by p.id,u.user_name + order by p.id desc </select> <select id="queryAuthedProjectListByUserId" resultType="org.apache.dolphinscheduler.dao.entity.Project"> select
