异常TooManyResultsException:Expectedoneresult(ornull)tobereturnedbyselectOne(),butfound:2SELECTID,LOCATORID,DATEFORMAT(DATE,'%H:%i:%S')ASDATE,CAST(TYPEASCHAR)ASTYPEFROMTRAILWHERECODE=#{minerCode,jdbcType=INTEGER}ANDDATEBETWE

Question

异常TooManyResultsException:Expected one result(or null) to be returned by selectOne(),but found:2
SELECT ID,LOCATORID,DATE_FORMAT(DATE,'%H:%i:%S') AS DATE,CAST(TYPE AS CHAR) AS TYPE
FROM TRAIL
WHERE CODE = #{minerCode,jdbcType=INTEGER}
AND DATE BETWEEN
STR_TO_DATE(DATE_FORMAT(#{date},'%Y-%m-%d %H:%i:%S'),'%Y-%m-%d %H:%i:%S')
AND date_add(date_add(STR_TO_DATE(DATE_FORMAT(#{date},'%Y-%m-%d %H:%i:%S'),'%Y-%m-%d %H:%i:%S'),interval 1 day),interval -1 second)

Answer 1

你希望返回一行,但实际select得到的,超过一行记录.
先查清楚WHERE条件,确定是返回一行的情况,再用selectOne