mybatis group by substr函数传参报错的解决

SELECT
    SUBSTR( region_code, 1,#{ queryMap.groupCodeLength, jdbcType = INTEGER } ) AS "region_code",
    count( CASE WHEN TYPE = 1 THEN 0 END ) AS "like",
    count( CASE WHEN TYPE = 2 THEN 0 END ) AS "roast" 
FROM
    t_pub_sentiment 
WHERE
    1 = 1 
GROUP BY
    SUBSTR(region_code,1,#{ queryMap.groupCodeLength,jdbcType = INTEGER })

SELECT
    SUBSTR( region_code, 1, $ { queryMap.groupCodeLength } ) AS "region_code",
    count( CASE WHEN TYPE = 1 THEN 0 END ) AS "like",
    count( CASE WHEN TYPE = 2 THEN 0 END ) AS "roast" 
FROM
    t_pub_sentiment 
WHERE
    1 = 1 
GROUP BY
    SUBSTR( region_code, 1, $ { queryMap.groupCodeLength } )

<resultMap id="deptMap" type="java.util.Map">
        <result column="id" property="id"/>
        <result column="dept_name" property="deptname"/>
        <result column="count(1)" property="count"/>
    </resultMap>
  
 <select id="getDeptByIdStep" resultMap="deptMap">
  select  id,dept_name,count(1)  from tbl_dept where dept_id=#{id} group by id;
 </select>

public List<Map> getDeptByIdStep(Integer id);