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

Query Tab in UI: Inserting long values rounds them off when seen in UI

    XMLWordPrintable

Details

    • Untriaged
    • Unknown

    Description

      This issue was found while testing:
      (MB-20164) N1QL rounding causes CAS mismatch
       
      Inserting long values through query-ui rounds it off.
      The following query does round off from query workbench UI : 
      insert into simple_table_db_195_simple_table values("k3",
      { "id":110000000003421999 }
      );
      When I go to UI, and check the document k3 , it looks as:
      { "id": 110000000003422000 }
       
      when you query from cbq after inserting you get right result: 
      select * from simple_table_db_195_simple_table where meta().id= "k3"; 
      { 
      "requestID": "af502c34-fba4-4926-92d8-1a5b0c08a9e5", 
      "signature":
      { "*": "*" }
      , 
      "results": [ 
      { 
      "simple_table_db_195_simple_table":
      { "id": 110000000003421999 }
       
      } 
      ], 
      "status": "success", 
      "metrics":
      { "elapsedTime": "127.367179ms", "executionTime": "127.321399ms", "resultCount": 1, "resultSize": 116 }
       
      }
       
      When we query from workbench UI, same query gives: 
      [ 
      { 
      "simple_table_db_195_simple_table":
      { "id": 110000000003422000 }
       
      } 
      ]
      
      

      Attachments

        Issue Links

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

          Activity

            People

              korrigan.clark Korrigan Clark (Inactive)
              Prerna.Manaktala Prerna Manaktala (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty