关于使用@select书写SQL注意的细节

关于使用@select书写SQL注意的细节

前言

关系sql是书写方式有很多种，几天记录下自己在使用@select书写遇到的几个细节问题

一、错误示范

下文的sql是其他同事提供的开发文档原文，在执行时遇到多出细节错误。

SQL:SELECT 
HA.HRAREA_ID HRAREAID,
HA.TYPE,
AM.NAMEC OWNER,
HA.WAYSNUM,
HA.HDMAPNUM,
HA.STATUS,
HA.CONFIRM_UID CONFIRMUID,
HA.CONFIRM_TIMESTAMP CONFIRMTIMSTAMP,
HA.CREATE_TIMESTAMP CREATETIMESTAMP
FROM TB_HRAREA HA LEFT JOIN TB_ADMIN AM 
ON HA.OWNER = AM.ADMINID
WHERE HA.ISDEL= FALSE
<IF TEST=HRAREAID!= NULL AND HRAREAID!=\"\" '  >
AND HA.HRAREAID= ${HRAREAID}
</IF>
<IF TEST = 'OWNER!= 0'>
AND HA.OWNER= ${OWNER}
</IF>
<IF TEST = TYPE!= 0'>
AND HA.TYPE = ${TYPE}
</IF>
<IF TEST = 'STATUS != NULL AND STATUS != \"\"'>
AND HA.STATUS = ${STATUS}
</IF>
<IF TEST = 'CONFIRMUID != 0'>