BUG #2954: null is not checked against domain constraints in return clause

From: "Sergiy Vyshnevetskiy" <serg(at)vostok(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2954: null is not checked against domain constraints in return clause
Date: 2007-02-01 15:43:55
Message-ID: 200702011543.l11FhtSB071525@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2954
Logged by: Sergiy Vyshnevetskiy
Email address: serg(at)vostok(dot)net
PostgreSQL version: 8.2.1
Operating system: FreeBSD-6 stable
Description: null is not checked against domain constraints in return
clause
Details:

#psql = serg(at)[local]:5432 test
create domain "DInt" as int not null;
CREATE DOMAIN
#psql = serg(at)[local]:5432 test
create or replace function test() returns "DInt" immutable strict language
plpgsql as $F$begin return null; end$F$;
CREATE FUNCTION
#psql = serg(at)[local]:5432 test
select test() is null;
?column?
----------
t
(1 )

#psql = serg(at)[local]:5432 test

We should have gotten an error during execution of test().

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sergiy Vyshnevetskiy 2007-02-01 17:20:34 Re: BUG #2954: null is not checked against domain constraints in return clause
Previous Message Sergiy Vyshnevetskiy 2007-02-01 15:04:43 Re: BUG #2948: default null values for not-null domains