Tag
null-handling
- Oct 23, 2024 Nulls, Three-Valued Logic, and the Constraints They Break How UNKNOWN propagates through SQL predicates, why NOT IN behaves unexpectedly with nulls, and which integrity constraints a null silently satisfies. databases
- Mar 9, 2022 Null Representation: Validity Bitmaps Against Sentinel Values How a columnar format records the absence of a value, why a separate bitmap costs one bit per value, and when an in-band sentinel breaks the type system. data engineering