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 returns a SingleStore TINYINT 1 if the specified value is present in the BSON array.
Syntax
BSON_ARRAY_CONTAINS_BSON(<array>, <value>)Arguments
-
<array>: A BSON array or an expression that evaluates to a valid BSON array. -
<value>: The value to find in the array.
Return Type
SingleStore TINYINT type.
Remarks
-
If the specified
<array>argument is not a valid BSON array, returnsNULL. -
If the specified
<array>argument is SQLNULL, returns 0. -
If the specified
<value>is present in the<array>, returns 1, otherwise 0.
Examples
Note: The following examples explicitly cast string to BSON for clarity.
SELECT BSON_ARRAY_CONTAINS_BSON('[true,"abc",123]':>BSON, '123':>BSON) AS Result;
+--------+
| Result |
+--------+
| 1 |
+--------+SELECT BSON_ARRAY_CONTAINS_BSON('[{"a":1,"b":2},"abc",123]':>BSON, '{"b":1,"a":2}':>BSON) AS Result;
+--------+
| Result |
+--------+
| 0 |
+--------+SELECT BSON_ARRAY_CONTAINS_BSON('{"a":12,"b":23}':>BSON, '123':>BSON) AS Result;
+--------+
| Result |
+--------+
| NULL |
+--------+Last modified: