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 <[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 (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>
