当iBATIS出项某个列不存在的问题

<statement id="queryNewTmpSIList" resultClass="siInfo"
  parameterClass="siqry" >
  <dynamic prepend="">
   <isEqual property="qryFlag" compareValue="1">
   select * from adc_spinfotmp a where a.status = 0
   </isEqual>
   <isEqual property="qryFlag" compareValue="2">
   select * from adc_spinfo a where a.status = 7
   </isEqual>
   <isEqual property="qryFlag" compareValue="3">
    select * from adc_spinfo a where 1=1
   </isEqual>
   <isEqual property="qryFlag" compareValue="4">
    select a.* from adc_spinfo a,adc_sptype b where a.status = 1 and a.sptype=b.sptype
   </isEqual>
   <isEqual property="qryFlag" compareValue="5">
   select a.* from adc_spinfo a where (a.status = 1 or a.status=7)
   </isEqual>
   <isEqual property="qryFlag" compareValue="6">
   select * from adc_spinfotmp a where 1 = 1
   </isEqual>
   <isEqual property="qryFlag" compareValue="7">
   select  a.* from adc_spinfo a, adc_workbill b
                    where b.billtype<![CDATA[<]]>3 and a.spid=b.billkey
   </isEqual>
   <isEqual property="qryFlag" compareValue="7">
    <isEqual property="status" compareValue="0">
     and 1=1
    </isEqual>
    <isEqual property="status" compareValue="1">
     and a.status = 1
    </isEqual>
    <isEqual property="status" compareValue="5">
     and a.status = 5
    </isEqual>
    <isEqual property="status" compareValue="6">
     and a.status = 6
    </isEqual>
    <isEqual property="status" compareValue="7">
     and a.status = 7
    </isEqual>
   </isEqual>
   <isNotEmpty prepend="AND" property="spid">
    spid = #spid#
   </isNotEmpty>
   <isNotEmpty prepend="AND" property="spname">
    spname like '%$spname$%' escape '/'
   </isNotEmpty>
   <isNotEmpty prepend="AND" property="spcode">
    spcode like '%$spcode$%'
   </isNotEmpty>
   <isNotEmpty prepend="AND" property="sptype">
    a.sptype =#sptype#
   </isNotEmpty>
   <isNotEmpty prepend="AND" property="begintime">
    opentime  <![CDATA[>=]]> to_date('$begintime$','yyyy-mm-dd hh:mi:ss')
   </isNotEmpty>
   <isNotEmpty prepend="AND" property="endtime">
    endtime <![CDATA[<=]]> to_date('$endtime$','yyyy-mm-dd hh:mi:ss')
   </isNotEmpty>
   <isNotEmpty prepend="AND" property="areapath">
    areapath like '%$areapath$%'
   </isNotEmpty>
   order by opentime desc
  </dynamic>
 </statement><!--  查询临时SI表记录总数 -->

 

生成的sql语句没有问题  而跑出了数据库中没有某一个的异常时 在select 加上

remapResults="true"就可以了