[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5978?page=c... ] 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 */ {quote} When inserting pure string, it's ok: {quote} insert into Role (name, id) values ('Patient', upper('1')) /** i did this */ {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 */ {quote} When inserting pure string, it's ok: {quote} insert into Role (name, id) values ('Patient', upper('1')) /** i did this */ {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 */ > > {quote} > When inserting pure string, it's ok: > {quote} > insert into Role (name, id) values ('Patient', upper('1')) /** i did this */ > > {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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5978?page=c... ] 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 */ {quote} When inserting pure string, it's ok: {quote} insert into Role (name, id) values ('Patient', upper('1')) /** i did this */ {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. 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 */ {quote} When inserting pure string, it's ok: {quote} insert into Role (name, id) values ('Patient', upper('1')) /** i did this */ {quote} The same for any string function or operator I've tried. 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 */ > > {quote} > When inserting pure string, it's ok: > {quote} > insert into Role (name, id) values ('Patient', upper('1')) /** i did this */ > > {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. -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5978?page=c... ] Strong Liu updated HHH-5978: ---------------------------- Fix Version/s: (was: 3.6.2) 3.6.next -- 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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5978?page=c... ] Strong Liu resolved HHH-5978. ----------------------------- Resolution: Fixed -- 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