libopeng created CALCITE-5930: --------------------------------- Summary: When data types do not match, calcite may make a calculation error Key: CALCITE-5930 URL: https://issues.apache.org/jira/browse/CALCITE-5930 Project: Calcite Issue Type: Bug Reporter: libopeng
select * from dept where deptno in ( select count(*) from emp where comm is null); +--------+------------+----------+ | DEPTNO | DNAME | LOC | +--------+------------+----------+ +--------+------------+----------+ {code:java} select * from dept where cast(deptno as bigint) in ( select count(*) from emp where comm is null); +--------+------------+----------+ | DEPTNO | DNAME | LOC | +--------+------------+----------+ | 10 | ACCOUNTING | NEW YORK | +--------+------------+----------+{code} -- This message was sent by Atlassian Jira (v8.20.10#820010)