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

[Ondrej Zizka (JIRA)]

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}


FWICT, this is a PostgreSQL bug.
Assigning to Strong Liu for consideration.

-- 
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