项目场景:对三个表联查的多条件动态,分页查询
问题描述
使用分页和原生sql时报参数被默默忽视的错误,虽然对查询出的结果没有影响,能正常返回结果
INFO-- Silently ignoring
改进前:
@Query(value = "select " +
"sw.*, qw.expected_result, qw.update_at, qw.create_at, qw.update_by_id, u.name " +
// "sw.stock_id, sw.seq, sw.word, sw.site_code, qw.expected_result, qw.update_at, qw.create_at, qw.update_by_id, u.name " +
"from ess_stock_word sw " +
"left join ess_query_word qw on qw.word=sw.word and qw.site_code=sw.site_code " +
"left join gl2_user u on qw.update_by_id=u.user_id " +
"where " +