[FLINK-35001] Avoid scientific notation for DOUBLE to STRING

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Table SQL / Runtime
• Assignee: Unassigned
• Reporter: Timo Walther
• Created: 03/Apr/24 12:40
• Updated: 03/Apr/24 12:42

Description

Flink currently uses Java semantics for some casts.

When executing:

SELECT CAST(CAST('19586232024.0' AS DOUBLE) AS STRING);

Leads to

1.9586232024E10

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

We should reconsider this behavior for consistency.