[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-4917) Keyword TYPE not supported
Steve Ebersole (JIRA)
noreply at atlassian.com
Sat Feb 13 12:07:29 EST 2010
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steve Ebersole updated HHH-4917:
--------------------------------
Assignee: Steve Ebersole
Fix Version/s: 3.5.x
> Keyword TYPE not supported
> --------------------------
>
> Key: HHH-4917
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4917
> Project: Hibernate Core
> Issue Type: Bug
> Components: entity-manager
> Affects Versions: 3.5.0-CR-1
> Reporter: Juergen Zimmermann
> Assignee: Steve Ebersole
> Fix For: 3.5.x
>
>
> The keyword TYPE according to JPA 2 cannot be used:
> In PostgreSQL:
> CREATE TABLE kunde(
> k_id BIGSERIAL NOT NULL PRIMARY KEY,
> ...
> art CHAR(1) DEFAULT 'P'
> );
> Entity classes:
> @Entity
> @Table(name="kunde")
> @Inheritance
> @DiscriminatorColumn(name="art", length=1)
> @NamedQueries({
> @NamedQuery(name = "typeSample",
> query = "SELECT k FROM Kunde k WHERE TYPE(k) IN (Privatkunde, Firmenkunde)")
> })
> public abstract class Kunde implements java.io.Serializable {...}
> @Entity
> @DiscriminatorValue("P")
> public class Privatkunde extends Kunde {...}
> public abstract class Kunde implements java.io.Serializable {...}
> Wrong generated SQL query:
> select
> ...
> from
> kunde kunde0_
> where
> TYPE(kunde0_.k_id) in (
> 'P' , 'F'
> )
--
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
More information about the hibernate-issues
mailing list