[CALCITE-976] Sql ANY type handling when find least restrictive type or add cast function

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: drill
• Assignee: Jinfeng Ni
• Reporter: Jinfeng Ni
• Created: 17/Nov/15 19:17
• Updated: 29/Jan/16 21:52

Description

This comes from a commit in Drill's forked Calcite (https://github.com/dremio/calcite/commit/32accb4ca09b8b1029caf6d1c3cc5a6010106b86)

1) When one input type is ANY, SqlTypeFactoryImpl.leastRestrictiveSqlType() should return ANY.

2) Do not create CAST() function, if target type is ANY.

mehant, could you please submit a PR after rebasing ?