Fix ExecSubPlan to handle nulls per the SQL spec --- it didn't combine
Tom Lane <tgl@sss.pgh.pa.us>
Fix ExecSubPlan to handle nulls per the SQL spec --- it didn't combine nulls with non-nulls using proper three-valued boolean logic. Also clean up ExecQual to make it clearer that ExecQual *does* follow the SQL spec for boolean nulls. See '[BUGS] (null) != (null)' thread around 10/26/99 for more detail.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/executor/execQual.c | modified | +33 −59 |
| src/backend/executor/nodeSubplan.c | modified | +112 −46 |
| src/include/executor/nodeSubplan.h | modified | +2 −1 |