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).
Added the setting input_format_json_throw_on_bad_escape_sequence to control handling of bad escape sequences in JSON input formats.

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 set input_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.