UNION ALL 的时候由于类型不一致返回地址

csdn_526654341 2018-01-09 07:59:02

sql语句：
<select id="findQuantityPrescription" resultType="map" parameterType="map">

SELECT CONCAT(count(1),'') prescriptionNum FROM (SELECT
count(1)
FROM casemanagement cm
INNER JOIN prescriptionrecord pd ON cm.id = pd.caseId
WHERE
1 = 1
<if test="doctorId != null and doctorId != '' ">
AND cm.doctorId = #{doctorId}
</if>
<if test="clinicId != null and clinicId != '' ">
AND cm.clinicId = #{clinicId}
</if>
<if test=" startTime == null or startTime == '' ">
AND pd.createTime BETWEEN CONCAT(DATE_FORMAT(now(),'%Y-%m'),'-01',' ','00:00:00')
AND CONCAT(DATE_FORMAT(now(),'%Y-%m-%d'),' ','23:59:59')
</if>
<if test=" startTime != null and startTime != '' ">
AND pd.createTime BETWEEN CONCAT(#{startTime},' ','00:00:00')
AND CONCAT(DATE_FORMAT(#{endTime},' ','23:59:59')
</if>
GROUP BY
pd.caseId) a

UNION ALL
SELECT CONCAT(count(1),'') diagnosisNum FROM casemanagement WHERE 1 = 1
<if test="doctorId != null and doctorId != '' ">
AND doctorId = #{doctorId}
</if>
<if test="clinicId != null and clinicId != '' ">
AND clinicId = #{clinicId}
</if>
<if test=" startTime == null or startTime == '' ">
AND createTime BETWEEN CONCAT(DATE_FORMAT(now(),'%Y-%m'),'-01',' ','00:00:00')
AND CONCAT(DATE_FORMAT(now(),'%Y-%m-%d'),' ','23:59:59')
</if>
<if test=" startTime != null and startTime != '' ">
AND pd.createTime BETWEEN CONCAT(#{startTime},' ','00:00:00')
AND CONCAT(DATE_FORMAT(#{endTime},' ','23:59:59')
</if>

UNION ALL
SELECT
CONCAT(
format (count(
CASE
WHEN cm.diagnosis = 'visit' THEN
'visit'
END
) * 100.0 / count(1),2
),'%')
revisit
FROM
casemanagement cm
WHERE 1 = 1
<if test="doctorId != null and doctorId != '' ">
AND doctorId = #{doctorId}
</if>
<if test="clinicId != null and clinicId != '' ">
AND clinicId = #{clinicId}
</if>
<if test=" startTime == null or startTime == '' ">
AND createTime BETWEEN CONCAT(DATE_FORMAT(now(),'%Y-%m'),'-01',' ','00:00:00')
AND CONCAT(DATE_FORMAT(now(),'%Y-%m-%d'),' ','23:59:59')
</if>
<if test=" startTime != null and startTime != '' ">
AND pd.createTime BETWEEN CONCAT(#{startTime},' ','00:00:00')
AND CONCAT(DATE_FORMAT(#{endTime},' ','23:59:59')
</if>
</select>

返回值：
"prescriptionNum": "[B@7dde2e9f",
"prescriptionNum": "[B@131d5600",

...全文