1:42 a.m.
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
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:07 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-4917) Keyword TYPE not supported
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4917?page=c...
]
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:19 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4917) Keyword TYPE not supported
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4917?page=c...
]
Steve Ebersole commented on HHH-4917:
-------------------------------------
REFERENCE : 4.6.17.4 Entity Type Expressions
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:40 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4917) Keyword TYPE not supported
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4917?page=c...
]
Steve Ebersole commented on HHH-4917:
-------------------------------------
This initial commit addresses use in the where clause. Use in the select clause is still
an issue we need to address.
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.0-CR-2
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:55 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-4917) Keyword TYPE not supported
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4917?page=c...
]
Steve Ebersole updated HHH-4917:
--------------------------------
Component/s: (was: entity-manager)
query-hql
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: 45 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'
)
--
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
12:53 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4917) Keyword TYPE not supported
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4917?page=c...
]
Steve Ebersole commented on HHH-4917:
-------------------------------------
Usage in select clause is now acconted for.
The spec does not explicitly define the type of the return when used in the select clause.
The most logical is the java.lang.Class reference which was unfortunately much different
than our current ".class" psuedo property behavior. So these are currently
handled very differently. At some point we should come back and align so that
".class" is the select returns the Class ref as well.
Note too that returning Class is only valid for EntityMode.POJO. For other entity modes,
I return the entity name.
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'
)
--
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
12:53 p.m.
New subject: [Hibernate-JIRA] Closed: (HHH-4917) Keyword TYPE not supported
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4917?page=c...
]
Steve Ebersole closed HHH-4917.
-------------------------------
Resolution: Fixed
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'
)
--
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
1:11 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4917) Keyword TYPE not supported
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4917?page=c...
]
Juergen Zimmermann commented on HHH-4917:
-----------------------------------------
Is there a snapshot so that I could test it with my application?
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'
)
--
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
9:49 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-4917) Keyword TYPE not supported
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4917?page=c...
]
Steve Ebersole commented on HHH-4917:
-------------------------------------
Well you can always build from source.
I went ahead and pushed a snapshot though. We publish snapshots to the jboss snapshot
repo @ http://snapshots.jboss.org/maven2. The plan is to have CI push nightly snapshots
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'
)
--
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
5438
days inactive
5447
days old
hibernate-issues@lists.jboss.org
8 comments
2 participants
participants (2)
-
Juergen Zimmermann (JIRA) -
Steve Ebersole (JIRA)