BSON_ BUILD_ ARRAY
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
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 BSONNULL
and 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: May 8, 2024