工作CASE_1 Hold Lot 已经Release但是Hold记录为空

说明：

DWT_HOLD_LOT 的Hold Lot Hold Event('Hold','EditHoldComment','Release')，且每个Event都为一条记录，每条记录都有对应的RELEASE_EVENT_TIME，HOLD_SYS_ID，HOLD_RELEASE

HOLD LOT已经Release，但是对应HOLD记录的Release时间是空的

SELECT * FROM DWT_HOLD_LOT dhl        
WHERE lot_ID='BS00284'       
AND  HOLD_SYS_ID='00000e2e.0b5617ac.6734b619.000023a6.2119515'

反馈IT查看修正

验证SQL：

SELECT * FROM DWT_HOLD_LOT t2
WHERE EXISTS (
SELECT 1 FROM DWT_HOLD_LOT t1 
WHERE t1.HOLD_RELEASE IS NOT  NULL
AND t1.HOLD_SYS_ID=t2.HOLD_SYS_ID
)
AND t2.EVENT_NAME IN ('Hold','EditHoldComment','RunningHold')
AND t2.HOLD_RELEASE IS NULL