Re: More info.

From: Morten <usenet_at_kikobu.com>
Date: Tue, 07 May 2002 15:44:45 +0200
Message-ID: <3CD7DA4D.9050607@kikobu.com>

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... Received on Tue May 07 2002 - 08:44:45 CDT