Parse Unquoted NULL Literal as NULL (if Setting Format_csv_unquoted_null_literal_as_null=1)

Why it matters

This feature addresses the need to correctly interpret unquoted NULL literals in CSV data as actual NULL values, improving data import accuracy. Additionally, it ensures that fields with non-nullable data types can be initialized with their default values when the input data contains nulls, thereby preventing errors during data insertion.

How to use it

Enable the parsing of unquoted NULL literals as NULL by setting the parameter format_csv_unquoted_null_literal_as_null=1. To initialize null fields with default values for non-nullable columns, set input_format_null_as_default=1 during data import operations.