[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5978) TS: Postgresql 8.x - CustomSQLTest fails because UPPER()'s result is not converted to number.

TS: Postgresql 8.x - CustomSQLTest fails because UPPER()'s result is not converted to number. --------------------------------------------------------------------------------------------- Key: HHH-5978 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5978 Project: Hibernate Core Issue Type: Bug Environment: PostgreSQL 8.x JDBC 4 Reporter: Ondrej Zizka Assignee: Strong Liu Fix For: 3.6.2 {quote} create table Role ( id int8 not null, name varchar(255), primary key (id) ) insert into Role (name, id) values ('Patient', upper('1')) /** i did this */ >> ERROR: column "id" is of type bigint but expression is of type text SQLState: 42804 {quote} When inserting pure string, it's ok: {quote} insert into Role (name, id) values ('Patient', upper('1')) /** i did this */ >> 1 Row(s) Inserted {quote} The same for any string function or operator I've tried. FWICT, this is a PostgreSQL's and Oracle's flaw. Assigning to Strong Liu for consideration.