<select id="queryQuestionsByIds" resultMap="BaseResultMap">
SELECT
*
FROM question_tbl
where id in
<foreach collection="ids" item="id" open="(" close=")"
separator=",">
#{id}
</foreach>
<!-- order by find_in_set (id,
<foreach collection="s_ids" item="s_id" open="'"
close="'" separator=",">
#{s_id}
</foreach>
) --> 注释的地方有错误
</select>
List<Question> queryQuestionsByIds(Map<String, List<String>> m_ids);
报错信息如下：
### SQL: SELECT * FROM question_tbl where id in ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) order by find_in_set (id, ' ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ' )
### Cause: java.sql.SQLException: Parameter index out of range (19 > number of parameters, which is 18).
; SQL []; Parameter index out of range (19 > number of parameters, which is 18).; nested exception is java.sql.SQLException: Parameter index out of range (19 > number of parameters, which is 18).] with root cause
java.sql.SQLException: Parameter index out of range (19 > number of parameters, which is 18).
