Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

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 } } ]

Components

Affects versions

Fix versions

Labels

Environment

None

Link to Log File, atop/blg, CBCollectInfo, Core dump

None

Release Notes Description

None

Activity

Show:

Korrigan Clark July 18, 2017 at 8:06 PM

, verified that the bug is still present in latest Spock.

Prerna Manaktala July 13, 2017 at 11:10 PM


Please verify and close this bug.

Pavel Blagodov March 27, 2017 at 1:13 AM

We already have ticket for this issue

Prerna Manaktala September 27, 2016 at 6:34 PM

Hi Pavel

Eben fixed it from his side, but I still see same issue when I edit an existing document in UI for long values.

Example:
If I create a document from UI containing:
{
"tasks": 9007199254740993
}

and save it.
If I go back to the document, it is saved as:
{
"tasks": 9007199254740992
}

Thanks
Prerna

Eben Haber August 15, 2016 at 9:44 PM

I checked a fix in for Spock.

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Is this a Regression?

Unknown

Triage

Untriaged

Priority

Instabug

Open Instabug

PagerDuty

Sentry

Zendesk Support

Created August 1, 2016 at 5:36 AM
Updated July 18, 2017 at 8:50 PM
Resolved March 27, 2017 at 1:13 AM
Configure
Instabug