[jira] [Created] (IGNITE-23179) Calcite. Wrong numeric type coercion with 'IS DISTINCT FROM'

[Vladimir Steshin (Jira)]

Vladimir Steshin created IGNITE-23179:
-----------------------------------------

             Summary: Calcite. Wrong numeric type coercion with 'IS DISTINCT 
FROM'
                 Key: IGNITE-23179
                 URL: https://issues.apache.org/jira/browse/IGNITE-23179
             Project: Ignite
          Issue Type: Bug
            Reporter: Vladimir Steshin
            Assignee: Vladimir Steshin


The test

{code:java}
@Test
    public void testIsNotDistinctFrom() {
        executeSql("CREATE TABLE t1(i1 INTEGER, i2 INTEGER)");
        executeSql("INSERT INTO t1 VALUES (1, null), (2, 2), (null, 3), (3, 
null)");

        executeSql("CREATE TABLE t2(i3 DECIMAL, i4 INTEGER)");
        executeSql("INSERT INTO t2 VALUES (1, 1), (2, 2), (null, 3), (4, 
null)");

        String sql = "SELECT i1, i4 FROM t1 JOIN t2 ON i1 IS NOT DISTINCT FROM 
i3";

        assertQuery(sql)
            .returns(1, 1)
            .returns(2, 2)
            .returns(null, 3)
            .check();
    }
{code}

fails with:

{code:java}
java.lang.AssertionError: Collections sizes are not equal:
Expected: [[1, 1], [2, 2], [null, 3]]
Actual:   [[null, 3]] 
{code}

The is an incirrect numeric types coercion with _IS NOT DISTINCT_. Works is the 
column type would be the same (_INTEGER_).

Adoption of IGNITE-18163.





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