At the moment, DataFusion casts floats to integers using the floor function.
Is it possible to configure this behavior?
Actual
select cast(2.8 as int) as result;
+--------+
| result |
+--------+
| 2 |
+--------+
Expected
This way work Postgresql and MySQL.
select cast(2.8 as int) as result;
+--------+
| result |
+--------+
| 3 |
+--------+