can't compare NULL type with NULL type

[liukun4515]

Describe the bug
A clear and concise description of what the bug is.

❯ select null and null;
ArrowError(ExternalError(Internal("Cannot evaluate binary expression And with types Null and Null")))
❯ select null or null;
ArrowError(ExternalError(Internal("Cannot evaluate binary expression Or with types Null and Null")))

To Reproduce
Steps to reproduce the behavior:

Expected behavior
A clear and concise description of what you expected to happen.

Additional context
Add any other context about the problem here.

[liukun4515]

maybe has been fixed by #4242

[HaoYang670]

Two cases not supported yet:

❯ select null and null;
ArrowError(ExternalError(Internal("Cannot evaluate binary expression And with types Null and Null")))
❯ select null or null;
ArrowError(ExternalError(Internal("Cannot evaluate binary expression Or with types Null and Null")))

While on Postgre, we get nulls: https://onecompiler.com/postgresql/3ypsr7k27

[jackwener]

I can take it up.

[melgenek]

@jackwener Hey! This issue is assigned to you. But I bumped into it and decided to give it a try, so I opened a pr #5158. I hope it is alright.