[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-5978) TS: Postgresql 8.x - CustomSQLTest fails because UPPER()'s result is not converted to number.
Ondrej Zizka (JIRA)
noreply at atlassian.com
Thu Mar 3 19:22:08 EST 2011
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ondrej Zizka updated HHH-5978:
------------------------------
Description:
{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 bug.
Assigning to Strong Liu for consideration.
was:
{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.
> 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 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
More information about the hibernate-issues
mailing list