IS_
On this page
Returns a TINYINT 1 for nullable BSON input values, and returns a TINYINT 0 for other values.
By default, empty values, BSON NULL, and BSON Undefined are interpreted as nullable.
Syntax
IS_BSON_NULL(<value>)
Argument
<value>: A valid BSON value or an expression that evaluates to a valid BSON value.
Return Type
SingleStore TINYINT type.
Remarks
The following table specifies the value returned by IS_ function for each input value:
|
Input Value |
Output Value |
|---|---|
|
|
1 |
|
BSON |
1 |
|
BSON |
1 |
|
Any other value |
0 |
Examples
Here are a few examples that demonstrate the behavior of IS_ function:
SELECT IS_BSON_NULL(NULL) AS Result;
+--------+
| Result |
+--------+
| 1 |
+--------+SELECT IS_BSON_NULL('null':>BSON) AS Result;
+--------+
| Result |
+--------+
| 1 |
+--------+SELECT IS_BSON_NULL('{"$undefined":true}':>BSON) AS Result;
+--------+
| Result |
+--------+
| 1 |
+--------+SELECT IS_BSON_NULL('"random string"') AS Result;
+--------+
| Result |
+--------+
| 0 |
+--------+SELECT IS_BSON_NULL(1234) AS Result;
+--------+
| Result |
+--------+
| 0 |
+--------+Last modified: April 4, 2024