[DRILL-3174] Calcite blocks queries whose type-missmatch can be resolved by Drill's Implicit casting

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 1.1.0
• Component/s: Query Planning & Optimization
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Sean Hsuan-Yi Chu
• Created: 22/May/15 22:18
• Updated: 01/Jul/15 01:01
• Resolved: 09/Jun/15 22:26

Description

select a from ... union all select b from ...

where a is int, and b is a bunch of integers in varchar types. Drill-Calcite interrupts this query by the column types. Since Drill has its own ways of handling type-mismatch, can we let Calcite ignore type checking?

Issue Links

• duplicates: DRILL-2724 Implicit cast test fails in Union All query (reports type mismatch)