Regression: NOT NULL constraint, declared in domain, does not work
------------------------------------------------------------------
Key: CORE-4453
URL: http://tracker.firebirdsql.org/browse/CORE-4453
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Alpha 2
Reporter: Pavel Zotov
LI-T3.0.0.31155:
SQL> create domain dm_01 varchar(20) not null; --- ::: NB ::: "NOT null" clause
here
SQL> commit;
SQL> create table t_01(s dm_01, x int); commit;
SQL> insert into t_01(x) values(100); -- PASSED!! Why ?
SQL> commit;
SQL> select * from t_01 where s is null;
S X
==================== ============
100
PS-1. No such error in 2.5.
PS-2. No such error in case when not null clause is included in field
declaration rather than in domain, i.e.:
SQL> create domain dm_02 varchar(20); commit; -- this domain is declared
WITHOUT not-null clause...
SQL> create table t_02(s dm_02 not null, x int); commit; -- ... but field 'S'
*does* contain explicit "not null" declaration
SQL> insert into t_02(x) values(100);
Statement failed, SQLSTATE = 23000
validation error for column "T_02"."S", value "*** null ***"
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
