From: Rob Sargent <robjsargent@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Odd query behavior
Date: Fri, 12 Mar 2010 09:06:33 -0700
Message-ID: <4B9A6689.2030904@gmail.com> (raw)
In-Reply-To: <BA48DC793F18724D862C27C8F2C131CC62094F@exchange03.cryptocard.internal>
References: <BA48DC793F18724D862C27C8F2C131CC62094F@exchange03.cryptocard.internal>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: robjsargent@gmail.com
Subject: Re: Odd query behavior
In-Reply-To: <4B9A6689.2030904@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox