correct handling of null values for ALL data types