Details
-
Bug
-
Resolution: Duplicate
-
Major
-
5.0.0
-
5.0.0-2051
-
Untriaged
-
Unknown
Description
Following scenario doesnt work for covered queries:
|
|
The following query returns no results.
|
|
{code:java}
|
insert into default values("k01",{"x1":9007199254740993});
|
create index ix1 on default(x1);
|
select x1 from default where x1 = 9007199254740993;
|
{code}
|
|
./cbindex -type scan -bucket default -low='[9007199254740993]' -high='[9007199254740993]' -incl 3 -index ix1
|
Scan index:
|
[9.007199254740992e+15] ... k01
|
Total number of entries: 1
|
|
Above query returns correct result when its not covered. Since query fetches data and applies predicate.In case of covered query is relying on index data which is giving wrong result as 9007199254740992.
|
|
This bug was found while resolving:
|
Couchbase Issues: (MB-20603) Avoid loss of precision in array indexing
|
|
Comments from MB-20603 which might be relevant to this issue:
|
As [~prathibha] mentioned it should happen on any filed. As [~gerald] mentioned Indexer needs to change ActualForIndex()
|
|
Attachments
Issue Links
- duplicates
-
MB-20385 Indexing treatment of int must not be float64
- Closed