In SQL, most operations that contain NULL will propagate NULL to the result of the operation. PartiQL specifies two unknown values -- MISSING and NULL. For an operation with operands of both these values, the PartiQL spec currently doesn't define the result behavior (i.e. whether it should result in MISSING or NULL).
In SQL, most operations that contain
NULLwill propagateNULLto the result of the operation. PartiQL specifies two unknown values --MISSINGandNULL. For an operation with operands of both these values, the PartiQL spec currently doesn't define the result behavior (i.e. whether it should result inMISSINGorNULL).