v.24.4New Feature
Add Input Format Setting to Handle Bad Escape Sequences in JSON
Add a setting input_format_json_throw_on_bad_escape_sequence, disabling it allows saving bad escape sequences in JSON input formats. #61889 (Kruglov Pavel).Why it matters
This feature allows users to disable errors caused by bad escape sequences in JSON input, enabling more lenient parsing and acceptance of non-standard JSON data. It improves data ingestion flexibility when dealing with malformed JSON.How to use it
Users can setinput_format_json_throw_on_bad_escape_sequence to 0 or false to disable throwing exceptions on bad escape sequences in JSON input formats. This can be done via session, user, or server settings.