Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: More info.
does the same query fail when run in sqlplus?
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Morten" <usenet_at_kikobu.com> wrote in message news:3CD7DA4D.9050607_at_kikobu.com...Received on Tue May 07 2002 - 10:41:30 CDT
> Morten wrote:
> >
> > I did some more searches on metalink. I found that removing the
> > ORDER BY line "resolves" this issue. Maybe someone remember this
> > behaviour? I'm trying to locate the proper TAR.
> >
> > SELECT id, score(1) "score"
> > FROM ccs_search
> > WHERE contains(content, '((test%)*(1/10))', 1) > 1
>
> That was a bit premature, seems that I just got "lucky". The
> query just broke a bit later than the one with the ORDER BY clause..
>
> Tried sqlplus:
>
> SQL> SELECT id, score(1) "score"
> 2 FROM ccs_search
> 3 WHERE contains(content, '((test%)*(1/10))', 1) > 1
> 4 ORDER BY score(1) DESC;
> SELECT id, score(1) "score"
> *
> ERROR at line 1:
> ORA-03113: end-of-file on communication channel
>
> Mmm...
>