{"capability":{"Key":"sqljson-is-json","SourceKind":"yaml","SourceDatabase":"center","SourceTable":"featurematrix.yaml","SourceKey":"SQL/JSON IS JSON","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","Name":"SQL/JSON IS JSON","NameLocale":"en","GroupKey":"json","GroupName":"JSON","GroupLocale":"en","Ordinal":7,"GroupOrder":6,"Facts":{"feature":{"description":"SQL/JSON syntax for testing the type of JSON object. For example:\r\n\r\n```\r\nSELECT js,\r\n  js IS JSON \"json?\",\r\n  js IS JSON SCALAR \"scalar?\",\r\n  js IS JSON OBJECT \"object?\",\r\n  js IS JSON ARRAY \"array?\"\r\nFROM (VALUES\r\n      ('123'), ('\"abc\"'), ('{\"a\": \"b\"}'), ('[1,2]'),('abc')) foo(js);\r\n```","name":"SQL/JSON IS JSON","versions":{"16":"Yes"}},"group":"JSON","versions":{"max":18,"min":8.1}},"Cells":[{"Version":"10","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"11","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"12","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"13","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"14","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"15","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"16","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"16","Supported":true,"Original":"Yes"},{"Version":"17","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"16","Supported":true,"Original":"Yes"},{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"16","Supported":true,"Original":"Yes"},{"Version":"8.1","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.2","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.3","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.4","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.0","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.1","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.2","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.3","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.4","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.5","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.6","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"}],"Texts":[{"Locale":"en","Title":"SQL/JSON IS JSON","BodyHTML":"\u003cp\u003eSQL/JSON syntax for testing the type of JSON object. For example:\u003c/p\u003e\n\u003cpre\u003e\u003ccode\u003eSELECT js,\n  js IS JSON \u0026#34;json?\u0026#34;,\n  js IS JSON SCALAR \u0026#34;scalar?\u0026#34;,\n  js IS JSON OBJECT \u0026#34;object?\u0026#34;,\n  js IS JSON ARRAY \u0026#34;array?\u0026#34;\nFROM (VALUES\n      (\u0026#39;123\u0026#39;), (\u0026#39;\u0026#34;abc\u0026#34;\u0026#39;), (\u0026#39;{\u0026#34;a\u0026#34;: \u0026#34;b\u0026#34;}\u0026#39;), (\u0026#39;[1,2]\u0026#39;),(\u0026#39;abc\u0026#39;)) foo(js);\n\u003c/code\u003e\u003c/pre\u003e\n","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","ContentHash":"13bfbadcfa68f4d3bd65751467ba4b8985cfad530cbea4dad2d3ebf760fbb25e","Payload":{"description":"SQL/JSON syntax for testing the type of JSON object. For example:\r\n\r\n```\r\nSELECT js,\r\n  js IS JSON \"json?\",\r\n  js IS JSON SCALAR \"scalar?\",\r\n  js IS JSON OBJECT \"object?\",\r\n  js IS JSON ARRAY \"array?\"\r\nFROM (VALUES\r\n      ('123'), ('\"abc\"'), ('{\"a\": \"b\"}'), ('[1,2]'),('abc')) foo(js);\r\n```","name":"SQL/JSON IS JSON","versions":{"16":"Yes"}}},{"Locale":"zh-Hans","Title":"SQL/JSON IS JSON","BodyHTML":"\u003cp\u003e新增用于测试 JSON 值类型的 SQL/JSON 语法，例如判断一个值是否为 JSON、标量、对象或数组。\u003c/p\u003e\n","SourceHash":"071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50","ContentHash":"9c60e7fb5aa1b976faf66652d7e4416b6916830edc90ce2914b0095bff89f812","Payload":{"description":"新增用于测试 JSON 值类型的 SQL/JSON 语法，例如判断一个值是否为 JSON、标量、对象或数组。","name":"SQL/JSON IS JSON"}}],"GroupTitles":{"en":"JSON","zh-Hans":"JSON"},"LegacyIDs":["396"]},"observed":true,"selected_cell":{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"16","Supported":true,"Original":"Yes"},"selected_version":"18"}