taigam commented on issue #8480:
URL: https://github.com/apache/shardingsphere/issues/8480#issuecomment-737689554
the mapper
`<select id="selectRepeatedMatrixInfoList"
resultMap="ResultMapRepetitionExtension">
select
app_code,
group_id,
matrix_pwd,
count(matrix_pwd) as repeatedCount
from
matrix_info
<where>
<if test="groupId != null and groupId != 0" >
group_id = #{groupId,jdbcType=INTEGER}
</if>
<if test="appCode != null and appCode != ''" >
app_code = #{appCode,jdbcType=VARCHAR}
</if>
<!-- and a.delete_flag = 0 -->
</where>
group by
matrix_pwd
<if test="minCount != null and minCount != 0" >
having count(matrix_pwd) >= #{minCount,jdbcType=INTEGER}
</if>
order by
count(matrix_pwd) desc
</select>`
it's with PageHelper
the final SQL result from jdbc is not the log show ? how to get it ?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
