19.03.2018 12:21, Leyne, Sean wrote:
And, probably, we should add:
(3) - NOT NULL is set and default value was set before
Really, why?
I don't see that as a change that would affect the existing index values.
The question was about existing NULL values. After i tried it i see that
NOT NULL will not be set in this case:
SQL> alter table a alter id set not null;
Statement failed, SQLSTATE = 22006
unsuccessful metadata update
-Cannot make field ID of table A NOT NULL because there are NULLs present
Regards,
Vlad
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel