Criteria + Example + Projections = "Y1_": invalid identifier ------------------------------------------------------------ Key: HIBERNATE-106 URL: https://jira.jboss.org/jira/browse/HIBERNATE-106 Project: Hibernate Issue Type: Bug Environment: Hibernate 3.3.1 Oracle 10 Sun JVM 1.5 Reporter: Krasimir Goutcev Assignee: Steve Ebersole When trying someting like this: SystemClassif sc=new SystemClassif(); //sc.setTekst("присъствал"); sc.setTekst("123"); Example sample=Example.create(sc).enableLike(MatchMode.ANYWHERE); session.createCriteria(SystemClassif.class).setProjection( Projections.projectionList() .add(Projections.property("code"),"code") .add(Projections.property("tekst"),"tekst") ).add(sample); hibernate trying to execute this SQL: select this_.ID as y0_, this_.TEKST as y1_ from SP.ADM_SYSTEM_CLASSIF this_ where (y1_ like ?) and throus exception: ORA-00904: "Y1_": invalid identifier this happen only if we using Example AND property name AND alias are identical strings. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira