版本2.5.7,随便找个表执行就出现这个错误,请问下是不支持on not exists吗?
select * from ass_monitoring a
left join ass_monitoring b
on b.digest = a.digest
and not EXISTS
(
select * from ass_monitoring c
where c.digest = b.digest and c.digest = ‘di_fw’
)
版本2.5.7,随便找个表执行就出现这个错误,请问下是不支持on not exists吗?
select * from ass_monitoring a
left join ass_monitoring b
on b.digest = a.digest
and not EXISTS
(
select * from ass_monitoring c
where c.digest = b.digest and c.digest = ‘di_fw’
)
报错信息是什么,相关子查询是支持 [NOT] EXISTS的
这个是on后面写 not exists 不是where条件里面,你随便找个表就能复现
感谢反馈,我这边复现下给您答复
我这边测试了 2.5.13 是不会报错的,建议进行升级。