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)
