[CALCITE-824] Type inference when converting IN clause to semijoin

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.0-incubating, 1.3.0-incubating, 1.2.0-incubating, 1.1.0-incubating
• Fix Version/s: 1.5.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: Josh Wills
• Created: 30/Jul/15 14:50
• Updated: 27/Feb/24 22:24
• Resolved: 02/Sep/15 01:13

Description

I hit an issue where using an IN clause of int literals would work properly when compared against a BIGINT column when the IN clause had less than 20 values, but would fail when processing more than 20 values. I traced the issue to the way target row types are handled inside of the code that converts the IN clause into a semijoin.