Command "Alter table <T> alter <C> NULL" is allowed for column <C> which was
already defined as PRIMARY KEY for <T>
---------------------------------------------------------------------------------------------------------------------
Key: CORE-4725
URL: http://tracker.firebirdsql.org/browse/CORE-4725
Project: Firebird Core
Issue Type: Bug
Components: Engine
Reporter: Pavel Zotov
WI-T3.0.0.31733
Script:
======
recreate table test02(x int not null);
alter table test02 add constraint test02_pk primary key (x);
commit;
alter table test02 alter x null; --------- PASSED!
commit;
set echo on;
show table test02;
insert into test02(x) values(null);
insert into test02(x) select x from test02;
update test02 set x = null;
select * from test02;
Output:
======
show table test02;
X INTEGER Nullable
CONSTRAINT TEST02_PK:
Primary key (X)
insert into test02(x) values(null);
insert into test02(x) select x from test02;
update test02 set x = null;
select * from test02;
X
============
<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
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
