[IGNITE-14589] Calcite engine. Numerous problem with type Decimal

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: calcite
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Vladimir Ermakov
• Reporter: Konstantin Orlov
• Created: 19/Apr/21 09:12
• Updated: 16/Nov/21 15:55
• Resolved: 05/Jul/21 13:22

Description

There are numerous problem with a decimal types:

• leading and trailing zeros are truncated when converting to string
• casting to precise scale is not working( select cast('0.01' as decimal(10, 1)) * 10 returns 0.1 instead of 0)

Affected tests:
src/test/sql/types/decimal

Issue Links

• is part of: IGNITE-14535 Caclite SQL engine capabilities
• links to: GitHub Pull Request #9199