=======================================================================
							SQL Statements
=======================================================================

Old Statement:	
SELECT COUNT(DISTINCT RES.ID_)
FROM ACT_RU_JOB RES
WHERE  RES.SUSPENSION_STATE_ = 1

----------------------------------------------

New Statement PostgreSQL:
SELECT COUNT(*) 
FROM (
	SELECT DISTINCT RES.ID_ 
	FROM ACT_RU_JOB RES
	WHERE RES.SUSPENSION_STATE_ = 1)

=======================================================================
			new Properties (in DbSqlSessionFactory.java)
=======================================================================

PostgreSQL:
countDistinctBeforeStart="SELECT COUNT(*) FROM (SELECT DISTINCT"
countDistinctBeforeEnd=""
countDistinctAfter=")"

Others:
countDistinctBeforeStart="select count(distinct"
countDistinctBeforeEnd=")"
countDistinctAfter=""

=======================================================================
							MyBatis Mapper
=======================================================================
Old Statement in Job.xml:
  <select id="selectJobCountByQueryCriteria" parameterType="org.camunda.bpm.engine.impl.JobQueryImpl" resultType="long">
    select count(distinct RES.ID_)
    <include refid="selectJobByQueryCriteriaSql"/>
  </select>

----------------------------------------------

New Statement in Job.xml:
  <select id="selectJobCountByQueryCriteria" parameterType="org.camunda.bpm.engine.impl.JobQueryImpl" resultType="long">
    ${countDistinctBeforeStart} RES.ID_ ${countDistinctBeforeEnd}
    <include refid="selectJobByQueryCriteriaSql"/>
	${countDistinctAfter}
  </select>