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
┌─JSON_VALUE('{"hello":{"world":"!"}}', '$.hello')─┐
│ {"world":"!"} │
└──────────────────────────────────────────────────┘
1 row in set. Elapsed: 0.001 sec.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;
┌─JSON_VALUE('{"hello":"world"}', '$.b')─┐
│ ᴺᵁᴸᴸ │
└────────────────────────────────────────┘
1 row in set. Elapsed: 0.001 sec.Possible values:
- true — Allow.
- false — Disallow.