Re: strange behaviour (oracle 8.1.7.4.0)

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Mon, 11 Jul 2005 12:28:14 +0200
Message-ID: <dathje$v6u$00$1@news.t-online.com>

Fabio wrote:
> I have a table composed by varchar2, number and date columns.
> If I alter the current session like this
>
> ALTER SESSION SET NLS_COMP=ANSI;
> ALTER SESSION SET NLS_SORT=GENERIC_BASELETTER;
>
> and execute a select statement like
>
> select * from table where varchar2_10_field = 'a string value'
>
> the result simply ignore the where clause and I get all the records.
> The same exception doesn't occurr in oracle9i
>
> Is there anyone that experienced souch a bahaviour?
>
> Thanks
> Fabio
>
>

Yes , it's known bug (2761565).

Best regards

Maxim Received on Mon Jul 11 2005 - 05:28:14 CDT