Looks like a bug!
-Original Message-
Sent: Thursday, June 20, 2002 2:17 PM
To: Multiple recipients of list ORACLE-L
pro
select distinct col1 from table_name where
col1 like 'ABC_' and col2 0
order by col1;
returns 38 rows ..
but
select distinct col1 from table_name
You are exactly correct ... it is a bug in
an earlier version on Oracle we have on one of our servers
See Note:1036394.6 on metalink !
thank you !
Mike
-Original Message-
Sent: Thursday, June 20, 2002 11:51 AM
To: Multiple recipients of list ORACLE-L
simple
Looks like a bug!
Run sql trace on each and see the differences in the execution plan. If #2
is using an index, try a rebuild and see if it changes. I have seen indexes
be built without data in them (though data is in the table). Checking for a
bug is an excellent idea as well.
Daniel W. Fink
Sr. Oracle DBA