Re: like operator error in 9.2.0.3

si_bendoviNO_S_P_A_M_at_hotmail.com wrote:

> Hello,
>
> I am curious if anyone else seen this problem. Query with 7 tables
> joined with equijoin. Qualified using two strings, one of them with
> like operator:
>
> name like 'ABCDEFG LLC%'
>
> Query would return 50 rows or so. When changing condition to:
>
> name like 'ABCDEFG LL%'
>
> Query returned 0 rows. No error, just wrong result. Tried another
> database with similar data. It worked initially, but when playing with
> string by removing and adding characters it returned 0 rows again.
> Running statistics fixed problem, but it would reappear again I think.
> Statistics is gathered for all columns. Normally statistics is running
> every week. Database is about 500 GB big on 64 bit Solaris. We have TAR
> opened with Oracle, but they did not find anything, so far. Query with
> same plan, but rule base optimizer does return data always. Database is
> upgrade from 7.3 and there are no problems like this on 7.3. Query does
> have first_rows(100) hint and few other hints to mimic rule base plan
> to make sure it is not about plan.
> Anyone seen anything like this? It did significantly shake my
> confidence in Oracle.
>
> Thank you,
>
> Stan

Never seen it but then again when Oracle releases patches I test them and apply them.

Move to 9.2.0.5.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)