New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
NOT-NULL-column can be used as primary key and filled with NULL-values [CORE4070] #4398
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Commented by: Thomas Beckmann (thbeckmann) Hm, I've some problems understanding this: Why does the server complain about the NULL-value even though it has been deleted and does not show up? SQL> set; UID908BCF2F81144D3A94F482170C1FE013 |
Commented by: @dyemanov The affending row should be not only deleted but also garbage collected. |
Modified by: @asfernandesFix Version: 3.0 Initial [ 10301 ] |
Modified by: @asfernandesVersion: 3.0 Initial [ 10301 ] Fix Version: 3.0 Alpha 1 [ 10331 ] Version: 3.0 Alpha 1 [ 10331 ] => Fix Version: 3.0 Initial [ 10301 ] => |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Thomas Beckmann (thbeckmann)
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>
Commits: d7c58ad FirebirdSQL/fbt-repository@f1e1187
The text was updated successfully, but these errors were encountered: