v.24.5New Feature
New Setting to Force NULL Values for Omitted Fields
A new setting input_format_force_null_for_omitted_fields that forces NULL values for omitted fields. #60887 (Constantine Peresypkin).Why it matters
This feature addresses the issue of handling missing fields during data input by explicitly assigning NULL values to any fields that are omitted. This improves data consistency and prevents errors or unexpected results caused by absent values in input formats.How to use it
Enable the feature by settinginput_format_force_null_for_omitted_fields to 1 (true) when reading input data. This forces any omitted fields to be interpreted as NULL rather than defaulting to other behaviors.