The following is a Hibernate generated statement,
select count(*) as y0_
from view_localized_task this_
inner join TASKS nonlocaliz1_ on this_.non_localized_task_id=nonlocaliz1_.TASK_ID
where (this_.ended>=? or this_.state=? or this_.state=? or this_.state=?)
and (nonlocaliz1_.TASK_ID in (select distinct this_.TASK_ID as y0_
from TASKS this_
left outer join TASK_OBJECT_HANDLES taskobject3_ on this_.TASK_ID=taskobject3_.TASK_ID
left outer join OBJECT_HANDLE taskobject1_ on taskobject3_.OBJECT_HANDLE_ID=taskobject1_.ID
where taskobject1_.ID in (select distinct this_.objecthandle_id as y0_
from OBJECT_VISIBILITY_CONTEXT this_
where this_.context_handle_id in (?)))
or lower(this_.userId) like ?
It works with PostgreSQL 8.2. But it fails after I upgrade the database to PostgreSQL 8.4, nothing else is changed.
The jdbc driver is 8.4 build 701.
Here is the error message from the code:
2010-06-07 10:31:35,541 [WARN ] JDBCExceptionReporter - SQL Error: 0, SQLState: 42601
2010-06-07 10:31:35,541 [ERROR] JDBCExceptionReporter - ERROR: unterminated quoted string at or near "'\')"
The value for the last parameter is "superuser".
Thanks in advance for your help.
Turn down-time into play-time with Messenger games
Grokbase › Groups › PostgreSQL › pgsql-novice › June 2010