Evgeny Stanilovsky created IGNITE-20849: -------------------------------------------
Summary: Sql. Incorrect result returns from CAST as DECIMAL Key: IGNITE-20849 URL: https://issues.apache.org/jira/browse/IGNITE-20849 Project: Ignite Issue Type: Bug Components: sql Affects Versions: 3.0.0-beta1 Reporter: Evgeny Stanilovsky After [1] will be merged, additional case need to be fixed: {code:java} @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{code} 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 -- This message was sent by Atlassian Jira (v8.20.10#820010)