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

Big number support

    XMLWordPrintable

Details

    • Epic
    • Resolution: Unresolved
    • Major
    • feature-backlog
    • 5.0.0
    • query
    • None

    Description

       

      explain select  77777772222222222.01;
      		 
      "#operator": "InitialProject",
      		 
       "result_terms": [
      		 
       {
      		 
       "expr": "77777772222222224"
      		 
       }
      		 
       ]
      		 
       }

       

      The expression value is wrong. This is just show. But there is bigger problem. Due to floating point precision the value will change but that needs to be consistent across the couchbase. For

      example you save document in KV using UI  {"k0":77777772222222222.01} will show as {"k0":77777772222222220}

      When you do select * from default; it shows as {"k0":77777772222222224} 

      But in 4.5.0 it shows right.

       

       

      Rreported by Prathibha Bisarahalli

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MB-61365 Inserts via transactions of large numbers truncated in 7.6.0

          • Major - Major loss of function.
          • Reopened

          Bug - A problem which impairs or prevents the functions of the product. MB-29391 [INT64] Modulo operation returns incorrect result only in case of int64

          • Major - Major loss of function.
          • Closed
          is parent task of

          Technical task - A technical task. MB-20395 select a long value which is < maxint64 also shows values > maxint64

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MB-31798 Values greater than MaxFloat64 get evaluated as Binary type

          • Major - Major loss of function.
          • Closed

          Technical task - A technical task. MB-20395 select a long value which is < maxint64 also shows values > maxint64

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MB-29391 [INT64] Modulo operation returns incorrect result only in case of int64

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MB-29393 Incorrect results returned in case of scan for min int64 value

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MB-29401 sum of large negative numbers gives wrong results

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. MB-20354 big integer: SELECT MININT returns wrong answer

          • Major - Major loss of function.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              Unassigned Unassigned
              Sitaram.Vemulapalli Sitaram Vemulapalli
              Votes:
              0 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty