ORA-29908:缺少辅助运算符的主调用 [英] ORA-29908: missing primary invocation for ancillary operator

问题描述

我有一个似乎无法弄清的错误.有人知道我在这里做错了吗?请假定图像的位置，主题，描述和测试在主题，位置或描述中多次出现.另外，我确实将ConText初始化参数TEXT_ENABLE设置为true.

I have an error that I can't seem to figure out. Anyone has an idea what I'm doing wrong here? Please assume that images has place, subject, description, and testing appears several times in subject or place or description. Also, I did set the ConText initialization parameter TEXT_ENABLE to be true.

SELECT 4*SCORE(1) + 2*SCORE(2) + SCORE(3) AS RANK
FROM   images i
WHERE  CONTAINS(i.subject, 'testing', 1)>0
OR  CONTAINS(i.place, 'testing', 2)>0
OR  CONTAINS(i.description, 'testing', 3)>0
ORDER BY RANK;

推荐答案

我通过用另一个查询包围当前查询并将ORDER BY RANK拉到外部查询来解决该问题.像这样:

I manged to solve the problem by surrounding the current query with another query and pulling the ORDER BY RANK to the outside query. Like so:

SELECT * 
FROM (SELECT 4*SCORE(1) + 2*SCORE(2) + SCORE(3) AS RANK
      FROM   images i
      WHERE  CONTAINS(i.subject, 'testing', 1)>0
      OR  CONTAINS(i.place, 'testing', 2)>0
      OR  CONTAINS(i.description, 'testing', 3)>0)
ORDER BY RANK;

这篇关于ORA-29908:缺少辅助运算符的主调用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！