/
krasninja
/
querycat
Обзор
Документация
Войти
/
krasninja
/
querycat
Код
Пакеты
0
Релизы
0
Аналитика
Безопасность
develop
src/QueryCat.IntegrationTests/Tests/SelectAddons/SelectJson3.yaml
29 строк
953 B
Ivan Kozhin
Group tests
20 май 2024, 11:20
20 май 2024, 11:20
089ba20
Код
Авторство
О чём код?
expected: | 1,,,"Sport" ,,"{""town"":""Cheltenham"",""county"":""Gloucestershire"",""country"":""England""}","[""Sport"",""Water polo""]" query: | declare json string := ' { "info": { "type": 1, "address": { "town": "Cheltenham", "county": "Gloucestershire", "country": "England" }, "tags": ["Sport", "Water polo"] }, "type": "Basic" }'; select json_value(json, '$.info.type'), -- 1 -- value json_value(json, '$.info.none'), -- NULL (no property) json_value(json, '$.info.address'), -- NULL (object, not a value) json_value(json, '$.info.tags[0]') -- NULL (object, not a value) union all select json_query(json, '$.info.type'), -- NULL -- value (not an object) json_query(json, '$.info.none'), -- NULL (no property) json_query(json, '$.info.address'), -- NULL (object, not a value) json_query(json, '$.info.tags') -- NULL (object, not a value)