[KYLIN-5042] floor function return wrong result for date type

• Type: Bug
• Status: Reopened
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: v4.0.0-beta, v3.1.2
• Assignee: Unassigned
• Reporter: Congling Xia
• Created: 22/Jul/21 02:53
• Updated: 23/Jul/21 07:02

Description

floor function return wrong result for date type, for example:

select 
  floor(current_date to YEAR), 
  floor(cast('2021-07-01' AS DATE) to YEAR), 
  floor(cast('2021-07-01' AS TIMESTAMP) to YEAR)

the result is:

EXPR$0      EXPR$1      EXPR$2
1970-01-01  1970-01-01  2021-01-01 00:00:00