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)
