[CALCITE-2926] IN operator type validation failure

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 1.18.0
• Component/s: core
• Assignee: Unassigned
• Reporter: Will Yu
• Created: 15/Mar/19 23:04
• Updated: 20/Mar/19 23:03
• Resolved: 15/Mar/19 23:43

Description

There are two columns in my table. Column A's type is VARCHAR while column B's type is VARCHAR ARRAY.

When validating the SQL call `A IN B` the validation failed. 

The root cause seems to be in checkTypes functions in SqlInOperator. 

1. Not sure whether UNORDERED comparator is a good candidate because IN operands should have order.
2. During being checked in the checker, `canConvertStringInCompare` will give a `false` when family is ARRAY and cause this failure.