Worked on the paradedb/paradedb repository to enhance correctness and reliability in PostgreSQL query processing, focusing on the @@@ operator’s handling of NULL semantics. Addressed a bug where NULL values could incorrectly collapse to FALSE, ensuring accurate predicate evaluation for missing indexed fields. Introduced an existence guard for negated predicates and refined logic to distinguish between matched rows, non-matching rows, and missing fields across both custom scan and direct operator paths. Leveraged Rust and PostgreSQL expertise to implement precise NULL handling, expanded regression test coverage, and updated test fixtures, resulting in more reliable query results and improved PostgreSQL compatibility.