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

N1QL rounding causes CAS mismatch

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.5.1, 4.6.0, 5.0.0
    • 4.5.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      The query engine internally represents all numbers as float64. This leads to rounding errors at the margins. In particular, with large CAS values, the rounding errors cause CAS mismatch errors.

      See https://forums.couchbase.com/t/different-cas-value-for-the-same-document-obtained-via-java-sdk-and-n1ql/6503/25 and https://forums.couchbase.com/t/n1ql-returns-a-different-cas-than-the-driver-functions/9124/3

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MB-19612 4.5.1 Minor Release

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MB-20290 4.6.0 Point Release

          • Major - Major loss of function.
          • Closed
          depends on

          Bug - A problem which impairs or prevents the functions of the product. MB-20385 Indexing treatment of int must not be float64

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          For Gerrit Dashboard: MB-20164
          # Subject Branch Project Status CR V
          65881,2 MB-20164. Add intValue type using int64. master query Status: MERGED +2 +1
          65883,3 MB-20164. Add integer parsing and integer arithmetic. master query Status: MERGED +2 +1
          66295,5 MB-20164 Use fixed JSON unmarshaller in couchbaselabs/go_json to unmarshal long int into int64 master query Status: MERGED +2 +1
          66329,2 MB-20164. Add intValue type using int64. watson query Status: MERGED +2 +1
          66336,2 MB-20164. Add integer parsing and integer arithmetic. watson query Status: MERGED +2 +1
          66337,2 MB-20164 Use fixed JSON unmarshaller in couchbaselabs/go_json to unmarshal long int into int64 watson query Status: MERGED +2 +1
          66339,2 MB-20164. update SHA for go_json master manifest Status: MERGED +2 +1
          66376,2 MB-20164 Add unit tests for large integers. master query Status: MERGED +2 +1
          66408,2 MB-20164 Add unit tests for large integers. watson query Status: MERGED +2 +1
          66411,2 MB-20164 Move integer tests to a separate directory. master query Status: MERGED +2 +1
          66522,2 MB-20164. Add explanation of integer parsing and overflow. master go_json Status: MERGED +2 +1
          68183,2 MB-20164. Add explanation of integer parsing and overflow. watson go_json Status: MERGED +2 +1

          Activity

            People

              Sitaram.Vemulapalli Sitaram Vemulapalli
              gerald Gerald Sangudi (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty