Large numbers being floored

[UwUDev]

Describe the bug Large numbers (i guess above an u32) get their last decimal floored to 0

Edit: Sometime it can be more than one decimal

To Reproduce Steps to reproduce the behavior:

1. Create a sample table
2. put a lage numer such as 574317759736053768
3. Make a querry that get this value such as select test_column from test_table
4. You could see that the value will be 574317759736053760 instead of 574317759736053768

Expected behavior Get the right number

Environment (you can view the current version under Settings):

• Operating System : Windows 10 1809 (same issue on 21h2)
• Surrealist Version : 1.11.2

• SurrealDB Version : 1.1.1

  Example Expected response:

Got:

You can also see that sometimes the last two decimals got floored

[UwUDev]

The issue seems to come fromJSON.parse()

Maybe there is a better lib to parse json in TS

EDIT: using bigint seems to fix it

function reviver(key, value) {
  if (typeof value === 'string') {
    if (/^\d+$/.test(value)) {
      return BigInt(value);
    }
  }
  return value;
}

const parsed = JSON.parse(jsonString, reviver);

[macjuul]

This is an extremely tricky issue to solve, as even revivers won't result in the correct outcome (See https://jsoneditoronline.org/indepth/parse/why-does-json-parse-corrupt-large-numbers/).

I'll continue to investigate possible solutions for this issue though.

[macjuul]

This has now been resolved in Surrealist 2.0 when previewing responses in SurrealQL, as unlike JSON, SurrealQL does support 64-bit numbers.

We are still rolling this out to other editors throughout Surrealist in the coming releases