0
 Followers
3
 Likes

Stop updating default values when creating new columns

Backend
New

When we deploy a new version that contains a new column on an entity, the compiler service generates the DDLs to alter the table adding the new column (with its default value), but also generates an Update script to set the previous record's with the default values for the new column.

At least on Oracle, it's not necessary, because the Alter table command already changes automatically the old records.

Besides, it can create a huge problem when changing big tables (millions of records), because the update command will take very long to finish and commit, which normally leads to timeout while deploying, which normally leads to an inconsistent database.

Created on 16 Mar
Comments (1)

This is a BUG and I have told OutSystems about this *multiple times* about it.


J.Ja

views
96
Followers
0