You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by zh...@apache.org on 2022/12/28 06:21:56 UTC
[dolphinscheduler] 11/11: [fix][dml] Also query workflow without tenant by given name (#13075)
This is an automated email from the ASF dual-hosted git repository.
zhongjiajie pushed a commit to branch 3.0.4-prepare
in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git
commit e028e640af7481cb22b5c33159acaf0b33d374ec
Author: Jay Chung <zh...@gmail.com>
AuthorDate: Wed Dec 28 14:14:29 2022 +0800
[fix][dml] Also query workflow without tenant by given name (#13075)
before this, once remove user tenant, all users workflow
can not be found anymore, this patch fix this problem, make
this entrypoint can query workflow without tenant to its
users
(cherry picked from commit 6627c38be572a4b0621d6f9b4109d6143b8df7e3)
---
.../apache/dolphinscheduler/dao/mapper/ProcessDefinitionMapper.xml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProcessDefinitionMapper.xml b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProcessDefinitionMapper.xml
index 7ac596ea3c..4bad9cae9f 100644
--- a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProcessDefinitionMapper.xml
+++ b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProcessDefinitionMapper.xml
@@ -62,8 +62,8 @@
from t_ds_process_definition pd
JOIN t_ds_user u ON pd.user_id = u.id
JOIN t_ds_project p ON pd.project_code = p.code
- JOIN t_ds_tenant t ON t.id = u.tenant_id
- JOIN t_ds_queue q ON t.queue_id = q.id
+ LEFT JOIN t_ds_tenant t ON t.id = u.tenant_id
+ LEFT JOIN t_ds_queue q ON t.queue_id = q.id
WHERE p.code = #{projectCode}
and pd.name = #{processDefinitionName}
</select>