[hibernate-issues] [Hibernate-JIRA] Created: (EJB-335) Polymorphic delete fails while creating a temp table
Polymorphic delete fails while creating a temp table
----------------------------------------------------
Key: EJB-335
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-335
Project: Hibernate Entity Manager
Issue Type: Bug
Affects Versions: 3.2.1
Environment: Postgres 8.3, hibernate hibernate 3.2 from rev 14201
Reporter: Heiko W. Rupp
We have an Entity
@Entity
@Inheritance(strategy = InheritanceType.TABLE_PER_CLASS)
MeasurementData {
@EmbeddedId
MeasurementDataPK id;
@JoinColumn(name = "SCHEDULE_ID", insertable = false, updatable = false)
@ManyToOne(fetch = FetchType.LAZY)
Schedule schedule;
..
}
and Subclasses:
MeasurementDataNum(_1h,_6h,..) extends MeasurementData {
Double value;
}
MeasurementDataTrait extends MeasurementData {
String value;
}
A bulk delete "DELETE FROM MeasurementData md WHERE md.schedule IN (:schedules )
"
fails with
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not insert/select ids for bulk delete
at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)
at org.hibernate.ejb.QueryImpl.executeUpdate(QueryImpl.java:57)
Postgres 8.3 complains about the following SQL:
ERROR: UNION types double precision and character varying cannot be matched
insert into HT_MeasurementData
select measuremen0_.TIME_STAMP as TIME_STAMP, measuremen0_.SCHEDULE_ID as SCHEDULE_ID
from (
select value, maxvalue, SCHEDULE_ID, TIME_STAMP, minvalue, 1 as clazz_
from MEASUREMENT_DATA_NUM_1D
union all
select value, maxvalue, SCHEDULE_ID, TIME_STAMP, minvalue,
2 as clazz_
from MEASUREMENT_DATA_NUM_1H
union all
select value, maxvalue, SCHEDULE_ID, TIME_STAMP,
minvalue, 3 as clazz_
from MEASUREMENT_DATA_NUM_6H
union all
select value, null::float8 as maxvalue, SCHEDULE_ID, TIME_STAMP, null::float8 as
minvalue, 4 as clazz_
from RHQ_MEASUREMENT_DATA_TRAIT
) measuremen0_
where SCHEDULE_ID in ($1 , $2 , $3)
So basically it creates a column for "value" and tries to insert strings and
doubles into it.
The "obvious" :-) solution would be only to insert the timestamp and schedule id
into the table and not the value and other stuff that is not needed to identify the items
to delete.
--
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