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 adds the specified BSON value to the end of the input BSON array, and returns the array with the appended value as the result.
Syntax
BSON_ARRAY_PUSH(<array>, <value>)Arguments
-
<array>: A valid BSON array or an expression that evaluates to a BSON array. -
<value>: A BSON value to be appended to the input array.
Return Type
A BSON array.
Remarks
-
If
NULLis specified as the input array, it is considered as an empty BSON array. -
If
NULLis specified as the value to append, it is considered as the BSONNULLtype.
Examples
Note: The following examples explicitly cast string to BSON for clarity.
SELECT BSON_ARRAY_PUSH('[1, true, null, [7,8,9], "abc"]':>BSON, '{"a":{"b":9}}':>BSON):>JSON AS Result;
+-------------------------------------------+
| Result |
+-------------------------------------------+
| [1,true,null,[7,8,9],"abc",{"a":{"b":9}}] |
+-------------------------------------------+SELECT BSON_ARRAY_PUSH('[]':>BSON, '"abc"':>BSON):>JSON AS Result;
+---------+
| Result |
+---------+
| ["abc"] |
+---------+SELECT BSON_ARRAY_PUSH('[1,2,3,4]':>BSON, 'null':>BSON):>JSON AS Result;
+----------------+
| Result |
+----------------+
| [1,2,3,4,null] |
+----------------+Last modified: