[MB-65767] Analytics workbench cannot handle integers greater than 2^53 without losing precision

Product: Couchbase Server
Component: analytics-service
Issue Link: MB-65767
Affects Version(s): 7.2.6, 7.6.5
Fix Version(s): 7.6.6, 8.0.0

Summary

• The Analytics Workbench cannot handle integers greater than 2^53 without losing precision. To prevent incorrect results, the current behavior is to avoid parsing such numbers and instead display a message indicating that the result cannot be shown.
• A similar limitation was previously addressed in the Query Workbench, but the fix was not applied to Analytics at that time. This update ensures that the same fix has now been implemented for Analytics in the designated fix versions by MB-65767.

Symptoms 

• Despite the actual large numerical results showing in Query Workbench, Columnar, cbq, etc., the UI displays:

"status": "Result is returned but cannot be displayed"

Triggers

Large numerical results in the Analytics Workbench UI, greater than 2^53. This issue is not present in Columnar, only in Couchbase Server Analytics workbench.

See below a test for this, run the following query in the on-prem Analytics workbench:

select 2503110226000002;

Verification

When running a query in Analytics workbench:

select 2503110226000002;

One should see:

"status": "Result is returned but cannot be displayed"

It means you are affected by this issue.

Workarounds

A workaround for this would be to cast the result of the large numerical results to a string in the query itself so that the result can be displayed in the UI.