diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2018-02-15 16:25:19 -0500 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2018-02-15 16:25:19 -0500 |
commit | 51db0d18fbf58b0c2e5ebc2b5b2c48daf45c8d93 (patch) | |
tree | 30fe1118750ea9c2805bd38a7485390f4d381715 /src/backend/executor/nodeWindowAgg.c | |
parent | 439c7bc1a070d746fab69d8696fca78673e64ba9 (diff) | |
download | postgresql-51db0d18fbf58b0c2e5ebc2b5b2c48daf45c8d93.tar.gz postgresql-51db0d18fbf58b0c2e5ebc2b5b2c48daf45c8d93.zip |
Fix plpgsql to enforce domain checks when returning a NULL domain value.
If a plpgsql function is declared to return a domain type, and the domain's
constraints forbid a null value, it was nonetheless possible to return
NULL, because we didn't bother to check the constraints for a null result.
I'd noticed this while fooling with domains-over-composite, but had not
gotten around to fixing it immediately.
Add a regression test script exercising this and various other domain
cases, largely borrowed from the plpython_types test.
Although this is clearly a bug fix, I'm not sure whether anyone would
thank us for changing the behavior in stable branches, so I'm inclined
not to back-patch.
Diffstat (limited to 'src/backend/executor/nodeWindowAgg.c')
0 files changed, 0 insertions, 0 deletions