v.20.5New Feature
Support NULL and NOT NULL Modifiers in CREATE Query
Now supportNULLandNOT NULLmodifiers for data types inCREATEquery. #11057 (ΠΠ°Π²Π΅Π» ΠΠΎΡΠ΅ΠΌΠΊΠΈΠ½).
Why it matters
This feature allows users to explicitly define whether a column can storeNULL values or not, improving schema clarity and enabling better data validation and integrity enforcement.How to use it
When creating a table, specify the nullability of columns using theNULL or NOT NULL modifiers in the CREATE TABLE statement, for example:CREATE TABLE example (
id UInt64 NOT NULL,
name String NULL
) ENGINE = MergeTree()
ORDER BY id