Subject | FB3 and not null |
---|---|
Author | liviuslivius |
Post date | 2016-03-11T10:39:52Z |
Hi,
in earlier versions of Firebird - when i try to change column nullable to not null
this go very very fast but without check of all records contain value in such field.
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?
On my big table with 910 468 710 records this operation take 72 minutes.
I am sure that all records contain value in this field and this check is then "useless".
regards,
Karol Bieniaszewski