Columns are NOT NULL by default and improved dynamic default detection