[CALCITE-6608] RexBuilder#makeIn should create EQUALS instead of SEARCH for single point values

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.39.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Stamatis Zampetakis
• Reporter: Stamatis Zampetakis
• Created: 03/Oct/24 11:41
• Updated: 18/Oct/24 08:04
• Resolved: 18/Oct/24 08:04

Description

RexBuilder.makeIn(inputRef(0), ImmutableList.of(literal(100)))

Current behavior:

SEARCH($0, Sarg[100])

Proposed behavior:

=($0, 100)

The EQUALS operator is simpler than the SEARCH operator and it is handled better by other components. Although, the SEARCH to EQUALS transformation is already something that is done during simplification not every piece of code calls the simplifier.

This basic simplification could also be done directly inside the makeIn method when the caller passes a single point value.

Issue Links

• links to: GitHub Pull Request #3991