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

[Barak Ori (JIRA)]

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
         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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira