Docs HomeMongoDB Manual

$bitOr (aggregation)

Definition定义

New in version 6.3. 6.3版新增。

$bitOr

Returns the result of a bitwise or operation on an array of int and long values.返回对intlong值的数组执行逐位或运算的结果。

Syntax语法

The $bitOr operator has the following syntax:$bitOr运算符具有以下语法:

{ $bitOr: { [ <expression1>, <expression2>, ... ] }

Behavior行为

If the operands include both integers and long values, MongoDB sign-extends the calculated integer result and returns a long value. 如果操作数同时包含整数和长值,MongoDB符号将扩展计算出的整数结果并返回一个长值。Otherwise, if the operands include only integers or only longs, MongoDB returns results with the corresponding value type.否则,如果操作数仅包含整数或仅包含long,MongoDB将返回具有相应值类型的结果。

Note

All numbers in mongosh are doubles, not integers. mongosh中的所有数字都是双数,而不是整数。To to specify integers in mongosh, use the NumberInt() or the NumberLong() constructor. 要在mongosh中指定整数,请使用NumberInt()NumberLong()构造函数。To learn more, see Int32 or Long.要了解更多信息,请参阅Int32Long

To learn how your MongoDB driver handles numeric values, refer to your driver's documentation.要了解MongoDB驱动程序如何处理数值,请参阅驱动程序文档

If any arguments in the array are of a different data type such as a string, double, or decimal, MongoDB returns an error.如果数组中的任何参数都是不同的数据类型,如字符串、双精度或十进制,MongoDB将返回一个错误。

If the argument is an empty array, the operation returns NumberInt(0).如果参数是空数组,则该操作将返回NumberInt(0)

If any of the arguments in the array equate to null, the operation returns null.如果数组中的任何参数等于null,则该操作将返回null

Examples实例

The examples on this page use the switches collection, which contains the following documents:此页上的示例使用switches集合,该集合包含以下文档:

db.switches.insertMany( [
{ _id: 0, a: NumberInt(0), b: NumberInt(127) },
{ _id: 1, a: NumberInt(2), b: NumberInt(3) },
{ _id: 2, a: NumberInt(3), b: NumberInt(5) }
] )

Bitwise OR with Two Integers带两个整数的位OR

The following aggregation uses the $bitOr operator in the $project stage:以下聚合在$project阶段使用$bitOr运算符:

db.switches.aggregate( [
{
$project: {
result: {
$bitOr: [ "$a", "$b" ]
}
}
}
])

The operation returns the following results:该操作返回以下结果:

  [
{ _id: 0, result: 127 },
{ _id: 1, result: 3 },
{ _id: 2, result: 7 }
]

Bitwise OR with a Long and Integer与长整型的位OR

The following aggregation uses the $bitOr operator in the $project stage:以下聚合在$project阶段使用$bitOr运算符:

db.switches.aggregate( [
{
$project: {
result: {
$bitOr: [ "$a", NumberLong("63") ]
}
}
}
])

The operation returns the following results:该操作返回以下结果:

  [
{ _id: 0, result: Long("0") },
{ _id: 1, result: Long("2") },
{ _id: 2, result: Long("3") }
]

Learn More了解更多信息