Lack of interest Schema manager & nullable columns

This suggestion has been closed automatically because it did not receive enough votes over an extended period of time. If you wish to see this, please search for an open suggestion and, if you don't find any, post a new one.

Xon

Well-known member
When using the schema manager calling setDefault(null) on a column does not make a column nullable.

I don't feel it makes much sense that if there is an explicit call to set the default as nullable, the column stays non-nullable
 
Upvote 0
This suggestion has been closed. Votes are no longer accepted.
Although perhaps not an unreasonable suggestion, would it not be clearer and shorter to just forget setting a default value, and just set nullable yourself? If no other default value is set, the default value is set to NULL for a nullable column in the Schema Manager.
 
I'm ok with that, but in that case shouldn't setDefault(null) on a non-nullable column throw a logic exception?

Sure, the schema manager silently ignores it; but being explicit about your SQL schema types is good.
 
Back
Top Bottom