CREATE DOMAIN D_DATE AS DATE
CHECK (VALUE BETWEEN DATE '01.01.1900' AND DATE '01.01.2050');
CREATE PROCEDURE TMP (PDATE D_DATE)
AS BEGIN END;
COMMIT;
EXECUTE PROCEDURE TMP (NULL);
/* ERROR:
The insert failed because a column definition includes validation constraints.
validation error for variable PDATE, value "1858-11-17".
At procedure 'TMP'.
*/
As we can see, the NULL value is treated as a zero-valued date by the check constraint.
Description
Test case:
CREATE DOMAIN D_DATE AS DATE
CHECK (VALUE BETWEEN DATE '01.01.1900' AND DATE '01.01.2050');
CREATE PROCEDURE TMP (PDATE D_DATE)
AS BEGIN END;
COMMIT;
EXECUTE PROCEDURE TMP (NULL);
/* ERROR:
The insert failed because a column definition includes validation constraints.
validation error for variable PDATE, value "1858-11-17".
At procedure 'TMP'.
*/
As we can see, the NULL value is treated as a zero-valued date by the check constraint.
Bug
Closed
Major
Domain-level CHECK constraints wrongly process NULL values
