framework/resources/Functional/joins/explicit_cast/on_c_bigint_and_d18.sql

select count(*) from cast_tbl_1 a, cast_tbl_2 b where CAST(a.c_bigint as DOUBLE PRECISION ) = CAST(b.d18 as DOUBLE PRECISION);