[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-2639) HQL parser treats closing (right) parenthesis wrong

HQL parser treats closing (right) parenthesis wrong --------------------------------------------------- Key: HHH-2639 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2639 Project: Hibernate3 Issue Type: Bug Components: query-hql Affects Versions: 3.2.1 Environment: Hibernate 3.2.1 against Oracle 10g. Reporter: Barak Ori The following HQL query "from Employee e where e.id > 100)" (notice the extra right parenthesis) works fine, although the parentheses are not balanced. It works as if the last parenthesis doesn't exist. The following HQL query also works: "from Employee e where e.id > 100)) and e.id < 1000", and returns results like the previous query. It looks like the first time an extra right parenthesis is found, it marks the end of the HQL query, and everything else is ignored. I've encountered this since I have a large piece of code that generates HQL queries dynamically. One component failed to balance parentheses properly, and the query didn't fail - instead it returned wrong results (imagine a this problematic HQL fragment as in inner query...) I think a parsing error on such queries is much nicer than accepting them and returning wrong results.