Fix allowNull in combination with primaryKey

This PR will fix the allowNull handling across all the dialects when applied to a primary key column.
Fixes #2646