Submitted by: Cosmin Apreutesei (cosmin_ap2)

Duplicates CORE2039

The code to reproduce the error is below (always happens for me). Try to execute New_Procedure(NULL). It wil give you ISC error 335544879 which means not_valid_for_var Validation error for variable @1, value "@2". The check should instead evaluate to TRUE for a NULL value and so let the value pass. It evaluates correctly if applied to a table field though, I only get this behavior for sp parameters.

CREATE DOMAIN MY_DOMAIN AS VARCHAR(200) CHARACTER SET ASCII
CHECK (VALUE IS NULL OR TRIM(VALUE) <> '')
COLLATE ASCII;

create procedure New_Procedure (x my_domain)
returns (y my_domain)
as
begin
if (x IS NULL OR TRIM(x) <> '') then
y = 'valid';
else
y = 'not valid';
suspend;
end