Oracle Text 基于多列索引的查询不返回任何行

发布于 2024-12-18 23:37:00 字数 722 浏览 3 评论 0原文

我有一个 MAH_KERESES_MV 表，其中包含 3 列 OBJEKTUM_NEV、KERESES_SZOVEG_1、KERESES_SZOVEG_2。我创建以下多列 Oracle Text 索引：

exec ctx_ddl.create_preference( 'MAH_SEARCH', 'MULTI_COLUMN_DATASTORE');
exec ctx_ddl.set_attribute('MAH_SEARCH', 'COLUMNS', 'OBJEKTUM_NEV, KERESES_SZOVEG_1, KERESES_SZOVEG_2');

create index MAX_KERES_CTX on MAH_KERESES_MV(OBJEKTUM_NEV)
  indextype is ctxsys.context
  parameters ('DATASTORE MAH_SEARCH');

但是查询不返回任何行，尽管如果我使用 like 运算符制定查询，那么我会得到预期的结果：

SELECT  id, OBJEKTUM_NEV 
FROM MAH_KERESES_MV
WHERE CONTAINS(OBJEKTUM_NEV, 'C')>0;

Can somebody please help ？蒂亚，

塔马斯

原文

I have a MAH_KERESES_MV table with 3 columns OBJEKTUM_NEV, KERESES_SZOVEG_1, KERESES_SZOVEG_2. I create the following multi column Oracle Text index:

exec ctx_ddl.create_preference( 'MAH_SEARCH', 'MULTI_COLUMN_DATASTORE');
exec ctx_ddl.set_attribute('MAH_SEARCH', 'COLUMNS', 'OBJEKTUM_NEV, KERESES_SZOVEG_1, KERESES_SZOVEG_2');

create index MAX_KERES_CTX on MAH_KERESES_MV(OBJEKTUM_NEV)
  indextype is ctxsys.context
  parameters ('DATASTORE MAH_SEARCH');

But the query does not return any rows, although if I formulate the query with the like operator, then I get the results as expected:

SELECT  id, OBJEKTUM_NEV 
FROM MAH_KERESES_MV
WHERE CONTAINS(OBJEKTUM_NEV, 'C')>0;

Can some body please help? TIA,

Tamas

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

三生池水覆流年 2024-12-25 23:37:00

以防万一以后有人可能感兴趣，解决方案是上面的 CONTAINS 子句将 C 字符作为独立实体（即单词）进行过滤。正确的 where 子句应该是：

WHERE CONTAINS(OBJEKTUM_NEV, 'C%')>0;

Just in case any body might be interested later on, the solution was that the above CONTAINS clause filters for the C character as a stand alone entity (i.e. word). The correct where clause would have been: