You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Piotr Bojko (JIRA)" <ji...@apache.org> on 2018/04/01 20:54:00 UTC

[jira] [Created] (CALCITE-2233) IN clause does not follow type semantics like JOIN

Piotr Bojko created CALCITE-2233:
------------------------------------

             Summary: IN clause does not follow type semantics like JOIN
                 Key: CALCITE-2233
                 URL: https://issues.apache.org/jira/browse/CALCITE-2233
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.16.0, 1.17.0
            Reporter: Piotr Bojko
            Assignee: Julian Hyde


Consider following queries
SELECT * FROM A WHERE A.ID IN (SELECT B.ID FROM B)
SELECT A.* FROM A JOIN B ON A.ID = B.ID

When A.ID is NUMERIC(18,0) and B.ID is BIGINT - first query produces empty results while the  latter produces proper results.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)