[IGNITE-18661] Sql. Decimal multiplication could not be performed exactly: throw error

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Fix Version/s: 3.0
• Component/s: sql
• Labels: calcite2-required calcite3-required ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Iurii Gerzhedovich
• Reporter: Maksim Zhuravkov
• Created: 30/Jan/23 11:23
• Updated: 04/Sep/24 16:19
• Resolved: 07/May/24 11:45

Description

The following query is expected to fail but it does not.

SELECT '0.000000000000000000000000000001'::DECIMAL(38,30) * '0.000000000000000000000000000001'::DECIMAL(38,30)