graph does not filter out record correctly

[nebula-bots]

Please check the FAQ documentation before raising an issue

Describe the bug (required)

Look at the two queries below:

(root@nebula) [gdlancer]> MATCH (v0)<-[e0]-()<-[e1]-(v1) WHERE (id(v0) == 6) return  ((NOT (NOT ((v1.Label_6.Label_6_5_Int > (e1.Rel_0_5_Int - 0.300177)) AND v1.Label_6.Label_6_1_Bool))))

+--------------------------------------------------------------------------------------------+
| !(!(((v1.Label_6.Label_6_5_Int>(e1.Rel_0_5_Int-0.300177)) AND v1.Label_6.Label_6_1_Bool))) |
+--------------------------------------------------------------------------------------------+
| __NULL__                                                                                   |
| false                                                                                      |
| true                                                                                       |
| false                                                                                      |
| false                                                                                      |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| false                                                                                      |
| true                                                                                       |
| false                                                                                      |
| false                                                                                      |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
+--------------------------------------------------------------------------------------------+
Got 26 rows (time spent 3.265ms/22.177125ms)

Thu, 12 Jan 2023 18:39:01 CST

(root@nebula) [gdlancer]> MATCH (v0)<-[e0]-()<-[e1]-(v1) WHERE (id(v0) == 6) AND ((NOT (NOT ((v1.Label_6.Label_6_5_Int > (e1.Rel_0_5_Int - 0.300177)) AND v1.Label_6.Label_6_1_Bool)))) RETURN  ((NOT (NOT ((v1.Label_6.Label_6_5_Int > (e1.Rel_0_5_Int - 0.300177)) AND v1.Label_6.Label_6_1_Bool))))
+--------------------------------------------------------------------------------------------+
| !(!(((v1.Label_6.Label_6_5_Int>(e1.Rel_0_5_Int-0.300177)) AND v1.Label_6.Label_6_1_Bool))) |
+--------------------------------------------------------------------------------------------+
| __NULL__                                                                                   |
| true                                                                                       |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
| true                                                                                       |
| __NULL__                                                                                   |
| __NULL__                                                                                   |
+--------------------------------------------------------------------------------------------+
Got 8 rows (time spent 2.713ms/17.916709ms)

Thu, 12 Jan 2023 18:39:04 CST

(root@nebula) [gdlancer]>

The second query conflict to the first query, the problem is that Nebula does filter out the rows with NULL value in the where predicate.

Your Environments (required)

• OS: uname -a
• Compiler: g++ --version or clang++ --version
• CPU: lscpu
• Commit id (e.g. a3ffc7d8) https://github.com/vesoft-inc/nebula-ent/commit/261433608ccb385339a610a3877014377defc379

How To Reproduce(required)

Steps to reproduce the behavior:

1. Step 1
2. Step 2
3. Step 3

Expected behavior

Additional context