[IGNITE-20849] Sql. Incorrect result returns from CAST as DECIMAL

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0-beta1
• Component/s: sql
• Labels: ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 14/Nov/23 07:19
• Updated: 14/Nov/23 12:23

Description

After [1] will be merged, additional case need to be fixed:

@Test
public void test0() {
List<List<Object>> res = sql("SElECT a::BIGINT FROM \n"
+ "(SELECT '111111111111111111111111111111111'::DECIMAL as a) t(a)");

System.err.println("!!!: " + res);
}

return: 4553682020284002759

The problem is :
IgniteSqlValidator#literalCanFitType filter only
INT_TYPES for now, seems need to be changed into NUMERIC_TYPES, after this change additional problem rised in min, max bound definition :
org.apache.calcite.sql.type.SqlTypeName#getLimit - it works incorrect, need to be fixed
 
[1] https://issues.apache.org/jira/browse/IGNITE-18662

Issue Links

• is part of: IGNITE-18662 Sql. Numeric to/from decimal cast with overflow does not produce an error