NOT-NULL-column can be used as primary key and filled with NULL-values
----------------------------------------------------------------------
Key: CORE-4070
URL: http://tracker.firebirdsql.org/browse/CORE-4070
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: Windows 7 64, ISQL, Version: WI-T3.0.0.30287 Firebird 3.0
Unstable
Reporter: Thomas Beckmann
Priority: Critical
I guess, this should not be possible:
SQL> show version;
ISQL Version: WI-T3.0.0.30287 Firebird 3.0 Unstable
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T3.0.0.30287 Firebird
3.0 Unstable"
on disk structure version 12.0
SQL> create table TEST$DATABASE (UID char(16) character set OCTETS collate
OCTETS);
SQL> alter table TEST$DATABASE add primary key (UID);
SQL> commit;
SQL> insert into TEST$DATABASE (UID) values (null);
SQL> insert into TEST$DATABASE (UID) values (null);
SQL> commit;
SQL> show table TEST$DATABASE;
UID CHAR(16) CHARACTER SET OCTETS Nullable
CONSTRAINT INTEG_21:
Primary key (UID)
SQL> select * from TEST$DATABASE;
UID
================================
<null>
<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
------------------------------------------------------------------------------
Own the Future-Intel® Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game
on Steam. $5K grand prize plus 10 genre and skill prizes.
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
