[dolphinscheduler] branch 3.1.0-prepare updated: [Bug][Workflow Definition] fix ordinary users can not create depend task (#11961) (#11977)

[ca...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

caishunfeng pushed a commit to branch 3.1.0-prepare
in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git


The following commit(s) were added to refs/heads/3.1.0-prepare by this push:
     new cd8f32d876 [Bug][Workflow Definition] fix ordinary users can not create depend task (#11961) (#11977)
cd8f32d876 is described below

commit cd8f32d876fb5abc4e252e7a61e1732c8fac4e51
Author: caishunfeng <ca...@gmail.com>
AuthorDate: Fri Sep 16 09:42:59 2022 +0800

    [Bug][Workflow Definition] fix ordinary users can not create depend task (#11961) (#11977)
---
 .../org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml   | 10 ++++------
 1 file changed, 4 insertions(+), 6 deletions(-)

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 34c1247ea9..96a095d186 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
@@ -162,13 +162,11 @@
 
     <select id="queryAllProject" resultType="org.apache.dolphinscheduler.dao.entity.Project">
         select
-        <include refid="baseSqlV2">
-            <property name="alias" value="p"/>
-        </include>
-        from t_ds_project p
+        <include refid="baseSql"/>
+        from t_ds_project
+        where 1 = 1
         <if test="userId != 0">
-            right join t_ds_relation_project_user rpu on p.id = rpu.project_id
-            where rpu.user_id = #{userId}
+            and user_id = #{userId}
         </if>
     </select>