[IGNITE-20170] Sql. AbstractPlannerTest#checkSplitAndSerialization founds serialization\deserialization problems.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0-beta1
• Component/s: sql
• Labels: calcite3-required ignite-3
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 07/Aug/23 07:41
• Updated: 07/Aug/23 08:03

Description

Check case below :

    @Test
    public void test0() throws Throwable {
        sql("SELECT CAST('1'::TINYINT AS FLOAT)").ok().getExecutable().execute();
    }

serialization\deserialization check return:

Caused by: org.opentest4j.AssertionFailedError: Invalid serialization / deserialization.
Expected:
rel#10:IgniteValues.(type=RecordType(FLOAT EXPR$0),tuples=[{ 1 }])
Deserialized:
rel#11:IgniteValues.(type=RecordType(FLOAT EXPR$0),tuples=[{ 1E0 }])

seems need to be fixed.

Issue Links

• duplicates: IGNITE-19858 Sql. RelJson serialization/deserialization mismatch for statements that include very large numbers.