While migrating to Spring Boot 3.x (including hibernate 5.x to 6.x) we found one of our JPQL queries to fail while preparing the statement. We identified the problem was that the expression CAST ([some integer property] as string) causes an SQL exception - it translates to native SQL CAST ([fieldname] as text) causing cannot cast from integer to text (informix error code “IX000”,-9634 ). The informix database is 14.10.FC10IE I have attached a demo project with a unit test demonstrating the situation. |
