Hi all, Given a SQL query with an in subquery:
select a.name from dept a where a.deptno in ( select b.deptno * 2 from dept b) Calcite translates it to an inner join, but the correct way should be translating it to a left semi join. According to the comments in the code, it seems this behavior is a design choice. So can you please help explain the rationale behind this? Do we have a plan to fix it? Best, Liya Fan