[jira] [Created] (IGNITE-22447) Sql. Numeric aggregate functions accept VARCHAR types

[Maksim Zhuravkov (Jira)]

Maksim Zhuravkov created IGNITE-22447:
-----------------------------------------

             Summary: Sql. Numeric aggregate functions accept VARCHAR types
                 Key: IGNITE-22447
                 URL: https://issues.apache.org/jira/browse/IGNITE-22447
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Maksim Zhuravkov


Numeric aggregate functions accept character string values due to implicit 
casts added by type coercion:

{code:java}
SELECT AVG('100')
> Gets transformed into
SELECT AVG("100"::DECIMAL(MAX_PREC, MAX_SCALE)) 
{code}

*Expected behaviour*
Aggregate functions that accept only numeric types should be rejected by the 
validator, when called with arguments of other types.




--
This message was sent by Atlassian Jira
(v8.20.10#820010)