Details
-
Bug
-
Resolution: Duplicate
-
Major
-
5.5.0
-
Build: 5.5.0-2556
Node 1: kv, index, n1ql
-
Untriaged
-
Unknown
Description
Steps:
- Install and configure cluster. Create bucket b1
- Have following documents:
d1 - {"long_num":-9223372036854775808}
|
d2 - {"long_num":-9223372036854770000}
|
d3 - {"long_num":10}
|
d4 - {"long_num":-2147483600}
|
3. Create index i1
create index i1 on b1(long_num)
|
4. Run Following query:
SELECT long_num FROM b1 use index (i1) where (long_num % 10 == 0)
|
Results obtained:
[
|
{
|
"long_num": -2147483600
|
},
|
{
|
"long_num": 10
|
}
|
]
|
Document d2 is also expected to be returned.
Logs: https://s3.amazonaws.com/bugdb/jira/abc/collectinfo-2018-04-24T133516-ns_1%40127.0.0.1.zip