|
mysql数据库迁移PostgreSQL 出现
错误org.apache.openjpa.persistence.PersistenceException: 错误: 操作符不存在: character varying = boolean
建议:没有匹配指定名称和参数类型的操作符. 您也许需要增加明确的类型转换.
位置:455 {prepstmnt 1110918338 SELECT t0.xid FROM public.CAL_EVENT t0 LEFT OUTER JOIN public.CAL_EVENT_manageablePersonList t1 ON t0.xid = t1.CALENDAR_EVENT_XID LEFT OUTER JOIN public.CAL_EVENT_viewablePersonList t2 ON t0.xid = t2.CALENDAR_EVENT_XID WHERE (t0.xcalendarId = ? AND t0.xcalendarId IS NOT NULL AND t0.xeventType = ? AND t0.xcreatePerson = ? AND t0.xstartTime <= ? AND t0.xendTime >= ? AND (t1.xmanageablePersonList = ? OR t2.xviewablePersonList = ? OR t0.xisPublic = ?))} [code=0, state=42883]
数据迁移工具是用的Navicat内置的 工具-数据传输 功能
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有账号?立即注册
x
|