This is an automated email from the ASF dual-hosted git repository.
zhongjiajie pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git
The following commit(s) were added to refs/heads/dev by this push:
new 6627c38be5 [fix][dml] Also query workflow without tenant by given name
(#13075)
6627c38be5 is described below
commit 6627c38be572a4b0621d6f9b4109d6143b8df7e3
Author: Jay Chung <[email protected]>
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
---
.../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 7ba450d920..b075cebd1b 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>
