Message-ID: <4B9A6689.2030904@gmail.com>
Date: Fri, 12 Mar 2010 09:06:33 -0700
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.1.8) Gecko/20100228 SUSE/3.0.3-1.1.1 Lightning/1.0b1
	Thunderbird/3.0.3
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: Odd query behavior
References: 
 <BA48DC793F18724D862C27C8F2C131CC62094F@exchange03.cryptocard.internal>
In-Reply-To: 
 <BA48DC793F18724D862C27C8F2C131CC62094F@exchange03.cryptocard.internal>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Any views involved, or separate users/roles?

On 03/12/2010 08:41 AM, Dan McFadyen wrote:
> Hello,
> 
>  
> 
> I've come across an odd situation. I've had access to a database where a
> the following happens:
> 
>  
> 
> " SELECT * FROM table WHERE name LIKE 'abc%' "    returns 2 rows...
> 
>  
> 
> but...
> 
>  
> 
> " SELECT * FROM table WHERE name IN (SELECT name FROM table WHERE name
> LIKE 'abc%') "  returns 0 rows...
> 
>  
> 
> I've also tried doing a join on the column to another table that has
> what appears to be the same data, and the join comes out with zero rows.
> Weirder yet, I took the hash of both of the values and it came out
> identical.
> 
>  
> 
> Now, I know the first thing you'll ask is if you can get a copy of the
> data to re-produce it, and the problem is, I got a  copy of the data in
> question, and loaded into another server and it works fine. Both queries
> return 2 rows.
> 
>  
> 
> I do know that server it was running on was Finnish. The database uses a
> UTF8 encoding though, so I don't know what that would make any difference.
> 
>  
> 
> Any ideas about things I should be looking at?
> 
>  
> 
> Thanks
> 
>  
> 
> Dan
> 
>  
> 
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Statements and opinions expressed in this e-mail may not
> represent those of the company. Any review, retransmission,
> dissemination or other use of, or taking of any action in reliance upon,
> this information by persons or entities other than the intended
> recipient is prohibited. If you received this in error, please contact
> the sender immediately and delete the material from any computer. Please
> see our legal details at http://www.cryptocard.com CRYPTOCard Inc. is
> registered in the province of Ontario, Canada with Business number 80531
> 6478. CRYPTOCard Europe is limited liability company registered in
> England and Wales (with registered number 05728808 and VAT number 869
> 3979 41); its registered office is Aztec Centre, Aztec West,
> Almondsbury, Bristol, UK, BS32 4TD