[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-4917) Keyword TYPE not supported

Keyword TYPE not supported -------------------------- Key: HHH-4917 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4917 Project: Hibernate Core Issue Type: Bug Components: query-hql Affects Versions: 3.5.0-CR-1 Reporter: Juergen Zimmermann Assignee: Steve Ebersole Fix For: 3.5.0-CR-2 Time Spent: 5 hours, 23 minutes Remaining Estimate: 0 minutes 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' )