【原因】篩選數(shù)據(jù)類(lèi)型和數(shù)據(jù)庫(kù)數(shù)據(jù)類(lèi)型不符【解決】where條件逐一排查,查看是否符合數(shù)據(jù)類(lèi)型,若條件較多則采用分批試運(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'