2026-05-19 22:04
我修改了一下sql，select id as "id",bat_no as "bat_no",pal_no as "pal_no",pstatus as "pstatus",ptype as "ptype",quantity as "quantity",tenant_id as "tenant_id",create_user as "create_user",create_time as "create_time",create_dept as "create_dept",update_user as "update_user",update_time as "update_time",is_deleted as "is_deleted",(select count(sn.id) as sn_quantity from tab_info sn where sn.is_deleted = 0 and sn.status = 1 and sn.pal_no = tbl.pal_no) as "snquantity" from tab_palinfo tbl where tbl.is_deleted = 0 AND #{jeelowcode_auto_where} 去掉哪些过滤，只保留了AND #{jeelowcode_auto_where}，我不使用查询条件，可以查询出数据，只要增加查询条件，就抛空指针
java.lang.NullPointerException
at com.jeelowcode.framework.plus.build.buildmodel.wrapper.SqlInfoQueryWrapper$Wrapper.buildSql(SqlInfoQueryWrapper.java:215)
at com.jeelowcode.core.framework.config.aspect.enhance.JeeLowCodeAnnoaionAspectjSQL.getAutoWhereSql(JeeLowCodeAnnoaionAspectjSQL.java:559)
at com.jeelowcode.core.framework.config.aspect.enhance.JeeLowCodeAnnoaionAspectjSQL.executeEnhanceAfterPage(JeeLowCodeAnnoaionAspectjSQL.java:318)
at com.jeelowcode.core.framework.config.aspect.enhance.JeeLowCodeAnnoaionAspectjSQL.executSQLPlugin(JeeLowCodeAnnoaionAspectjSQL.java:215)
at com.jeelowcode.core.framework.config.aspect.enhance.JeeLowCodeAnnoaionAspectjSQL.afterReturingAdvice(JeeLowCodeAnnoaionAspectjSQL.java:114)
at sun.reflect.GeneratedMethodAccessor892.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
2026-05-18 18:18
我在sql增强中这样配置，查询报空指针异常，(select count(sn.id) as sn_quantity from tab_info sn where sn.is_deleted = 0 and sn.status = 1 and sn.pal_no = tbl.pal_no) as "snquantity" 这个是我设置的一个虚拟字段，虚拟字段使用sql查询，帮忙看看 这个哪里不对。。
select id as "id",
bat_no as "bat_no",
pal_no as "pal_no",
pstatus as "pstatus",
ptype as "ptype",
quantity as "quantity",
tenant_id as "tenant_id",
create_user as "create_user",
create_time as "create_time",
create_dept as "create_dept",
update_user as "update_user",
update_time as "update_time",
is_deleted as "is_deleted",
(select count(sn.id) as sn_quantity from tab_info sn where sn.is_deleted = 0 and sn.status = 1 and sn.pal_no = tbl.pal_no) as "snquantity"
from tab_palinfo tbl where 1=1
AND
IFNULL(#{sn_numstatus} '') = '',
OR #{sn_numstatus} = 0 and tbl.quantity > (select count(sn.id) as sn_quantity from tab_info sn where sn.is_deleted = 0 and sn.status = 1 and sn.pal_no = tbl.pal_no)
OR
#{sn_numstatus} = 1
AND tbl.quantity = (select count(sn.id) as sn_quantity from tab_info sn where sn.is_deleted = 0 and sn.status = 1 and sn.pal_no = tbl.pal_noo)
AND #{jeelowcode_auto_where}
