TablePlus icon indicating copy to clipboard operation
TablePlus copied to clipboard

`round` with wrong precision returned when using Clickhouse

Open shellvon opened this issue 1 year ago • 0 comments

Please answer the questions below, it helps us to keep track of the issue. Please do not ignore it or your issue will be closed.

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0):

ClickHouse 23.10.4.25

  1. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81):

Version 6.0.0 (550)

  1. The steps to reproduce this issue:

In some special cases, there are issues with the returned precision:


select round(52817/56099, 2), round(14734671/15744568, 2), round(1772646/1891397, 2);
-- Output is => 0.9399999999999999, 0.9399999999999999, 0.9399999999999999

image

When I switch to another client like DBeaver, everything works fine

shellvon avatar Jul 02 '24 04:07 shellvon