Details
-
Bug
-
Resolution: Won't Fix
-
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 = -9223372036854775808
|
Results obtained:
{
|
"results": []
|
}
|
Document d1 is also expected to be returned.
Explain Plan:
{
|
"plan": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "IndexScan3",
|
"covers": [
|
"cover ((`b1`.`long_num`))",
|
"cover ((meta(`b1`).`id`))"
|
],
|
"index": "i1",
|
"index_id": "2c108fe5860faf10",
|
"index_projection": {
|
"entry_keys": [
|
0
|
]
|
},
|
"keyspace": "b1",
|
"namespace": "default",
|
"spans": [
|
{
|
"exact": true,
|
"range": [
|
{
|
"high": "(-9223372036854776000)",
|
"inclusion": 3,
|
"low": "(-9223372036854776000)"
|
}
|
]
|
}
|
],
|
"using": "gsi"
|
},
|
{
|
"#operator": "Parallel",
|
"~child": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "Filter",
|
"condition": "(cover ((`b1`.`long_num`)) = (-9223372036854776000))"
|
},
|
{
|
"#operator": "InitialProject",
|
"result_terms": [
|
{
|
"expr": "cover ((`b1`.`long_num`))"
|
}
|
]
|
},
|
{
|
"#operator": "FinalProject"
|
}
|
]
|
}
|
}
|
]
|
},
|
"text": "select long_num from b1 use index (i1) where long_num = -9223372036854775808"
|
5. If there is only Primary index and no secondary index on long_num, correct results are returned.
[{
|
"long_num": -9223372036854775808
|
}
|
]
|
Logs: https://s3.amazonaws.com/bugdb/jira/abc/collectinfo-2018-04-24T133516-ns_1%40127.0.0.1.zip
Attachments
Issue Links
- relates to
-
MB-24464 Big number support
- Open