Visual Designer not updating null field that changed

Hello,

Here is my problem:

• I have a LightSpeed model that is already linked to tables in my database.
• I have a field in one table that is Not Nullable.
• I change that field directly in the database to be Nullable.
• I go to the LightSpeed visual designer and right-click and choose to update from source.
• The visual designer detect the change in the field.
• I say yes to proceed changes

When I click on the field in the visual designer, the field now allow Null but the property Validate presence is still to True instead of False.

Is this a correct behavior?

Thank you guys.

This is kind of correct, in that we don't know whether you've deliberately applied the validation and we don't want to remove it if you have.  When we infer the validation from a table drag, we're basically guessing at your business logic based on your database design.  If we removed the validation, we might be removing part of your business logic rather than merely reflecting a change in the persistence layer.

However, you're right that it leaves you with a nullable column into which we won't let you put null, which seems a bit pointless!  So we will take a look at whether we should be offering to remove that validation. For the meantime though you will need to remove the validation manually.

Thanks for drawing our attention to this!