Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-22939

Avoid loss of precision in indexing on long fields

    XMLWordPrintable

Details

    • 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

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              prathibha Prathibha Bisarahalli (Inactive)
              Prerna.Manaktala Prerna Manaktala (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty