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_
On this page
The BSON_ function creates a BSON array from the input values.
Syntax
BSON_BUILD_ARRAY([value_1, value_2, ..., value_n])Arguments
<value_: A valid BSON value or an expression that evaluates to a valid BSON value.
Return Type
A BSON array.
Remarks
-
If the input is SQL
NULL, it is considered equivalent to BSONNULLand appended to the array.
Examples
Note: The following examples explicitly cast string to BSON for clarity.
SELECT BSON_BUILD_ARRAY():>JSON AS Result;
+--------+
| Result |
+--------+
| [] |
+--------+SELECT BSON_BUILD_ARRAY(1:>BSON, 'true':>BSON,'null':>BSON, '{"$date":"2023-03-14T09:48:10.720Z"}':>BSON, NULL):>JSON AS Result;
+---------------------------------------------------------+
| Result |
+---------------------------------------------------------+
| [1,true,null,{"$date":"2023-03-14T09:48:10.720Z"},null] |
+---------------------------------------------------------+Note that in the previous example the SQL NULL is also inserted as BSON NULL in the array.
SELECT BSON_BUILD_ARRAY('{"$undefined":true}':>BSON,'{"$oid":"641044fd4542e7dc53758df9"}':>BSON, 'true':>BSON, '{"$date":"2023-03-14T09:48:10.720Z"}':>BSON, 'null':>BSON):>JSON AS Result;
+----------------------------------------------------------------------------------------------------------+
| Result |
+----------------------------------------------------------------------------------------------------------+
| [{"$undefined":true},{"$oid":"641044fd4542e7dc53758df9"},true,{"$date":"2023-03-14T09:48:10.720Z"},null] |
+----------------------------------------------------------------------------------------------------------+Last modified: