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

[John Aylward (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=38219#action_38219 ] 

John Aylward commented on HHH-2691:
-----------------------------------

http://www.antlr.org/wiki/display/ANTLR3/Error+reporting+and+recovery
looks like in antlr 3.1 you can create your own subclass for the error reporter and have it throw an exception instead of "recover". The tree parser sounds like it already has this option.

> Insert Into Select command outputs incorrect exception
> ------------------------------------------------------
>
>                 Key: HHH-2691
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: query-hql
>    Affects Versions: 3.2.4.sp1
>         Environment: Hibernate 3.2.4.sp1 with Annotations 3.3.0 And Validator 3.0.0
> MySQL 5.0.42
>            Reporter: John Aylward
>            Assignee: Steve Ebersole
>         Attachments: HHH_2691.hbm.xml, HHH_2691_Test.java
>
>
> receive following exception:
> org.hibernate.QueryException: number of select types did not match those for insert [INSERT INTO ProviderInvoiceLineItem (amount,billingAccount,circuit,description,invoice,type) SELECT pili.amount,pili.billingAccount,pili.circuit,pili.description,:newInvoice,pili.type) FROM com.cicat.bedrock.billing.model.ProviderInvoiceLineItem pili WHERE pili.invoice = :oldInvoice]
> exception should be that token ')' is not excepected near "pili.type"
> Should not have gotten as far as it did, should have blown up on parsing the HQL

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