[jira] [Created] (IGNITE-23088) Sql. Serialization/deserialization of some numbers can be incorrect.

["Iurii Gerzhedovich (Jira)" <ji...@apache.org>]

Iurii Gerzhedovich created IGNITE-23088:
-------------------------------------------

             Summary: Sql. Serialization/deserialization of some numbers can be incorrect.
                 Key: IGNITE-23088
                 URL: https://issues.apache.org/jira/browse/IGNITE-23088
             Project: Ignite
          Issue Type: Improvement
            Reporter: Iurii Gerzhedovich


For some reason, a set of numbers can be serialized/deserialized in the right manner. 
Example:
{code:java}
SELECT CASE WHEN RAND_UUID() != RAND_UUID() THEN 9223372036854768299 ELSE 3.4028235E38 END FROM t

org.opentest4j.AssertionFailedError: Invalid serialization / deserialization.
Expected:
rel#1323:TableScan.(table=[PUBLIC, T],projects=[CASE(<>(RAND_UUID(), RAND_UUID()), 9223372036854768299:DOUBLE, 3.4028235E38:DOUBLE)],requiredColumns={},sourceId=1)
Deserialized:
rel#1324:TableScan.(table=[PUBLIC, T],projects=[CASE(<>(RAND_UUID(), RAND_UUID()), 9.223372036854769E18:DOUBLE, 3.4028235E38:DOUBLE)],requiredColumns={},sourceId=1){code}

Reference in code in NumericCaseTypeCoercionTest



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