You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
While creating a table or struct, declaring a column type as NOT NULL is not honoured by the system since the nullability information gets lost in converting Relational DataType -> Record Layer Type -> Record Metadata.
ARRAY type is an exception to this as the nullability of Array is strictly defined by means of the NullableArrayWrapper - which is preserved in the RecordMetadata and its existence is indicative of Array's nullability.
Long Term: We need a solution to specify nullability.
Short Term: We should explicitly not allow defining a table with a NOT NULL non-array column.
The text was updated successfully, but these errors were encountered:
While creating a table or struct, declaring a column type as
NOT NULL
is not honoured by the system since the nullability information gets lost in converting Relational DataType -> Record Layer Type -> Record Metadata.ARRAY type is an exception to this as the nullability of Array is strictly defined by means of the NullableArrayWrapper - which is preserved in the RecordMetadata and its existence is indicative of Array's nullability.
Long Term: We need a solution to specify nullability.
Short Term: We should explicitly not allow defining a table with a NOT NULL non-array column.
The text was updated successfully, but these errors were encountered: