[Bug] not in 子查询的bug

[prosejazz]

Search before asking

• I had searched in the issues and found no similar issues.

Version

3.0

What's Wrong?

not in 子查询结果非预期
select * from subjects where id not in (
select subjectsId from deliver
)
查询结果为空，原因select subjectsId from deliver子查询中的结果有null
修改为
select * from subjects where id not in (
select subjectsId from deliver where subjectsId is not null
)
可达到预期结果

What You Expected?

同上

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct