Hi all.

I'm seeing some weird stuff in our database schema while trying to
improve sanity for migrations.

Basically I'm noticing that tables we migrated from earlier schemas
have "no default" (COLUMN_DEF = null), whereas tables we create today
seem to have COLUMN_DEF = NULL.

I'm wondering whether there is any semantic difference between the
two, because as far as I know, if you don't put a default in for a
column, the default for that column is already null. Is that not the
case? And if it is not the case, why does DEFAULT NULL even result in
the schema being different?

TX

Reply via email to