Subject | Re: FB3 and not null |
---|---|
Author | Dmitry Yemanov |
Post date | 2016-03-11T13:32:14Z |
11.03.2016 13:39, liviuslivius wrote:
inconsistent database as a result.
Out of curiosity, how often do you change NULL <-> NOT NULL on such big
tables? ;-)
Dmitry
>Correct.
> I see that in FB3 this was changed and before apply not null to column -
> all existed data are validated.
> Is three some possibility to disable this behavior?Nope.
> On my big table with 910 468 710 records this operation take 72 minutes.But Firebird is not that sure. You may forget something and get
> I am sure that all records contain value in this field and this check is
> then "useless".
inconsistent database as a result.
Out of curiosity, how often do you change NULL <-> NOT NULL on such big
tables? ;-)
Dmitry