【原因】篩選數(shù)據(jù)類型和數(shù)據(jù)庫數(shù)據(jù)類型不符【解決】where條件逐一排查，查看是否符合數(shù)據(jù)類型，若條件較多則采用分批試運(yùn)行排查的方法 select * from workflow_requestlog where workflowid = 5085 and logtype = '3' -- and logtype = 3 logtype是char(1) and nodeid in ('11173', '11168') and OperaTEDATE > '2014-01-01'
