[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5539) ParameterParser does not support escaped ' symbols

ParameterParser does not support escaped ' symbols -------------------------------------------------- Key: HHH-5539 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5539 Project: Hibernate Core Issue Type: Bug Components: query-sql Affects Versions: 3.6.0.Beta4 Environment: 3.6.0 and postgresql 8.2.1 Reporter: Alexey Romanchuk Original Estimate: 2h Remaining Estimate: 2h I create native SQLQuery with createSQLQuery method. Looks like ParameterParser incorrectly process queries with escaped ' symbol. For example query like "select * from a where a.b = 'asdf \' asdf'" works fine, but "select * from a where a.b = 'asdf \' asdf: '" fails with org.hibernate.QueryException: Space is not allowed after parameter prefix ':' 'select * from a where a.b = 'asdf \' asdf'' at org.hibernate.engine.query.ParameterParser.parse(ParameterParser.java:92) at org.hibernate.engine.query.ParamLocationRecognizer.parseLocations(ParamLocationRecognizer.java:75) at org.hibernate.engine.query.QueryPlanCache.buildNativeSQLParameterMetadata(QueryPlanCache.java:149) at org.hibernate.engine.query.QueryPlanCache.getSQLParameterMetadata(QueryPlanCache.java:79) at org.hibernate.impl.AbstractSessionImpl.createSQLQuery(AbstractSessionImpl.java:146) at org.hibernate.impl.SessionImpl.createSQLQuery(SessionImpl.java:1656)