mybatis中使用union出现Cannot convert string ‘WECHAT‘ to java.sql.Timestamp value

问题：

rg.springframework.dao.DataIntegrityViolationException: Error attempting to get column 'create_time' from result set.  Cause: java.sql.SQLDataException: Cannot convert string 'WECHAT' to java.sql.Timestamp value
; ]; Cannot convert string 'WECHAT' to java.sql.Timestamp value; nested exception is java.sql.SQLDataException: Cannot convert string 'WECHAT' to java.sql.Timestamp value

原因：

我union前后的两个语句的字段排列不一致，导致转换成实体类出错。

(Select info.order_id,info.status,info.no,'1' as type,info.create_time,info.trade_type,from t_info info
)
union all(select refun.id,refun.status,refun.no,'2' as type,refun.trade_type,refunpay.create_time,
from t_refund_info refun)

连个select 语句的查询结果必须字段一致，顺序一致。