Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group