| org.hibernate.test.map.MapIndexFormulaTest fails because it uses a column "`password`", and a custom query: {{ select
lower(u.name) as {u.name} , lower(u."password") as {u.password} ,
lower(s.userName) as {s.key} , lower(s.name) as {s.index} , s.id as {s.element} , {s.element.*} from users u}} The back-tics used for quotes in the column mapping work for creating tables, but for custom native queries, the quotes need to be appropriate to the dialect. Using double-quotes in the custom query does not work. The quotes used in the custom query need to be correct for the dialect. MySQL requires back-tics; other dialects (e.g., H2) require double-quotes. I've changed the column mapping to "pw", which is not a reserved word so does not need quotes. Fixed in master and 5.0 branches. |