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.
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 |