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

["Maksim Zhuravkov (Jira)" <ji...@apache.org>]

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)