[incubator-dolphinscheduler] branch dev updated: Update TaskInstanceMapper.xml

[lidongdai]

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

lidongdai pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/incubator-dolphinscheduler.git


The following commit(s) were added to refs/heads/dev by this push:
     new 96c7a8c  Update TaskInstanceMapper.xml
     new 9798123  Merge pull request #4186 from wangxj3/dev
96c7a8c is described below

commit 96c7a8c7e919984fa9051d0e94bd0f8c1aa366aa
Author: wangxj3 <857234...@qq.com>
AuthorDate: Wed Dec 9 11:29:38 2020 +0800

    Update TaskInstanceMapper.xml
    
    optimize page of [TaskInstance] load data slow
---
 .../org/apache/dolphinscheduler/dao/mapper/TaskInstanceMapper.xml     | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git 
a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/TaskInstanceMapper.xml
 
b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/TaskInstanceMapper.xml
index 0d0d5ea..71bd251 100644
--- 
a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/TaskInstanceMapper.xml
+++ 
b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/TaskInstanceMapper.xml
@@ -120,8 +120,8 @@
         ,
         process.name as process_instance_name
         from t_ds_task_instance instance
-        join t_ds_process_definition define on instance.process_definition_id 
= define.id
-        join t_ds_process_instance process on 
process.id=instance.process_instance_id
+        left join t_ds_process_definition define on 
instance.process_definition_id = define.id
+        left join t_ds_process_instance process on 
process.id=instance.process_instance_id
         where define.project_id = #{projectId}
         <if test="startTime != null">
             and instance.start_time > #{startTime} and instance.start_time 
<![CDATA[ <=]]> #{endTime}