BSON_ 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.
On this page
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: April 3, 2024