We use @ColumnTransformer on an entity for reads like:
"@ColumnTransformer(forColumn = "instance_label", read="case object_type_to when 'SERVER' then '' else create_instance_label(p_instance_label, id, packet_id) end")"
This results in this SQL query:
when 'SERVER' then '' else create_this_.instance_label(p_this_.instance_label, id, packet_id)
So Hibernate prefixes every occurrence of "instance" with the this_. alias. We tried several things, like escaping, custom dialect, ... however with no results and had to eventually revert to 5.2.17. The underlying database is MySQL |