[jira] [Created] (IGNITE-21827) Sql. Union returns incorrect result for DECIMAL and INT columns

[Pavel Pereslegin (Jira)]

Pavel Pereslegin created IGNITE-21827:
-----------------------------------------

             Summary: Sql. Union returns incorrect result for DECIMAL and INT 
columns
                 Key: IGNITE-21827
                 URL: https://issues.apache.org/jira/browse/IGNITE-21827
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Pavel Pereslegin


Union returns incorrect result for DECIMAL and INT columns

Simple reproducer:

{code:java}
    sql("CREATE TABLE t0(id INT PRIMARY KEY, val INT)");
    sql("CREATE TABLE t1(id INT PRIMARY KEY, val DECIMAL)");
    sql("INSERT INTO t0 VALUES (1, 10)");
    sql("INSERT INTO t1 VALUES (1, 10)");

    assertQuery("SELECT id, val from t0 UNION select id, val from t1")
            .returns(1, new BigDecimal(10))
            .check();
{code}

The current output of such a query contains duplicate values.
{noformat}
 1  10
 1  10
{noformat}



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