[hibernate-issues] [Hibernate-JIRA] Issue Comment Edited: (HHH-2691) Insert Into Select command outputs incorrect exception

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] John Aylward edited comment on HHH-2691 at 8/10/10 9:35 AM: ------------------------------------------------------------ I've verified this with lots of simple test cases, and I don't think this is limited to sub select clauses. The problem seems to originate in an invalid count of closing ")". Any query where there is an extra ")" will cause the HQL parser to treat that as the end of a statement. an example: SELECT t.col1 FROM Table t WHERE 1=1) ORDER BY t.col1 the ORDER BY will not be parsed an will be dropped from the query with no error. was (Author: johnjaylward): I've verified this with lots of simple test cases, and I don't think this is limited to sub select clauses. The problem seems to originate in an invalid count of closing ")". Any query where there is an extra ")" will cause the HQL parser to treat that as the end of a statement. some examples: SELECT t.col1 FROM Table t WHERE 1=1) ORDER BY t.col1 the ORDER BY will not be parsed an will be dropped from the query with no error. -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira