[
https://issues.apache.org/jira/browse/IGNITE-23179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17886162#comment-17886162
]
Ignite TC Bot commented on IGNITE-23179:
----------------------------------------
{panel:title=Branch: [pull/11525/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/11525/head] Base: [master] : New Tests
(1)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL{color} [[tests
1|https://ci2.ignite.apache.org/viewLog.html?buildId=8092265]]
* {color:#013220}IgniteCalciteTestSuite:
DataTypesTest.testIsNotDistinctFromTypeConversion - PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=8092342&buildTypeId=IgniteTests24Java8_RunAll]
> 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
> Affects Versions: 2.14
> Reporter: Vladimir Steshin
> Assignee: Vladimir Steshin
> Priority: Major
> Labels: calcite, ignite-2, ise
> Fix For: 2.17
>
> Attachments: IsNotDistinctFromTest.java
>
> Time Spent: 1h 20m
> Remaining Estimate: 0h
>
> 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 incorrect numeric types coercion with _IS NOT DISTINCT_. Works is
> the column type is the same: _INTEGER_.
> Adoption of IGNITE-18163.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
