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

select count(*) from cast_tbl_1 a INNER JOIN  cast_tbl_2 b ON (a.c_integer = b.c_integer AND CAST(a.c_integer AS DOUBLE PRECISION ) <> b.c_double);