JSON_PARSE_NOTNULL_ERROR_TO_INVALID

Description

This function is used to parse a JSON string. If the JSON string is malformed or a parsing error occurs, the function will return an invalid JSON object (usually {}). The main purpose of this function is to ensure that when a JSON format error occurs, a safe default value is returned, preventing query failures due to parsing errors.

Aliases

• JSONB_PARSE_NOTNULL_ERROR_TO_INVALID

Syntax

JSON_PARSE_NOTNULL_ERROR_TO_INVALID( <str> )

Required Parameters

parameters	described
<str>	The JSON string to be parsed. This parameter should be a valid string containing JSON-formatted data. If the JSON format is invalid, the function will return an invalid JSON object.

Return Value

Returns an invalid JSON object (usually {}).

Examples

SELECT JSON_PARSE_NOTNULL_ERROR_TO_INVALID('{"name": "Alice", "age": 30}') AS parsed_json;

+---------------------------+
| parsed_json               |
+---------------------------+
| {"name":"Alice","age":30} |
+---------------------------+