Redundant RETRIES predicate in 'selectExclusiveJobsToExecute'

Description

Predicate (RETRIES_ > 0) is contained twice in the where clause.

<select id="selectExclusiveJobsToExecute" parameterType="map" resultMap="jobResultMap">
select *
from ACT_RU_JOB
where (RETRIES_ &gt; 0)
and (DUEDATE_ is null or DUEDATE_ &lt; #{now, jdbcType=TIMESTAMP})
and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ &lt; #{now, jdbcType=TIMESTAMP})
and (RETRIES_ &gt; 0)
and (EXCLUSIVE_ = TRUE)
and (PROCESS_INSTANCE_ID_ = #{pid})
</select>

Assignee

Bernd Ruecker (camunda)

Reporter

Etienne Studer

Labels

None

Fix versions

Priority

Major
Configure