Float32, Float64

    Types are equivalent to types of C:

    • — float.
    • Float64 — double.

    Aliases:

    • Float32 — FLOAT.
    • Float64 — DOUBLE.
    • Computations with floating-point numbers might produce a rounding error.
    1. │ 0.09999999999999998 │
    2. └─────────────────────┘
    • The result of the calculation depends on the calculation method (the processor type and architecture of the computer system).
    • Floating-point calculations might result in numbers such as infinity (Inf) and “not-a-number” (NaN). This should be taken into account when processing the results of calculations.
    • When parsing floating-point numbers from text, the result might not be the nearest machine-representable number.

    NaN and Inf

    In contrast to standard SQL, ClickHouse supports the following categories of floating-point numbers:

    • Inf – Infinity.
    1. ┌─divide(0.5, 0)─┐
    • -Inf — Negative infinity.
    1. ┌─divide(-0.5, 0)─┐
    2. │            -inf │
    3. └─────────────────┘
    • NaN — Not a number.
    1. ┌─divide(0, 0)─┐
    2. └──────────────┘