redash icon indicating copy to clipboard operation
redash copied to clipboard

The query result displays large numbers as NaN

Open starworks-readonly opened this issue 1 year ago • 2 comments

Issue Summary

The query result in a table displays large numbers as NaN (e.g. U128(1e21)).

Steps to Reproduce

  1. For a clickhouse data source execute the query:
SELECT toString(toUInt128('1000000000000000000000')) as s, toUInt128('1000000000000000000000') as i
Screen Shot 2024-02-15 at 10 20 24 AM

The result displays string fine, while u128 result as NaN.

Technical details:

  • Redash Version: Version: 8.0.0+b32245 (a16f551e)
  • Browser/OS: Brave, Mac
  • How did you install Redash: AWS image

starworks-readonly avatar Feb 15 '24 18:02 starworks-readonly

Same issue after upgrade to Version: 10.0.0 (9c928bd1)

starworks-readonly avatar Feb 15 '24 20:02 starworks-readonly

This is a known problem with Numeral-js. The only solution we have at the moment is to build Redash with a patched version of this library; see https://github.com/getredash/redash/discussions/6731

eradman avatar Apr 18 '24 15:04 eradman