Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

BSON_GET_TYPE

The BSON_GET_TYPE() function returns a string that specifies the BSON type of the input BSON value.

Syntax

BSON_GET_TYPE(<input>)

Argument

<input>: A valid BSON value or an expression that evaluates to a valid BSON value.

Return Type

A string.

Remarks

  • If NULL is specified as the input value, returns "null" as the result.

  • If the input is an invalid BSON value, returns "missing" as the result.

Examples

Note: The following examples explicitly cast string to BSON for clarity.

SELECT BSON_GET_TYPE( '{"a":1, "b":2, "c":"abc"}':>BSON) AS Type;
+--------+
| Type   |
+--------+
| object |
+--------+
SELECT BSON_GET_TYPE('[1, true, null, [7,8,9], "abc"]':>BSON) AS Type;
+-------+
| Type  |
+-------+
| array |
+-------+
SELECT BSON_GET_TYPE('true':>BSON) AS Type;
+------+
| Type |
+------+
| bool |
+------+
SELECT BSON_GET_TYPE('"abc"':>BSON) AS Type;
+--------+
| Type   |
+--------+
| string |
+--------+
SELECT BSON_GET_TYPE('null':>BSON) AS Type;
+------+
| Type |
+------+
| null |
+------+
SELECT BSON_GET_TYPE("abc") AS Type;
+---------+
| Type    |
+---------+
| missing |
+---------+

Last modified:

Was this article helpful?