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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira