JSON_GET_TYPE

Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

Arguments

json: a valid JSON value.

Return Value

The type is returned as one of the following strings:

boolean
double
string
array
object
null
Or, SQL NULL if json is not a valid JSON object.

Examples

SQL

SELECT JSON_GET_TYPE('true');

+-----------------------+
| json_get_type('true') |
+-----------------------+
| boolean               |
+-----------------------+

SQL

SELECT JSON_GET_TYPE('12345');

+------------------------+
| JSON_GET_TYPE('12345') |
+------------------------+
| double                 |
+------------------------+

SQL

SELECT JSON_GET_TYPE('"alpha, beta, gamma"');

+---------------------------------------+
| JSON_GET_TYPE('"alpha, beta, gamma"') |
+---------------------------------------+
| string                                |
+---------------------------------------+

SQL

SELECT JSON_GET_TYPE('[1,2,3]');

+--------------------------+
| JSON_GET_TYPE('[1,2,3]') |
+--------------------------+
| array                    |
+--------------------------+

SQL

SELECT JSON_GET_TYPE('{"alpha”:1, "beta”:2}’);

+----------------------------------------+
| JSON_GET_TYPE('{"alpha":1, "beta":2}') |
+----------------------------------------+
| object                                 |
+----------------------------------------+

SQL

SELECT JSON_GET_TYPE('null');

+-----------------------+
| JSON_GET_TYPE('null') |
+-----------------------+
| null                  |
+-----------------------+

Note

A JSON or Javascript null value is distinct from SQL NULL.