Fix handling of NULL constraint conditions: per SQL92 spec, a NULL result
Tom Lane <tgl@sss.pgh.pa.us>
Fix handling of NULL constraint conditions: per SQL92 spec, a NULL result from a constraint condition does not violate the constraint (cf. discussion on pghackers 12/9/99). Implemented by adding a parameter to ExecQual, specifying whether to return TRUE or FALSE when the qual result is really NULL in three-valued boolean logic. Currently, ExecRelCheck is the only caller that asks for TRUE, but if we find any other places that have the wrong response to NULL, it'll be easy to fix them.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/access/gist/gist.c | modified | +3 −3 |
| src/backend/access/hash/hash.c | modified | +3 −3 |
| src/backend/access/nbtree/nbtree.c | modified | +3 −3 |
| src/backend/access/rtree/rtree.c | modified | +3 −3 |
| src/backend/catalog/index.c | modified | +3 −3 |
| src/backend/commands/copy.c | modified | +2 −2 |
| src/backend/executor/execMain.c | modified | +7 −5 |
| src/backend/executor/execQual.c | modified | +50 −18 |
| src/backend/executor/execScan.c | modified | +4 −3 |
| src/backend/executor/execUtils.c | modified | +2 −4 |
| src/backend/executor/nodeAgg.c | modified | +2 −2 |
| src/backend/executor/nodeHash.c | modified | +2 −5 |
| src/backend/executor/nodeHashjoin.c | modified | +2 −4 |
| src/backend/executor/nodeIndexscan.c | modified | +5 −3 |
| src/backend/executor/nodeMergejoin.c | modified | +13 −13 |
| src/backend/executor/nodeNestloop.c | modified | +2 −4 |
| src/backend/executor/nodeResult.c | modified | +4 −2 |
| src/include/executor/executor.h | modified | +3 −14 |
| src/test/regress/input/constraints.source | modified | +8 −2 |
| src/test/regress/output/constraints.source | modified | +22 −8 |