[
https://issues.apache.org/jira/browse/IGNITE-21210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky resolved IGNITE-21210.
-----------------------------------------
Release Note: resolved in appropriate calcite issue
Resolution: Won't Do
> Sql. Incorrect precision derivation for negative numeric types
> --------------------------------------------------------------
>
> Key: IGNITE-21210
> URL: https://issues.apache.org/jira/browse/IGNITE-21210
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0.0-beta1
> Reporter: Evgeny Stanilovsky
> Priority: Major
> Labels: ignite-3
>
> Seems precision for negative numeric types derived erroneously.
> {noformat}
> @Test
> public void testLiteralTypeMatch() throws Exception {
> String query = "SELECT -1.1, DECIMAL '-1.1'";
> IgniteRel rel = physicalPlan(query, new IgniteSchema(DEFAULT_SCHEMA,
> 1, List.of()));
> RelDataType numericLitType =
> rel.getRowType().getFieldList().get(0).getType();
> RelDataType decimalLitType =
> rel.getRowType().getFieldList().get(1).getType();
> assertEquals(numericLitType, decimalLitType);
> }
> {noformat}
> throws on comparison:
> {noformat}
> Expected :DECIMAL(2, 1)
> Actual :DECIMAL(3, 1)
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
