[ 
https://issues.apache.org/jira/browse/IGNITE-19858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Maksim Zhuravkov updated IGNITE-19858:
--------------------------------------
    Description: 
{code:java}
SELECT C2 > 340282346638528860000000000000000000001::REAL FROM test2
{code}

Type of C2 is REAL.
Tests that use AbstractPlannerTest::checkSplitAndSerialization will produce the 
following error:

{code:java}
org.opentest4j.AssertionFailedError: Invalid serialization / deserialization.
Expected:
IgniteTableScan(table=[[PUBLIC, TEST2]], projects=[[>($t0, 
340282346638528860000000000000000000001)]], requiredColumns=[{1}], sourceId=[1])
Deserialized:
IgniteTableScan(table=[[PUBLIC, TEST2]], projects=[[>($t0, 
3.402823466385289E38)]], requiredColumns=[{1}], sourceId=[1])
 ==> 
{code}


  was:
{code:java}
SELECT * FROM test2 WHERE C2 > 340282346638528860000000000000000000001::REAL
{code}

Tests that use AbstractPlannerTest::checkSplitAndSerialization will produce the 
following error:

{code:java}
org.opentest4j.AssertionFailedError: Invalid serialization / deserialization.

Expected:
IgniteIndexScan(table=[[PUBLIC, TEST2]], index=[TEST2_C2_IDX], type=[SORTED], 
searchBounds=[[RangeBounds [lowerBound=1.7976931348623157E308:DOUBLE, 
upperBound=$NULL_BOUND(), lowerInclude=false, upperInclude=false]]], 
filters=[>($t1, 
179769313486231570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001)],
 requiredColumns=[{0, 1}], sourceId=[114], collation=[[1]])

Deserialized:
IgniteIndexScan(table=[[PUBLIC, TEST2]], index=[TEST2_C2_IDX], type=[SORTED], 
searchBounds=[[RangeBounds [lowerBound=1.7976931348623157E308:DOUBLE, 
upperBound=$NULL_BOUND(), lowerInclude=false, upperInclude=false]]], 
filters=[>($t1, 1.797693134862316E308)], requiredColumns=[{0, 1}], 
sourceId=[114], collation=[[1]])
{code}



> Sql. RelJson serialization/deserialization mismatch for statements that 
> include very large numbers.
> ---------------------------------------------------------------------------------------------------
>
>                 Key: IGNITE-19858
>                 URL: https://issues.apache.org/jira/browse/IGNITE-19858
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 3.0.0-beta2
>            Reporter: Maksim Zhuravkov
>            Priority: Minor
>              Labels: ignite-3
>
> {code:java}
> SELECT C2 > 340282346638528860000000000000000000001::REAL FROM test2
> {code}
> Type of C2 is REAL.
> Tests that use AbstractPlannerTest::checkSplitAndSerialization will produce 
> the following error:
> {code:java}
> org.opentest4j.AssertionFailedError: Invalid serialization / deserialization.
> Expected:
> IgniteTableScan(table=[[PUBLIC, TEST2]], projects=[[>($t0, 
> 340282346638528860000000000000000000001)]], requiredColumns=[{1}], 
> sourceId=[1])
> Deserialized:
> IgniteTableScan(table=[[PUBLIC, TEST2]], projects=[[>($t0, 
> 3.402823466385289E38)]], requiredColumns=[{1}], sourceId=[1])
>  ==> 
> {code}



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

Reply via email to