Timo Walther created FLINK-35001:
------------------------------------

             Summary: Avoid scientific notation for DOUBLE to STRING
                 Key: FLINK-35001
                 URL: https://issues.apache.org/jira/browse/FLINK-35001
             Project: Flink
          Issue Type: Sub-task
          Components: Table SQL / Runtime
            Reporter: Timo Walther


Flink currently uses Java semantics for some casts.

When executing:

{code}
SELECT CAST(CAST('19586232024.0' AS DOUBLE) AS STRING);
{code}

Leads to
{code}
1.9586232024E10
{code}

However, other vendors such as Postgres or MySQL return {{19586232024}}.

We should reconsider this behavior for consistency.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to