Maksim Zhuravkov created IGNITE-20311:
-----------------------------------------
Summary: Sql. Handle return type of ROUND.
Key: IGNITE-20311
URL: https://issues.apache.org/jira/browse/IGNITE-20311
Project: Ignite
Issue Type: Bug
Components: sql
Reporter: Maksim Zhuravkov
The return type for ROUND(x)/ROUND(x, n) is equal to the type of x, which
causes issues when reading data from a `BinaryRow` because this way
ROUND(DECIMAL(2,1)) has return type DECIMAL(2,1),
and the return type is then used to construct `RowSchema` (that `RowSchema` is
then for reading data a `BinaryRow`).
{code}
SELECT ROUND(1.7)
# Although the implementation of the round function produces 2
# RowSchema has NativeType (precision=2, scale=1).
# And because of that read operation returns 2.0
# returns 2.0
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
