BUG #4939: error query result

From: "limaozeng" <limaozeng(at)163(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4939: error query result
Date: 2009-07-24 01:50:55
Message-ID: 200907240150.n6O1otsJ055036@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4939
Logged by: limaozeng
Email address: limaozeng(at)163(dot)com
PostgreSQL version: 8.4.0
Operating system: linux-32 bit
Description: error query result
Details:

create table t(str char(200));
insert into t values 'mzli';
insert into t values
'abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvw
xyz';
select user;
current_user
--------------
mzli
(1 row)
select * from t where str in (user,
'abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijk');
str

----------------------------------------------------------------------------
----------------------------------------------------------------------------
--------------------------------------------------
mzli


abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwx
yz

(2 rows)

only 'mzli' ought to be appeared in the result list.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Itagaki Takahiro 2009-07-24 03:35:27 Re: BUG #4939: error query result
Previous Message Magnus Hagander 2009-07-23 21:00:43 Re: BUG #4938: upgrade to 8.4 issue