[IMPALA-10556] Casting to a date without date portion should return error?

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: Frontend
• Epic Color: ghx-label-2
• Assignee: Unassigned
• Reporter: Steve Carlin
• Created: 01/Mar/21 23:50
• Updated: 01/Mar/21 23:50

Description

The query select cast(cast('23:59:59' as timestamp) as date) returns NULL.

Is this the desired behavior or should we return an error?  Postgres returns an error in this case.