This is an automated email from the ASF dual-hosted git repository.
wangjipeng 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 d0f5e7edf3 optimize the process instance query, change the date time
range (#11719)
d0f5e7edf3 is described below
commit d0f5e7edf34a71e31bd2f5fa376bf235b395ec7d
Author: juzimao <[email protected]>
AuthorDate: Wed Aug 31 19:53:41 2022 +0800
optimize the process instance query, change the date time range (#11719)
---
.../org/apache/dolphinscheduler/dao/mapper/ProcessInstanceMapper.xml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git
a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProcessInstanceMapper.xml
b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProcessInstanceMapper.xml
index 0b44f6b027..49553621d1 100644
---
a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProcessInstanceMapper.xml
+++
b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProcessInstanceMapper.xml
@@ -122,8 +122,8 @@
<if test="searchVal != null and searchVal != ''">
and instance.name like concat('%', #{searchVal}, '%')
</if>
- <if test="startTime != null ">
- and instance.start_time > #{startTime} and instance.start_time
<![CDATA[ <=]]> #{endTime}
+ <if test="startTime != null and endTime != null ">
+ and instance.start_time <![CDATA[ >= ]]> #{startTime} and
instance.start_time <![CDATA[ <= ]]> #{endTime}
</if>
<if test="states != null and states.length > 0">
and instance.state in
