Update assignment type check should allow subtypes
Description
When executing a statement update MyEntity e set e.date = current_date it fails saying that java.sql.Date is not assignable to java.util.Date, given that the date attribute in MyEntity is of type java.util.Date.
Obviously, we should as least allow subtypes, but I think we might want to change the result type resolver of the current_date, current_timestamp etc. functions to respect some compatible inference types and change the result type accordingly.
When executing a statement
update MyEntity e set e.date = current_dateit fails saying thatjava.sql.Date is not assignable to java.util.Date, given that thedateattribute inMyEntityis of typejava.util.Date.Obviously, we should as least allow subtypes, but I think we might want to change the result type resolver of the
current_date,current_timestampetc. functions to respect some compatible inference types and change the result type accordingly.