[CALCITE-2614] Converting datetime_plus to timestampadd should be done recursively

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: core
• Assignee: Unassigned
• Reporter: James Duong
• Created: 05/Oct/18 17:38
• Updated: 22/Feb/19 01:20

Description

The method in RexUtil convertDatetimePlusToTimestampAdd() should handle the case where the timestamp operand is another call to Datetime_plus. (eg SELECT <date_column> - interval '1' hour - interval '1' hour)

This can be impemented by having the datetime operand accept the same visitor.