You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by ke...@apache.org on 2023/01/03 09:55:11 UTC

[dolphinscheduler] 01/02: cherry-pick [Bug][DAO] Worked out the issue with throwing the sql exception.

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 <ji...@163.com>
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