Details
Description
If you create tables as follows:
create table a as select 'A' as str, cast(10.5 as decimal(15,6)) as num;
create table b as select 'A' as str;
Then
select floor(num) from a;
returns 10
but
select floor(num) from a join b on a.str = b.str;
returns 11