framework/resources/Functional/joins/implicit_cast/on_c_timestamp_and_c_date_1.sql

-- This query will return actual result
select count(*) from t_ts_required t1, t_date_required t2 where t1.a1 = t2.a1;