在用MyBatis+SpringBoot查询数据时,出现了Not showing null elements ,即数据库中只有三条数据,但是返回的list集合大小为4。映射文件如下的代码如下:
<select id="xxxx" resultType="xxx.xxx">
SELECT
tau.auth_name authName,
tau.`describe` `describe` ,
tau.is_delete isDelete
FROM t_admin tad
LEFT JOIN t_admin_auth taa
ON tad.xx= taa.xxx
LEFT JOIN t_auth tau
ON tau.xx= taa.xx
WHERE tad.xxx= #{xxx}
</select>
出现Not showing null elements的原因是我关联表查询时,连接顺序写反了,当我改成下面的语句时就没有错误了。
<select id="xxx" resultType="xxx.xxx">
SELECT
tau.auth_name authName,
tau.`describe` `describe` ,
tau.is_delete isDelete
FROM t_auth tau
LEFT JOIN t_admin_auth taa
ON tau.id = taa.auth_id
LEFT JOIN t_admin tad
ON tad.id = taa.admin_id
WHERE tad.xxx= #{xxx}
</select>