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

[Hibernate-JIRA] Updated:...

[Hibernate-JIRA] Created:...

John Aylward (JIRA)

Thursday, 28 June 2007 Thu, 28 Jun '07

6:20 a.m.

Insert Into Select command outputs incorrect exception ------------------------------------------------------ Key: HHH-2691 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691 Project: Hibernate3 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 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

Show replies by date

Henri Yandell (JIRA)

Thursday, 28 June Thu, 28 Jun

6:06 p.m.

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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] Henri Yandell commented on HHH-2691: ------------------------------------ This one looks like it's a duplicate of HHH-2692 and can be closed.

...

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

Henri Yandell (JIRA)

6:48 p.m.

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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] Henri Yandell commented on HHH-2691: ------------------------------------ Ignore that - colleague points out that I'm missing the point :)

...

Emmanuel Bernard (JIRA)

Friday, 29 June Fri, 29 Jun

9:55 a.m.

New subject: [Hibernate-JIRA] Updated: (HHH-2691) Insert Into Select command outputs incorrect exception

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] Emmanuel Bernard updated HHH-2691: ---------------------------------- Comment: was deleted

...

Emmanuel Bernard (JIRA)

9:55 a.m.

New subject: [Hibernate-JIRA] Updated: (HHH-2691) Insert Into Select command outputs incorrect exception

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] Emmanuel Bernard updated HHH-2691: ---------------------------------- Comment: was deleted

...

Steve Ebersole (JIRA)

4:52 p.m.

New subject: [Hibernate-JIRA] Assigned: (HHH-2691) Insert Into Select command outputs incorrect exception

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] Steve Ebersole reassigned HHH-2691: ----------------------------------- Assignee: Steve Ebersole

...

Insert Into Select command outputs incorrect exception ------------------------------------------------------ Key: HHH-2691 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691 Project: Hibernate3 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 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

Martin Backhaus (JIRA)

Thursday, 2 October Thu, 2 Oct

12:42 p.m.

New subject: [Hibernate-JIRA] Updated: (HHH-2691) Insert Into Select command outputs incorrect exception

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] Martin Backhaus updated HHH-2691: --------------------------------- Attachment: HHH_2691_Test.java HHH_2691.hbm.xml Test Case

...

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

John Aylward (JIRA)

Tuesday, 10 August Tue, 10 Aug

4 p.m.

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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] John Aylward commented on HHH-2691: ----------------------------------- 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.

...

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

John Aylward (JIRA)

4:35 p.m.

New subject: [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.

...

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

Steve Ebersole (JIRA)

Friday, 27 August Fri, 27 Aug

3:59 a.m.

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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] Steve Ebersole commented on HHH-2691: ------------------------------------- The issue there is actually antlr. Its a "feature" they call back tracking. Not sure we can disable it tbh

...

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

Steve Ebersole (JIRA)

4:16 a.m.

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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] Steve Ebersole commented on HHH-2691: ------------------------------------- grr, that should be "recovery" not "backtracking"...

...

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

John Aylward (JIRA)

3:20 p.m.

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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] 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

Steve Ebersole (JIRA)

3:26 p.m.

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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] Steve Ebersole commented on HHH-2691: ------------------------------------- We use Antlr 2

...

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

John Aylward (JIRA)

3:28 p.m.

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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] John Aylward commented on HHH-2691: ----------------------------------- yeah, I guess I was indirectly suggesting a planned upgrade path to antlr 3.x

...

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

Steve Ebersole (JIRA)

3:35 p.m.

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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] Steve Ebersole commented on HHH-2691: ------------------------------------- It is not a drop in replacement. You need significant changes to your grammars. But if you are offering... :)

...

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

John Aylward (JIRA)

3:54 p.m.

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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] John Aylward commented on HHH-2691: ----------------------------------- breifly looking over the docs here: http://www.antlr2.org/doc/err.html#_bb1 and here http://www.antlr2.org/doc/options.html#defaultErrorHandler I would venture a guess that there may be an error in the hql grammar definition that allows a ")" to end a section of the tree even if there is no matching "(". Where is the grammar definition in the repository? I wouldn't mind having a look at it.

...

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

Steve Ebersole (JIRA)

4:30 p.m.

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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2691?page=c... ] Steve Ebersole commented on HHH-2691: ------------------------------------- https://fisheye2.atlassian.com/browse/Hibernate/core/trunk/core/src/main/...

...

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

5052

days inactive

6208

days old

hibernate-issues@lists.jboss.org

Manage subscription

16 comments

5 participants

tags (0)

participants (5)

Emmanuel Bernard (JIRA)
Henri Yandell (JIRA)
John Aylward (JIRA)
Martin Backhaus (JIRA)
Steve Ebersole (JIRA)

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

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