[BEAM-12046] Large doubles become "Invalid integer literal" in BeamZetaSqlCalcRel.

• Type: Bug
• Status: Open
• Priority: P3
• Resolution: Unresolved
• Component/s: dsl-sql-zetasql
• Assignee: Unassigned
• Reporter: Kyle Weaver
• Created: 24/Mar/21 17:11
• Updated: 04/Jun/22 19:50

Description

Example query: "SELECT 1.7976931348623157e+308 AS ColA"

The double literal is expanded into a BigDecimal literal [1] that is interpreted by the ZetaSQL parser as an INT64.

[1] 179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368