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_date
it fails saying thatjava.sql.Date is not assignable to java.util.Date
, given that thedate
attribute inMyEntity
is 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_timestamp
etc. functions to respect some compatible inference types and change the result type accordingly.