[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-964) ORA-00936 with joined subclass / Oracle

ORA-00936 with joined subclass / Oracle --------------------------------------- Key: HHH-964 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-964 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.1 beta 2 Environment: Hibernate 3.1 beta 3, Oracle 9i Release 2 (9.2.0.1) Reporter: Heiko Hüter Assignee: Steve Ebersole Priority: Blocker Fix For: 3.1 rc 1 Attachments: testCase.zip if i do a delete from SubObjekt where propertyA='1234' bulk -delete i get an ORA-00936 error. The entity SubObjekt is a joined-subclass of the type SuperObjekt. The generated sql looks like : insert into HT_SUB_OBJEKT select del.ID as ID from SYSADM5.SUB_OBJEKT del, SYSADM5.SUPER_OBJEKT del_1_ where and del.ID=del_1_.IDPROPERTY_A='1234' The problem is the unnecessary and directly after the where clause. the attached zip files contains a runnable junit test for the problem. You just need to have an running oracle instance with user TEST (password TEST) and granted roles CONNECT, RESOURCE I tested the existence of this bug with 3.1 beta 2 and 3.