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