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_ARRAY_CONTAINS_BSON

The BSON_ARRAY_CONTAINS_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, returns NULL.

  • If the specified <array> argument is SQL NULL, 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:

Was this article helpful?