Re: Oracle SQL bug in 9.2.0.8
From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Thu, 10 Feb 2011 19:23:42 +1100
Message-ID: <ij0785$tj3$1_at_news.eternal-september.org>
DG problem wrote,on my timestamp of 10/02/2011 12:04 PM:
> On Feb 10, 10:34 am, Noons<wizofo..._at_gmail.com> wrote:
>> Same in 10gr2. And I suspect it'd be the same in 11g.
>> I think you've been trapped by implicit conversion in Oracle, which
>> doesn't happen in the original MSSQL.
>>
>
> But there is no conversion going on. It is looking for an exact match.
> Also, you can see that the spaces are still present in the output.
>
> The result displayed, 'WHY ', does not equal 'WHY'.
>
Date: Thu, 10 Feb 2011 19:23:42 +1100
Message-ID: <ij0785$tj3$1_at_news.eternal-september.org>
DG problem wrote,on my timestamp of 10/02/2011 12:04 PM:
> On Feb 10, 10:34 am, Noons<wizofo..._at_gmail.com> wrote:
>> Same in 10gr2. And I suspect it'd be the same in 11g.
>> I think you've been trapped by implicit conversion in Oracle, which
>> doesn't happen in the original MSSQL.
>>
>
> But there is no conversion going on. It is looking for an exact match.
> Also, you can see that the spaces are still present in the output.
>
> The result displayed, 'WHY ', does not equal 'WHY'.
>
All I can say is: read the manual I pointed out. Implicit conversion means you don't see it. Otherwise it'd be explicit. Received on Thu Feb 10 2011 - 02:23:42 CST