Set up docs MCPThese settings are available in system.settings and are autogenerated from source.
function_json_value_return_type_allow_complex
Type
Bool
Default
0
Control whether allow to return complex type (such as: struct, array, map) for json_value function.
SELECT JSON_VALUE('{"hello":{"world":"!"}}', '$.hello') settings function_json_value_return_type_allow_complex=true
┌Possible values:
- true — Allow.
- false — Disallow.
function_json_value_return_type_allow_nullable
Type
Bool
Default
0
Control whether allow to return NULL when value is not exist for JSON_VALUE function.
SELECT JSON_VALUE('{"hello":"world"}', '$.b') settings function_json_value_return_type_allow_nullable=true;
┌Possible values:
- true — Allow.
- false — Disallow.