Details
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
- is triggering
-
MB-22323 query result output format changed in web-console
- Closed