Francesco Guardiani created FLINK-25300: -------------------------------------------
Summary: Remove CEIL and FLOOR call with one argument for integral values Key: FLINK-25300 URL: https://issues.apache.org/jira/browse/FLINK-25300 Project: Flink Issue Type: Technical Debt Components: Table SQL / Runtime Reporter: Francesco Guardiani Right now when the user tries to invoke {{FLOOR}} and {{CEIL}} on any integral number, a call to {{Math.floor}}/{{Math.ceil}} is generated, which is noop and possibly might end up in incorrect results. We should rather implement a rule in the planner (or reuse the expression reducer rule) that removes {{FLOOR}} and {{CEIL}} in case its arguments are integral types, that is TINYINT, SMALLINT, INT and BIGINT -- This message was sent by Atlassian Jira (v8.20.1#820001)